When a customer pays an invoice in Business Central, the money arriving in your bank is only half the job. You also need to apply payments to the right invoices so your books stay clean and your statements are accurate.
Receiving payment is great – but you are not done yet. However, if you do not apply payments to the matching invoices, both the invoice and the payment remain open in Business Central. That creates a problem when you run a customer statement. As a result, the statement will show invoices as unpaid even though the money is in. So the matching step matters as much as the payment itself.
Why You Need to Apply Payments in Business Central
In Business Central, a customer ledger entry stays open until you settle it. An invoice is one type of open entry. A payment is another type. Until you apply payments to the matching invoices, both sit as open entries in the system. Therefore, your aged receivables report and customer statements will show invoices as outstanding even after the customer has paid.
This matters most when you send a statement to a customer. You want to show them clearly: here are the invoices you have paid and here are the ones still due. Without the application step, that picture is wrong. Also, it affects your ability to chase overdue invoices. If you cannot tell which invoices are genuinely unpaid, you risk chasing invoices that are already settled. So the apply payments step is not just bookkeeping – it is a basic requirement for running accounts receivable well.
How to Apply Payments Using the Cash Receipt Journal
The main tool to apply payments in Business Central is the cash receipt journal. To start, open the journal and create a new line. Set the account type to Customer and select the customer. Enter the bank account you are posting to in the balancing account field. At this point, you have a journal line but no link to a specific invoice.
To link the payment to an invoice, look at the right side of the journal line. There is a field called Applies-to Document No. Click the three dots next to it. BC then opens a list of all open invoice entries for that customer. Select the invoice you want to settle, then click OK. So the document number fills in and the amount is set to match. When you post the journal, BC applies the payment to that invoice and closes both entries.
What Happens When You Post
Posting the cash receipt journal closes the open entries, settling both. The invoice is no longer outstanding, and BC matches the payment. So the next time you run a customer statement, that invoice will not appear as unpaid. Also, BC links the two entries in the customer ledger. Therefore, you can always trace which payment covered which invoice by looking at the applied entries on either document.
Apply Payments to Multiple Invoices at Once
Sometimes a customer sends one payment to cover several invoices. In this case, using the Applies-to Document No. field on the journal line is not the right approach. That field handles one invoice at a time. However, BC has a better option for this: the Apply Entries action.
To use it, create the journal line for the customer and the bank account but leave the amount blank. Then open the Apply Entries page from the action menu. This shows all open invoices for the customer. Also, each row has a column called Applies-to ID. Click on the first invoice you want to include and choose Set Applies-to ID. BC fills in your document number. Then, repeat for each invoice you want to cover. As you select each one, the total applied amount at the bottom of the page updates. So you can check whether the total matches the payment you received before confirming.
When you click OK, BC returns to the journal line and fills in the amount. Also, the line now links to all the selected invoices. Furthermore, posting this single line will close all of them at once. Consequently, your bank reconciliation stays clean. You have one payment line matching one bank transaction, not several separate lines for the same cheque or transfer.
Handling Partial Payments
Sometimes a customer pays only part of what they owe. They might cover one full invoice and part of another. BC handles this through the Amount to Apply column on the Apply Entries page. By default, this column shows the full remaining amount on each invoice. However, you can change it. However, you can change it to any amount you choose.
For example, suppose a customer is paying one full invoice and only $1,000 of a second invoice that has a remaining balance of $5,000. On the Apply Entries page, first select both invoices. Then change the Amount to Apply on the second invoice to $1,000. The total at the bottom updates to reflect the partial amount. When you click OK and post, BC closes the first invoice and leaves the second partially open with a remaining balance of $4,000. So BC records the partial payment and the invoice stays active for the remaining amount. Also, the customer ledger reflects the correct situation. Therefore, your next statement for that customer will show the right balances.
Running the Test Report Before Posting
Before you post any cash receipt journal, it is worth running the test report. This is available from the journal’s action menu. Furthermore, the report shows every line that is about to be posted and the accounts it will affect. It also shows a reconciliation section with the balance after posting for each account. So you can check that the bank account balance will match your bank statement before you commit anything.
In particular, this step is useful when the journal has many lines. Indeed, with ten or twenty payment lines, it is easy to miss an error. So the test report gives you a full picture before anything changes in BC. Moreover, it costs nothing – you can run it as many times as you like. In short, it is a simple habit that prevents posting mistakes that are harder to correct after the fact.
Wrapping Up: How to Apply Payments in Business Central
The cash receipt journal in Business Central gives you a flexible way to apply payments to invoices. You can match a single payment to one invoice, cover several invoices with one journal line, or handle partial amounts using the Amount to Apply field. Also, the test report lets you review everything before posting. In short, once you know the Apply Entries method, most apply payments scenarios in BC are straightforward to handle.
This is part one of a two-part guide. Part two covers what to do when payments have already been posted without being applied. Check the NAV SEAL YouTube channel and visit navseal.com for more Business Central guides.
For more Business Central guides and tutorials, visit NAV SEAL Blog and watch more videos on our YouTube Channel.
