Reconciliation

Book transactions easily in one tool.

Updated over a week ago

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.

Related articles

Did this answer your question?