What the QuickBooks file contains
Three columns, in this order: Date, Description, Amount. Money in is a positive amount and money out a negative one, as in the 3-column example in Intuit's guide, with no currency symbols and no thousands separators. Dates are written the way you choose; Intuit's guide recommends dd/mm/yyyy.
Importing it into QuickBooks
- Convert your statement above and press QuickBooks to download the CSV.
- In QuickBooks Online, upload the file to the bank account it belongs to. For a credit-card statement, choose the credit-card account, not a bank account, as Intuit's guide says.
- When QuickBooks asks, match its fields to the file's columns and pick the date format you chose here.
Source: Intuit: Format CSV files in Excel to get bank transactions into QuickBooks. MyFulus is not affiliated with or endorsed by QuickBooks.
How the conversion is checked
Most statements print a running balance beside each line, an opening and a closing balance, or totals for the period. Every converted line has to agree with them exactly. If they agree, you see that it was checked; if they do not, you see which lines to compare with your statement, on screen and in the Excel file. If a statement prints none of them, you are told it could not be checked. See an example.
Quick answers
Why does QuickBooks refuse some bank CSV files?
QuickBooks Online accepts a 3-column (Date, Description, Amount) or 4-column (Date, Description, Credit, Debit) layout, and a bank's own export often has extra columns, summary rows or a different order. The file MyFulus writes is the 3-column layout and nothing else.
Can I import more than 90 days at once?
Intuit's guide says a manual upload can bring in more than 90 days of transactions. Convert each statement and upload the files one after another.
Is anything kept after I download the file?
No. The statement is read in memory and never saved, and the converted lines are deleted after 60 minutes, or as soon as you press Delete.