Bank import
Read in a bank statement as CAMT.053 XML or CSV and book, split or ignore the lines.
Instead of typing in every transfer by hand, you can import your bank's statement directly. SinfoniaOne reads in the individual lines, and you decide for each line whether and how it gets booked.
Which files work?
The bank import understands two formats that you can download from almost any bank:
- CAMT.053 – an XML file, the banks' standardized statement format.
- CSV – a simple spreadsheet file with the transactions.
Where do I get this file?
You download the file from your club's online banking – usually under "Export transactions" or "Bank statement". It doesn't matter which of the two formats you choose; take the one your bank offers.
Import and assign a statement
Upload the file
In the cashbook, open the Bank import area and upload your CAMT.053 XML or CSV file — on a computer you can also drag it onto the field. The field stays locked until you have picked a target account. SinfoniaOne then shows you all lines of the statement.
TODO-Screenshot
Assign a line to a category
Go through the lines and pick a suitable category for each one (just like when booking). Based on the amount and the reference from the statement, you can usually tell quickly what it's about.
If a category is missing, type its name into the picker’s search box and create it right there with “Create …” — it automatically takes the kind of the line, income or expense. The same works while splitting a line.
Book, split or ignore
For each line you have three options:
- Book – the line becomes a real transaction in the journal.
- Split – the line is spread across several transactions (see below).
- Ignore – the line is skipped, for example if it was already entered by hand or doesn't concern the club.
What is still unbooked?
A bank statement is rarely finished in one go — so SinfoniaOne shows you in three places how much is still open:
- In the menu, a number sits next to Bank import as soon as statement lines are waiting to be booked. You see it without opening the area.
- In the import list, a note at the top gives the total number and the open amount. Every statement also carries a label: “3 open” — or “Booked” when there is nothing left to do.
- In the statement itself, a line above the list tells you how many of how many are still open; the filters Open, Booked and All name their counts as well.
What counts as “open”?
Open means lines that have not been booked at all — and those that have only been partly split. Ignored lines don't count: you settled those on purpose. A statement counts as processed as soon as no line is open any more.
Deleting an import
If you uploaded the wrong file or the same statement twice, you can remove the whole import again — from the action menu of the row in the import list, or inside the statement via Delete import. The statement disappears with all of its lines; there is no trash for it.
Transactions are kept
If transactions were already created from the statement, they stay in the journal — a record never disappears just because you clear away an import. They only lose the link to the statement, and the delete dialog tells you beforehand how many transactions are involved. If you want to get rid of the transactions too, delete them in the journal first.
Splitting one line into several transactions
Sometimes one bank line holds more than one thing: two membership fees in a single transfer, or an invoice covering sheet music and a repair. So that every item still ends up in the right place in the cashbook, you can split such a line.
Choose Split
Tap Split on the line. At the top you can always see how much of the line is still open.
TODO-Screenshot
Enter amount and reference per part
For each part you only enter the amount and the reference – and the category if you like. Everything else is taken from the statement: date, account, counterparty and payment method.
Add part gives you another row; Rest fills the amount with whatever is still open.
Bring the rest down to €0
If something is left over after booking, the line stays partly booked and shows the open rest. It stays in the Open list until you have assigned that rest too – either with another split or with Book rest.
The rest has to reach €0
As long as a rest is open, your cashbook does not match the bank statement. That is why a partly booked line cannot be ignored either: book the rest, or delete the parts you already booked in the journal.
Assign every line deliberately
The bank import makes no automatic category suggestion – you decide for each line yourself. That takes a little longer, but it ensures that every transaction is really sorted correctly.
Several lines at once
When many lines were recognised correctly you do not have to confirm them one by one: tap “Select” to tick them and book them with each line’s own suggestion, pick one shared category, or ignore them together. Partly booked lines are left out — you decide about their remainder individually. See Working on several entries at once.