Supported statement formats
Updated
Langbyrde reads a statement by what is inside the file, not by its name. Any of the extensions below works, and a file whose extension is not listed is simply not offered as a statement. The format is named in the account's Statement format picker and in the Format column of the imports list.
What to choose when your bank asks
Some banks, RBC among them, ask which software the download is for. Each choice gives the same kind of file:
| The bank's list says | Download | Langbyrde reads it as |
|---|---|---|
| Quicken | .qfx | OFX / QFX / QBO |
| QuickBooks | .qbo | OFX / QFX / QBO |
| Money | .ofx | OFX / QFX / QBO |
| Sage 50 Accounting | .asx | OFX / QFX / QBO |
| Makisoft Personal, Makisoft the Accountant | .afx, .aso | OFX / QFX / QBO |
| Spreadsheet software (.csv for Excel, Quattro Pro, Lotus) | .csv | CSV |
When you have the choice, OFX / QFX / QBO is the most dependable: it carries the account's currency and the opening and closing balances.
The formats
| Format | Extensions | Carries | Good to know |
|---|---|---|---|
| OFX / QFX / QBO | .ofx, .qfx, .qbo, .afx, .aso, .asx, and OFX 2 as .xml | Bank and credit card statements: currency, dates, amounts, balances | The same format under each accounting package's name. A download can hold several accounts: see below. |
| CAMT.053 XML | .xml | ISO 20022 bank statement: currency, booking and value dates, balances | A file can hold several statements, one per account: see below. |
| MT940 | .sta, .mt940, .940 | SWIFT statement: currency, dates, balances | Several messages for the same account are read as one statement when the balances join up. A file with several accounts is read account by account: see below. |
| QIF | .qif | Dates, amounts, vendor names | States no currency and no date order. Amounts are read in the account's currency. A Quicken export of several accounts is read account by account: see below. If every date could be read day first or month first, Langbyrde uses the order set under Statement dates and stops when it is left at Not set: decide from each file, and stop when it is unclear: the failed import says so and links to that setting (Set the statement date order), then bring the file in again. |
| CSV | .csv, .txt | Whatever columns the file has | RBC's own CSV (Account Type, Account Number, Transaction Date, Cheque Number, Description 1, Description 2, CAD$, USD$) is read as it is, and RBC's "all accounts" download is read account by account: see below. Any other CSV asks you to map its columns once; the mapping is remembered for the account. |
| PDF statement | .pdf | Lines read from the page | Only where Langbyrde has a reader for that layout: RBC chequing, savings, Mastercard and Visa, Scotiabank card, and Wise. Other PDFs are not read; use the bank's OFX or CSV download. |
A download with several accounts
Some banks put every account into one download: a chequing account, a savings account and a card in the same file. Langbyrde reads such a file account by account when it is OFX / QFX / QBO, CAMT.053 (one Stmt block per account), MT940 (a new statement wherever the account changes), QIF (one statement per !Account section, listed in your company's reporting currency and statement date order until you choose the account) or RBC's CSV (one statement per Account Number). It lists each account it finds in the file, with the last four digits of its number (for QIF, the account's name), its currency, the dates it covers and how many transactions it holds, and asks where each one goes:
- An account you already have. When one of your accounts ends in the same four digits, it is suggested. It is only a suggestion: check it, then import.
- New account… opens the same form as Accounts › Add account, already filled in with the kind and currency the file states. Check the details and save.
- Skip: do not import. Nothing is imported from that account, and the list says so.
Import N statements then starts one import per chosen account. Each one is reviewed, imported or reverted on its own. The file is kept once in your documents, filed under the first account you import. CSVs other than RBC's are still read one account per file.
When a file is not recognized
The import fails and says why: it lists every format Langbyrde tried, what each one looks for and how sure it was, and what the file looks like (a PDF or text, its size and the number of fields on its first line), never its contents. Choose the format by hand with Choose format… on the import's row (Choose another format… when one was tried), or for a CSV choose Re-map columns. See Importing a statement.
Not supported
- Open Financial Connectivity (
.ofc) files, an older format that is not OFX. - Statements as images or scans.
- A PDF from a bank whose layout Langbyrde has no reader for.
Nothing leaves your computer when you import: every format is read locally.