{"id":5108,"date":"2026-11-21T16:55:34","date_gmt":"2026-11-21T09:55:34","guid":{"rendered":"https:\/\/easystatementsheet.com\/blog\/?p=5108"},"modified":"2026-11-21T16:56:49","modified_gmt":"2026-11-21T09:56:49","slug":"bank-statement-reconciliation-checklist","status":"publish","type":"post","link":"https:\/\/easystatementsheet.com\/blog\/bank-statement-reconciliation-checklist\/","title":{"rendered":"Bank Statement Reconciliation Checklist"},"content":{"rendered":"<p><strong>Bank statement reconciliation is the process of comparing every line on your bank statement to your own books and explaining every difference until the reconciled closing balance equals the statement&#8217;s closing balance.<\/strong> It is the single check that proves your records match the bank&#8217;s records for the period.<\/p>\n<p>For a small business owner, reconciliation catches missing deposits, duplicate charges, unrecorded fees, and outright errors before they compound into tax or cash flow problems. Done monthly, it takes minutes. Left for a year, it becomes a project.<\/p>\n<blockquote><p>Reconciliation is not about matching totals. It is about explaining every difference, line by line, until nothing is left unexplained.<\/p><\/blockquote>\n<p><strong>Key facts.<\/strong> Reconciliation compares the bank statement to your own records and explains every difference. Start with the opening balance, then match each transaction by date, description, and amount. Common discrepancies include timing differences, duplicate entries, missing transactions, and bank fees not yet recorded. The reconciled closing balance should equal the statement&#8217;s closing balance. Reconcile monthly to catch errors early and keep tax records accurate.<\/p>\n<div style=\"background:#f0f7ff;padding:20px;margin:24px 0;border-left:4px solid #1a73e8\">\n<p><strong>Balance check<\/strong> the reconciled closing balance must equal the statement&#8217;s closing balance. If the two differ, the difference is your to-do list, not a rounding issue.<\/p>\n<\/div>\n<h2>Before you start: gather and confirm<\/h2>\n<p>Gather the statement PDF, your ledger or spreadsheet, and receipts for the period. Confirm the statement period and account number match what you expect. If they do not, stop and request the correct statement.<\/p>\n<p>Download the statement as a PDF from your bank portal, not a screen print. The PDF is the official record and includes all pages.<\/p>\n<p>If you have multiple accounts, reconcile one at a time. Mixing accounts is the fastest way to create phantom differences.<\/p>\n<p>Confirm the statement covers a full month. A partial period needs special handling, because opening and closing balances will not line up.<\/p>\n<p>Check the account type and currency. A savings account or foreign currency account needs its own reconciliation process.<\/p>\n<p>If statements arrive by mail, switch to paperless. Electronic statements are easier to search and store.<\/p>\n<p>If your bank offers multiple statement formats, pick the one with running balances. It gives you a built-in check on every line.<\/p>\n<p>Keep a reconciliation folder per account. Store statements, notes, and supporting receipts in one place.<\/p>\n<p>Check the opening balance against last month&#8217;s closing balance. They should agree exactly. A mismatch here means last month was not fully reconciled, and you should fix that first.<\/p>\n<p>If you are new to the document, <a href=\"\/what-is-a-bank-statement\/\">what is a bank statement<\/a> explains the layout and each field in plain terms.<\/p>\n<p>Note the statement&#8217;s closing balance somewhere visible. That number is your target for the end of the process.<\/p>\n<h2>The reconciliation checklist<\/h2>\n<p>Work these steps in order. Do not skip ahead, because each step feeds the next.<\/p>\n<div style=\"overflow-x:auto\">\n<table>\n<thead>\n<tr>\n<th>Step<\/th>\n<th>Action<\/th>\n<th>Why it matters<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>1<\/td>\n<td>Confirm opening balance matches prior closing balance<\/td>\n<td>Anchors the whole month<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>Match deposits and credits line by line<\/td>\n<td>Confirms money in<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>Match withdrawals and debits line by line<\/td>\n<td>Confirms money out<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>Record bank fees and interest not yet in books<\/td>\n<td>Captures charges you missed<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>Record adjustments and reversals<\/td>\n<td>Explains corrections<\/td>\n<\/tr>\n<tr>\n<td>6<\/td>\n<td>Investigate unmatched items<\/td>\n<td>Resolves real differences<\/td>\n<\/tr>\n<tr>\n<td>7<\/td>\n<td>Compute the reconciled closing balance<\/td>\n<td>Produces your figure<\/td>\n<\/tr>\n<tr>\n<td>8<\/td>\n<td>Compare to the statement closing balance<\/td>\n<td>The final test<\/td>\n<\/tr>\n<tr>\n<td>9<\/td>\n<td>If equal, mark reconciled and save the PDF<\/td>\n<td>Closes the month<\/td>\n<\/tr>\n<tr>\n<td>10<\/td>\n<td>If not equal, return to step six<\/td>\n<td>Keeps you honest<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>Tick each line as you go. A short list of unmatched items is normal. A long list means you are rushing or the period is messy.<\/p>\n<p>Document what you did. Note the date, the statement period, and any reconciling items carried forward. A short note saves hours next month.<\/p>\n<p>Reconcile monthly, soon after the statement arrives. Problems stay small when caught early, and tax records stay accurate all year.<\/p>\n<div class=\"easys-ess-cta-in-article easys-entity-placement\" id=\"easys-2986764048\"><div id=\"easys-1100874351\" role=\"region\" aria-label=\"Advertisements\"><div style=\"border:1px solid #e1e7e2;border-radius:8px;padding:20px;margin:28px 0;background:#f7faf7\">\r\n  <p style=\"margin:0 0 8px;font-size:18px;font-weight:700;line-height:1.3\">From Bank Statement to QuickBooks-Ready File<\/p>\r\n  <p style=\"margin:0 0 16px;line-height:1.6\">That manual cleanup you just read about? This tool skips it. Turn your PDF into QBO for QuickBooks without storing your data anywhere.<\/p>\r\n  <a href=\"https:\/\/easystatementsheet.com\/?utm_source=blog&utm_campaign=ess-cta-02\" style=\"display:inline-block;background:#1e7a4c;color:#fff;text-decoration:none;padding:10px 18px;border-radius:6px;font-weight:600\">Start Converting<\/a>\r\n<\/div><\/div><\/div><h2>Matching transactions the right way<\/h2>\n<p>Match by date, description, and amount together. A single field is not enough, because two transactions can share an amount or a date.<\/p>\n<p>Work in date order. Start at the top of the statement and walk down. Mark each matched line in your books. Unmatched lines go on a short list.<\/p>\n<p>For deposits, match to invoices or payment confirmations. For withdrawals, match to receipts or bills. If a line has no match, it is either missing from your books or a bank error.<\/p>\n<p>Partial payments and split bills are common traps. A single invoice paid in two deposits needs two matches. A single card charge split across categories still needs one match to the statement.<\/p>\n<p>Watch for deposits in transit and outstanding checks. A check you wrote but the bank has not cleared belongs on your side only.<\/p>\n<p>Merchant names on statements rarely match your invoices. Keep a mapping of common vendors so you do not chase false mismatches.<\/p>\n<p>Reconcile deposits to actual receipts, not to invoices. An invoice is a request; a deposit is cash. Only cash clears the bank.<\/p>\n<p>Sort by amount when a date is unclear. Matching amounts first often resolves stubborn lines.<\/p>\n<p>Use the statement&#8217;s description, not your memory, as the source of truth for what happened.<\/p>\n<p>Match credits to deposit slips or payment processor reports. Processor payouts often batch several sales into one deposit.<\/p>\n<p>For cash businesses, count the drawer and compare to deposits. Unbanked cash is a common source of mismatch.<\/p>\n<p>If you <a href=\"\/how-to-convert-a-bank-statement-to-excel\/\">convert a bank statement to Excel<\/a>, matching becomes a sort and filter exercise instead of manual transcription.<\/p>\n<p>Reading the layout first helps. <a href=\"\/how-to-read-a-bank-statement\/\">How to read a bank statement<\/a> walks through dates, descriptions, and running balances.<\/p>\n<figure><img decoding=\"async\" src=\"https:\/\/easystatementsheet.com\/blog\/wp-content\/uploads\/stack-of-paper-documents-reconciliation-checklist-green-body.jpg\" alt=\"bank statement reconciliation checklist\" width=\"1200\" height=\"896\" title=\"\"><figcaption>bank statement reconciliation checklist<\/figcaption><\/figure>\n<h2>Common discrepancies and how to resolve them<\/h2>\n<p>Most differences fall into a small set of buckets. Knowing them speeds up the work.<\/p>\n<div style=\"overflow-x:auto\">\n<table>\n<thead>\n<tr>\n<th>Discrepancy<\/th>\n<th>Likely cause<\/th>\n<th>Resolution<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Timing difference<\/td>\n<td>Recorded in different months<\/td>\n<td>Wait for next statement or adjust period<\/td>\n<\/tr>\n<tr>\n<td>Duplicate entry<\/td>\n<td>Same item entered twice<\/td>\n<td>Void the duplicate<\/td>\n<\/tr>\n<tr>\n<td>Missing transaction<\/td>\n<td>Forgot to record or bank posted late<\/td>\n<td>Add the entry<\/td>\n<\/tr>\n<tr>\n<td>Unrecorded fee<\/td>\n<td>Bank charged a fee<\/td>\n<td>Record the fee<\/td>\n<\/tr>\n<tr>\n<td>Wrong amount<\/td>\n<td>Typo or bank error<\/td>\n<td>Correct or dispute<\/td>\n<\/tr>\n<tr>\n<td>Unidentified deposit<\/td>\n<td>Customer payment without reference<\/td>\n<td>Research and label<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>Work the differences one at a time. Timing differences usually resolve by waiting for the next statement. Missing entries get added. Duplicates get voided or reversed. Errors get reported to the bank within the dispute window printed on the statement.<\/p>\n<p>An NSF check from a customer reverses a deposit you already recorded. Record the reversal and re-invoice the customer.<\/p>\n<p>A reversed card charge appears as a credit followed by a matching debit. Match both lines so neither looks like a new deposit.<\/p>\n<p>Fees sometimes post on the first of the next month. Move them into the correct period rather than leaving them unmatched.<\/p>\n<p>Duplicate vendor charges often post on the same day. Compare descriptions and amounts before assuming two separate purchases.<\/p>\n<p>A missing deposit is often a deposit made after the cutoff time. Check the next statement before recording an error.<\/p>\n<p>Bank fees sometimes vary by month. Compare to the fee schedule so you know what is normal.<\/p>\n<p>Interest income is easy to forget. Record it when you reconcile so it does not sit unrecorded.<\/p>\n<p>Keep evidence. Save receipts, invoices, and confirmation numbers for any item you question. A bank dispute is easier to win with documentation than with memory.<\/p>\n<h2>When the balances still do not match<\/h2>\n<p>Recompute. Add all deposits, subtract all withdrawals and fees, and compare to the statement&#8217;s net change. A math error in your sheet is common.<\/p>\n<p>Check for transposed digits. 145.00 versus 154.00 is a classic. Scan amounts, not just totals.<\/p>\n<p>Check the date range. A transaction from the last day may have slipped into the next period on the bank&#8217;s side.<\/p>\n<p>If you still cannot find it, reconcile to the last matched transaction and carry the difference forward as a reconciling item, then investigate next month. Do not force a match by editing the opening balance.<\/p>\n<p>Keep an audit trail. Note what you changed, when, and why. Future you, or your accountant, will need it.<\/p>\n<p>If the bank made the error, gather proof before calling. Statements, receipts, and timestamps make the dispute faster.<\/p>\n<p>Never edit the opening balance to force a match. That hides the real problem and corrupts every future month.<\/p>\n<p>Set a time limit for investigating. If you cannot resolve it in one session, document and carry it forward.<\/p>\n<p>Reconciling to the penny matters. Small differences today become large ones after a year of compounding.<\/p>\n<p>Compare your reconciled balance to any third party reports, like payment processor summaries.<\/p>\n<p>If you use multiple bookkeepers, agree on one method. Consistency beats cleverness.<\/p>\n<p>For a deeper workflow, the <a href=\"\/complete-guide-bookkeeper-bank-statement-workflow\/\">complete guide to a bookkeeper&#8217;s bank statement workflow<\/a> covers handling edge cases and month end close.<\/p>\n<h2>Records, retention, and the next step<\/h2>\n<p>Save the reconciled statement and your reconciliation notes together. Consistent naming like bank-account-YYYY-MM makes retrieval fast.<\/p>\n<p>Keep statements for at least seven years for tax and audit purposes, in a secure backed up location.<\/p>\n<p>Back up reconciled files in two places. A single device failure should not erase a year of records.<\/p>\n<p>Share reconciled statements with your accountant or bookkeeper on a schedule. Consistent handoffs prevent year end surprises.<\/p>\n<p>Label files with account and period. Searching by date is faster than guessing.<\/p>\n<p>Keep a change log for any correction. Auditors love a clear trail.<\/p>\n<p>At year end, reconcile all twelve months in sequence. Gaps surface quickly when months connect.<\/p>\n<p>Export your reconciled ledger to a backup format you can open without the original software.<\/p>\n<p>If you need the data in another tool, <a href=\"\/convert-bank-statement-to-csv\/\">convert a bank statement to CSV<\/a> for import into your accounting software.<\/p>\n<p>After reconciliation, review the month at a glance. Look for rising fees, duplicate vendors, or unusual spending patterns.<\/p>\n<p>Reconcile monthly. A short session after each statement arrives prevents a large year end cleanup and catches unauthorized transactions while they are still easy to dispute.<\/p>\n<div class=\"easys-ess-cta easys-entity-placement\" id=\"easys-349424456\"><div id=\"easys-4175333449\" role=\"region\" aria-label=\"Advertisements\"><div style=\"border:1px solid #e1e7e2;border-radius:8px;padding:20px;margin:28px 0;background:#f7faf7\">\r\n  <p style=\"margin:0 0 8px;font-size:18px;font-weight:700;line-height:1.3\">Turn any PDF statement into a clean sheet<\/p>\r\n  <p style=\"margin:0 0 16px;line-height:1.6\">Skip the typos and the hours of copying. Our converter handles any bank statement format and outputs Excel, CSV, or QBO for QuickBooks. No file retention, free to try.<\/p>\r\n  <a href=\"https:\/\/easystatementsheet.com\/?utm_source=blog&utm_campaign=ess-cta-04\" style=\"display:inline-block;background:#1e7a4c;color:#fff;text-decoration:none;padding:10px 18px;border-radius:6px;font-weight:600\">Convert your statement<\/a>\r\n<\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>A step-by-step checklist for reconciling a bank statement to your books, with common discrepancies and how to resolve them.<\/p>\n","protected":false},"author":2,"featured_media":5111,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5108","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bank-statement"],"_links":{"self":[{"href":"https:\/\/easystatementsheet.com\/blog\/wp-json\/wp\/v2\/posts\/5108","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/easystatementsheet.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/easystatementsheet.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/easystatementsheet.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/easystatementsheet.com\/blog\/wp-json\/wp\/v2\/comments?post=5108"}],"version-history":[{"count":2,"href":"https:\/\/easystatementsheet.com\/blog\/wp-json\/wp\/v2\/posts\/5108\/revisions"}],"predecessor-version":[{"id":5117,"href":"https:\/\/easystatementsheet.com\/blog\/wp-json\/wp\/v2\/posts\/5108\/revisions\/5117"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/easystatementsheet.com\/blog\/wp-json\/wp\/v2\/media\/5111"}],"wp:attachment":[{"href":"https:\/\/easystatementsheet.com\/blog\/wp-json\/wp\/v2\/media?parent=5108"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/easystatementsheet.com\/blog\/wp-json\/wp\/v2\/categories?post=5108"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/easystatementsheet.com\/blog\/wp-json\/wp\/v2\/tags?post=5108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}