Skip to content
MoneyBat Sign inGet started

Help

Import statements

No bank connection, or a bank Plaid does not cover? Import statements instead and MoneyBat stays complete. Open Accounts and choose Import a statement, or go to /app/import. Drop the file, check what MoneyBat read, and import. Every import is one run you can undo with a click.

Files that work

What happens on import

Categories come from your rules, what MoneyBat learned from your edits, and built in hints, plus the category column when the file has one. Transfers between your own accounts are paired. Transactions already in MoneyBat (the same bank id, or the same amount within a day with a similar description) are marked and skipped unless you choose "import anyway". Manual accounts can take the statement's closing balance, move by the net of what came in, or stay as they are. The file is processed in memory and dropped afterwards unless you choose to keep it with the import. Files can be up to 20 MB and 20,000 transactions.

Dates: month first or day first?

Dates like 03/04/2026 could be March 4 or 4 March. When every date in the file reads both ways MoneyBat asks you once, shows how the first row reads, and remembers your answer with the layout.

Keeping a manual account current

An account you added by hand shows "Imported 3 days ago" once you import into it, on Accounts and on the Overview. Turn on Remind me monthly on the account (or at the end of an import) and MoneyBat reminds you about four weeks after the last import.

How to export from common banks

These notes describe the banks' documented exports as of late 2026 and are best effort: banks change their sites. If a layout is not recognised, choose the columns yourself; it takes a few seconds and is saved for next time.

Chase
Sign in at chase.com, open the account or card, choose the download icon above the activity list, pick "Spreadsheet (Excel, CSV)" and a date range. Checking files have a Posting Date, Description, Amount and Balance; card files have Transaction Date, Description, Category and Amount (charges negative).
Bank of America
Sign in, open the account, choose Download above the transactions and pick "Microsoft Excel Format" or CSV. The file starts with a summary block; MoneyBat skips it and reads from the "Date, Description, Amount, Running Bal." row. Card exports have Posted Date, Reference Number, Payee, Address and Amount.
Wells Fargo
Choose Accounts, then Download Account Activity, pick the account and date range, and the "Comma Delimited" format. The file has no header row (date, amount, a star, check number, description); MoneyBat recognises the shape.
Capital One
Open the card or 360 account and choose "Download Transactions", then CSV. Card files have Debit (a charge) and Credit (a payment or refund) columns with dates like 2026-11-14. 360 files have one amount column and a Transaction Type of Debit or Credit.
Citi
Open the card, choose the export icon above the activity and pick CSV. Debit holds charges; Credit holds payments, which Citi prints as negative numbers. MoneyBat reads both as you would expect.
American Express
Open Statements and Activity, choose Download and pick CSV with the date range you want. Charges are positive numbers and payments negative; MoneyBat flips them so spending is money out.
TD Canada Trust
In EasyWeb open the account, choose Download above the activity and pick "Spreadsheet (.csv)". The file has no header row: date, description, withdrawal, deposit, balance. Dates are month first.
RBC Royal Bank
In Online Banking choose Download Transactions under the account list, pick "Excel (CSV)", the accounts and a date range. Every account is in one file; MoneyBat asks you to match each account number once and remembers it.
Scotiabank
In Scotia OnLine open the account and choose Download (CSV) above the activity. The file has no header row: date, amount, a blank, payee, description.
BMO Bank of Montreal
In Online Banking open the account, choose Download Transactions and pick CSV. The file starts with a note line and dates look like 20261114; both are handled.
CIBC
In Online Banking open the account, choose Download Transactions under the activity list and pick "Spreadsheet (CSV)". The file has no header row: date (2026-11-14), description, money out, money in, and the card number for credit cards.
Tangerine
Sign in, open the account, choose "Download Transactions" and pick CSV with a date range. Columns are Date, Transaction, Name, Memo and Amount.
Mint
Mint closed in 2024. If you downloaded transactions.csv before it closed, import that one file: every account is in it, and you match each Mint account to a MoneyBat account in one go. Mint categories are mapped to MoneyBat ones where the names line up.

Undoing an import

Each import is a run. Undo it from the Done screen or from Past imports on the import page. Its transactions are removed, a balance it changed goes back, and a kept file is deleted. Bank transactions and anything you typed in are never touched by an undo.