Import a bank statement

Bring your bank activity in from a statement file:

1. Go to Ledger › Banking › Statements.
2. Optionally set the currency (it defaults to Auto-detect Currency).
3. If you're uploading a CSV, OFX or QFX, pick the account it belongs to from the CSV/OFX account dropdown. A PDF statement names its own account, so you can leave this alone for one.
4. Click Upload Statement and pick a PDF, CSV, OFX, or QFX file: you can select several at once.

A PDF is read in the background: the row shows Processing, then flips to completed once TALISK_HQ has pulled out the transactions and checked them against the statement's own balances. CSV and OFX files import right away.

Extracted transactions land on the Transactions tab ready to categorize and match. Everything belonging to one account sits in one list in date order, whether it came from a statement, a connected bank feed, a file import or your own typing: under each date is a small note saying which. Each statement row lets you rename its account, Move it to another account, open it to fix any rows that don't tie, or delete it.

If a connected bank feed already delivered some of a statement's transactions, TALISK_HQ links those existing lines to the statement instead of importing them a second time. The statement still accounts for every line it lists, and any work already done on the feed's copy (a category, a match, a reconciliation) is left exactly as it was. On a line nobody has worked yet, the statement's own transaction date wins over the feed's posted date, which usually runs a day or three later.

Move really does move the transactions, not just the name on them, so use it when a statement was filed under the wrong account. TALISK_HQ refuses the move once any of those transactions has been categorized or matched: their entries are already recorded against the account they are on now, and shifting them would leave your books saying one thing and the transaction another. Clear the categories or unmatch first, then move. A line that actually came from your connected bank feed stays on its own account either way: the move releases its link to the statement instead of carrying it along.

If you skip the account dropdown on a CSV, its rows still import: they sit in their own CSV Import group instead of joining an account.

If the statement is in a supported foreign currency (for example USD), TALISK_HQ files it under a bank account in that currency, creating one if needed, and its lines convert to your book's currency at the rate for their date. If the statement is in a currency TALISK_HQ can't convert, or its lines end up on an account in a different currency, they still import but can't be categorized or matched, because posting them would book the foreign amount as your own currency. A health card on your dashboard lists each of those lines. If they were filed under the wrong account, Move the statement onto the account that really holds the money, typing that account's name exactly as it appears under Banking › Accounts: a statement moved onto a different account takes that account's currency, and so do its lines. A name that matches no account only renames the statement.

If the statement is already under the right account but its currency was read wrongly (a CAD statement read as USD, say), a Move can't fix it, because there is nowhere to move it. Instead, find it on the Statements tab in Banking: a note on the statement says which currency it was read in and which currency its account is held in, with a button to use the account's currency. Press it and confirm, and the statement and every line it imported take the account's currency; nothing new is recorded in your books. A line that came from your connected bank feed is left alone, since it belongs to the feed's own account. It only ever offers the account's own currency. TALISK_HQ refuses it while any of those lines has an entry in your books (from categorizing it, for example), is matched, or is part of a completed reconciliation, and the note says which. Clear the category or unmatch first. Once you have chosen a statement's currency this way (or by moving it, or by changing the currency in its preview), re-extracting it keeps your choice. Uploading the same file again as a new statement reads the currency off it afresh.