Importing payments from a bank statement (CSV)

What it is for

An import does what Record payment does, in bulk: each transfer you accept becomes a payment recorded by the owner, pays off the payer’s (or the whole family’s) oldest charges and — like any payment you record by hand — can be reversed later.

Importing, step by step

1. 1

   Download your account history from the bank in CSV format — for the period you want to settle, ideally incoming payments only. How to do it in your bank: below.

2. 2

   In Sport Match open Payments and choose Import bank statement. Pick the file you downloaded and choose Import.

   app.sportmatch.pl

   

   

   

3. 3

   The app lists the money that came in: the sender, date, amount, title and kind — Transfer or BLIK. The club’s outgoing payments are left out. A payment that looks recorded already (the same amount around the same day) is flagged.

   app.sportmatch.pl

   

   

   

4. 4

   For each one choose Accept or Ignore. Ignore anything that isn’t a payment from a family — grants, refunds or transfers between the club’s own accounts, for example.

5. 5

   Once accepted, choose whose payment it is: the payer and, if needed, the family account. If an earlier import matched the same sender’s account, the app suggests the same person or family; check the suggestion before you keep it.

6. 6

   A running summary shows the payments you’ve accepted — how many and how much, Transfers and BLIK separately. You can stop and come back to the import later the same day.

7. 7

   Choose Submit. You’ll see a summary for each family: how many payments, and how much, will be recorded. Check it and choose Confirm and record.

   app.sportmatch.pl

   

   

   

8. 8

   Done — the payments are in each family’s payment history and settle their charges, and the data from the file is deleted.

What happens to the file and the data

• The file itself is not kept. Sport Match reads only the incoming payments from it: the date, sender, title, amount and kind, and the sender’s account number only to recognise it at the next import. The club’s outgoing payments and the account balances are skipped.
• The loaded payments are deleted as soon as you confirm or cancel the import. An unfinished import is deleted automatically after 1 day — after that it can’t be opened, and you load the file again.
• Only one thing is remembered: which sender account belongs to which family or person — to suggest it next time. Sport Match doesn’t keep the full account number for this, and forgets an unused match by itself after about a year.
• Want the app to forget the matches? In the statement import choose Forget remembered accounts — the next imports start without suggestions.

How to download the CSV from your bank

Every bank does it a little differently, so each one has its own guide. When downloading, pay attention to three things:

1. The period

set the from–to dates to cover only the period you are settling (one month, say). Less in the file means less to review — and less of the club’s information leaving the bank.

2. Incoming only

if the bank lets you filter by type of operation, choose credits (incoming) only. The club’s spending isn’t needed to settle fees — Sport Match skips it anyway, but it’s better if it isn’t in the file at all.

3. No balance after each transaction

if the bank lets you choose the export’s columns, untick the balance after the transaction — the club’s balance isn’t needed for the import. If your bank doesn’t offer this, that’s fine: Sport Match doesn’t read balances and doesn’t keep the file.

Guides for each bank