What bank reconciliation means
On paper, the cash balance in a company’s general ledger should equal the balance its bank reports. In practice, the two rarely agree on any given day. Payments clear on the bank’s timeline rather than the company’s, deposits post after they are recorded internally, and the bank applies its own fees, interest and adjustments that finance has not booked yet.
Reconciling the two answers a single question: is the cash the company says it has the cash it actually has? Once the book balance and the bank balance are adjusted for those known differences and still fail to agree, the remaining gap points to something worth investigating, such as a duplicate payment, a missing entry or, occasionally, fraud. Finance teams shorten the term to “bank rec” and also call it book-to-bank reconciliation or bank statement reconciliation.
Why bank reconciliation matters
Cash is the account most exposed to error and misappropriation, which is why bank reconciliation is treated as a control and not just bookkeeping. It is usually one of the first tasks of the month-end close, because later reconciliations and reports rely on a confirmed cash balance. US public companies subject to the Sarbanes-Oxley Act (SOX) typically include the cash reconciliation and its independent review among their internal controls over financial reporting, performed on a fixed cadence rather than left until year-end.
The person who prepares the reconciliation should not be the person who handles cash receipts or signs payments, and a second person reviews and approves it. That separation of duties turns the comparison into evidence. A business with hundreds of accounts across currencies and subsidiaries reconciles each one separately, so the process depends on consistent rules more than on one-off spreadsheet checks.
How to do a bank reconciliation
Most teams follow the same five-step bank reconciliation process, adjusting each side until the two balances meet:
- Set the starting balances. Record the ending bank balance from the statement and the ending book balance from the cash ledger for the same date.
- Adjust the bank side. Add deposits in transit and subtract outstanding checks the bank has not processed yet.
- Adjust the book side. Record items the bank already knows about but the ledger does not, such as service fees, interest and NSF checks.
- Compare the adjusted totals. The corrected bank balance and the corrected book balance should now match.
- Resolve and approve. Investigate any remaining difference, post the adjusting journal entries and have a reviewer sign off.
Bank reconciliation formula
The bank reconciliation formula works on two sides that must end at the same number. On the bank side, the adjusted bank balance equals the balance per bank statement, plus deposits in transit, minus outstanding checks, plus or minus any bank error. On the book side, the adjusted book balance equals the balance per books, plus collections and interest the bank credited but the company has not recorded, minus bank fees and NSF checks, plus or minus any book error.
Only the book-side items need a journal entry. The bank has already recorded a fee or an NSF check, so the company’s ledger is the record that is missing it. Bank-side items, such as a deposit in transit, are already in the books and will clear the bank in a later period; they only need follow-up if they never clear, as happens with a stale check.
Bank reconciliation example
Suppose a company’s cash ledger shows a closing balance of $89,300, while the bank statement reports $90,500, a $1,200 difference to reconcile.
On the bank side, a $2,000 deposit in transit arrived on the last day of the month but posts the next business day, and $3,500 in outstanding checks to suppliers have not cleared. On the book side, the bank charged a $300 service fee that finance has not yet recorded.
| Reconciling item | Bank side | Book side |
|---|---|---|
| Ending balance | $90,500 | $89,300 |
| Add: deposit in transit | $2,000 | |
| Less: outstanding checks | ($3,500) | |
| Less: bank service fee | ($300) | |
| Adjusted balance | $89,000 | $89,000 |
After adjusting the bank balance for the deposit and the uncleared checks, and the book balance for the fee, both sides land on the same adjusted balance of $89,000. The fee is the only item that needs an entry: debit bank service charges expense for $300 and credit cash for $300. The reconciliation ties out and the account is ready for review.
What a bank reconciliation statement shows
A bank reconciliation statement is the document that records the reconciliation for one account and one date. It shows the balance per bank and the balance per books, each reconciling item on its side, the two adjusted balances and any difference still unexplained. The table in the example above is a simple version; a complete statement also names the preparer and the reviewer and lists the items expected to clear next period.
What causes bank statement discrepancies
Most differences fall into two buckets: timing differences that resolve on their own, and true errors that need a correcting entry.
- Deposits in transit: cash recorded internally but not yet posted by the bank.
- Outstanding checks: payments issued that have not cleared.
- Bank fees and interest: amounts the bank applies before finance records them.
- NSF checks: deposits reversed because the payer’s account lacked funds.
- Recording errors: transposed digits, duplicate entries or postings to the wrong account, on either side.
Bank deposits that come from payment processors
When a company sells through a card processor or a payment service provider, a bank deposit rarely equals the sales behind it. The processor settles a batch days after the sales, deducts its fees and nets out refunds and chargebacks, so one deposit can cover hundreds of sales from different dates.
The deposit closes when the team adds a third record: the processor’s settlement report. Sales are matched to the settlement report, and the settlement report is matched to the bank deposit, which shows fees, refunds and chargebacks as separate reconciling items instead of one unexplained gap. That transaction-level comparison is the subject of transaction reconciliation.
Manual vs. automated bank reconciliation
As volume climbs, hand-matching in spreadsheets becomes a bottleneck, and teams start comparing bank reconciliation software. The real difference is how matching, exceptions and changes are controlled:
| Dimension | Manual (spreadsheets) | Configured reconciliation platform |
|---|---|---|
| Data collection | Statements and exports pasted in by hand | Bank files and ledger exports ingested and normalized, including formats and dates |
| Matching | Line by line, every close | Configured rules and tolerances, one-to-one, one-to-many or many-to-many |
| Exceptions | Tracked in notes or colored cells | Unmatched records kept as pending items with an owner and a logged action trail |
| Changes to the logic | Formulas edited in place | Rule changes prepared in a draft and approved before they affect results |
| Evidence | File versions and email threads | Trace from the raw record to the final result |
How Simetrik supports bank reconciliation
Simetrik is an AI-native reconciliation and financial control platform. For Simetrik, the bank statement is one source among several: it works on the transaction and operational data underneath the cash balance, from bank files to processor settlement reports and internal records. Comparing those records at transaction level explains a deposit before it reaches the ledger as an unexplained difference. The same transaction-level view supports treasury reconciliation across accounts, banks and entities.
In Simetrik, the team loads the bank and internal records through integrations with ERPs, banks and processors and configures matching rules, tolerances and approval flows. The deterministic engine applies those rules: with the same inputs and the same rules, it produces the same result every time, with a trace from the raw record to the final result. Records that do not match stay as pending items for review, and every action on them is logged.
Simetrik’s AI works around that engine. It suggests matching rules for the team to approve before they run, and its anomaly detection flags operational and data quality problems, such as a drop in the share of records that match. Deciding how to treat a difference, and signing off the reconciliation, stays with the finance team.