Skip to content

How-to guide

A month-end close bank-statement checklist

Updated July 24, 2026 · 6 min read

Month-end close is where small errors turn into big headaches. If your bank statements are late, incomplete, or hard to import, reconciliation stalls and the whole close slips.

This checklist walks through the bank-statement side of close, from gathering documents to filing them. Use it as a repeatable routine so each period looks the same and nothing gets missed.

Gather every statement and supporting file

Start by pulling the statement for each account that had activity: checking, savings, credit cards, merchant accounts, and any loan or line-of-credit accounts. Confirm the statement period matches your close period, since some banks cut statements mid-month.

Download statements as PDFs and, when available, a machine-readable file like CSV, OFX, QFX, or QBO. If your accounting software supports a direct bank feed, the feed still needs to be reconciled against the official statement, not treated as a substitute for it.

Keep a short list of accounts so you can check each one off. Missing an account is one of the most common reasons a close drags on, because the imbalance only shows up later during reconciliation.

Convert and import transactions cleanly

If you only have a PDF statement, you will need to turn it into structured data before you can import it. Convert the PDF to CSV or Excel, then map columns to date, description, amount, and running balance so the import matches your software's format.

For QuickBooks, Xero, and Wave, you can import transactions from CSV or from bank-specific formats such as OFX, QFX, or QBO. QuickBooks Desktop also uses QBO files with an INTU.BID identifier; if your file is rejected, the bank ID or file type is the usual culprit. QIF is an older format still accepted in some tools.

Before importing, scan the data for split lines, wrapped descriptions, and negative signs applied inconsistently. Fix these at the file stage. Cleaning data before import is far faster than untangling miscategorized entries after they hit your ledger.

Reconcile against the statement

Reconciliation means matching every transaction in your books to a line on the bank statement, then confirming the ending balance agrees. Enter the statement's ending balance and closing date, then clear each matched transaction.

Investigate anything that does not match. Common differences include outstanding checks that have not cleared, deposits in transit, bank fees or interest you have not recorded yet, and duplicate entries from an overlapping import or bank feed.

Do not force a reconciliation to balance by adding an adjustment you do not understand. A stubborn difference usually points to a real error: a transposed amount, a missing transaction, or a payment posted to the wrong account. Resolve the root cause before you close.

Review, document, and file

Once each account reconciles, review the categorized transactions for anything coded to a suspense or uncategorized account. Reassign those before finalizing, because they distort your profit and loss and balance sheet.

Save a reconciliation report or a snapshot of the reconciled balances for each account. Keep the original PDF statements and any converted files together in a folder named for the period, so an auditor or your accountant can trace every number back to source.

Finally, lock or close the period in your accounting software if it supports it. Locking prevents accidental edits to closed months and gives you a clean starting point for the next close.

Ready to convert a statement?

Upload a PDF, review every row, and export in seconds.

Convert a statement
What order should I close bank accounts in?

There is no required order, but reconciling operating checking first often surfaces the most transactions and errors early. Do credit cards and merchant accounts next, then savings and loan accounts, which usually have fewer entries.

My statement is only a PDF. How do I import it?

Convert the PDF into a structured file first. Export to CSV or Excel, verify date, description, and amount columns, then import that file into QuickBooks, Xero, or Wave. If your software needs a bank format, convert to OFX, QFX, or QBO instead.

Why won't my reconciliation balance?

Check for outstanding checks and deposits in transit, unrecorded bank fees or interest, duplicate transactions from an overlapping bank feed and manual import, and transposed amounts. Match the statement's ending balance and closing date exactly before troubleshooting further.

How long should I keep bank statements and reconciliation reports?

Retention rules vary by jurisdiction and business type, so confirm with your accountant. As a general practice, keep statements and reconciliation records for several years and store the original files alongside any converted versions for the same period.

Related

How To Reconcile A Bank Statement In ExcelConvert a bank statement to QuickBooksHow To Categorize Bank Transactions