Bank Reconciliation Operations

01Purpose and scope

• This manual supports the course Bank Reconciliation Operations. It is written for staff accountants, senior accountants, cash management analysts, and supervisors who prepare or review the matching of bank activity against the company's cash records. It describes how the work is actually done in a typical finance team, not only the textbook definition of the task.
• A bank reconciliation compares the cash balance reported by a bank with the cash balance in the general ledger for the same account and period, then explains every difference. The differences are usually timing items such as checks issued but not yet cleared, deposits recorded but not yet credited, and bank fees or interest that the company has not yet booked. Some differences are errors, either by the bank, by the company, or by a payee, and these need to be traced and corrected rather than simply explained.
• The scope here covers operational reconciliation of bank and cash accounts, including petty cash and merchant or payment processor clearing accounts where those are reconciled in the same way. It does not cover the broader cash forecasting, treasury investment decisions, or the audit of bank confirmations, although reconciliations feed those activities. Organizations in regulated industries, or those operating across several legal jurisdictions, may have additional requirements for record retention and segregation of duties. Those requirements depend on the entity and its location, so confirm them with the current authoritative source and your controller or internal audit function.

02Core principles

• The first principle is that the reconciliation must tie to an independent source. The bank statement or bank portal data is the external record, and the general ledger is the internal record. Neither should be adjusted to match the other without evidence. When someone changes the book balance to make the reconciliation work, the reconciliation has stopped being a control and become a plug.
• The second principle is that every reconciling item needs a reason, an owner, and an expected resolution. A check that has been outstanding for four months is not automatically a problem, but it should have a documented explanation, such as a vendor who has not cashed a payment, and a follow-up path. Items without those three elements are the ones that accumulate into write-offs and audit findings.
• The third principle is that the reconciliation should be performed by someone who does not initiate, approve, or record the underlying cash transactions, or at least that the reviewer is independent of the preparer. Where a small team cannot fully separate these duties, the compensating control is a higher level of review and more frequent sampling of the reconciling items. The fourth principle is timeliness. A reconciliation completed a week after period end is far less useful for detecting fraud or errors, because bank records and supporting documents are harder to retrieve and memories of the transactions have faded.

03Planning and preparation

• Before starting a reconciliation, confirm the scope for the period. List every bank account, currency, and payment channel that must be reconciled, and confirm the statement cut-off date. Many banks issue statements on a calendar basis while the company closes on a fiscal or business-day calendar, so a mismatch in cut-off is one of the most common sources of unexplained timing items. Obtain the statement in its final form, and where possible use the bank's own download rather than a retyped copy.
• Gather the supporting records. These usually include the bank statement with all detail lines, the cash receipts journal, the disbursements register or check register, the payroll funding records, electronic payment confirmations, the prior period reconciliation with its open items list, and any bank correspondence about returned items, holds, or service charges. Confirm that the prior period's outstanding items have been tracked to the current statement, because an item that disappears without clearing or being written off is a warning sign.
• Decide on the tools. Some teams use a spreadsheet with a standard template, which is adequate for a small number of accounts with modest transaction volume. Larger teams use a reconciliation module in the general ledger or a dedicated reconciliation platform that performs automated matching on amount, date window, and reference number. Automated matching reduces manual effort but requires periodic review of match rules, because loose rules can pair unrelated transactions that happen to share an amount. The choice of tool should be documented along with the matching tolerances used.
• Set the tolerance and materiality thresholds in advance. Most organizations define a dollar threshold below which small variances, such as rounding or minor bank fees, may be posted without individual investigation, and a higher threshold that requires escalation. These thresholds are policy decisions and should be approved by the controller and reflected in the close procedures. They are not a license to ignore unexplained differences.

04Recommended workflow

1. 1
   : Import or obtain the bank statement and the general ledger cash detail for the same period. Confirm the opening balances agree to the prior period's closing reconciliation before you do anything else. If they do not agree, stop and resolve that break first, because every later step depends on it.
