LedgerHQ
Use LedgerHQ

Investigate a reconciliation difference

Find missing, duplicate, mistimed, or incorrectly signed activity before accepting a reconciliation discrepancy.

Use the statement and register to explain a nonzero Difference before you create a reconciliation discrepancy.

Check The Setup First

  1. Confirm the Statement ending date.
  2. Compare the displayed Beginning balance and Ending balance with the statement.
  3. For a credit card or loan, use the positive balance-due amount shown on the statement. See Enter credit-card and loan balances correctly.

An active reconciliation with a nonzero Difference, search, and unchecked fictional transactions

Find The Transaction Difference

  1. Search the reconciliation by date, description, reference, or amount.
  2. Check for a statement transaction that is present but not checked.
  3. Uncheck any row that does not clear on this statement.
  4. From Bank Recs, click Register and search the full account history for:
    • a missing or duplicate amount;
    • a transaction posted to the wrong register;
    • a date outside the statement period;
    • a payment or charge with the wrong sign.
  5. Check Bank Feeds for pending, uncoded, or coded-but-unposted rows through the statement date.

A fictional account register search used to investigate reconciliation differences

Return to the reconciliation after correcting the source transaction. Check or uncheck the corrected row and confirm whether Difference reaches $0.00.

Use A Discrepancy Only By Decision

Book reconciliation discrepancy creates a real income or expense adjustment. It makes the reconciliation balance but does not explain the cause. Do not use it first for a large, repeated, or unclear difference.

If you cannot identify the difference safely, create a support ticket with the company, account, statement end date, and difference. Do not create a separate manual offsetting entry.

When the difference is zero, finish the reconciliation.

On this page