How to Prepare a Bank Reconciliation: A Step-by-Step Accounting Guide

A bank reconciliation compares the cash balance in an organization’s accounting records with the balance reported by the bank. The two amounts often differ temporarily because checks have not cleared, deposits are in transit, fees and interest have not yet been recorded, or an error appears in one set of records. Reconciliation explains those differences and produces an adjusted balance that should agree on both sides.

This guide presents a practical reconciliation workflow for small businesses, bookkeepers, students, and account owners. It explains the documents required, the treatment of outstanding items, journal entries, common errors, internal controls, and the methods used to investigate an unexplained difference without forcing the accounts to balance.

Understand the Purpose and Gather the Right Documents

Reconciliation verifies that recorded cash activity agrees with external bank records, identifies missing entries, and helps detect duplicate payments, unauthorized activity, posting errors, or stale items. It is a control process, not merely an accounting exercise. Regular completion supports accurate financial statements and gives management a more reliable view of available cash.

This detail matters because financial systems often treat small differences as material. Before you continue, compare the information on screen with an official statement, cardholder agreement, or support page. If anything is unclear, pause rather than guessing. A short verification step is usually easier to correct than a payment, withdrawal, or authorization that has already been processed.

Gather the complete bank statement, general ledger or cash account detail, prior reconciliation, deposit records, check register, electronic-payment reports, merchant-settlement records, and supporting documents for unusual transactions. Use the same cutoff date on both sides. Beginning with incomplete or mismatched periods is a common reason a reconciliation becomes confusing.

Use a deliberate workflow instead of moving quickly through the screens. Read each label, review any fee or timing notice, and keep the confirmation page or receipt. People often focus only on completing the task and overlook a cutoff time, daily limit, account type, or eligibility rule that later explains why the result was different from what they expected.

Reconcile the Bank Statement Balance

Start with the ending balance shown on the bank statement. Add deposits recorded in the books before the statement date that the bank had not yet credited. These deposits in transit should be supported by deposit records and should normally appear on the next statement or online activity after the cutoff.

The safest approach is to use the institution’s official app, website, telephone number, or physical location. Search advertisements, unsolicited messages, and third-party support numbers can lead to impersonation scams. Never reveal a password, full PIN, or one-time security code to someone who contacted you unexpectedly, even when the caller ID appears familiar.

Subtract checks and electronic payments recorded in the books that had not cleared by the statement date. Use the prior reconciliation to identify items that remain outstanding and investigate old payments rather than carrying them forever. Also adjust for a verified bank error, but do not record a journal entry for the bank’s error unless your books are independently wrong.

Document the important details as you go. Record the date, amount, account involved, reference number, and any instructions you received. Good records are especially valuable when a transaction is delayed, returned, disputed, or reviewed for fraud. They also help a customer-service representative understand the issue without asking you to reconstruct the entire sequence from memory.

Reconcile the Ledger or Book Balance

Start with the ending cash balance in the accounting system. Record bank service charges, wire fees, merchant fees, check-printing charges, interest income, automatic debits, automatic credits, and returned customer payments that the bank recorded but the books did not. Each adjustment needs a clear account classification and supporting evidence.

Policies vary among banks, card issuers, countries, and account types. A method that works for one customer may be unavailable to another, so treat examples as a framework rather than a guarantee. Your own disclosure, agreement, or in-app notice controls. Confirm current limits and fees before depending on the money for an urgent purchase or deadline.

Correct bookkeeping errors such as a transposed amount, duplicate entry, payment posted to the wrong bank account, or deposit recorded for the wrong value. Enter journal entries with the correct date and explanation. Do not edit a reconciled historical period casually; follow the organization’s closing and audit procedures when a prior-period correction is required.

Think about the alternative before accepting an expensive or irreversible option. A branch visit, standard bank transfer, in-network ATM, direct transfer, or written authorization may take longer but cost less and create a clearer paper trail. Convenience is useful, but it should not replace checking the total cost, timing, and consequences of the transaction.

Video Lesson: Bank Reconciliation Example

Watch this video directly on YouTube if the embedded player does not appear.

Match Transactions Efficiently

Match items using date, amount, check number, payee, payer, and bank reference. Electronic transactions can settle under abbreviated descriptions that differ from the vendor name in the ledger, so maintain a map of recurring bank descriptions. Many accounting systems suggest matches, but the preparer must verify that the suggestion is correct.

If the expected result does not appear, avoid repeating the transaction immediately. First check whether it is pending, whether a receipt or confirmation was generated, and whether your available balance already reflects a hold. Duplicate attempts can create multiple charges or deposits. Contact the institution with the reference number when the status remains uncertain.

Work systematically rather than jumping between unmatched items. Mark all exact matches first, then investigate differences. For batched deposits, compare the total to the merchant processor or deposit detail. For payroll and card settlements, reconcile the gross amount, fees, and net bank deposit so a single net figure does not hide missing expense entries.

This detail matters because financial systems often treat small differences as material. Before you continue, compare the information on screen with an official statement, cardholder agreement, or support page. If anything is unclear, pause rather than guessing. A short verification step is usually easier to correct than a payment, withdrawal, or authorization that has already been processed.

Investigate an Unexplained Difference

Calculate the remaining difference and look for clues. A difference divisible by nine can suggest transposed digits. A difference equal to a known transaction may indicate omission or duplication. Compare the current outstanding list with the prior month, search the bank activity for the exact amount, and review entries posted near the cutoff date.

