Download the file from your online bank
With a KID agreement, the bank publishes a file of payments made with KID, usually once every working day. Where it is varies between banks — often under «Filer» (Files), «Avtaler» (Agreements) or «Innbetalinger» (Incoming payments). Ask your bank if you cannot find it.
Sportio reads OCR giro (Nets) and camt.054 (ISO 20022). The file can be up to 3 MB.
Import the file
- Go to ‘Finances’ → ‘Payments’ and choose ‘Import bank file’.
- Choose the file. Sportio shows what it contains before anything is posted: ‘Format’, ‘Payments’, ‘Matched automatically’, and where relevant ‘Without KID’, ‘Invalid KID’ and ‘Reversals’.
- Read the warnings. If the file is for an account other than the club’s, it says so. A file that has been imported before cannot be imported again.
- Choose ‘Post … payments’.
- The result shows ‘Matched to invoice’, ‘Not reconciled’, ‘Already recorded’ and any reversals that need reviewing.
- Every imported file is listed under ‘Imported bank files’ at the bottom of the page.
What do the terms mean?
‘Not reconciled’: the money is recorded but not matched to any invoice — for example because the payer did not use the KID, entered a KID that does not exist, or paid an invoice that had been cancelled.
‘Invalid KID’: the check digit does not add up. The payment is posted as not reconciled.
‘Already recorded’: the same payment was already there — typically when two files overlap. It is skipped, so nothing is counted twice.
‘Reversals’: the bank has reversed a payment. These are never posted as income. Review them and correct the invoice yourself if needed.
Match a payment to an invoice
- Under ‘Payments’, choose the ‘Not reconciled’ filter.
- Choose ‘Match to invoice’ on the payment.
- Search by name, KID or invoice number. Invoices with exactly the same amount are marked ‘same amount’.
- Choose the right invoice. It is updated to paid or partly paid straight away.
- Matched the wrong one? ‘Unmatch’ removes the link for bank and manual payments that have not been refunded.
Record a payment manually
Did someone pay in cash, or without a KID agreement? Open the invoice and choose ‘Record payment’. Fill in ‘Amount (NOK)’, ‘Date paid’ (not in the future) and preferably a note, for example ‘cash at training’.