Resolve Common Reconciliation Exceptions

Diagnose the most common reasons a reconciliation cannot start or finish cleanly, including first-time setup issues, date-window issues, and nonzero differences.

Purpose

Use this article when reconciliation stops with a validation error, an unexpected difference, or a transaction-selection problem.

Prerequisites

  • You are working in Reconcile.
  • You know which bank or credit card account and statement period you are trying to reconcile.

Steps

  1. If SPRK says Select the opening balance journal entry, start with the first-time setup path:
  • Choose the journal entry that represents the account’s opening balance anchor.
  • Confirm that the selected entry belongs to the account you are reconciling.
  1. If SPRK says the difference must be zero, compare the summary bar to the statement:
  • Remove transactions that do not belong on the statement.
  • Add missing confirmed transactions that do belong on the statement.
  • Verify the ending balance sign, especially for credit accounts.
  1. If a transaction is missing from the reconciliation table, confirm that it is:
  • In the selected account
  • Already confirmed
  • Dated on or before the statement ending date
  • Not already reconciled
  1. If a match is wrong, use Unmatch before finishing the reconciliation and choose the correct check again if needed.
  2. If SPRK reports that a transaction is already reconciled, remove it from your current plan and confirm whether it was cleared in an earlier statement period.
  3. If the opening balance looks unexpected, confirm whether SPRK is carrying forward the ending balance from the last posted reconciliation before the current statement ending date.

Expected Result

You can identify whether the issue is caused by account selection, transaction status, statement setup, or the first-time opening balance path. Current transaction and general ledger impact as of 2026-05-02:

  • Troubleshooting steps do not create new general ledger entries by themselves.
  • Correcting a reconciliation issue usually means adjusting transaction selection, dates, balances, or match state before posting the reconcile record.
  • If you must change original transaction coding, do that in the source workflow before returning to reconciliation.

Common Mistakes

  • Trying to solve a reconciliation difference by leaving incorrect transactions selected.
  • Using reconciliation to fix posting mistakes that should be corrected in the original banking, invoice, bill, or journal-entry workflow.
  • Forgetting that already reconciled transactions cannot be reused in a later statement period.

Info

  • App sections: reconcile
  • Last validated: 2026-05-02
  • Screenshot status: not-started