Convert a bank CSV to QBO

Steps

1. Open the CSV in Ledgermere. The heading row and columns are detected automatically – even when the bank puts account details above the table.
2. Check Columns / options: one Amount column (+/−), or separate Debit and Credit columns, the date order, and the number format.
3. Choose QBO, enter the account number if you want QuickBooks to remember the account, and download.

Columns Ledgermere recognises

Headings like Date, Posting Date, Description, Payee, Memo, Amount, Debit, Credit, Withdrawals, Deposits, Paid out, Paid in, Balance, Check number and Reference – and their Spanish, Portuguese, French, German, Italian and Dutch equivalents. A column marked Dr/Cr or D/C sets the sign.

Re-importing safely

Every transaction gets a FITID derived from its date, amount and text. Converting the same CSV again gives the same IDs, which QuickBooks uses to skip transactions it already has.