Bank CSV to QuickBooks (Credit and Debit)

A bank statement CSV with Date (month first), Description, Debit and Credit columns, for QuickBooks Online's 4-column bank upload.

Download the workflowOpen the Data Workspace

Processed locally in your browser. File contents are not uploaded. No account needed.

Before and after

Made-up rows from the sample file, run through the same code Rote Workspace runs, when this page was built. Removed rows are struck through; changed cells are highlighted — point at one for its old value.

Data Workspacebank-to-quickbooks-4-column.csv4 rows · 5 columns · UTF-8 Processed locally

Original

Before: the sample file
RowDateDescriptionDebitCreditBalance
29/1/2026COFFEE SHOP$4.50$1,995.50
39/15/2026PAYROLL DEPOSIT$2,000.00$3,995.50
4 (removed)
512/3/2026RENT (has spaces at its edges)$1,200.00$2,795.50

Result

After: Bank CSV to QuickBooks (Credit and Debit)
RowDateDescriptionCreditDebitBalance
209/01/2026 (changed)COFFEE SHOP4.50 (changed)$1,995.50
309/15/2026 (changed)PAYROLL DEPOSIT2000.00 (changed)$3,995.50
512/03/2026 (changed)RENT (changed)1200.00 (changed)$2,795.50

3 rows × 5 columns after the fixes · was 4 × 5 · 7 cells changed

· marks a space at the start or end of a value. The dots are not in the data; they show spaces you would otherwise not see.

Why

QuickBooks accepts exactly Date, Description, Credit, Debit in that order, with blank cells rather than 0 and no currency signs; bank files rarely arrive that way.

What it does

  1. Remove empty rowsOn the sample: 1 row removed
  2. Trim spaces in every columnOn the sample: 1 cell changed
  3. Read "Debit", "Credit" as numbers (decimal mark: dot, 1,234.56); values that are not numbers are left as they areOn the sample: 3 cells changed
  4. Rewrite the dates in "Date" (read as month first) as MM/DD/YYYY; blank and unreadable values are left as they areOn the sample: 3 cells changed
  5. Put the columns in this order: "Date", "Description", "Credit", "Debit"; any other columns followOn the sample: columns reordered

Your file needs these columns, spelled exactly: Date, Description, Debit, Credit. If one is missing or renamed, the workflow tells you which step it breaks and does not run.

QuickBooks reads only these four columns, which this puts first. Drop any others with Columns ▾ → Drop before you download.

How to use it

  1. Download the workflow

    A small .json file with the steps above — no data. Want to try it first? Use the sample file (made-up rows).

  2. Open your export

    In the Data Workspace, choose your file. It is processed in your browser, not uploaded.

  3. Import, review, run

    Workflow → Import, choose the file — or skip the download: under Workflow → Templates, press Check & open. Each step is checked against your columns; press Run on this file, then Download.