Banking
Linking a bank or uploading a bank file
Get transactions into the bank feed automatically or from a downloaded file.
Link your bank
Where bank linking is available, click Link account on the Banking page, sign in to your bank and choose which accounts to bring in and which account in your books each one feeds. New transactions come in daily, or when you click Update.
Upload a file
- 1Download transactions from your bank's website as .qbo (QuickBooks Web Connect), .qfx, .ofx or .csv. Prefer .qbo/.qfx/.ofx: they include the bank's own transaction ids and the statement balance.
- 2On Banking, select the account and click Upload from file.
- 3MitoBooks imports the lines, skips ones you've already uploaded, and matches what's already in your books.
CSV tips
A CSV needs a header row with a Date column and either an Amount column or separate Debit/Credit (Withdrawal/Deposit) columns. A Type column that says Debit/Credit or DR/CR is used to sign unsigned amounts.
US (month/day) and day-first dates are both understood — MitoBooks works out which from the dates themselves. Rows it can't read are listed with their line numbers after the upload.
Many credit card CSVs show charges as positive numbers. MitoBooks spots that for card accounts and reads them as charges. If money in and money out still look reversed, click Re-upload with signs flipped in the upload message.
A file that contains several accounts is refused — download one file per account.
Undo an upload
Click Undo upload in the upload message to remove that file's lines from the feed. If you've already added some of them to your books, undo those first on the Categorized tab.