And this is how it works...
Where can I find this function?
You can find the module under ⨠Bookkeeping ⨠Reconciliation.
Reconcile transactions
If information is missing from the transaction or if no matching document can be found, the transaction is escalated. The escalated transactions are displayed in the escalated tab and must be reconciled with the corresponding documents or with manual entries.
Navigate to ⨠Bookkeeping ⨠Reconciliation ⨠Escalated and click ⨠Reconcile.
❗ IMPORTANT: In order for you to perform a smooth year-end close, it is essential to fully reconcile the escalated transactions to the supporting documents.
Reconciliation by document
If a document exists for a transaction, it can be selected and will be automatically booked to the corresponding contra account of the document (often 1100 for customers or 2000 for vendors).
Type | Debit | Credit | Amount |
Transaction (debit) | 2000 Kreditor | 102x Bank/Post | 10'000 CHF |
Receipt | Expense account | 2000 Kreditor | 10'000 CHF |
|
|
|
|
Transaction (credit) | 102x Bank/Post | 1100 Debitor | 15'000 CHF |
Beleg | 1100 Debitor | Revenue account | 15'000 CHF |
Reconciliation by manual booking (without document)
❗ NOTE: If the document is still to be submitted, you should wait with this step so that the transaction can be reconciled with the document.
If there is no receipt for a transaction, it can be cleared with a manual posting. It should be noted that the posting is made directly to the bank account or credit card account. The posting records can be as follows, for example:
Type | Debit | Credit | Amount |
Transaction (debit) | Expense account | 102x | 2'500 CHF |
Transaction (credit) | 102x | Revenue account | 2'500 CHF |
Here, several manual bookings can also be made in the booking mask. The decisive factor is that the correct amount (according to the transaction) is posted to the bank account in total.
Type | Debit | Credit | Amount |
Transaction | 1099 | 102x | 5'000 CHF |
Manual booking 1 | Expense / revenue account | 1099 | 2'500 CHF |
Manual booking 2 | Expense / revenue account | 1099 | 2'500 CHF |
Reconciliation several documents and manual bookings
If a document exists for a transaction, it can be selected and will be automatically booked to the corresponding contra account of the document (often 1100 for customers or 2000 for vendors).
Type | Debit | Credit | Amount |
Transaction | 2000 expense / 1100 revenue | 102x | 10'000 CHF |
Receipt 1 | Expense / revenue account | 2000 creditor / 1100 debitor | 5'000 CHF |
Manual booking 1 | Expense / revenue account | 2000 creditor / 1100 debitor | 2'500 CHF |
Manual booking 2 | Expense / revenue account | 2000 creditor / 1100 debitor | 2'500 CHF |
As soon as more than one document is reconciled with a transaction, all the related manual bookings must be booked to the transit account 1099 instead of 2000 or 1100.
Type | Debit | Credit | Amount |
Transaction | 1099 | 102x bank | 10'000 CHF |
Receipt 1 | 2000 | 1099 | 2'500 CHF |
Receipt 2 | 2000 | 1099 | 2'500 CHF |
Manual booking 1 (without document) | Expense account | 1099 | 2'500 CHF |
Manual booking 2 (without document) | Expense account | 1099 | 2'500 CHF |
Reconciliation credit card receipts
Credit card receipts are automatically transferred from the pass-through account 2050 credit card payments to the effective credit card account (207x) by assigning them to a credit card transaction.
Type | Debit | Credit | Amount |
credit card transaction | Expense / revenue account | effective credit card account eg: 2071 | 550 CHF |
Differences
If there is a difference of the document and the transaction, a posting mask opens, where this difference must also be posted to the contra account of the document.
Example currency difference (currency loss):
A creditr invoice for EUR 10'000 was booked with the exchange rate 1.05, i.e. CHF 10,500. Due to exchange rate fluctuations, CHF 10'800 was finally paid. The currency difference of CHF 300 must now be booked out. In addition, CHF 20 in bank charges have been incurred. When assigning the receipt to the transaction, a booking mask with CHF 300 will automatically pop up. This would be booked as follows:
Type | Debit | Credit | Amount |
Transaction | 2000 | 102x | 10'820 CHF |
Receipt | Expense account | 2000 | 10'500 CHF |
Currency difference | 6999 | 2000 | 300 CHF |
Bank charges | 6900 | 2000 | 20 CHF |
The entries written in italics must be made manually by you.
Example currency difference (currency profit):
Type | Debit | Credit | Amount |
Transaction | 2000 | 102x | 10'820 CHF |
Receipt | Expense account | 2000 | 10'500 CHF |
Currency difference | 2000 | 6999 | 300 CHF |
Bank charges | 6900 | 2000 | 20 CHF |
The entries written in italics must be made manually by you.