Schema CPA
BlogSign inStart free

Statement reconciliation

This category covers making sure statements are complete and balanced. Posts explain bank reconciliation from first principles, how to tie each month's beginning balance to the prior month's ending balance, how to spot and request missing statements, and how reconciliation works in Excel, QuickBooks and Xero. Turning statement PDFs into rows is covered in Bank statements to Excel. Start with "Missing bank statements: how to find gaps in a run of statements", which shows the month-to-month check every reconciliation depends on.

  1. Missing Bank Statements: How to Find Gaps in a Run

    Missing bank statements break every reconciliation. Learn to spot gaps in a run of statements by period dates and balances before the books or return are done.

    October 15, 2026bank statementsmissing documentsreconciliation

  2. How to Request Missing Bank Statements From a Client

    How to request missing bank statements from a client: name the account and months, say where to download them, and get complete PDFs back on the first try.

    October 15, 2026bank statementsclient requestsmissing documents

  3. Catch-Up Bookkeeping Bank Statements: Where to Start

    Catch-up bookkeeping starts with the bank statements: collect the full run, reconcile a year of statements in order and decide what to rebuild from scratch.

    October 14, 2026catch-up bookkeepingbank statementsbacklog

  4. How Often to Reconcile Bank Accounts: Monthly or Less?

    How often to reconcile bank accounts: monthly, quarterly or yearly cadences compared by volume and risk, and when a client account needs weekly checks.

    October 6, 2026bank reconciliationmonth-endcadence

  5. Stale-Dated and Voided Checks in a Bank Reconciliation

    How to treat stale-dated and voided checks in a bank reconciliation: when a void is safe, what replaces it in a closed month, and when to write a check back.

    October 4, 2026bank reconciliationchecksjournal entries

  6. Bank Reconciliation Template in Excel, Built Step by Step

    Build a bank reconciliation template in Excel: the format, the columns and formulas, and a simple layout you can reuse every month for each client account.

    September 25, 2026bank reconciliationexceltemplates

  7. How to Reconcile Merchant Processor Deposits to Sales

    Reconcile merchant processor deposits to card sales: gross up each net payout for fees, refunds and chargebacks, and place batches in the right month.

    September 22, 2026bank reconciliationcard salesmerchant fees

  8. Auto Bank Reconciliation in Excel With Matching Formulas

    Set up auto bank reconciliation in Excel with XLOOKUP and COUNTIFS so book entries match bank lines on their own and only the exceptions need your attention.

    September 13, 2026bank reconciliationexcelformulas

  9. How to Reconcile QuickBooks Online Bank Accounts

    Reconcile QuickBooks Online accounts against the bank statement step by step, read the difference figure, and undo a bad reconciliation without losing work.

    September 4, 2026quickbooks onlinebank reconciliationmonth-end

  10. How to Reconcile a Closed Bank Account to a Zero Balance

    Reconcile a closed bank account to zero: tie the final statement, settle outstanding checks and late charges, then retire the account in the books.

    August 29, 2026bank reconciliationclosed accountsyear end

  11. Outstanding Checks and Deposits in Transit, Explained

    Outstanding checks and deposits in transit explained: why they exist, how they adjust the bank balance, and when an old one should be investigated.

    August 29, 2026bank reconciliationtiming itemschecks

  12. Bank Statement Analysis Software for Accounting Firms

    What bank statement analysis software does for accounting firms: cash flow summaries, income and recurring payment checks, and how analysis differs.

    August 9, 2026bank statementsanalysiscash flow

  13. What Is a Bank Reconciliation? A Plain Guide for Firms

    What is a bank reconciliation? A plain explanation of matching the books to the bank statement, the adjusted balance math, and why firms do it every month.

    August 8, 2026bank reconciliationbookkeepingmonth end

  14. Year-End Bank Reconciliation Before the Tax Return

    A year-end bank reconciliation before the tax return: tie the December statement to the books, run a proof of cash, and clear items before the client files.

    July 12, 2026bank reconciliationyear endproof of cash

  15. Bank Reconciliation Errors: Finding Why It Won't Balance

    The bank reconciliation errors that keep accounts from balancing, from transpositions to doubled entries, and an order for finding and fixing each one fast.

    June 28, 2026bank reconciliationerrorsmonth-end

  16. Transfers Between a Client's Own Accounts: Income or Not?

    Transfers between a client's own accounts can pass for income. Learn to prove each one with the other account's statement and record owner draws properly.

    June 11, 2026bank reconciliationtransfersowner draws

  17. Tools for Bank Account Reconciliation, Compared by Type

    Tools for bank account reconciliation compared by type: Excel, accounting software and statement checkers, and which pair of tools fits a firm's clients.

    April 17, 2026bank reconciliationexcelsoftware

  18. How to Tie Out Bank Statements Month to Month

    Tie out bank statements month to month by rolling each ending balance into the next beginning balance, and learn what to do when the two do not match.

    January 15, 2026bank statementstie-outreconciliationexcel

  19. Bank Statement Reconciliation Software: What to Look For

    What to look for in bank statement reconciliation software: gap detection, balance tie-outs, matching, exports and review, with questions to ask before you buy.

    August 24, 2025bank reconciliationsoftwarebuying guide

  20. How to Reconcile Credit Card Statements Each Month

    Reconcile credit card statements each month: closing dates, payments, refunds and interest, plus the steps for reconciling a card account in QuickBooks.

    May 10, 2025credit cardsbank reconciliationquickbooks

  21. Bank Feed vs Bank Statement Reconciliation: Which to Trust

    Bank feed vs bank statement reconciliation compared: what each one proves, where feeds drop or double transactions, and why firms still use the statement.

    March 7, 2025bank reconciliationbank feedsquickbooks

  22. Reconciling Multiple Bank Accounts for One Client

    Reconciling multiple bank accounts for one client: order the work, match transfers between accounts, and keep loan and card balances in step with the bank.

    December 24, 2024bank reconciliationtransfersloans

  23. Xero Reconcile Bank Statement Workflow for Bookkeepers

    A Xero reconcile bank statement workflow: match statement lines, compare the statement balance with Xero's, and fix lines that were imported twice.

    November 29, 2024xerobank reconciliationmonth end

  24. Reconcile Bank Statement in QuickBooks Desktop, Step by Step

    Reconcile a bank statement in QuickBooks Desktop: enter the statement figures, clear items, use the discrepancy report and fix a changed prior period.

    October 19, 2024quickbooks desktopbank reconciliationdiscrepancy report