Bookkeeping CSV format
Bank Statement CSV Format for Bookkeeping
A review-friendly CSV keeps transaction context, amount direction, and running balances together so that spreadsheet cleanup and reconciliation take less time.
Before you export
Keep the bookkeeping review short and deliberate
- 1
Standardize dates before sorting or importing the file.
- 2
Retain the bank-provided description instead of shortening it too early.
- 3
Use separate debit and credit values when the source statement provides them.
- 4
Keep balance and page number fields to make reconciliation traceable.
Why a bank statement CSV needs more than date and amount
A minimal CSV can be convenient for a quick pivot table, but it is difficult to audit. When a row looks wrong later, the original description, running balance, and source page provide the context needed to correct it quickly.
The goal is not to force every accounting system into one schema. It is to create a clean intermediate file that is easy to inspect, filter, and map to the next workflow.
Debit, credit, and amount should not contradict each other
Some banks show separate deposits and withdrawals; others use one signed amount column. Preserve the values supplied by the source where possible, then normalize the amount field consistently for analysis.
Before importing, check a few rows against the PDF. A reversed sign can make a file appear valid while producing the wrong cash movement.
Balance and confidence fields support human review
A running balance is useful for detecting missing rows, merged transactions, and decimal errors. Parser confidence is not a guarantee of correctness, but it is a useful sort key for deciding which rows deserve attention first.
For sensitive statements, review the output in your browser before export. Files are processed temporarily and the original PDF is deleted after conversion by default.
Prepare the CSV before an accounting import
First reconcile the exported rows with the statement period and ending balance. Then make any system-specific column mapping in a copy of the CSV. This preserves a clean source export for future review.
QuickBooks and Xero-specific CSV templates are planned. Today, the converter provides a generic CSV and Excel workbook so you can verify and adapt the data yourself.
CSV structure
A practical bank statement CSV format
Keep the original transaction description and running balance. They make reconciliation and later error review much easier than a minimal date-and-amount export.
| Column | Purpose |
|---|---|
| date | Transaction date in a consistent date format. |
| description | Merchant, payment reference, or bank transaction description. |
| debit | Money leaving the account, when the statement separates debits. |
| credit | Money entering the account, when the statement separates credits. |
| amount | Normalized signed amount when a single amount column is useful. |
| balance | The running balance after the transaction. |
| pageNumber | Source PDF page for quick visual review. |
| confidence | Parser confidence to help prioritize manual checks. |
Sample demo
Try the converter with a fictional bank statement
Use the sample PDF to see the workflow before uploading a private statement. The downloadable CSV and Excel files show the kind of clean transaction table this converter is designed to produce.
- Fictional account data only
- No bank login required
- Review rows before export
- Source PDFs are deleted after conversion by default
| Bank | Sample Bank |
|---|---|
| Account | Business Checking ending 4821 |
| Statement period | Jan 1, 2026 to Jan 31, 2026 |
| Starting balance | $10,000.00 |
| Ending balance | $13,330.96 |
| Validation | 0 balance issues in the sample output |
| Date | Description | Debit | Credit | Amount | Balance |
|---|---|---|---|---|---|
| 2026-01-03 | ACH CREDIT ACME PAYROLL | - | 2,850.00 | 2,850.00 | 12,850.00 |
| 2026-01-05 | CARD PURCHASE OFFICE SUPPLY | 184.29 | - | -184.29 | 12,665.71 |
| 2026-01-08 | WIRE TRANSFER CLIENT PAYMENT | - | 1,200.00 | 1,200.00 | 13,865.71 |
| 2026-01-10 | SERVICE FEE BUSINESS CHECKING | 15.00 | - | -15.00 | 13,850.71 |
| 2026-01-18 | ACH DEBIT CLOUD SOFTWARE | 119.75 | - | -119.75 | 13,730.96 |
| 2026-01-24 | ATM WITHDRAWAL MAIN STREET | 400.00 | - | -400.00 | 13,330.96 |
Convert a statement
Upload a PDF and review the transaction table
The converter highlights low-confidence rows and balance interruptions before you download CSV or Excel. Source PDFs are processed temporarily and deleted after conversion by default.