Follow

Reconcile Accounts

Reconciliation is the month-end process of checking your Agrimaster Cash Book against your bank statements. You will compare and ensure that transactions in the Cash Book match the transactions appearing on your Bank Statement.

During reconciliation you can add monthly bank fees to the Cash Book and correct any data errors. Reconciliation also gives you a system for finding charges that you need to contact your bank for a correction or dispute.

All accounts must be reconciled for the months in a Business Activity Statement (BAS) period, before the BAS process can be started.

Prepare for Reconciliation

Before you start, make sure all of the month’s data is entered into your Cash Book:

  • Transactions (payments to suppliers including payments by cheque, EFT, credit or auto-debit)
  • Wages with PAYG Withholdings
  • Cash transfers (between your accounts)
  • Invoices (goods you sold to buyers)
  • Recipient Created Tax Invoices (farm products you sold where the supplier invoiced themselves for the final amount after receiving the product)

Have all of your bank statements for this monthly period in front of you.

Perform Reconciliation

  1.   Click on Home 
  2.  Click on Cash Book
  3.  Click on Reconciliation
  4. Click on the Bank Account name to select the Bank Account you are going to work with
  5. Enter the Bank Statement Closing Balance from the printed bank statement Use a positive number for a Savings or Cheque Account
  6. Enter a negative number for a loan, overdraft balance or credit card balance owed Click on the Reconcile This Account button. Or, press the Enter key twice
  7. The Reconciliation window opens

    Line matches in Cash Book account and Bank Statement

     

     

    Click in the OS column An asterisk * will mark the item

    Expense, interest charge or monthly bank fee needs to be added

     

     

    Click on Add New Transaction

    Enter the details of the fee or payment For example, Code use Bank Fees for monthly bank fees or Debit Interest for loan interest Enter the Amount (as a positive number)

    Add a missing payment from cheque or savings to loan or credit

     

     

    Click on Add New Cash Transfer

    Enter the Amount, Account From, Account To

    Optional, add a tracking or cheque number

    At the message, ‘Clear transfer?’ click Yes

    Click on Close

    Item in the account needs to be corrected

     

     

    Click on the row (on the transaction detail) Click on Edit Highlighted

    After making the changes click Save

    At the message, ‘The TOTAL of this transaction has changed from $... Is this OK?” click Yes complete

    Click on Close

    Duplicate item or wrong item in the account

     

     

    Click on the row (on the transaction detail) Click Delete Highlighted

    A message appears, ‘Erase highlighted record?’

    WARNING this cannot be undone

    Click Yes to delete

     

  8. Continue to verify transactions and watch the Difference
  9. When there is a 0.00 difference, click on to close
  10. Repeat the steps for the next Bank Account until all accounts have 0.00 difference

 

Print Monthly Reconciliation Report

Once all accounts have been reconciled to a zero balance

  1. Click on Monthly Report

     

  2. Click

     

  3. Click on Print

     

  4. Click on to close to return to the Monthly Report window
  5. Click on to close to return to the Reconciliation window

 

Print Optional Reports

If you have a Budget linked to the Cash Book, click on Budget Comparison Report

For an overview of your accounts including unprinted cheques and invoices, click on Cash Book Summary

If you need to do a Business Activity Statement (BAS) process for this period, click on Tax Reports

 

Finish the Reconciliation

  1. Click on Close Month
  2. At the Close Month message click
  3. Click to to close
Was this article helpful?
1 out of 2 found this helpful
Have more questions? Submit a request

Comments