A Cash Reconciliation is simply a check that the Cash on Hand per your Records equals the Actual Balance of Cash on Hand. This can be done as often as you wish. The Cash on Hand per your Records automatically calculates from the Opening Cash Balance which transfers from the previous month, the Receipts Not Banked entries in your Money In Record and the Total Cash Payments column in your Money Out Record.
The formula that is used is simply:
Opening Cash Balance
+ Receipts Not Banked (from your Money In Record)
-Cash Payments (from your Money Out Record)
= Cash on Hand per your Records.
Recording your Opening Cash Balance
1.Click on the Cash Reconciliation tab.
2.Change to the month in which you are commencing your records.
3.Click on the [Settings]button.
4.Record the Opening Cash Balance. (Your records may be locked as a result of your Opening Bank Balance. If so, click on the Bank Reconciliation tab and on the [Unlock]
button. Then return to Money In.)
5.Click on [OK].
Reconcile your Cash:
Click on the Cash Reconciliation tab.
Count your cash on hand and type the amount into the box for the current amount of cash on hand.
If the Cash on Hand per your Records is the same as the Actual Cash on Hand then your cash reconciles. If they do not agree you should check your records and recount your cash on hand to see if there is an error.
If you cannot find an error and your cash does not reconcile, the discrepancy must be recorded in the Money In or Money Out Records to correct the error.
For example, if your actual cash on hand is $5.00 less than the balance per your records, you need to record the discrepancy in your Money Out Record.
Open the Money Out Record and go to the next line available.
Record the date of your reconciliation in the Day column. Arrow to the Details column and type ‘Cash Discrepancy’. Record the amount of the discrepancy in the Total Cash Payments column. Now record the amount in Sundry Other Non GST Payments column. If you now click on the Cash Reconciliation tab, the Balance of Cash on Hand per your Records has been changed to reflect the entry you have made and should now reconcile with the cash amount you typed in.
If your actual cash is greater than the amount of balance per your records, record the ‘overage’ discrepancyin your Money In Record.
Open the Money In Record and go to the next line available.
Record the date you are reconciling in the Day column. Type "Cash Discrepancy" in the Details column. Record the amount of the discrepancy in the Total Receipts
column, Other Non GST Receipts and Receipts Not Banked columns. If you now click on the Cash Reconciliation tab, the Current Cash on Hand per My Records has now changed to reflect the entry you have made and should now reconcile with the cash amount you typed in.
You can complete your Cash Reconciliation at any time. However, you must record any discrepancies in the Money In or Money Out Record at the end of every month so that you do not carry forward an incorrect balance to the new month.