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.

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.

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, complete, split or ignore

For each line you have four options:

Book – the line becomes a real transaction in the journal.
Details – book the line and fill in every other detail at the same time (see below).
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.

Booking a line with every detail

A quick Book takes everything from the statement: account, date, counterparty — and bank transfer as the payment method. That usually fits. If the transaction needs more, tap Details on the line: it offers the same set of fields as the booking form, so the transaction is complete once it is booked.

Purpose – prefilled with the text from the statement, and required just like when booking.
Category – you pick it yourself; a bank statement does not contain one. Only for the remainder of a split line is the first part's category suggested.
Counterparty and payment method – for example direct debit instead of bank transfer.
Document no. – leave it empty and SinfoniaOne assigns the next number for this account and financial year.
Status – Booked or Draft. A draft does not get a document number yet.
Receipts – a PDF or photo of the invoice. On your phone you take the picture right there, on a computer you drag the file onto the field. The upload happens when you book, because before that there is no transaction for the receipt to belong to.
Event – counts towards the result per event report.
For money coming in: an open membership fee – the linked fee then counts as paid.
For money going out: a submitted invoice – the linked incoming invoice then counts as paid.

What if a receipt does not go through?

Then you are told explicitly: the transaction is created anyway – the bank statement is correct, after all. Only the file is missing, and you add it to the transaction in the journal.

Account and date stay with the statement

Account, booking date and document date cannot be changed here — they are the link between the cashbook and the bank statement. The amount is always whatever is still open on the line; to create several transactions from one line, use Split.

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.

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 derives no category from the counterparty or the purpose text – you decide for each line yourself. That takes a little longer, but it ensures that every transaction is really sorted correctly. The only suggestion is for the remainder of a split line, where the first part's category is offered.

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.

Bank import