Importing a bank or card statement
Upload a CSV statement from your bank or credit card to bring its lines into your books. Works on every plan.
Import a statement to bring a month, or a whole year, of bank or credit card lines into your books. It works on every plan, and you can use it alongside a connected bank.
Co-owners of the books and bookkeepers can import. Accountants with view-only access can't.
Get the file from your bank
In your online banking, download the account's transactions as a CSV file. Signet doesn't read PDF statements. The file must be under 2 MB; if your bank's file is bigger, download a shorter date range.
Import it
- Go to Money → Accounting, open Add and choose Import a statement.
- Under Bank account, pick the account the statement is from. The first time, add it instead: press Add an account, choose Business chequing or Business credit card, type a Name and the Last 4 digits, then press Add account.
- Press Choose a CSV file and pick the file.
- Check the preview of the first lines. If they look right, press the import button. It names the number of lines, like Import 42 lines.
- Signet shows how many lines it added and how many it skipped because they were already there. Press Sort them now to start sorting.
Only business accounts can be imported this way. A personal account that sometimes pays business costs comes in through a bank connection instead.
Statements Signet already knows
Signet reads statements from these banks without asking anything: RBC Royal Bank, BMO (chequing and credit card), Scotiabank (chequing and credit card), CIBC credit card, and TD.
Any other bank
For any other file, Signet asks which column holds what:
- Under First row, say whether it holds Column names or A transaction.
- Pick the Description and Date columns, and the Date format.
- For amounts, choose One amount column or Money out and money in columns, then pick the columns. With one column, say how money out shows: A minus number (-12.34) or A plain number (12.34).
- Press Use these columns and check the preview.
If you see "Dates could be read either way. Check the preview.", make sure the days and months look right before you import. Signet remembers your columns for that account, so next month's file goes straight to the preview. To change them later, press Change columns on the preview.
If some rows can't be read, Signet lists them and won't import until they're fixed, in the file or by changing the columns.
Overlapping statements
You don't need to be careful about dates. Lines that are already in your books are skipped, so importing overlapping statements won't double anything.
Undoing an import
Recent imports are listed under Recent imports on the same page. Press Undo next to one, then Undo import.
This removes that file's lines that aren't confirmed yet, with their receipts. Confirmed lines stay. If a later import covered the same dates, the lines it shared with this file go too; import that file again to bring them back.