How Do I Reconcile My Cash Account?

How Do I Reconcile My Cash Account?

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. 1. Click on the Cash Reconciliation tab.
  2. 2. Change to the month in which you are commencing your records.
  3. 3. Click on the [Settings]button.
  4. 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. 5. Click on [OK].

 

Reconcile your Cash:

  1. 1. Click on the Cash Reconciliation tab.
  2. 2. 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.
  3. 3. 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.
  4. 4. Open the Money Out Record and go to the next line available. 
  5. 5. 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’ discrepancy in your Money In Record.
  6. 6. Open the Money In Record and go to the next line available. 
  7. 7. 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. 
  8. 8. 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.

    • Related Articles

    • How Do I Reconcile Against My Bank Statement?

      What is a Bank Reconciliation? A Bank Reconciliation is simply a process that matches your Money In and Money Out Records with your Bank Account. It is an important process because it provides you with a check as to the accuracy of your records and ...

    • What Do I Do If I Cannot Reconcile

      1.Check that the Opening Balance per your Records is the reconciled balance from the month before. 2.Check that the amount you have typed into the Bank Statement Closing Balance is the end of the month balance according to your Bank Statement. ...

    • How Do I Import My Bank Statement for Bank Reconciliation? UK

      A Bank Reconciliation is simply a process that matches your Money In and Money Out Records with your Bank Account. It is an important process because it provides you with a check as to the accuracy of your records and can therefore save your ...

    • How Do I Create An Account Budget?

      The latest version allows you to create Account-based Business-based budgets. This means you can produce budgets for specific Cashflow “accounts”, or for the entire “business”. Both the Account and Business Budgets can be accessed via the Side Panel. ...

    • My Payments (Money Out) Are Not Showing In The Bank Reconciliation

      If your 'Money out' payments have not come into the reconciliation: 1. Go to the [Money Out] tab where you entered the payments and 2. Check if the totals have been allocated to 'Total Bank Payments' not 'Total Cash Payments' 3. If they are in ...

    • Popular Articles

    • How Do I Update My Payment Details? UK

      Need to change your credit card details? Log on to our shop and update your subscription so you don't lose access to Cashflow Manager. This takes about five minutes. If you already know your password for the shop, log in at this link my account: ...

    • How Do I Run Cashflow Manager on an Apple Mac? UK

      Cashflow Manager is a Windows-based program. However, the MacBook, MacBook Pro, Mac Mini and the iMac computers have the capability of converting to the Windows PC platform via two methods. Option 1: Using software called “Boot Camp” which can be ...

    • How do I download and install the program from the website?

      Visit the Australian or UK Downloads Centre and select the version you wish to install. If you already have a Cashflow Manager icon pinned to your desktop/taskbar, please remove it before downloading. 1. Click [Save] to save the downloaded file to a ...

    • How Do I Set Up The Inventory Section?

      Inventory Items make it easy to prepare your invoices and provide you with management information to help run your business. Some features of the Inventory are only available in the Cashflow Manager GOLD edition. However, both versions of Cashflow ...

    • How do I set up Customers?

      When you click on the (Invoice) Tab on the Dashboard, the (Customers) tab will appear. If you are in another Invoice section, click on the (Customers) tab to open it. This consists of: Customer List:  The Customer List is the main window of the Sales ...