2. 2
   : Load the bank activity and book activity into the reconciliation template or matching tool. Check that the record counts and total debits and credits in the imported data agree to the source totals shown on the statement and in the ledger report. A short import is a common and easily missed cause of phantom differences.
3. 3
   : Match the clear items first. Pair receipts to deposits, checks and electronic payments to disbursements, and bank fees or interest to the corresponding ledger entries. Use reference numbers, check numbers, and payee names where available. Record the matching rule used for any item matched on amount alone.
4. 4
   : List the remaining book-only and bank-only items. Classify each as outstanding check, deposit in transit, bank error, book error, unrecorded bank charge, unrecorded interest, returned item, or unknown. Look at the aging of each open item, since outstanding checks older than the company's stale-dated threshold usually need a separate follow-up with the payee or a reversal entry under policy.
5. 5
   : Investigate the unknown and high-value items. Pull the source documents, such as the invoice, the remittance advice, the deposit slip, or the wire confirmation. For returned items and rejected electronic payments, identify the original transaction and determine whether the company must reissue payment or reverse revenue. Where the cause is a bank error, document the bank's acknowledgment and the expected correction date, and open a claim if the bank's process requires one.
6. 6
   : Prepare the proposed adjusting entries for items that the company must record, such as bank fees, interest, and corrections of book errors. Each entry should cite the reconciliation line, the source document, and the approver. Do not post entries in the reconciliation file alone without a corresponding journal entry in the ledger, because a reconciliation that does not flow into the ledger will reappear in the next period.
7. 7
   : Compute the adjusted bank balance and the adjusted book balance and confirm that they are equal. Prepare the reconciliation summary showing the statement balance, the outstanding items, the adjusted balance, the ledger balance before and after adjustments, and the net change. Submit the package to the reviewer with the open items list and the source documents indexed in a way the reviewer can follow without asking for the file.

05Quality checks, risk controls and compliance

• A reviewer should check that the adjusted bank balance equals the adjusted book balance, that every reconciling item has a documented reason and owner, and that the prior period's open items have either cleared or been resolved. The reviewer should also sample a meaningful set of cleared items and trace them to source documents, and should scan the list of adjusting entries for round-dollar amounts, unusual payees, entries posted late in the period, and entries that reverse each other. These checks are simple, but the discipline of performing them each period is what makes the control effective.
• Fraud and error risk concentrate in a few places. Altered or duplicated check numbers, payments to unauthorized vendors, and disbursements that clear the bank but have no matching approved invoice are the typical patterns. Positive pay and similar bank services reduce the risk of altered checks, but the reconciliation is still the detective control that catches what gets through. Where the reconciliation preparer also has access to the bank portal, add a second person to review portal user activity and changes to payee or beneficiary setup.
• Compliance requirements vary. Some jurisdictions and industries require specific record retention periods, specific approval thresholds, or documented evidence of management review. Public entities, regulated financial institutions, and companies with certain listings often have additional reporting or internal control obligations. This manual describes common practice, but it does not replace qualified professional judgment, approved procedures, or any required authorization from your controller, auditors, or regulators. Confirm the current rules with the authoritative source for your jurisdiction and entity type before finalizing your procedures.

06Collaboration and documentation

• Reconciliation sits between several groups. Treasury or cash management usually owns the bank relationships and the portal access. Accounts payable owns outstanding checks and electronic payments. Accounts receivable owns deposits and remittance matching. The general ledger team posts the adjusting entries. A useful practice is to name a contact in each group for reconciling items in their area and to set a response time, such as two business days for a request to trace a payment. Without named contacts, unknown items tend to sit until the next close.
• Documentation should allow a person unfamiliar with the account to understand the reconciliation in one sitting. The file should include the cover page with the account, period, preparer, reviewer, and sign-off dates, the reconciliation summary, the open items schedule with aging and owners, the adjusting entries with approvals, the list of source documents, and a short narrative for any unusual item. Retain electronic copies in the designated shared location with access controls, and avoid storing reconciliations on personal drives where they cannot be reviewed or audited.
• Escalation paths should be written down. A small variance that is clearly a bank fee may be handled by the preparer. A possible fraudulent item, a large unexplained difference, or a bank error that affects customer funds should be escalated to the controller and, where the policy requires, to internal audit or the fraud response contact the same day. Escalation is not a sign of weakness. It is what the reconciliation is for.

