Cosmovex/tools

Convert a bank statement PDF to a CSV for QuickBooks import

QuickBooks import CSV with Statement to Spreadsheet

This page opens with the four-column layout: Date, Description, Credit and Debit. QuickBooks Online's bank upload accepts a CSV with either those four columns or three columns, Date, Description and a single signed Amount, and you can switch between them under Columns before you download.

  1. Drop your statement PDF on the tool. It is read in your browser and never uploaded.
  2. Check the preview and the balance check, and tick or fix any amber rows.
  3. Under Columns choose QuickBooks with Credit and Debit, or QuickBooks with a single Amount, then set Dates to the format your QuickBooks region expects.
  4. Press Download CSV and upload it in QuickBooks Online using the bank upload for CSV files.
bank statement to quickbooks csv convert pdf bank statement to quickbooksquickbooks bank upload csv formatquickbooks online csv date description credit debitbank statement pdf to csv for accounting software
Open Statement to Spreadsheet Free to start · no account

What to know

QuickBooks Online imports bank transactions from a CSV in a fixed shape: a Date column, a Description column, and either one Amount column or separate Credit and Debit columns. This page produces exactly those columns and nothing else, with no balance or reference column to confuse the mapping, so the import screen maps cleanly.

Dates are the usual source of failed imports. QuickBooks expects the date format of your region, such as day, month, year or month, day, year, and every row must use the same one. The Dates option writes them as dd/mm/yyyy, mm/dd/yyyy or yyyy-mm-dd, so you can match what your QuickBooks account uses; check one imported row before importing the whole file.

In the four-column layout, money in goes in Credit and money out goes in Debit, each as a positive number with the other left blank. In the three-column layout the amount is signed, with money out negative. Only the rows you have ticked are included, so rows the tool could not read stay out of your books until you have looked at them.

Updated · Cosmovex

Questions

Which columns does the QuickBooks CSV have?

Either Date, Description, Credit, Debit, or Date, Description, Amount. You choose under Columns. Credit and Debit are positive numbers; in the three-column layout money out is negative.

Which date format should I choose?

The one your QuickBooks account uses for its region. Choose dd/mm/yyyy, mm/dd/yyyy or yyyy-mm-dd under Dates, and test with a few rows first, because every row must use the same format.

Does this connect to QuickBooks?

No. It only makes the CSV, in your browser. You upload the file yourself using QuickBooks' own bank upload, so no login or bank connection is involved.

Are unreadable rows imported?

No. Rows with a date but no amount, or an amount but no date, are shown in the preview and excluded until you tick them.

Is the statement uploaded to a server?

Not by this tool. The PDF is read and the CSV built in your browser. What you upload to QuickBooks afterwards is your own step.

The free plan covers everything on this page. Statement to Spreadsheet Pro ($9/mo, billed monthly) is described on the Statement to Spreadsheet page.