Bank reconciliation for Swiss sole proprietorships
From bank statement to journal entry – with CAMT.053 or PDF
← Back to overviewThe payment is on the bank statement, the invoice is in Effizo, and manual work sits in between. Bank reconciliation closes that gap: you upload your statement, Effizo suggests the matching journal entries for every transaction – and you confirm with a click.
Even without a bank file
Upload the statement as your bank's CAMT.053 file or simply as a PDF, exactly as you download it from your e-banking. Effizo reads both formats.
- CAMT.053 – the Swiss standard for electronic bank statements
- PDF – the statement your bank provides anyway
Whatever you can download from your e-banking, you can reconcile. A PDF is read rather than simply imported – so you do not need a CAMT file if your bank does not offer one.
Effizo accepts camt.053 in versions 001.08 to 001.14 and PDF statements of up to 19 MB and 50 pages. You simply drag the file into the window or select it.
Checked before you even look
Effizo reconciles the statement against itself before you review the first transaction:
- Opening balance plus transactions against the closing balance – if it does not add up, it says so
- Declared turnover totals against the recorded payments – a missing transaction shows up
- Statements you have already uploaded are recognised, so you never book anything twice
- Balance gap – if the opening balance does not match the closing balance of the same account's previous statement, a statement in between is probably missing
The result appears at import: “Checked”, “Mismatch” or – if the statement states neither balances nor totals – “Unchecked”. A mismatch opens a diagnosis with hints on the individual transactions. That way you notice an incomplete statement straight away – not at year-end.
If Effizo has read a transaction from a PDF that the bank never booked – a line read twice, for example – you withdraw it. It then no longer counts towards the statement, and the check is recalculated.
Matching – by hand or automatically
For every transaction Effizo suggests the journal entries it could settle, the strongest one first. Each suggestion shows why it fits:
- the payment reference – it usually carries your invoice number
- the payer's IBAN
- the payer's name
- the amount – even when it covers only part of the open amount
By default you decide: Effizo suggests, you confirm. If that feels too fiddly, switch on “Book bank transactions automatically” in the settings – Effizo then books the unambiguous cases itself. Unambiguous means: exactly one open entry matches the payer – by the invoice number or payment reference, the IBAN or the name – and exactly the amount. So an invoice someone else pays for your client is recognised too. Everything else waits for you. A preview shows you beforehand how many transactions of your last statement that would affect.
For your expenses too
Reconciliation works in both directions. For a payment from your account, Effizo suggests the matching expense from your journal – the supplier invoice you captured as a receipt, for example.
- If the bank debited more than the receipt shows, because of charges or an exchange rate for example, you adjust the expense to the amount paid
- If the receipt arrives after the statement, Effizo books the transaction later, as soon as the receipt has been read – provided automatic booking is switched on
And then it is done
Once matched, the invoice counts as paid – including when things do not divide neatly:
- Partial payments are credited correctly
- A batch credit is broken down into the individual payments it consists of – each one is matched separately
- If you account for VAT on payments received, the VAT falls into the period the money arrived
The invoice then shows the bank payment and a link back to the bank reconciliation, and your books are current. And if you got it wrong: every match can be undone.
Not every transaction is an entry
Bank charges, payroll runs, private transfers: these do not belong to any open invoice. You ignore them – they disappear from the worklist, stay traceable all the same and can be restored at any time.
That way you work the list down to zero without losing anything.
How bank reconciliation works
- Upload the statement – CAMT.053 or PDF. Effizo reads the transactions and checks the statement.
- Match – for every payment the matching journal entries are ready, the most likely one first. With automatic booking switched on, Effizo handles the unambiguous cases itself.
- Ignore the rest – whatever is not an entry, you hide. The list is empty.
In brief
- Upload the bank statement as CAMT.053 (001.08 to 001.14) or as PDF, up to 19 MB
- Statement checked for balance, totals, statements uploaded twice and missing statements
- Incoming payments and payments from your account are matched
- Suggestions with reasons: payment reference, IBAN, name and amount
- Matching by hand – or automatic, as soon as you switch on “Book bank transactions automatically”
- Partial payments credited, batch credits broken down into individual payments
- With VAT on payments received, the VAT falls into the period the money arrived
- Transactions unrelated to an invoice can be ignored
- Every match can be undone
Bring your books up to date with your account
With bank reconciliation, a bank statement turns into clean bookkeeping – without the manual work, and without Effizo taking the decision out of your hands.
Have a look at invoicing, simple accounting and VAT accounting as well – or take a look at our pricing.