Bank Account Not Reconciling

This article is for users who are having reconciliation issues and are unable to find the discrepancy. Please follow the instructions below to find out the problem.

When reconciling, if the close month button is greyed out, the bank close entered and the bank close calculated are not exactly the same; this will also show a difference being shown in the reconciliation view.

This discrepancy is caused by the total sum of the transactions amounts recorded in the Agrimaster Cashbook not matching the bank statements transactions. If the bank statement closing amount is entered correctly, then somewhere in the cashbook is an incorrect transaction/s that is causing the bank account not to reconcile.

This issue may present itself with the following symptoms occurring:

• Unable to close the month due to a difference between the bank close entered and the bank close calculated.
• The opening balance of the previous month does not match the opening balance for the next month.
• My opening balance has changed, and now I am unable to reconcile.

How To Find The Discrepancy

1. Check the bank statement closing that has been entered is correct.
   • Double-check the amount entered as the bank statement closing amount is the same as what is seen on the bank statement.
2. Identify if this is the only month this issue has occurred.
   • To do this, you will need to confirm that the entered closing balance for previous months is the same as your bank statements.
   • If you find that the last month is incorrect, keep going back until you identify the previous month the closing/opening balances were correct.
   • Once you have confirmed the month this occurred, you will need to go back through all your entries until you find the discrepancies.
   • Ensure that what is on your bank statement is exactly the same as your transactions.
3. Investigate to locate the first month, where the closing balance is incorrect.
   • To locate the first month where the issue has occurred, you will need to utilise the View Balance Report by following these steps: 
     1. From Home > Cashbook > View Balances. 
     2. At the Balances screen: 
        • Report Type: Select View Balances. 
        • Select Bank Account: Highlight the bank account that is out of balance. 
        • Select Months: Highlight the previous month (or a range of months). Select a few months more than you think the issue is residing (just in case).
        • Click the green tick. 
   • At the Balances Report screen, check the Bank Statement Cash Flows and Balances (all reconciled transactions) section to confirm the statement opening figure matches the bank statement. 
   • Suppose the statement opening figure does not match the bank statement, in that case, you will need to check the previous month and re-check the statement opening and statement closing figures to the bank statement until you have found the month where the reconciliation error occurred.  
   • If this statement opening figure matches but the statement closing figure does not match the bank statement, you have found the month where a reconciliation error has occurred. 
   • Once you have found the month where the error has occurred, you can access the Reconciliation Balances Report to compare this report (being a list of all reconciled transactions) to the bank statement. This action will assist you to pinpoint where the error has occurred.
4. Identify the transaction that is causing the difference.
   • Once you have found the month where the error has occurred, you can utilise the Reconciliation Balances Report to compare this report (being a list of all reconciled transactions) to the bank statement.
   • Print off your bank statement from your bank's website.
   • With your Reconciliation Balances Report and your bank statement side by side, tick off the transactions on the bank statement that exactly match the transactions listed on the Reconciliation Balance Report transactions.
   • Once you have gone through all the bank statements transactions and ticket them off on Reconciliation Balance Report, the missing or incorrect transactions should not be crossed off on the Reconciliation Balances Report. These are the transaction/s that is causing the discrepancy.
   • Check to ensure all the dates and values are correct in the transaction. Be sure to check all the following are accurate: 
     • The Codes used.
     • Allocation assigned.
     • GST amount.
     • Debit and Credit values.
     • Transaction dates.
     • Each split.
     • The bank account the transaction is recorded for.
     • Month cleared.* 
     • Delivery Date.*

*This field may not be present, as they only appear for a few types of transactions.

If you are still unsure how to fix this, please contact Customer Support and provide us with as much detail as possible about the transaction causing the issue and what is incorrect. Then we can provide instructions on how to resolve the issue.      

Please Note

Customer Support can not fix the issue for any data entry as it is a chargeable service as per our Customer Service Agreement.