Here are some things
that the users must know before using the innovative Cash Management System 8.1F-A.
BASIC GUIDELINES:
Legends
that might help you navigate on the system.
[A] - Column on the first sheet [A1] - A cell on the first
sheet
[A1-B2] Cell Range [A-Z] Column Range [1]-Row on the First Sheet
FIRST SHEET
1.
Record
the Beginning Cash Receipt (Unrestricted) Balance on [V3]; Accrued Balances of
Receivables and Payables on [AG3] and [AI3] with proper disclosures on [AH3]
and [AJ3] respectively. Record also the Beginning Cash Balance* on [AT3]. For those who have their own iCMS 8G
records, you can refer it on the Financial Statements Sheet (2nd
Sheet)
* Take note that the CR(U)Balance Beginning does not
increase the Cash on Hand Beginning Balance. The purpose of the CR(U) Balance
Beginning is for the continuation of the previous month’s Transactions
Involving Cash from Allowance(iCMS 8G)
2.
Record
honestly the amount of Unrestricted Cash Receipts received in Cash Only on [B]
and on [C] if it is on Account. Classify Unrestricted Cash receipts on [D].
3.
Record
your expenses on [E-T] if it is an expense funded by allowance. Classify those
expenses what type of expense it is.
4.
Record
transactions on the date when you actually incurred such expense or have the
transaction by entering ONLY the AMOUNT of the certain item. Use the formula: =<Amount
1>+<Amount 2> if you have multiple amounts in the same category if you
don’t want to calculate those numbers by your own.
5.
For
the second section, to make valid entries, classify the transaction first
whether it is A, F, or P. After classifying, record the amount of your cash
receipt or cash allocation. The new restriction system will require you to classify
your transaction first. Same as with the cash payment category, you are prompt
to classify your transaction first before recording the amount.
6.
Once
you have chosen F as a classification on step 5, you can disclose it on [AB]
for Cash Receipts and on [AG] for cash payments.
7.
Disclose
such Receivable or Payable on [AI] or [AK] of the particular date.
8.
For
the Section 5 of the Sheet, enter the number of pieces of a certain coin
or bill for the current date on [AY-BG]. Observe the outcome on [AW], and the Difference
and Remarks on [AX] and [AV] respectively. The section will not recognize
centavo coins because of its materiality on the creator. Amount starts on Php
1.00 coin and ends at Php 1000.00 bill. Centavo coins are excluded because of
its materiality.
9.
Other
columns are not selectable. This means that the columns are not for editing or for
data entering purposes. Just observe what would be the result.
SECOND SHEET and
THIRD SHEET
1.
Just
observe the outcome. Users are prohibited to select or modify any cell on the
sheet.
2.
To
see the other weeks in the percentage table (for the second sheet) or the other
graphs (third sheet), drag the scroll bar below the window of Excel to the
right.
RULES AND TIPS FOR AN EFFECTIVE
USAGE OF THE SYSTEM
1.
Record
the amounts with honesty and faithful representation. This will help you
develop your cash management potential.
2.
Don’t
make any modifications on system that might ruin the system in general. For any
modification suggestion, just ask the creator by filling up the form provided by the Requests Tab.
4.
Don’t
enter abusive or bad words. Just enter what is right and helpful.
5.
Based
on the given data, you can take necessary action to help you save much money
for your future.
