Actual Budget CSV import

A free template and the import options Actual offers for CSV files. Already have a bank CSV? Drop it in the box and StatementSnap converts it.

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

Download the template

Rows are made-up examples. In Actual you choose which column is which, so the header names are a convenience, not a requirement.

How to fill it in

  1. Delete the example rows and keep the header row.
  2. Use one signed Amount column, or keep separate in and out columns and turn on "Split amount into separate inflow/outflow columns" when importing.
  3. In Actual, open the account, press Import, and select the file.
  4. Pick the column for each field, check the green date that shows how Actual read the date, and change the date format if it is wrong. Use "Flip amount" only if signs come out reversed.

Source: Actual Budget docs: Importing transactions. Actual's documentation also lists QIF, OFX, QFX and CAMT as importable. Not affiliated with Actual Budget.

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