Importing bank statements

You can import the statement file you download from your bank, and Sliptree matches the payments in it to your unpaid invoices. Open Payments in the main navigation and click Import statement, which is at the top of every tab there.

Worth knowing: a statement line is not a payment yet. Each row of the file becomes a line in Sliptree, and it turns into a payment on an invoice only once it is matched, by Sliptree or by you.

Which file to download from your bank

Sliptree reads two kinds of statement files, up to 100 MB each:

XML: the ISO 20022 account statement (camt.053 or camt.052), which most banks offer as an "XML statement" or "ISO statement". LHV, SEB and Swedbank all export it, and Sliptree reads the account and every booked line from it with nothing to set up.
CSV: the spreadsheet export from your bank's statement page. Excel (XLSX) and OpenDocument (ODS) files work too.

If your bank offers both, choose XML. It carries more detail, such as payment reference numbers, which makes automatic matching more accurate.

Importing a CSV file

After you upload a CSV file, Sliptree shows the Match columns step. It guesses from the column headings which column holds the date, the amount, the payer and the other details, and shows a sample row so you can check the guess.

Change any column that was guessed wrong, and leave a column you do not need on Don't import. Date and Amount are required. The reference number and the description are optional, but matching works much better with them, so map them when your file has them.

Click Continue to start the import.

Which account the statement belongs to

Sliptree reads the account number from the file, if the file has one. A statement is never imported into another account than the one it names: if the two differ, Sliptree says so and stops.

When the account in the file is not in Sliptree yet, the New bank account step opens with the account's details, read from the statement. Check them, change the account name if you want, and click Create account and continue. The new account does not show on your documents until you turn on Show on documents in your bank account settings.

When Sliptree cannot find an account number in the file, the Choose bank account step opens. Pick the account the statement belongs to, or choose Add new account and type in its details.

When the statement belongs to an archived account, the step names that account and the import cannot go ahead. Restore the account from Manage accounts, then import the file again.

Only an Owner or Admin can add or restore a bank account. A Member sees which account the statement is from and asks one of them to add or restore it, then imports the file again.

While the import runs

An import usually takes less than a minute. You can close the dialog while it runs, and the import carries on. If you close it before the import finishes, Sliptree emails you the results.

What happens after the import

Sliptree matches the new lines straight away: money in to unpaid invoices, and money out to credit notes. The result shows how many lines were matched and how many need your attention.

Transfers between your own accounts are ignored before matching starts, and the result says how many there were. A line counts as one when the other account is one of your bank accounts in Sliptree, archived ones included, or when the payer's name is your company's name.

When a line's reference number or invoice number points to one unpaid invoice, the line is matched automatically. The invoice is then paid, or partly paid if the amount was smaller. This also works for an invoice in another currency when the converted amount fits, as described in Matching bank payments to invoices.
When the reference number or invoice number points to an invoice that already has a payment you recorded by hand for the same amount, the line is linked to that payment, whatever its date. A recorded payment of the customer the line points to is linked too when it is dated from 3 days before to 14 days after the bank's date.
When Sliptree finds a likely invoice by other means, for example by the amount and the payer's name, the line gets the status Needs review. Sliptree suggests the invoice, and you confirm it. The same happens when the line could belong to more than one invoice or payment.
A short invoice number, such as 17, could also be a day or an order number. A line with one is matched automatically only when the amount fits and a word such as "invoice" or "arve" comes right before the number, or the payer is the invoice's customer. Otherwise it needs review.
Every other line stays Unmatched, so you can match it by hand, record it as customer credit, or ignore it.

Lines that need review and unmatched lines are both on the Unmatched tab. The number next to Payments in the navigation counts them, except money out that is waiting unmatched. See Matching bank payments to invoices for what to do with them.

Importing the same statement again

Importing a statement twice, or two statements whose periods overlap, is safe. Lines that are already in Sliptree are skipped, and the result says how many were skipped.

Deleting a statement

Each import is a row on the Bank statements tab, and opening it shows the statement's lines. To remove an import, choose Delete statement from the row's menu.

Deleting a statement removes its lines that are not matched, including ignored lines and lines that need review. Lines that are already matched stay, and so does the statement, so no invoice changes. If you want those lines gone too, tick the option for them in the dialog. Their payments are then deleted, including a payment you recorded by hand that a line was linked to, and any customer credit left on them goes too. Each invoice goes back to unpaid or partly paid, and the whole statement is deleted.