How to apply a customer payment in Business Central

By Emil Björk · Microsoft business apps consultant, Gothenburg

Step-by-step: record an incoming customer payment in Business Central and apply it to the right open invoice, plus how to handle partial and overpayments.

Reviewed September 20263 min read · 765 wordsPublished
On this page (6)

Recording a customer's payment and applying it to the invoice it covers are two different steps in Business Central. Skipping the second step is the single most common reason a customer's account shows an open invoice that's actually been paid.

Where it lives

There are three common entry points: the Cash Receipt Journal (for manual entry of a batch of payments), the Payment Reconciliation Journal (for payments coming in through an imported or connected bank feed), and directly from a customer card using the Apply Entries action against existing ledger entries.

Steps (manual entry via the cash receipt journal)

  1. Open the Cash Receipt Journal (search Alt+Q) and select the relevant batch.
  2. Add a line for the payment: posting date, the Bal. Account (the bank account the money landed in), the customer's account number, and the amount received.
  3. Set Applies-to Doc. No. on the line if you already know which invoice this covers — this applies the payment automatically the moment you post.
  4. If you don't know the invoice yet, leave it blank, post the payment, and apply it later from the customer's ledger entries once you have the remittance detail.
  5. Post the journal line. The payment is now recorded as a customer ledger entry.
  6. Apply it (if not done at posting). Open the customer card, go to Ledger Entries, select the unapplied payment, choose Application Worksheet or Apply Entries, tick the invoice(s) it covers, and confirm. Business Central shows the running balance so you can see the invoice clearing to zero as you check boxes.
  7. Post the application. This is the step that actually clears the invoice's open status — selecting the invoice in the worksheet alone doesn't do it.

Steps (via the Payment Reconciliation Journal, for bank-fed accounts)

  1. Open the Payment Reconciliation Journal, select the bank account, and import or refresh the statement.
  2. Review the auto-matched lines — Business Central proposes a customer and invoice match based on amount and reference.
  3. For unmatched or low-confidence lines, manually pick the customer and invoice, or leave it as a transfer if it isn't a customer payment at all.
  4. Post the journal. Matched lines both post the payment and apply it to the invoice in the same action.

What you need

Posting cash receipts typically sits with an accounts-receivable or finance role; check current licensing and permission-set assignment with your administrator if the journal or Apply Entries action isn't available to you. Bank feed connections for the reconciliation journal need to be configured separately by an administrator before this workflow is usable day to day.

Limits and gotchas

  • An unapplied payment looks like missing cash, not a system error. If a customer's balance looks too high, check for unapplied payments on their ledger before assuming an invoice wasn't recorded.
  • You can't apply more than the payment covers. The application worksheet enforces this — if the numbers don't add up, check for a partial payment or a second payment that arrived separately.
  • Currency mismatches block application. A payment in a different currency than the invoice needs the exchange rate resolved first; Business Central won't silently apply across currencies.
  • Deleted or reversed journal lines before posting are fine to fix; posted entries need Unapply, not deletion — never try to delete a posted ledger entry to correct a mistake.
  • This is separate from the monthly bank reconciliation. Applying customer payments clears the AR side; confirming the bank account balance itself against the bank statement is a different, usually monthly, control — see the site's guide on bank reconciliation in Business Central for that process, and Using Copilot for bank reconciliation matching in Business Central for the AI-assisted version of the matching step.

Building a habit that prevents a monthly scramble

The businesses that struggle at month-end with unapplied payments are almost always the ones that let application slip during the month rather than doing it as remittances arrive. Applying a payment takes under a minute once you know which invoice it covers — the expensive part is always the detective work of figuring out which invoice a vague bank reference actually belongs to weeks later. Keep a simple habit: whenever a remittance advice or payment notification arrives from a customer, apply it that day rather than letting it join a pile of "figure out later" transactions. This single habit does more to keep AR clean than any month-end catch-up session ever will.

Once payments are flowing cleanly, the next place most everyday users spend time is How to post a sales invoice in Business Central — the document that creates the open balance this guide clears.

Frequently asked questions

What's the difference between posting a payment and applying a payment?

Posting a payment records that cash came in and creates a customer ledger entry for it. Applying links that payment entry to a specific open invoice (or several), which is what actually clears the invoice's open balance. You can post without applying, and the payment shows as an unapplied credit until someone applies it.

How do I apply a payment to the wrong invoice by mistake?

Open the customer ledger entries, find the applied payment and invoice, and use Unapply Entries to reverse the application without touching the underlying posted amounts. Then reapply to the correct invoice.

What if the customer overpaid?

Apply the payment to the invoice(s) it covers and leave the remainder unapplied — it sits as a credit balance on the customer account until you either refund it or apply it to a future invoice.

Can I apply one payment to several invoices at once?

Yes. On the Application worksheet, select multiple open invoice lines and Business Central splits the payment across them by the amounts you specify, as long as the total doesn't exceed the payment amount (partial application per line is also allowed).

Does the Payment Reconciliation Journal replace manual application?

For businesses with a live bank feed or imported bank statements, it automates most of the matching and application in one pass. Manual application through the customer card or cash receipt journal is still there for payments that don't come through a bank feed, like a cheque handed over in person.

Further reading

Related guides

Browse every guide in Business Central or just Finance & accounting.

Was this helpful?

Signals which guides land and which need work. No account, no comment box — corrections go through the contact page.

Spot something wrong or want a topic covered? Send a correction or a topic request — both are welcome.