How to use the System

Now, I will tell you how to use the system.

1. Set-up the beginning balances.

 

             Record the Beginning Cash Balance on [S3], Receivables on [X3], Payables on [Y3], and necessary disclosures on [Z3] and [AA3] for Receivables and Payables respectively.

2. Record your Transactions

              Cash Receipts are recorded on [C],[D],[E]. Cash Payments are recorded on [F] to [P] based on your discretion. If ever you have receivables or payables on that date, make necessary disclosures on [Z] or [AA].

3. Have the Cash Count

                     In the Second sheet, enter the number of coins and bills on the column of the coin or bill. Observe the Total and The Remarks together with its Difference.

               TIP! The more Equal Remarks you get the better your cash management is.

 4. Observe the Results

                   For the rest of the sheets and columns, just observe the outcome of your recorded transactions and have necessary decisions that will help you manage your cash better and be able to save a greater portion of your cash receipts.

Things to Remember:

1. Record honestly. This is the number one thing that will make the system functional to you as user.

2. Don't make changes on the prefixed formula and formats on the system because it might ruin the system and will not function as it was intended to be.

3. For any modifications, problems on the system, and/or suggestions for improvement, just comment on my other posts.