Sage Bank Reconciliation: A Beginner’s Guide

Sage bank reconciliation compares the cash transactions recorded in Sage with the transactions cleared by a bank through a specific statement date. A complete reconciliation explains the difference between the statement balance and the book balance using valid outstanding items and supported corrections.

Sage Accounting, Sage 50, Sage 100, Sage 200, Sage 300, Sage X3, and Sage Intacct have different screens and terminology. Use the current help for your exact product, country, version, bank-feed connection, and permissions. Do not follow Sage 50 instructions in Sage 300 merely because both products use the Sage name.

What you need before starting

• The complete bank statement, including ending date and ending balance.
• Access to the correct Sage company, cash account, and reconciliation period.
• All bank, receipt, payment, transfer, payroll, card, fee, interest, and processor activity posted through the cutoff.
• Prior reconciliation report and unresolved outstanding-item list.
• Support for missing, duplicated, altered, or unusual transactions.

If the opening reconciliation balance does not agree to the prior completed report, stop and investigate before clearing current transactions. A changed opening point can indicate prior-period edits, deleted entries, an incorrect account, or a reconciliation that was not finalized as expected.

1. Confirm the account and statement cutoff

Select the cash or bank account that corresponds to the statement. Enter the statement ending date and balance exactly as presented, subject to the product’s workflow. The cutoff determines which cleared transactions belong in the reconciliation.

Do not use today’s online balance as a substitute for a period-end statement unless the reconciliation is intentionally for today and you have a complete activity record. Available balance may also differ from ledger or statement balance because of holds and pending items.

2. Finish recording book activity

Record missing bank fees, interest, electronic withdrawals, deposits, transfers, returned payments, payroll withdrawals, and other activity through the statement date. Use the proper source module where possible so customer, vendor, payroll, and control-account detail remains aligned.

Match payment-processor payouts to their gross sales, refunds, fees, reserves, and settlement timing. Recording only the net deposit can cause both revenue and fee errors.

3. Match cleared transactions

Compare each statement transaction with Sage using date, amount, payee or customer, reference, and transaction type. Mark only transactions that genuinely cleared the bank during the statement period.

Automated matching can accelerate the process but still needs review. A same-dollar amount is not sufficient when multiple checks, transfers, or deposits share an amount. Confirm identity and watch for duplicates.

4. Understand outstanding items

Outstanding does not mean ignored. Review aging and follow up on old checks, deposits, and transfers. Any correction should preserve the original support and approved reasoning.

5. Resolve the reconciliation difference

The goal is a zero unexplained difference, not a zero produced by an arbitrary adjustment. If the screen does not reconcile, test the following:

1. Recheck the statement ending date and balance.
2. Confirm the correct Sage cash account and company were selected.
3. Look for transposed digits, signs, or decimal errors.
4. Search for missing bank activity and duplicate book entries.
5. Review transactions cleared against the wrong statement.
6. Compare the opening balance with the prior reconciliation.
7. Check prior-period edits, voids, deletions, reversals, and imported transactions.
8. Confirm report filters and posting status.

A temporary reconciliation adjustment can hide a real problem and carry it into every later period. Use an adjustment only when its nature, account, date, amount, approval, and future resolution are documented.

6. Review before finalizing

Review the cleared count and total, outstanding checks, deposits in transit, old items, adjustments, and the relationship between adjusted bank and book balances. Compare unusual payees, electronic withdrawals, transfers, and round-dollar transactions with source records.

Where staffing allows, a person who did not initiate payments should review the bank statement and reconciliation. A small business can add compensating controls such as owner review, bank alerts, restricted payment permissions, and documented approval.

7. Save the reconciliation

Finalize the reconciliation according to the product workflow and save or export the report. Retain the statement, reconciliation summary, outstanding-item detail, adjustments, and reviewer sign-off in the month-end folder.

Be cautious with edits after completion. If the product allows a prior transaction to be changed, document the effect on the completed reconciliation and rerun the affected reports. Use the product-specific undo or correction procedure only after confirming the consequences.

Restrict who can change reconciled transactions, reconciliation status, or the cash account mapping. Review the product audit or activity records when a completed reconciliation changes unexpectedly.

Also compare the saved report total with the general-ledger cash balance for the same date and posting status.

Illustrative reconciliation

Assume the bank statement ends at $31,400. Sage shows $29,900 before reconciliation. The business identifies a $2,300 deposit recorded in Sage that cleared after the statement date, a $900 outstanding check, and a $100 bank fee appearing only on the statement.

After recording the $100 fee in Sage, the book balance becomes $29,800. The statement balance adjusted for the $2,300 deposit in transit and $900 outstanding check is also $32,800, not $29,800, so the reconciliation is still off by $3,000. This means the listed timing items do not yet explain the difference. The bookkeeper must continue investigating rather than force an adjustment.

This example intentionally shows a failed first pass. A useful reconciliation proves the relationship; it does not merely list plausible items.

When Sage reconciliation is out of balance

For a Sage 100 bank reconciliation out of balance, a Sage 50 opening balance problem, or a Sage 300 posting difference, start with the exact product’s reports and help. Export the transaction list, prior reconciliation, current statement activity, and general-ledger cash detail. Compare them by transaction identifier, date, amount, posting source, and cleared status.

If a bank-feed import duplicated activity, correct the duplicate in the appropriate workflow. If a posted transaction was changed after reconciliation, preserve the audit evidence and follow the approved correction process. If the general-ledger cash account differs from the bank-reconciliation module, investigate direct GL entries and posting status.

Monthly reconciliation checklist

• Correct company, bank account, statement date, and ending balance.
• Prior ending reconciliation agrees to the current opening point.
• All statement activity is recorded through cutoff.
• Cleared transactions match by identity, not amount alone.
• Outstanding checks and deposits are valid and reviewed for age.
• No unexplained adjustment is used to force the result.
• General-ledger cash agrees to the reconciliation module.
• Statement, report, support, and reviewer sign-off are retained.

For a product-neutral explanation, see how to reconcile a bank statement. Continue with the Sage month-end guide after cash is reconciled. Businesses needing recurring support can review bookkeeping services.