The Ultimate QuickBooks Year-End Cleanup Checklist for Bookkeepers

By Invoice Auditor Team · 2026-06-17

The Year-End Crunch Is Coming — Here's Your Checklist

Year-end is when every client file gets scrutinized — by the CPA, by the tax preparer, and by the client who suddenly cares about every number. The bookkeeper who arrives with a clean file and a defensible packet walks out looking like a hero. The one who doesn't spends January in email threads they should have avoided. Here's the checklist to run on every client file before the year closes.

1. Hunt Down Duplicate Payments

Run a duplicate payment check across all 12 months. Don't just look for matching invoice numbers — look for the same vendor, same amount, same date across Bills, Expenses, and Checks. Cross-object duplicates (bill + expense) are the ones QuickBooks structurally cannot catch and the ones that overstate your P&L. Flag every suspected pair and confirm or dismiss each one. This alone often pays for the entire year-end engagement.

2. Verify the Vendor Master

Review every active vendor for basic information: tax ID/W-9 on file, contact details, correct payment information. Flag any vendor with no contact info, no tax ID, or recent name/banking changes. Confirm with the client which vendors are still active and which can be made inactive. Merge any duplicate vendor records you find.

3. Apply All Unused Vendor Credits

Run the aging report and flag every vendor credit that was never applied to a bill. Match each credit to open bills with the same vendor and apply them before the last payment run of the year. Credits left unapplied at year-end become next year's problem — or, worse, get written off entirely.

4. Review Recurring Charges and Subscriptions

Inventory every recurring charge across the year. Flag any subscription the client no longer uses, any charge whose price increased without notice, and any vendor billing monthly that should be on an annual plan. Present the annual recurring-spend number to the client and walk the list together. This conversation alone often justifies your advisory fee.

5. Check Approval Threshold Compliance

Review bills for clusters that may have split a single purchase to stay under the approval limit. Same vendor, close in time, combined total crossing a round threshold. This is not about accusing anyone — it's about verifying that the control is actually working. Flag any clusters for the client or controller to explain.

6. Verify 1099 Readiness

Identify every vendor that should receive a 1099. Confirm you have a W-9 on file for each one. Flag any contractor above the $600 threshold who is missing tax documentation. This is the step that, if skipped, becomes a January emergency — and January vendors are harder to reach than December vendors.

7. Run the First-Digit Screen

If the file is large enough, run a forensic first-digit screen across the year's bill amounts. This is the test forensic accountants use to surface ledgers where amounts look fabricated rather than real. On most files, it stays silent — and that silence is itself a finding worth documenting. On files where the amounts drift from the natural pattern, you get one calm flag and a pointer to where to look.

8. Review GL Coding Consistency

Spot-check large expenses for correct GL account assignment. Flag any vendor whose coding deviated from historical patterns — a supplier always coded to 'Office Supplies' suddenly coding to 'Professional Services' could be intentional or a data-entry slip. Either way, confirm before the books close.

9. Prepare the CPA Handoff Packet

This is the deliverable that makes or breaks your reputation with the CPA. Don't hand over raw reports. Assemble a clean packet: each flagged item with its evidence, your review note and timestamp for each, a scope statement describing what was and wasn't reviewed, and a sign-off line. The CPA should be able to read your reasoning rather than reconstruct it. Invoice Auditor exports this as a separate register from the client-facing report — one for the CPA, one for the client.

10. Present the Books Integrity Score

Give the client one number: the Books Integrity Score, calculated the same way every time. Show what's behind it — the confirmed duplicate, the resolved credits, the items you cleared. Then run it again next quarter and show the improvement. A rising score turns invisible cleanup into visible progress the client can track.

Make It Systematic, Not Heroic

The goal isn't to spend 40 hours per client on year-end — it's to run the same systematic checks on every file in a fraction of that time. Invoice Auditor runs all ten of these checks in about two minutes per file, read-only. You get the flags, you decide what's real, and you assemble the packet. That's how you scale year-end across a full client roster without burning out. Free to use, no credit card required.

Run a free, read-only scan of your QuickBooks.

Start free scan