LedgerHQ
Use LedgerHQ

Bank reconciliation

Set up bank and credit-card reconciliation, check statement transactions, investigate differences, and save completed records.

Start With The Statement

LedgerHQ can read a verified statement and suggest transaction matches. Start from the account's Bank Recs row and follow the setup or reconciliation action shown there. You decide which transactions to check and when to finish.

Statement coverage and reconciliation are related but separate. A verified statement supplies evidence for a period; reconciliation still depends on the statement date, statement balance, and the posted transactions you check.

Follow The Sequence

  1. Prepare the account.
  2. Start a bank reconciliation.
  3. For a card or loan, enter liability balances correctly.
  4. If the difference is not zero, investigate the difference.
  5. Finish the reconciliation.

Set Up The First Baseline

The setup wizard asks whether the account was reconciled before. For an account with prior history, enter the last reconciled date, identify the starting statement, and select items that were still outstanding. For a first-ever reconciliation, select the first statement instead. Confirm the setup only after reviewing the carry-forward items.

For later periods, LedgerHQ carries the last completed ending balance into the next session. Review it before entering the new statement ending balance.

The first-ever setup path lets you choose where reconciliation begins. Earlier imported transactions stay outside the reconciliation pool. See Start a bank reconciliation.

Clear Statement Transactions

Inside the active session, check the transactions that appear on the statement. The list includes every eligible posted transaction that has not been checked in a completed reconciliation, even when its date is outside the current statement period.

If a transaction is missing, check whether it is pending, unposted, coded to a different register, duplicated, or outside the statement period. Use Bank Feeds, Journal Entries, the register, or statement evidence to investigate.

Finish And Record The Result

Finish the session only when Difference is $0.00. LedgerHQ saves a completed snapshot with the balances, cleared rows, difference, and finish details. Rows left unchecked remain available for a later period.

If the firm intentionally accepts an unexplained amount, Book reconciliation discrepancy creates a real posted journal entry. It makes the session balance but does not explain the underlying cause.

Reconciliation does not certify that every transaction that should exist has been entered. It records what was checked against the statement and the resulting difference.

Review Unreconciled Activity

Each Bank Recs account card shows its Unreconciled count and amount. Choose View activity to open one list of eligible posted activity. A row stays there until you check it in a reconciliation. Its date does not move it into a separate bucket.

Light-theme Bank Recs showing an account's unreconciled count and amount

Use Open full register for the complete account history. If a completed reconciliation needs a correction, open it and choose Unlock reconciliation. Only the newest completed reconciliation can be unlocked.

Tally-Assisted Reconciliation

Tally can read statement evidence, build worksheets, and suggest matches. It does not finish reconciliations automatically. A person checks the rows and finishes the session at zero difference.

On this page