• 01/07/2026
  • 4 minutes to read

Handling amount differences in the Payment Reconciliation Journal

During bank account reconciliation, you may encounter lines with amount differences. These discrepancies are marked with the Difference status, indicating that further action is required to resolve them. The Payment Reconciliation Journal allows you to address these differences directly.

To configure automatic handling of amount differences

Use the Banking Import Setup page to define how the system automatically handles amount differences.

Amount Difference FastTab

Configure how the system processes discrepancies using the following fields:

FieldDescription
Show DialogEnable or disable the dialog that appears when handling amount discrepancies. If disabled and an account for differences is specified, the system automatically processes the discrepancy without displaying a dialog.
Default Account TypeDefine the default journal template type for handling differences. The account type for difference lines is based on the bank statement or payment reconciliation line. By default, the system uses the account type from the Bank Account Reconciliation line, but you can adjust this in the difference-handling dialog.
Default Account No.Specify the account number used when creating lines for amount differences. This account is automatically applied when resolving discrepancies. When you want to use a G/L account for handling differences, make sure that the account allows direct posting.
Posting Description TemplateDefine a template for consistent descriptions when handling amount differences.

Matching FastTab

FieldDescription
Search RulesConfigure specific accounts for handling amount differences. These rules align with the settings in the Banking Import Setup.

To handle amount differences in the Payment Reconciliation Journal

In the Payment Reconciliation Journal, amount differences are managed by transferring them into new reconciliation lines. The system creates new, indented lines under the main reconciliation line, adjusting the transaction amount accordingly.

To handle amount differences in the Payment Reconciliation Journal:

  1. In the Payment Reconciliation Journal, locate a line with the Difference status.
  2. Select the line and choose Manual Application > Transfer Difference to Account.
  3. In the Transfer Difference to Account dialog, enter the required information and select OK.

To handle overpayments on the Payment Application Review page

Overpayments occur when a payment amount exceeds the invoice amount. The Payment Application Review Page provides actions to manage these situations, ensuring that customer ledger entries accurately reflect both the applied invoice and any overpaid amount.

You can handle overpayments by using the Transfer Difference to Payment action that includes the overpaid amount directly in the application of the invoice, so the ledger entry reflects the full payment.

To handle an overpayment:

  1. Locate a payment line with the Difference status in Payment Reconciliation Journal or Bank Account Reconciliation.
  2. Open the Payment Application Review Page.
  3. Review the Difference field to see the overpaid amount.
  4. On the action bar, select Transfer Difference to Payment to include the overpayment in the same ledger entry as the invoice.