CSV format reference

The most flexible profile. Best for Excel/Numbers/LibreOffice or accounting tools that aren’t QuickBooks or Xero.

Columns (3-column / signed-amount mode):

Date,Description,Vendor,Category,Amount,Balance

Columns (4-column / two-column mode):

Date,Description,Vendor,Category,Debit,Credit,Balance

With “Include confidence notes” enabled, two extra columns are appended: Status,Confidence.

Strips to the minimum QuickBooks Online’s upload wizard accepts. Two layouts based on the debit/credit toggle.

3-column layout (signed Amount):

Date,Description,Amount

Amount is signed: positive = deposit/income, negative = withdrawal/expense.

4-column layout (Credit and Debit):

Date,Description,Credit,Debit

Credit and Debit are populated independently; no signs.

See Import to QuickBooks Online for the upload steps.

The exact column order Xero’s “Import a statement” wizard expects.

Date,Amount,Payee,Description,Reference

• Amount is always signed (Xero ignores the debit/credit toggle).
• Payee uses the ProofRows-normalized vendor when available, raw description otherwise.
• Description is always the raw bank description.
• Reference is left blank in v1 — we don’t extract check numbers yet.

See Import to Xero for the upload steps.

• Date: ISO date from the statement. Format on export is your choice: MM/DD/YYYY (US), YYYY-MM-DD (ISO), or DD/MM/YYYY (EU).
• Description: either the raw bank description or, when “Apply vendor normalization” is on, ProofRows’s canonical vendor name.
• Vendor: ProofRows’s vendor guess (e.g., “AMAZON.COM*RT4N9” → “Amazon”). Generic CSV only.
• Category: ProofRows’s category guess (Supplies, Utilities, Payroll, etc.). Generic CSV only.
• Amount / Debit / Credit: decimal with two places of precision. Empty cell means no value, not zero.
• Balance: running balance after the transaction, when the statement included it. Generic CSV only.
• Status: ProofRows review status — confirmed, review, low, or duplicate. Optional column.
• Confidence: integer 0–100. Optional column.

All profiles follow RFC 4180:

• Fields containing a comma, double-quote, or newline are wrapped in double-quotes.
• Internal double-quotes are escaped by doubling them.
• Line terminator is \n (LF). Excel handles this correctly.

By default, every transaction in the statement is included — confirmed, needs-review, low-confidence, and duplicates. Turn off “Include flagged rows” in the Export modal to ship only rows with status confirmed.

Best practice: resolve every flagged row in the review screen before exporting. The CSV is yours, but the audit log records exactly which rows shipped.

ProofRows is a productivity tool. Every export carries a confidence score but the responsibility for what hits your accounting system is yours. Spot-check a sample of transactions against the source PDF before importing into a real ledger.