What Is Bank Reconciliation?
Bank reconciliation is the process of comparing the transactions your company records in its own books against the transactions that show up on the bank statement, to confirm both add up to the exact same amount. When a difference shows up — a payment that hasn't landed yet, a fee nobody recorded, a check that's still outstanding — bank reconciliation is what lets you catch it before it turns into a cash-flow problem or an error in your financial statements.
For any business that moves money by transfer, deposit, or withdrawal every day, doing a bank reconciliation consistently isn't a paperwork chore: it's how you know, with certainty, how much money you actually have in the bank, not just how much your own records say you have.
What Is Bank Reconciliation For?
Beyond "making the numbers match," bank reconciliation serves very specific purposes inside a business:
- Catches your own errors, like a transaction entered twice, a mistyped amount, or a payment posted to the wrong account.
- Catches bank-side errors or charges, like an undisclosed fee, interest charged incorrectly, or a duplicate charge.
- Flags fraud early, including transfers a client claims to have sent but that never actually arrived, or charges the company never authorized.
- Gives you certainty about your real available balance, essential before committing to a large payment to a supplier or payroll.
- Is a basic internal-control requirement for audits, for getting bank credit, and for any serious monthly close process.
Without bank reconciliation, a company can operate for weeks believing it has a balance that no longer exists, or miss transfers that actually arrived but that nobody ever recorded in the system.
How to Do a Bank Reconciliation Step by Step
Doing a bank reconciliation always follows the same logic, whether your business handles a handful of transactions a month or hundreds:
- Gather the bank statement for the period you're reconciling (usually a month) and the internal accounting record for that same period, whether it lives in your accounting system, your ERP, or a spreadsheet.
- Compare transaction by transaction: every deposit, transfer, withdrawal, and charge on the statement against its counterpart in the accounting record.
- Mark the transactions that already match on both sides, so only the ones that don't line up are left visible.
- Identify the reconciling items, meaning transactions that show up on one side but not yet on the other: checks issued that the bank hasn't cashed, deposits in transit, or transfers that arrived but haven't been recorded yet.
- Investigate and fix every real difference, whether that means entering a missing transaction into your books, contacting the bank about an unrecognized charge, or following up on a payment a client insists they sent.
- Document the result of the reconciliation, including any differences left pending, so you have a record for a later audit or review.
- Repeat the process regularly: monthly at a minimum, and weekly or even daily if your business receives a high volume of transfer payments.
The end goal is always the same: the balance your books show and the balance your bank shows end up as the exact same number, with every difference explained rather than simply ignored.
Common Differences in a Bank Reconciliation
Nearly every difference that shows up in a bank reconciliation falls into a handful of recurring categories:
- Deposits in transit: money already recorded in your books because a client sent it, but that the bank hasn't reflected on the statement yet.
- Outstanding checks or payments: payments your company already issued and recorded, but that the payee hasn't cashed at the bank yet.
- Bank fees and charges the bank deducts directly from the account, which the company only records once it reviews the statement.
- Data-entry errors, like a transposed amount (recording $1,250 instead of $1,520) or a transaction posted to the wrong account or month.
- Transfers with incomplete references, where the money arrived but without enough detail to know which invoice or client it belongs to.
- Payment receipts that don't correspond to a real transfer, an increasingly common problem as the volume of transfer payments grows and an edited receipt slips through unnoticed.
The more transactions a company handles per month, the more these differences multiply, and the more time it takes to review each one by hand.
Manual vs. Automatic Bank Reconciliation
When a business only handles a handful of transactions a month, manual bank reconciliation — someone comparing the statement against a spreadsheet — works fine. The problem shows up with volume: reviewing a hundred or a thousand transactions by hand doesn't just take hours, it also raises the odds that a data-entry error slips through unnoticed, precisely because the process depends on a person not making a single mistake across hundreds of lines.
Automatic bank reconciliation solves this with software that imports the bank statement and the accounting record, matches transactions automatically by amount, date, and reference, and leaves only the real, unmatched differences for a human to review. Instead of checking a thousand lines, the accounting team only has to look at the five or ten that actually need attention.
How to Automate Bank Reconciliation with OCR and CEP
The slowest part of reconciling transfer payments is almost never comparing figures that are already sitting in a system: it's manually entering the data from every receipt a client sends over email or WhatsApp, as an image or a PDF. That's where OCR (optical character recognition) changes the process entirely.
An automatic bank reconciliation system built on OCR reads the receipt a client sends, extracts the tracking key (clave de rastreo), amount, date, and issuing bank without anyone typing it in, and validates that data directly against the CEP (Comprobante Electrónico de Pago) issued by Banco de México — the process we cover in full in our guide on how to validate a SPEI transfer with the CEP. If the receipt matches Banxico's official record, the system reconciles the transaction automatically; if it doesn't, it flags the transaction as pending before the payment is treated as good.
This combination of OCR and CEP validation solves two problems in manual bank reconciliation at once: the time it takes to enter data by hand, which we cover in our guide on what OCR is, and the risk of treating an altered receipt as valid when it never actually settled in the payment system.
Bank Reconciliation Example
A simple example helps show how the whole process connects. Say that at month-end your books show a balance of $850,000 pesos, but the bank statement shows $832,000 pesos. Comparing transaction by transaction, you find the following:
- A client transfer for $20,000 pesos already recorded in your books, but that the bank hasn't reflected yet because it processed on the last day of the month (a deposit in transit).
- A $2,000-peso bank fee the bank deducted directly from the account, but that nobody had entered into the accounting system yet.
Adjusting for both items — adding the deposit in transit and subtracting the unrecorded fee — the two balances end up matching exactly: $850,000 pesos minus the $2,000 fee, meaning $848,000 pesos actually available. That's the number that should be documented as the reconciled balance, not the figure either record originally showed on its own.
Frequently Asked Questions
How often should I do a bank reconciliation?
At least once a month, at the accounting close. If your business receives a high volume of transfer payments or manages several bank accounts, it's worth reconciling weekly or even daily to catch differences before they pile up.
What happens if I don't do bank reconciliation?
You run the risk of operating on a balance that no longer actually exists, missing unrecognized fees or charges, and failing to catch a fake payment receipt or a transfer that never actually settled until it's too late.
What documents do I need to do a bank reconciliation?
The bank statement for the period and the internal accounting record for that same period, with the detail for every transaction: date, amount, reference, and description.
Does automatic bank reconciliation replace an accountant?
No. The software handles matching the transactions that already agree and flagging the ones that don't, but the final review of real differences still requires a person with accounting judgment.
How does bank reconciliation relate to validating SPEI receipts?
A large share of the differences in a bank reconciliation come from transfers that were recorded incorrectly or from receipts that don't correspond to a real payment; validating every transfer against Banxico's CEP before reconciling cuts down on that type of difference at the source.
If your team spends hours every month comparing the bank statement against your books by hand, at AISDC we build automatic transfer reconciliation with OCR that reads every receipt, validates it against Banxico's CEP, and leaves only the differences that actually matter ready for review.