Reconciliation

Navigation

The page for interacting with transactions to reconcile them can be found on Exact at: 'Financial' -> 'Banking & Cash' -> 'To be completed'.

Retrieving Transactions

Search panel for transactions to reconcile

First, we need to retrieve any transaction which need reconciliation. For this we need to use the search panel. The following steps are required:

• Make sure the checkbox for 'To be completed' is checked.
• Ensure no range is set. Or if it is set, that the range includes the date the transaction you wish to reconcile was made.
• Keep all other boxes and options empty.
• Click 'Refresh' if you made any changes to the search panel after arriving on the page.

On the right you can find an image showing an example of how the search panel ought to look.

Processing Transactions

Example of a transaction that needs reconciliation

To the right, you can find an example of a transaction that requires reconciliation. In order to do this, two steps are required:

1. Ensure the G/L Account is set correctly
2. Match the transaction to the correct invoice/receipt

We'll use the example transaction to demonstrate how to perform these steps.

Setting the G/L Account

Setting the G/L Account correctly consists of two things.

1. Setting the correct G/L Account. this refers to the ledger this cost should be put on. This is ususually '1600 - Crediteuren'.
2. Setting the correct Account. This refers to the business relation that was involved in this transaction.

In the example transaction, you see that the G/L Account is '1290 - Kruisposten liquide middelen' and the 'Account' is not set. Both parts are wrong for this transaction, so we need to set them correctly. There are two ways to achieve this:

1. By clicking the suggestion from Exact. This is the blueish rectangle below '1290- Kruisposten liquide middelen'. The values shown are the suggestions from Exact for the G/L Account (In this case '1600 - Crediteuren') and for the Account (In this case '40 - Albert heijn'). In this case, the suggestions are correct (For standard transactions, the '1600 - Crediteuren' is the correct G/L Account, and the payment was made to Albert Heijn, so the Account '40 - Albert Heijn' is also correct), but there might not always be a correct suggestion. There can also be multiple suggestions.
2. By clicking the 'Edit' button at the far right of the transaction line.

Both