Templates
Sample bank transaction CSV
Use a simple sample bank transaction CSV to check Date, Description, and Amount formatting before Excel or QuickBooks cleanup.
The simplest sample that is still useful
A three-column CSV is easy to inspect and easy to compare against a statement. Users can open it in Excel, sort by date, and quickly spot whether the extraction is shaped like transaction rows or generic PDF output.
- Date
- Description
- Amount
What to verify before import
Review before import still matters. Check that deposits are positive, withdrawals are negative, dates are consistent, and summary or balance rows did not slip into the file.
When extra review columns help
Balance, page, and needs-review flags can be useful during cleanup, especially on long or messy statements. They are review aids, not proof that the file is ready to import blindly.
No bank login required for test files
DocuRows uses uploaded files rather than bank credentials. Redacted files are fine if transaction rows remain visible, and original PDFs usually work better than scans.
Baseline sample
Date,Description,Amount 2026-04-02,ACH PAYMENT ACME SUPPLY,-128.44 2026-04-03,CLIENT DEPOSIT,2400.00 2026-04-04,MONTHLY SERVICE FEE,-12.00
Review before import. This sample is a helpful baseline, not a guarantee that every accounting product accepts the same file without adjustment.
FAQ
Should debits be negative and deposits positive?
Yes. Signed amounts make spreadsheet checks and QuickBooks prep easier for most cleanup workflows.
Can I use separate Debit and Credit columns instead?
Sometimes, but a single signed Amount column is the easiest place to start for review and troubleshooting.
Can I test with redacted files?
Yes. Redacted files are fine if dates, descriptions, amounts, and transaction rows remain readable.
Turn a statement file into reviewable rows
Upload a PDF, scan, screenshot, or clear photo and review the rows before downloading CSV.