TABLE OF CONTENTS


GEGI has the ability to reconcile deposits with a bank using the Deposits Reconciliation page (Financial → Reconcile). It allows setting deposits as reconciled or not and this information is further reflected on the Deposits Reconciliation Reports page.


How to Reconcile Deposits?


At the first step, you need to provide information for the reconciliation:

  • Bank Account - select the account with the deposits for reconciliation.
  • Statement Date - the date from the bank statement. The deposits are selected for reconciliation before this date.
  • Ending Balance - enter the reconciliation amount.
  • Show Deposits After Statement Date - if checked, the report will show the deposits created after the Statement Date. But such deposits cannot be marked as reconciled with a bank at Step 2:



At the second step, you will see a panel with the list of deposits from the selected bank account that have not been previously reconciled:



Each deposit can be marked as reconciled with a bank. When the corresponding checkboxes are checked, the amounts for Reconciled Amount and Difference (Ending Balance - Reconciled Amount) are calculated automatically:



After you have finished reconciling, click the Save button. You can complete the reconciliation only if Difference = 0. The system will not allow completing the reconciliation until the Difference value equals zero:




If you need to reset the selection in the Reconciled with Bank field, click the Reset link in the Total row. Please note that your changes will be reverted to the values from the last save. 


Note: The changes are saved automatically when you leave the Deposits Reconciliation page.


After the reconciliation is complete, the deposit data cannot be changed. The Reconciled with Bank checkmark will be automatically added for the reconciled deposit on the Deposit Details panel. This field cannot be edited manually. There is also the validation that checks whether a deposit is reconciled or not and prevents editing or deleting a reconciled report:




After you complete the reconciliation, you can save the results by clicking the Save button. If you have not finished the reconciliation for some reason, you can leave without losing the entered data - the intermediate results will be saved.


Note: If a deposits reconciliation report has already been created for the selected bank account, a new one will not be created until the existing report is deleted. Or you can edit the existing report and change all its data (except for the bank account) at Step 1.

The report can be exported as a CSV/PDF:



Where Can I Find the Results of Reconciliation?


The results of all reconciliations can be found here: Financial → Financial Reports → Deposits Reconciliation Reports:



This page shows the list of the deposits. You can edit and delete the reports, but the reconciled reports can be only viewed. The reconciliation results can be exported. The Status column shows whether reconciliation is completed or not. Use the Search & Order panel filters to find the reconciliation you need.


To continue working on the reconciliation report, use the Continue Reconciliation item in the Actions drop-down menu in the corresponding row. Use Delete to delete a report:



You can view detailed information for each report: who performed the reconciliation and when, which deposits are reconciled or not reconciled, etc. The information is shown when clicking the View item in the Actions drop-down menu in the corresponding row:




Note: The data in the completed reconciliations remains the same as it was previously saved.


You can download the reconciliation results using the Export to CSV item in the Actions drop-down menu under the Deposits Reconciliation Reports panel: