To reconcile a bank account with a digital statement, import or connect the bank's e-statement, then match each line against your recorded transactions. Software auto-matches most items instantly; anything left over — an uncleared check, a fee, a missed entry — gets investigated and resolved until book and bank balances agree. The steps are the same whether the statement arrives as a CSV download or a live bank feed.
Key takeaways
- Reconciling with an e-statement means importing or connecting the bank's digital statement, then matching each line against your recorded transactions.
- Most matching happens automatically. Your actual job is the leftovers — outstanding checks, deposits in transit, bank fees, and missed entries.
- Timing differences explain most of the gap between your book balance and your bank balance. They're normal, not errors.
- A reconciliation isn't finished until every unmatched item is either recorded in your books or listed as a known, explained difference.
- You're checking that the adjusted balances agree, not that the raw statement total matches your raw ledger total.
What you need before you start
Two things have to be in place, or the matching step won't work well:
- Your recorded transactions are up to date. If half of last week's sales and purchases aren't entered yet, the software has nothing to match the statement against, and you'll spend the session recording transactions instead of reconciling them. Same-day entry is what makes this step fast.
- A digital copy of the statement. Most banks offer a CSV or OFX download from online banking for a chosen date range, and many bookkeeping apps also support a direct bank feed that pulls transactions without a manual download at all.
If this is your first time reconciling this account, confirm your starting book balance and starting bank balance actually agreed as of some date in the past — otherwise you're reconciling forward from an already-wrong number. If you're not yet sure how often to run this whole process, how often a small business should reconcile is worth reading before your first session.
Step 1: Get the digital statement into your books
Download the statement for the period you're reconciling — typically the same range as your last bank statement — and import the file, or connect the live feed if your software supports it. On import, most tools show you a preview of every line before committing anything, which is worth a quick scan for an obviously wrong date range or a duplicate upload.
Step 2: Let the software match what it can
Once imported, the software lines up each bank transaction against your recorded entries by date and amount and flags the pairs it's confident about. In a typical month, this auto-matching clears the large majority of transactions — regular supplier payments, recorded sales, standing transfers — without you touching them individually.
Your job at this stage is to review the matches, not re-do them. Spot-check a handful, especially any the software marked as a "likely" match rather than an exact one, since a close-but-wrong match (same amount, different vendor) is the kind of error that's easy to wave through.
Step 3: Work through the unmatched transactions
What's left after auto-matching falls into a small number of predictable categories:
| Type | What it means | What to do |
|---|---|---|
| Outstanding check | You wrote it, the payee hasn't cashed it yet | List it, wait for it to clear on a future statement |
| Deposit in transit | You recorded and deposited it, the bank hasn't processed it yet | List it, confirm it clears next period |
| Bank fee or interest | The bank moved money you haven't recorded | Record it now as a new transaction |
| Missing entry | A real transaction you simply forgot to enter | Record it now |
| Duplicate or error | The same transaction was entered twice, or the wrong amount was keyed in | Correct the entry |
An unmatched line isn't automatically a mistake — most of the time it's a timing difference, not an error. What bank reconciliation actually catches is the useful background here if the distinction between "explained" and "wrong" isn't clear yet.
Step 4: Record or explain every leftover item
Take each unmatched line to a conclusion. Outstanding checks and deposits in transit go on a reconciling list — you're not recording anything new, just noting that they'll clear later. Bank fees, interest, and anything you genuinely forgot to enter need a new transaction now, dated the same day the bank moved the money.
A worked example makes the difference concrete. Driftwood Supply Co.'s ledger shows a bank balance of $8,520 at month end. The bank's e-statement shows $9,150.
| Item | Amount |
|---|---|
| Book (ledger) balance | $8,520 |
| Bank statement balance | $9,150 |
| Outstanding checks (#204, #206) | $800 |
| Deposit in transit | $150 |
| Bank fee, not yet recorded | $20 |
Two outstanding checks total $800 — written, not yet cashed. A $150 deposit made on the last day of the month hasn't posted to the bank yet. And the bank charged a $20 monthly fee that isn't in the books at all.
Adjusted bank balance: $9,150 − $800 (outstanding checks) + $150 (deposit in transit) = $8,500. Adjusted book balance: $8,520 − $20 (bank fee, now recorded) = $8,500.
The two adjusted balances agree at $8,500. That $20 fee is the one item that actually needed a new entry:
| Account | Debit | Credit |
|---|---|---|
| Bank Fees Expense | $20 | |
| Bank | $20 |
The outstanding checks and the deposit in transit don't get journal entries yet — they're not new transactions, just items still working their way through the bank's side of the process. This is also a good moment to attach the bank's own fee notice or statement excerpt to the new entry, the same way you would any other receipt — it's what turns "a $20 fee I noticed" into evidence someone else can verify later.
Confirm the balances actually agree
Reconciliation is complete when the adjusted bank balance and the adjusted book balance are the same number, and every difference between the raw statement total and your raw ledger total is either recorded or sitting on a reconciling list with a clear reason. If they still don't match after working through every unmatched line, don't force it — an unexplained gap almost always means one more transaction is still missing, duplicated, or keyed in at the wrong amount, and it's easier to find while the period is fresh.
A completed reconciliation, with its statement, matches, and any new entries kept together, is also a real piece of your audit trail — proof, month by month, that the cash side of your books was actually checked against an independent source, not just typed in and left alone. It's the same underlying process a set of double-entry books calls bank reconciliation, whether or not the software you use shows you a single debit and credit.
Reyuko's Bank Reconciliation module (Accounting → Bank Reconciliation) does the mechanical part of this walkthrough directly. It accepts a CSV or Excel e-statement import, runs an automatic matching pass against your recorded transactions, and leaves you to review and manually tick-match anything it isn't confident about.
For the leftovers, there's a "Create Journal" action right on an unmatched statement line — for a bank fee, interest, or an unreferenced transfer, you post the entry and match it to that line in one step, instead of switching screens to the General Journal and back. Outstanding checks and deposits in transit simply stay visible as unmatched until they clear on a later import.
Bank Reconciliation is part of the core ledger, so it's available on Reyuko's free plan — no upgrade needed to reconcile this way.
A quick reconciliation checklist
Show the checklist
- All transactions for the period are entered before you start.
- The e-statement is imported or the bank feed is connected for the right date range.
- Auto-matched items are spot-checked, not blindly accepted.
- Every unmatched line is sorted into: outstanding, in transit, or needs recording.
- Anything needing recording is entered and dated correctly.
- Adjusted bank balance and adjusted book balance are calculated and compared.
- The two adjusted balances match exactly — or the remaining gap is identified and being chased down.
Reyuko