Knowledge

• Step 1. Go to Reconcile menu under the Accounting module in the left sidebar 
  
  
• Step 2. From the Account dropdown, select the account you want to reconcile. -> Enter the Ending balance and Ending date 
  
  
• Step 3. Click on the Start reconciling

• 1st position: Information of this comparison.
  • STATEMENT ENDING BALANCE: This is the ending balance that you enter right before starting the reconciliation process. 
    
    
  • BEGINNING BALANCE: displayed on the Reconciliation screen follows these rules:
    •  If the account has NEVER been reconciled before
      The system will use the Opening Balance of the account (the initial balance entered when the account was created).
      If the Opening Balance = 0 → BEGINNING BALANCE = 0.
    • If the account HAS been reconciled before
      The system will NOT use the Opening Balance anymore.
      Instead, BEGINNING BALANCE = the Ending Balance of the previous reconciliation.
  • CLEARED BALANCE: The amount is calculated from: BEGINNING BALANCE - (PAYMENTS + DEPOSITS). DEPOSITS will be a negative number.
  • PAYMENTS: Total amount received (Calculated from selected transactions below)
    
    
  • DEPOSITS: Total Deposit (Calculated from selected transactions below)
    
    
• 2nd position: Error compared to reality of this comparison.
  • Will be calculated from the PAYMENTS and DEPOSITS of the selected transactions. Check for errors from the ending balance.
  • If the error is zero, it means that this account is normal, no errors occur. If the error is non-zero, then we have to review it, maybe make an adjustment to be able to complete this comparison.
  • Adjust the ending balance so that the error is zero. For example, if the error is 1000, we can increase or decrease the ending balance by 1000 to end the reconciliation.
    To adjust Ending balance and Ending date, click Edit Info
    
    The system displays the popup as below, enter the Ending balance and Ending date and press Save
    
  • Add a journal entry to rebalance the balance. For example, if the error is 100, we can add an entry with the value 100 to balance the error.
• 3rd position: List of transactions for reconciliation.
  • Transactions related to this account and within the reconciliation period will be displayed.
  • Once the transactions have been reconciled, the next reconciliation will not show up again.
  • The list of transactions displayed in the Reconciliation is determined as follows:
    • From Date: The day after the ending date of the previous reconciliation.
    • To date: The ending date of the current reconciliation.
  • Example:
    • Your previous reconciliation ended on 31 January 2025.
    • Your current reconciliation has a Ending Date of 28 February 2025.
    • Then the system will load all transactions from:
    • From Date: 1 February 2025
    • To Date: 28 February 2025
    • Only transactions within 01/02/2025 → 28/02/2025 will be included in the reconciliation list.
    • Any transaction before 1 February 2025 or after 28 February 2025 will not appear.

• Step 4. Your selected transactions must match your statement. When they match, you'll have a difference of 0.00.
  
  Calculate function: When selecting the transactions below, press this button to recalculate the above parameters to see if there is any difference.
  

• Step 5. If you need to finish now when your difference isn't 0.00 yet -> click on the Finish now
  
  Finish now function: Used to complete this reconciliation, If the balance is zero, then clicking will complete this reconciliation. If it is not balanced, it will allow to make adjustments. When you select a date and create an adjustment, a double entry will be created to rebalance the amount to zero.
  
  For example, the difference = - 4866.84. Click Finish now🡪 display the popup below -> Enter the Adjustment date and click on the Add adjustment and finish
  
  

          ==> The system will automatically create a pair of Reconcile Adjustments as shown below:

In case of an incorrect reconciliation, you only need to click the "Undo last reconciliation" button => the reconciled data will be removed from both the reconciliation account and Reconciliation Discrepancie