Saveable template
Run this checklist before the QBO upload, not after the reconciliation gets messy.
This checklist is for reviewers who want to confirm the file is genuinely QuickBooks Online-ready before they upload it into the banking workflow.
Use this when
- PDF statement to QBO-ready CSV
- Historical imports into QuickBooks Online
- Final reviewer sign-off before QBO upload
How to use it
- Run the checklist immediately before the QuickBooks Online upload step.
- Treat any failed item as a blocker, not a suggestion.
- Save the checklist with the workpaper or reviewer notes if your team requires sign-off evidence.
Copy-ready template
QBO Import Prep Checklist
QBO IMPORT PREP CHECKLIST Client: Account: Period: Reviewer: Upload date: Before uploading into QuickBooks Online, confirm: 1. SOURCE AND PERIOD - Correct client and bank/card account selected - Correct statement period or historical range - All required statements for the batch are included 2. ROW QUALITY - Dates look correct and in the expected range - Descriptions are readable enough for downstream review - No obvious statement headers, totals, or non-transaction rows remain 3. AMOUNT AND SIGN CHECK - Deposits are positive - Payments and withdrawals are negative - No obvious sign flips remain 4. DUPLICATES AND TRANSFERS - Duplicate rows have been reviewed - Obvious transfers are identified - Reviewer is comfortable that cash movement will not be double-counted 5. FORMAT CHECK - File exported in the QBO-ready format, not generic CSV or another destination format - Reviewer understands which QuickBooks Online account will receive the import - File name is clear enough for future lookup 6. EXCEPTION CHECK - Large unusual items have support or notes - Owner transactions are flagged or resolved - Unclear deposits have been classified or escalated 7. FINAL REVIEWER SIGN-OFF - I would be comfortable reconciling this file after import - I would be comfortable explaining any flagged exceptions to the next reviewer - Upload is approved Reviewer name: Date: Notes:
Why this checklist matters
QuickBooks Online import issues usually trace back to bad prep, not to the upload screen itself. A short pre-upload checklist catches the easy failures before they become a reconciliation mess.
What this checklist is trying to stop
The goal is to stop preventable issues like bad signs, duplicate rows, wrong account selection, or a file that was exported in the wrong format and only discovered after upload.
- Wrong direction on deposits and withdrawals
- Duplicate rows from OCR or overlapping pages
- Uploading to the wrong QuickBooks Online account
Related pages
Use the template next to the workflow it supports.
QuickBooks Online integration workflow
See where this checklist fits in the full statement cleanup and QBO prep flow.
Open page →
Bank statement to QBO
Open the workflow page designed around QBO-ready statement exports.
Open page →
Bank statement cleanup SOP
Use the SOP upstream of the final QBO reviewer checklist.
Open page →
FAQ
Frequently asked questions
When should I run this checklist?
Immediately before the QuickBooks Online upload. It is designed to be the last reviewer gate before import.
Should junior staff use this too?
Yes. It is especially useful for junior reviewers because it makes the pre-upload standard explicit instead of relying on memory.
What is the most common problem this catches?
Wrong sign behavior and wrong export format. Those are the fastest ways to create cleanup work after upload.
Can I adapt this for other systems?
Yes, but keep a QBO-specific version. The final checks should always reflect the destination system's import expectations.
Want fewer vague requests and cleaner reviewer handoffs?
Use the template, then plug it into the workflow page that matches your statement cleanup and import-prep process.
Free Plan includes up to 1 client total. No credit card required.