What Columns Does QuickBooks Need for a CSV Import? The Exact Format
QuickBooks Online reads a bank CSV with 3 columns (Date, Description, Amount) or 4 (Date, Description, Credit, Debit). Here is the exact format.
Read articleArticles and updates on bank statement conversion, reconciliation and automation.
QuickBooks Online reads a bank CSV with 3 columns (Date, Description, Amount) or 4 (Date, Description, Credit, Debit). Here is the exact format.
Read articleTurn your credit union PDF e-statement into a clean Excel or CSV with the running balance and full multi-year history, not just the short online export window.
Read articleTransfers between your own accounts and credit card payments are not income or expenses. Here is how to categorize them as transfers so you stop double counting your books.
Read articleThe running balance belongs to the statement, not the transaction list. Here is why banks leave it out of downloads, and what you lose when it is missing.
Read articleThe effective entry date is the date you want an ACH payment to settle, and it is not the same as the settlement date. Here is how the two differ and what happens when the date is wrong.
Read articleCombining CSV downloads from several banks means fixing four things first: headers, column order, sign convention and date format. Here is the order to do it in.
Read articleMost states look back three or four years, six for a substantial understatement, and with no limit at all for periods where no return was filed.
Read articleWhat a bookkeeper actually does, what it costs, the questions to ask, and how to prep your records so the first month goes smoothly and you do not overpay.
Read articleGoogle Sheets can't open a PDF directly. Convert the statement to CSV first, then use File > Import to load clean rows with dates, amounts, and running balance.
Read articleTotal each quarter's business deposits, subtract categorized expenses, and apply income tax plus self-employment tax. Here is the bank-statement method for 1040-ES, with the 2026 deadlines and safe-harbor rule.
Read articleCancel anytime from your account settings · refund policy
Get started converting bank statements to spreadsheets.
USD
per month
per month
$288 charged today
Choose speed vs accuracy when extracting
| Base AI Faster | 2,500 pages |
| Pro AI Best accuracy | 500 pages |
Scale statement conversion across your team with automation.
USD
per month
per month
$888 charged today
Choose speed vs accuracy when extracting
| Base AI Faster | 10,000 pages |
| Pro AI Best accuracy | 2,000 pages |
Enterprise-grade bank statement conversion and controls.
USD
per month
per month
$ charged today
Choose speed vs accuracy when extracting
| Base AI Faster | pages |
| Pro AI Best accuracy | pages |
Try it once, free: sign up and convert up to 15 pages (5 per statement) with no credit card. The demo does not renew.