Matching statement amount to account balance

• 15/09/2025
• 3 minutter at læse

The Match Statement Amount to Account Balance feature supports bank account reconciliation by automatically proposing payment applications when the statement amount matches the total open balance of a customer, vendor, or employee account. This allows the system to suggest matches even when no document number is available, based on the assumption that the amount corresponds to the full outstanding balance.

During bank statement reconciliation, the system checks whether the statement amount matches the total open balance of a customer, vendor, or employee account. If a match is found, all open ledger entries for that account are included in the payment application proposal.

For example, a bank transaction includes a statement amount of €1,000 and a description referencing Customer 1000. The system checks:

• Does Customer 1000 have open ledger entries totaling €1,000?
• If so, proposals are created for all matching entries.
• If the amount falls within the defined discount and reconciliation tolerances, the match is accepted.

To enable account balance matching:

1. Go to the Banking Import Setup page and in the Account Balance Matching section, enable one or more of the following:

   • Customer Account Balance Matching
   • Vendor Account Balance Matching
   • Employee Account Balance Matching

2. Open the Bank Acc. Reconciliation page and select Home > Match Automatically.

3. If the statement amount matches the account’s open balance, the system creates a payment application proposal. The proposal includes all open ledger entries for the account.

   Bemærk

   Payment discount and payment discount date tolerance are supported, as well as custom reconciliation tolerance on bank accounts. Payment tolerance from the General Ledger Setup isn’t supported.

4. Open the Payment Application Review page and review the proposed entries. You can post the journals or adjust the proposals as needed.