Bank reconciliation: how to match bank transactions to invoices and receipts
A bank reconciliation step by step: match each bank line to its invoice, bill or receipt, handle split payments and fees, and list what is missing.
Free app. Runs on your Mac with the Claude or Codex plan you already have.
What a bank reconciliation is
A bank reconciliation compares the transactions on the bank statement with the company's own records and explains every difference. Each bank line is tied to the invoice, bill or receipt behind it, and every line that cannot be tied becomes a question to answer. At the end, the adjusted book balance agrees with the bank balance. It is usually done for each bank account every month, and it is one of the first tasks of the month-end close.
Most bank lines match one document and take seconds. The work is in the rest: payments covering several invoices, part payments, bank fees, transfers and deposits nobody can explain. The method below is how a bookkeeper does it by hand. Each step says what to do and why, then how 10folds handles the matching part. Unlike most accounting work, it has a clear finish line: either the balances agree or a difference is left to explain.
What it does for the business
- Books you can rely onWhen every bank line is tied to a document, the cash, receivables and payables in your accounts reflect what really happened. Reports built on those accounts can then be trusted.
- Errors found earlyDouble charges, payments to the wrong supplier and unexplained withdrawals show up as unmatched transactions in the month they happen. Found early, they are far easier to recover.
- A faster month-end closeThe bank is the first account to reconcile at month end. Matching it regularly leaves only the hard cases for the close. The rest of the close can then rely on confirmed cash figures.
- Missing receipts found while they can still be foundListing card spending with no receipt each month gives people a chance to find the receipt before it is lost. It also shows which people or suppliers most often leave documents missing.
Bank reconciliation, step by step
Set the basis for matching
Before matching anything, agree what each number means.
What to do
- Get the bank statement or export for the period, and the open invoices, bills and receipts.
- Confirm the bank account, the legal entity, the currency and the period.
- Check the signs and units: whether money in is positive, and whether amounts are in cents.
- Start from the balance agreed at the last reconciliation.
- Remove documents already paid, voided or reconciled from the candidates.
Why
A wrong sign or unit makes every comparison fail, and a wrong opening balance carries an old error into the new month. Removing settled documents stops one payment from being matched twice. Stable IDs matter because row numbers change between exports, and a match recorded against a row number can point to the wrong line next time.
Match one to one, on more than the amount
Two invoices for the same amount are common, so the amount alone proves nothing.
What to do
- Match a bank line to a document when the reference, the counterparty and the exact amount agree.
- Check the direction: money in goes to customer invoices, money out to bills and receipts.
- Treat a counterparty and amount match without a reference as a candidate to review.
- Watch for a document dated after the payment.
Why
Transaction matching on amount alone is the classic error: two customers owe the same sum and the wrong one is marked paid. Requiring the reference makes each match defensible. Card payments and online transfers often carry a reference; cash and check deposits often do not, and those need more care.
Handle split payments, fees and transfers
One payment covering three invoices must add up to the cent.
What to do
- Use the remittance advice to allocate a batch payment across its invoices.
- Check that the allocations equal the bank line exactly, and that no invoice receives more than its balance.
- Treat bank fees, exchange differences, discounts and refunds as separate reconciling items, each with its own entry.
- Pair transfers between your own accounts so both sides appear.
Why
A difference forced to zero hides a short payment or an unrecorded fee. Each reconciling item needs its own cause, so the books show what happened. Remittance advice, the note a customer sends saying which invoices a payment covers, is the best evidence for splitting a payment.
Recheck earlier decisions
A match confirmed last month is evidence, and evidence can change.
What to do
- Keep a record of the matches you confirmed or rejected, with the date.
- When a document or bank line changes, look at its match again.
- Keep rejected pairs rejected until you change the decision.
Why
Re-exports change data: an invoice is credited, a payment is reversed. A record of decisions saves time and catches the cases where an old match no longer holds. Without a record, someone has to remember why an odd-looking match was accepted, and that knowledge leaves with them.
Clear the queue and finish the reconciliation
Missing is not paid.
What to do
- Give every unmatched transaction one next action: find the document, ask the customer, ask the cardholder.
- Note outstanding checks and deposits in transit: items in your books that are not yet on the bank statement.
- Record bank fees and interest in your books.
- Check that the adjusted book balance equals the bank statement balance, and keep the reconciliation as a record.
Why
Timing items such as outstanding checks and deposits in transit explain most differences. Whatever remains after them is an error or a missing entry, and it needs an answer before the period is closed. Keep the finished reconciliation with its evidence, because an auditor or a new bookkeeper will ask for it.
Common mistakes
- Matching on amount aloneTwo documents for the same sum are common, so check reference and counterparty too.
- Plugging differencesA small difference written off may be a fee, a short payment or a duplicate.
- Treating a missing document as paidIf it is absent from the export, ask for it.
- Ignoring the opening balanceAn error left from last month carries into this one.
- Reconciling only at year endTwelve months of differences are far harder to explain than one, and the documents are harder to find.
What a good result looks like
- Every bank line with a match, a list of candidates, or a next action.
- Each match with its reason and its source evidence.
- Split payments that add up exactly to the bank line.
- Fees, transfers and differences listed as open items, each with a cause to find.
- Missing documents and receipts listed, so they can be requested.
And then what? Using the result
- Review the proposed matches and confirm or reject each one.
- Ask cardholders and customers for the missing documents.
- Record fees and interest in your accounting software.
- Complete the reconciliation in your accounting software and lock the period.
- Keep your confirmed decisions for the next run.
When to run it
- Every month, before the closeThe bank is the first account to reconcile, and much of the close depends on it. Receivables, payables and the cash forecast all start from it.
- Every week, with many transactionsSmall batches are quicker to clear, and missing receipts are easier to find while they are recent. It also spreads the work evenly across the month.
- When the books have fallen behindProposed matches and a review queue turn a backlog of bank lines into a list of specific questions. Work from the oldest month forward, so each month starts from a confirmed balance.
- Before handing the books to an accountantA reconciled bank account with a short list of open items saves your accountant from rebuilding the year from statements.
Questions people ask
What is a bank reconciliation?
It is the comparison of your bank statement with your own records, explaining every difference so that the adjusted book balance agrees with the bank. It shows whether every transaction has been recorded once and correctly.
What are the steps of a bank reconciliation?
Set the period and opening balance, match bank lines to documents, handle split payments, fees and transfers, list outstanding checks and deposits in transit, and confirm the adjusted balances agree. Then keep the reconciliation as a record.
How often should you reconcile your bank account?
At least monthly, before the month-end close. Weekly works better when there are many transactions. Monthly also matches the bank statement, which gives a fixed balance to agree to.
Why doesn't my bank balance match my books?
Usually because of timing: outstanding checks and deposits in transit. Next come bank fees and interest not yet recorded. What remains is an error, a duplicate or a missing entry. Work through those in order, and whatever is left is the real question.
Does 10folds complete the bank reconciliation?
No. It proposes matches, explains each one, and gathers unclear lines and missing documents into one review queue for a person in finance. You confirm the matches and complete the reconciliation in your accounting software; nothing is posted and no invoice is marked paid.
How many transactions can one run handle?
Up to 2,000 bank lines and 5,000 invoices, bills or receipts per run. Each run produces proposals for your review; nothing is posted to your books.
More jobs in Finance
Match bank transactions to invoices and receipts, on your own Mac.Free app. Runs on your Mac with the Claude or Codex plan you already have. Your files stay on your computer.
Download for Mac