19.10 Reconciliation

The Reconciliation spreadsheet is where you reconcile your opening balance with your closing balance for any given period. This is a powerful tool to make the reconciliation process easier, and this can also be an important tool for your auditor. If you use Average exchange rate under Settings, the currency effects for the lease liability and the Right of use asset are shown in the Reconciliation template. Gain and loss in case of a termination of a lease or a sublease is shown in the same template.

Choose the period you want to reconcile:

Please note that if you want a reconciliation for a fiscal year, you need to set the lookup periods from January to December for the actual year.

Add other filters (Please read chapter 18.3.6 for detailed instructions on setting up Search filters):

Add currency:

The date of the currency is set in Menu.

You can directly click the individual contract by clicking the file name and go back by clicking reconciliation in the individual contract tab.