Match bank receipts with invoices in Business Central

Use the Payment Reconciliation Journal when a bank transaction needs to be matched to open entries in Business Central. Review the suggestion against the remittance before posting.
Upload a case

Key facts

A matching amount can still belong to the wrong invoice. Check the customer and reference as well as the amount.

Choose the bank account and import transactions

Start in the Payment Reconciliation Journal for the relevant bank account. Import the statement or use the configured feed. If the cash receipt has already been recorded, identify that entry before creating another payment. Keep the statement period and journal batch reference with the review.

Review matches before posting

Business Central can use payment text and entry information to suggest matches according to prioritized Payment Application Rules. Choose Apply Manually when a suggestion conflicts with the remittance. For an $850 receipt covering $500 and $350 invoices for the same customer, select both entries, check the applied amounts and choose Accept Application.

Check the bank and receivable outcomes

Resolve lines that require review and clear any unexplained differences before posting. Choose Post Payments Only if you reconcile the bank separately, or Post Payments and Reconcile Bank Accounts to close the related bank entries now. After posting, confirm the expected invoice balances and check the bank ledger or reconciliation for the same statement period.

RELATED ARTICLES

Illustration of a free e-book representing the 'Free International Debt Collection Guide.' This guide offers proven debt collection techniques. Get your free copy now.
FREE GUIDE

Download our free debt collection guide

Practical steps to get unpaid invoices paid, at home and abroad. Download our debt collection guide for free.

Thank you! The guide will land in your inbox shortly
Oops! Something went wrong while submitting the form.