---------------------------------------------------------------------------------------------------------------------------------
Updated as of February 25, 2015 (4:05 AM)
----------------------------------------------------------------------------------------------------------------------------------
Updated as of February 25, 2015 (4:05 AM)
----------------------------------------------------------------------------------------------------------------------------------
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
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 1A
records, you can refer the balances 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
1A). This feature might not be significant because February 28 falls on a Saturday;
the end of the week thus CR(U)Balance will suppose remain on the previous week
and a new set of CR(U)Balance will be established on March 1, Sunday.
2.
Record
honestly the amount of Unrestricted Cash Receipts received in Cash Only on [B]
and on [C] if it is on Account. Classify it 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 and
you don’t want to make calculations on the amount.
5.
For
Section 2, you can enter other cash receipts or allocate fund on [X] and [Z].
Classify them on [Y] and [AA] respectively.
6.
For
other cash payments, same procedures will be followed but now on [AC] and [AE]
and classify on [AD] and [AF] respectively.
7.
Once
you have chosen F as a classification on steps 5 and 6, you can disclose it on
[AB] for Cash Receipts and on [AG] for cash payments.
8.
Disclose such
Receivable or Payable on [AI] or [AK] of the particular date.
9.
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.
10.
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.
3.
Classify
your cash receipts and cash payments especially those on the second sheet
because the percentage table will not recognize your cash payments and cash
receipts once they are not classified.
4.
Don’t
enter abusive or bad words. Just enter what is right and helpful.
5.
Make
necessary actions based on the analysis given.
