Signed-amount bank sample
Fictional source rows with negative withdrawals, positive deposits, quoted descriptions, and stable references.
Download CSVOriginal download library
Practice files and import controls.
Use transparent fictional examples to understand supported layouts, then document each real import without sharing financial records with Bank2QBO.
Debit-and-credit bank sample
Fictional source rows showing separate money-out and money-in columns with one direction blank per row.
Download CSVQuickBooks three-column template
A blank Date, Description, Amount layout plus one clearly marked fictional example row.
Download CSVImport control log
Record account nickname, source, date window, row count, net amount, filename, test status, and reconciliation date.
Download CSVPost-import reconciliation checklist
A printable sequence for confirming scope, signs, counts, duplicates, balances, and retained evidence.
Download TXTHow to use the samples safely
Every transaction and identifier in these files is fictional. Open the samples to compare column structure, but never import a sample into production books. For a real test, export a short date range from one account, keep the untouched original, and work on a copy.
The template is intentionally minimal. A QuickBooks upload still requires you to choose the destination account, map the source fields, review transaction direction, and reconcile the result.
Why the control log matters
Duplicate imports often begin with uncertainty about the last successful date range. The log creates a local record of the account nickname, source, period, row count, net movement, filename, and reconciliation status. Store it under the same access controls as your other bookkeeping records.
Start with the CSV readiness checker, then read the controlled import guide.