Module 03 · Everyday Digital Record-Keeping

How to Reconcile Your Bank Account Using Digital Statements

The matching is mostly automatic. The skill worth learning is what to do with the handful of lines that don't match anything.

6 min readLesson 6 of 13 in this moduleUpdated 2026-08-25

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:

Recording the bank fee found during reconciliation
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.

Doing this in Reyuko

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
  1. All transactions for the period are entered before you start.
  2. The e-statement is imported or the bank feed is connected for the right date range.
  3. Auto-matched items are spot-checked, not blindly accepted.
  4. Every unmatched line is sorted into: outstanding, in transit, or needs recording.
  5. Anything needing recording is entered and dated correctly.
  6. Adjusted bank balance and adjusted book balance are calculated and compared.
  7. The two adjusted balances match exactly — or the remaining gap is identified and being chased down.

Frequently asked questions

How do I import a bank statement for reconciliation?

Most bookkeeping software lets you either connect directly to your bank feed or upload a downloaded e-statement file, commonly CSV or OFX, from your online banking portal. Once imported, the software lines transactions up against your recorded entries so you can review and match them.

What is an unmatched transaction in bank reconciliation?

An unmatched transaction is one that appears on the imported bank statement but has no corresponding entry in your books, or the reverse. It needs to be investigated: either it's a transaction you forgot to record, a bank fee, or a duplicate that needs correcting.

Can I reconcile my bank account without downloading a statement?

Yes. Many bookkeeping tools connect directly to a live bank feed and pull transactions automatically without a manual download. A manual e-statement upload is still useful as a backup method, or for a bank that doesn't support a direct feed connection.

What causes differences between book and bank balances during reconciliation?

The most common causes are outstanding checks that haven't cleared, deposits in transit still processing, bank fees or interest not yet recorded in the books, and simple data entry errors. Reconciliation walks through each of these categories to explain the gap rather than leaving it unresolved.

How do you handle outstanding checks during bank reconciliation?

List any checks you've written that haven't yet cleared the bank as outstanding, and subtract their total from the bank statement balance when comparing it to your books. Once a listed check finally clears on a later statement, remove it from the outstanding list.

Is a bank fee found during reconciliation a mistake?

No. A bank fee, interest charge, or similar automatic bank transaction is normal — it simply hasn't been recorded in your books yet because the bank, not you, initiated it. Reconciliation is exactly the process that's supposed to surface it so you can record it.

Reconcile straight from an e-statement import

Reyuko imports your bank's CSV or Excel e-statement, auto-matches it against your ledger, and lets you post an unmatched line straight to a journal entry.

Download Reyuko freeSee what's included