Two CSV layouts
- Money in / money out: Date, Description, Money in, Money out, Balance.
- Signed amount: Date, Description, Amount (negative for payments), Balance. This is what most accounting apps expect.
Dates are written as YYYY-MM-DD, which every spreadsheet and accounting app reads without guessing day and month order. The file starts with a byte-order mark, so Excel opens currency symbols and accents correctly.
Already have a CSV and need QuickBooks?
Drop the CSV here instead of a PDF and download it as QBO, OFX or QIF.
More: Bank statement PDF to Excel · PDF statement to QBO (QuickBooks) · CSV to QBO