Citi CSV won't import? Convert it for QuickBooks, Xero or YNAB.

StatementSnap reads the Citi export, fixes dates and amounts, and gives you a file your accounting or budgeting app accepts.

Your file never leaves your computer. Everything runs in this page. No upload, no account, no server.

Drop your bank CSV here or

or try a sample

What a Citi export looks like

The sources do not state the date format, and the sample uses made-up rows. StatementSnap reads the signed Credit value as money in, so payments come out positive. Not affiliated with Citi.

How to use

  1. Download your transactions as CSV from Citi.
  2. Drop the file into the box above. Nothing is uploaded.
  3. Check the preview, pick QuickBooks, Xero, YNAB or Actual Budget, and download.

The "try a sample" link above loads made-up rows in this layout.

Free online, or the offline edition

Online (this page)

Free

  • First 25 rows per file
  • All 5 import formats
  • Fully private, runs in your browser

Offline edition

$29 one time

  • One file you keep, works with no internet
  • No row limit, no key, no account
  • Same private conversion, for as many statements as you like
Buy the offline edition

FAQ

Is my bank data uploaded?

No. The converter is JavaScript running in your browser tab. You can disconnect from the internet after the page loads and it still works.

Which banks work?

Any bank that exports CSV. Dates, delimiters (comma, semicolon, tab), European number formats, separate debit/credit columns, headerless files and extra summary rows are handled, and you can override the column mapping.

What about ambiguous dates like 03/04/2024?

If every date could be day-first or month-first, the tool warns you and lets you pick the order before downloading.

Is this affiliated with any bank, Intuit, Xero or YNAB?

No. Names are used only to describe which file layout or import format is meant.

Guides by bank

Chase: QuickBooks Xero YNAB Actual Budget

Bank of America: QuickBooks Xero YNAB Actual Budget

Capital One: QuickBooks Xero YNAB Actual Budget

Wells Fargo: QuickBooks Xero YNAB Actual Budget

American Express: QuickBooks Xero YNAB Actual Budget

U.S. Bank: QuickBooks Xero YNAB Actual Budget

Citi: QuickBooks Xero YNAB Actual Budget

Discover: QuickBooks Xero YNAB Actual Budget

PNC: QuickBooks Xero YNAB Actual Budget

Ally Bank: QuickBooks Xero YNAB Actual Budget

Stripe payouts: QuickBooks Xero YNAB Actual Budget

Truist: QuickBooks Xero YNAB Actual Budget

PayPal: QuickBooks Xero YNAB Actual Budget

Templates: QuickBooks bank CSV template Xero CSV template YNAB CSV format Actual Budget CSV import

Troubleshooting: Bank CSV import errors in QuickBooks Online