Import your bank's files
Works on: iPhone, iPad, Mac.
Premium Reading PDF statements and statement photos is part of Premium. CSV, OFX and QFX files are free. Try Premium free for 30 days. Pricing and features may change before launch.
Bring a bank's statement into an account so you do not type each purchase.
- Download a CSV, OFX or QFX file from your bank, or use a PDF statement or a photo of one.
- Open "Manage Accounts" with the "Manage" link in the Accounts screen's toolbar. On iPhone that is the Accounts tab, then "Manage". On iPad it is "All Accounts" (or "Settings", then "Accounts"), then "Manage". On a Mac it is "Manage" in the sidebar, then "Accounts", then "Manage". Open the "Import Statement" menu. You can also open an account's "..." menu and choose "Import Statement".
- Premium PDFs and photos need Premium. CSV, OFX and QFX files are free. The "Import Statement" menu has "Choose File…", "Scan Statement" and "Choose from Library". On a Mac it has "Choose File…" and "Import from iPhone". A password-protected PDF shows "This PDF needs a password." Reading happens on your device.
- Choose the file. From "Manage Accounts", pick the account under "Import Into". Starting from an account's "..." menu skips "Import Into".
- For a CSV, "Map Columns" asks for the date, payee and amount columns, and the reference column if there is one. The app remembers the layout: for example, Chase statements will use these columns next time. If your bank writes amounts as 1.234,56, choose that format under "Amounts Look Like" on "Map Columns". If your statement has separate money out and money in columns, choose "Two Columns" under "Amounts Are In", then pick the "Money out column" and the "Money in column". Each row imports as money in less money out.
- On "Review Import", check each date and amount. For a CSV, a PDF or a photo, "Flip Signs" reverses the sign of every amount, for a statement that shows spending as positive. "Use All Suggestions" fills in every suggested category at once; see Let the app suggest categories. Every row shows its payee, amount, date and category. The page reads: "Importing into Checking." Nothing is written until you confirm. New names are remembered, so the next import follows them.
- A row that looks like one you already entered shows "Possible duplicate: same account, same amount, within three days." Choose "Skip", "Import anyway" or "Replace the transaction you entered". "Skip" is the default. Choosing "Replace the transaction you entered" asks "Replace the transaction you entered?" first.
- Confirm with the checkmark (on a Mac, "Confirm"). The app says, for example: "Imported 41 transactions into Checking."
A row with no category shows "Needs a category" and lists under that filter until you assign one.
On a credit card account, a payment to the card is proposed as a transfer from the account set under "Paid from" on "Manage Accounts", shown as "Transfer from Checking". You can change it before you confirm.
Each import is listed under "Import History" in the account's "..." menu. Open one and choose "Undo Import" to remove what it added.
A file with no transactions is turned away with a note and "Choose Another File". A CSV with only a header row shows "Nothing to preview" on "Map Columns".
A budget shared read-only cannot import.
Still stuck? Contact us.