Where to start when a month of QuickBooks records is messy
Use one bank statement to trace duplicate-looking entries, pending payments, and unresolved balances before handing the month to your bookkeeper.

This article is sponsored by Assured BATS. Partner content policy
In this article
A month of unfinished bookkeeping can look like a single long list of transactions. Open the bank statement first. It gives you a date range, a starting balance, and a record of what went through the account. That makes it easier to separate a missing entry from a payment that simply cleared later, and a real discrepancy from a second view of the same transaction.
Start with one business checking account and one complete statement period. If you have several months of work ahead, use the first complete statement after the last period your bookkeeper can confirm was reconciled. At the end of the first pass, you should be able to show which transactions you traced, what remains unexplained, and who has the documents to answer each question.
Set the boundaries before you open the bank feed
Write down the account nickname, the dates printed on the statement, and its beginning and ending balances. A statement might cover parts of two calendar months. Match the dates shown on the document when you compare the statement with QuickBooks Online. If you're looking at a credit card or payment processor in a second tab, label that account separately.
Check QuickBooks for the last completed reconciliation on the checking account. If the previous statement ends on August 31 and the next one begins September 1, for example, you have a clear place to pick up. If you find a gap, or someone says a period was finished but you can't find the report, write down exactly where the gap starts. Ask the bookkeeper which period to review first before changing any entries.
Collect documents that explain the statement lines
Gather the full statement and the records for the transactions you're reviewing. Those might include an invoice and payment confirmation for a vendor withdrawal, a remittance email for a customer payment, or a settlement report for a deposit from a card processor. The statement shows money moving. The supporting document often explains what the money paid for or which invoices it covered.
Keep the original documents in a restricted folder and note where each one came from. For a receipt you can't locate, record the date, the vendor, the amount, and who might have a copy. If the business bought two things for the same amount, add a reference number so the bookkeeper can identify the right one. The IRS guide to small-business records describes the documents that support entries and why some transactions require more than one record.
Check for an existing entry before creating one
A downloaded bank charge can look like new work even when someone already recorded the payment. In QuickBooks Online, matching connects a downloaded transaction to an existing entry. Categorizing a download without a corresponding entry creates a new record. Intuit explains the distinction in its bank transaction matching guide.
Compare the amount, account, payee, and available reference before accepting a suggested match. A bank posting date can follow the date on a receipt, and two card purchases from one retailer can have identical amounts. A repeat amount gives you somewhere to look. A matching receipt or payment confirmation helps identify the specific entry. If two candidates remain, leave a question for the reviewer. The same approach helps with a payment between the business's own accounts. Gather both sides before someone records an additional expense.
Work through a fictional $4,020 statement
Imagine a small repair business with a September checking statement. It starts with $3,200. Two deposits of $850 and $450 bring in $1,300, and withdrawals of $125, $310, and $45 take out $480. The statement closes at $4,020. These figures are made up to show how to trace the entries.
The $125 withdrawal appears in the bank feed and in a manually entered expense. The bookkeeper checks the invoice number and the card confirmation and sees that both refer to the same payment. There is one $125 withdrawal on the statement. If the download were posted as a second expense, the register would show $125 too much in withdrawals. Matching the download to the verified expense keeps a single record of the payment.
The $450 deposit just says “ACH credit.” That description leaves open whether it came from a customer, a processor, or another account. The owner asks whoever handles receipts to find the payment confirmation. The register also shows a $180 check that does not appear on this statement. The owner notes the check number and asks whether it cleared in October. The $180 stays out of September's cleared total. Those two open questions involve different evidence, even though both can show up on the same review list.
The bookkeeper could also trace the $850 deposit to a card settlement. If the processor report shows $875 in payments and a $25 fee, the $850 in the bank may represent several customer payments combined. Save the settlement report and note the deposit date and payout ID. Those details help a reviewer connect the deposit to the individual payments and see whether the fee was already entered. Keep the deposit open for review until there's a record that ties those amounts together.
Compare cleared transactions with the statement
Once the month's entries are ready for review, confirm the account, statement closing date, and statement ending balance before comparing transactions. In the reconciliation screen, mark entries that appear on that statement. Intuit's official reconciliation instructions explain what the cleared balance and difference represent and how to find the saved report after the reconciliation is complete.
If the difference is $125, look for a missing or extra $125 in the statement and register, but check other possibilities too. Multiple errors can add up to the same number. Double-check the statement date and balance you entered and look for an unchecked line with a known source. If the difference remains, record its amount and what you checked so the next person can start at that point. Intuit suggests talking to an accountant before accepting an unexplained difference through an adjustment.
A beginning balance discrepancy deserves its own note. If the account has been reconciled before, the beginning balance should agree with the last completed reconciliation. An edited or deleted entry in that earlier period can cause the numbers to diverge. Save the relevant dates and ask the bookkeeper to review the QuickBooks beginning-balance discrepancy guidance with the prior report available.
Give the bookkeeper a short list of answerable questions
For each unresolved item, record the date, account nickname, amount, document location, and one clear question. For the example above, “What is this ACH?” might send someone back to a spreadsheet and an email archive. “Can you find the source of the $450 September 18 deposit in the processor’s settlement report?” tells the recipient what to look for. Record who will follow up and when you’ll check again.
A useful first review can center on questions like these.
- Which month and account should we review first, and can we find the prior reconciliation report?
- Does the bank download correspond to an expense, invoice payment, or transfer already in the register?
- Who can retrieve the missing invoice or confirm which settlement produced the deposit?
- Did the outstanding check clear after the statement date, and who can confirm its status?
- Which entries affect an already reconciled or closed period and should wait for your review?
Add a short note when someone answers a question so the next person knows which document supported the decision. If several people collect records, use the South Dallas Report guide to bookkeeping questions before a staff handoff to set up shared ownership of the list.
Share records through an agreed secure channel
Keep the general discussion limited to what someone needs to identify the issue. An account nickname and a date can be enough in a scheduling email. Ask the bookkeeper how to transmit the actual statement and which people need to see it. Use a restricted folder or their approved document portal, confirm the recipient, and keep the original documents intact in your business records. For a group discussion, a short question may be enough without attaching customer or employee records.
If the bookkeeper needs access to QuickBooks, have the person who administers the account arrange access through the business's own approved process. Keep bank passwords and one-time verification codes private. For documents with account numbers, payroll details, or customer information, ask which files the reviewer needs and confirm where you'll upload them. Keep sensitive attachments out of ordinary project chats and send a message naming the file after the secure upload is complete.
Leave the next month easier to pick up
When the review is done, note which account and statement dates the bookkeeper reconciled. File the report with the relevant statement and keep a separate list for items that need a future check, such as a payment still in transit at the statement date. If someone is waiting on a document, give that item a name and an owner so it can move forward without holding up questions that already have answers.
Once the next statement arrives, set aside a regular time to gather receipts, check for possible duplicates, and review the outstanding list. One practical test is whether a colleague could pick up the folder and tell which month is complete, which transactions still need a decision, and where to find the supporting records. If they have to open five different threads to answer the first question, move the account nickname, statement dates, and report location into the same brief note.
Assured BATS sponsors this article. Its guide to catch-up bookkeeping discusses gathering records and working through older accounts when the backlog extends past one month.
Visit Assured BATS.
Sources
- IRS guide to small-business recordsirs.gov
- official reconciliation instructionsquickbooks.intuit.com
- bank transaction matching guidequickbooks.intuit.com
- QuickBooks beginning-balance discrepancy guidancequickbooks.intuit.com
- guide to catch-up bookkeepingassuredbats.com