07Measures and continuous improvement

• Useful indicators include the number of days from period end to completed reconciliation, the count and total value of open reconciling items by age bucket, the number of adjusting entries posted after the period is closed, the percentage of reconciliations reviewed within the policy timeline, and the number of bank errors identified and resolved. Trend these by account so that a chronic problem in one account is visible. Set targets only after you have a baseline from a few periods, because a target set without data tends to encourage reclassification of items to make the numbers look better.
• Review the open items list monthly with the owners. Items that have been open for two or more periods should be investigated for root cause, not merely re-listed. Common root causes are a vendor address change that has delayed check delivery, a remittance that arrives without a reference number, or a bank cutoff time that differs from the company's batch schedule. Fixing the root cause, such as updating the vendor master or changing the payment file timing, reduces future open items more than any amount of diligence at reconciliation time.
• Revisit matching rules and tolerances at least annually, and after any change to bank accounts, payment systems, or the general ledger chart of accounts. A new payment channel that uses a different reference format will often produce a surge of unmatched items until the rules are updated. Keep a change log of rule and template changes so that a reviewer can see why a result changed from one period to the next.

08Common mistakes and how to prevent them

• The most frequent mistake is forcing a balance by adjusting the book balance by the amount of the difference without identifying what the difference is. This hides real problems such as duplicate payments, unrecorded bank debits, and fraud. The prevention is a rule that no plug entry is permitted, and that any adjusting entry must be tied to a specific item with support.
• A second common mistake is carrying old outstanding items forward indefinitely. Checks written many months earlier that remain uncleared are often void, lost, or unclaimed, and they can represent liabilities that should be reversed under the company's unclaimed property or stale-dated check policy. Those rules depend on jurisdiction, so confirm the current requirements before reversing or escheating any balance.
• A third mistake is using the bank's ending balance as of the wrong cut-off, or comparing a statement from one account to the ledger of another. Label each reconciliation with the account number, the statement date, and the ledger period, and have the reviewer check those labels before reviewing any amounts. Finally, many teams rely on a single person who knows how the reconciliation works. Cross-train at least one backup preparer and rotate the review assignment so that the control does not depend on one individual's memory of the account's quirks.

09Practical checklist

• Confirm the statement cut-off date and obtain the final bank statement or portal download for every account in scope.
• Agree the opening balance to the prior period's approved reconciliation before matching begins.
• Verify that imported bank and ledger records match source record counts and total amounts.
• Match clear items using reference numbers, check numbers, amounts, and dates, and record any rule used for amount-only matches.
• Classify every remaining item as a timing difference, bank error, book error, unrecorded charge, or unknown, with an owner and an expected resolution.
• Investigate unknown and high-value items using source documents, and escalate possible fraud or large unexplained differences the same day.
• Post every required adjusting entry to the ledger with support and approval, and do not use plug entries.
• Confirm that the adjusted bank balance equals the adjusted book balance and that the summary ties to the ledger.
• Have an independent reviewer check the file, sample cleared items to source, and review adjusting entries for unusual patterns.
• Update the open items schedule, aging report, and root cause notes, and retain the file in the designated location according to the applicable retention requirements.

★Learning sources

• Micro Degree: Bank Reconciliation Operations
• Micro Degree: Accounts Payable Management
• Micro Degree: FinTech Fundamentals
• Micro Degree: Digital Payment Systems