Use a deliberate workflow instead of moving quickly through the screens. Read each label, review any fee or timing notice, and keep the confirmation page or receipt. People often focus only on completing the task and overlook a cutoff time, daily limit, account type, or eligibility rule that later explains why the result was different from what they expected.

Do not create a plug entry simply to make the adjusted balances agree. A forced adjustment can hide fraud, an unrecorded liability, a duplicate payment, or an incorrect account classification. Escalate unresolved differences according to policy, document the work performed, and keep the reconciliation open until the cause is identified or formally approved for treatment.

The safest approach is to use the institution’s official app, website, telephone number, or physical location. Search advertisements, unsolicited messages, and third-party support numbers can lead to impersonation scams. Never reveal a password, full PIN, or one-time security code to someone who contacted you unexpectedly, even when the caller ID appears familiar.

Apply Strong Internal Controls and Review

Whenever practical, the person reconciling the account should not be the same person who receives cash, issues payments, and approves journal entries. Separation of duties reduces the opportunity for an error or unauthorized transaction to remain concealed. Small organizations can compensate with owner review, bank alerts, dual approval, and direct access to statements.

Document the important details as you go. Record the date, amount, account involved, reference number, and any instructions you received. Good records are especially valuable when a transaction is delayed, returned, disputed, or reviewed for fraud. They also help a customer-service representative understand the issue without asking you to reconstruct the entire sequence from memory.

A reviewer should inspect the bank statement, adjusted balances, old outstanding items, unusual reconciling items, and journal entries. The review should be evidenced with a date and approval. Reconciliations should normally be completed monthly and more frequently for high-volume or high-risk accounts. Delayed reconciliation weakens the control and makes investigation harder.

Policies vary among banks, card issuers, countries, and account types. A method that works for one customer may be unavailable to another, so treat examples as a framework rather than a guarantee. Your own disclosure, agreement, or in-app notice controls. Confirm current limits and fees before depending on the money for an urgent purchase or deadline.

Video Lesson: Seven-Step Bank Reconciliation

Watch this video directly on YouTube if the embedded player does not appear.

Use Software Wisely and Retain Evidence

Bank feeds and reconciliation modules can speed matching, but they do not replace judgment. Confirm the opening balance, statement date, and statement ending balance before reconciling. Avoid accepting suggested matches when dates or amounts differ materially, and understand how the software handles deleted, duplicated, or edited transactions after reconciliation.

Think about the alternative before accepting an expensive or irreversible option. A branch visit, standard bank transfer, in-network ATM, direct transfer, or written authorization may take longer but cost less and create a clearer paper trail. Convenience is useful, but it should not replace checking the total cost, timing, and consequences of the transaction.

Retain the statement, reconciliation report, list of outstanding items, journal entries, explanations, and reviewer approval according to the organization’s record-retention policy. A clean file enables future staff, auditors, tax professionals, and management to understand why the adjusted balance was accepted and how unusual transactions were resolved.

If the expected result does not appear, avoid repeating the transaction immediately. First check whether it is pending, whether a receipt or confirmation was generated, and whether your available balance already reflects a hold. Duplicate attempts can create multiple charges or deposits. Contact the institution with the reference number when the status remains uncertain.

Frequently Asked Questions

Why does the bank balance differ from the ledger?

Timing differences, fees, interest, returned items, automatic transactions, and errors commonly cause the difference.

What is a deposit in transit?

It is a deposit recorded in the books before the statement date but not yet credited by the bank.

What is an outstanding check?

It is a check or payment recorded in the books that has not cleared the bank by the statement date.

Do outstanding checks require journal entries?

Normally no, because they are already recorded in the books. They adjust the bank side of the reconciliation.

Do bank fees require journal entries?

Yes, when the bank recorded a fee that is not yet in the accounting records.

What should I do with a very old outstanding check?

Investigate whether it was lost, replaced, voided, or subject to unclaimed-property rules before changing the records.

Can accounting software reconcile automatically?

Software can propose matches, but a knowledgeable person must review the results and exceptions.

How often should accounts be reconciled?

Monthly is common, while high-volume or sensitive accounts may require daily or weekly review.

What if the difference is small?

A small difference can still signal a real error. Investigate rather than automatically writing it off.

Who should review the reconciliation?

A person independent of cash handling and payment processing should review it whenever possible.

Final Checklist

• Use the same ending date for books and bank.
• Carry forward prior outstanding items.
• Add deposits in transit to the bank side.
• Subtract outstanding payments from the bank side.
• Record fees, interest, returns, and book errors.
• Investigate old and unusual items.
• Avoid unsupported plug entries.
• Obtain documented independent review.

Final Thoughts

A strong bank reconciliation converts two apparently different balances into one supported adjusted cash amount. The value comes from investigation and control, not merely achieving equality. Accurate source documents, disciplined matching, proper journal entries, and independent review turn reconciliation into an effective defense against errors and unauthorized activity.

---

Official Sources and Further Reading

• FDIC: Consumer Deposits and Related Activities
• Federal Reserve: Payment System Glossary

Keywords: bank reconciliation, bank reconciliation statement, outstanding checks, deposits in transit, cash ledger, reconciliation journal entries, accounting controls

Hashtags: #Accounting #BankReconciliation #Bookkeeping #SmallBusiness #InternalControls #Finance