Here are some things
the users must know before using the iCash Management System 8G version B.
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 (Allowance Balance) on [R3]; Current Balances of
Receivables and Payables on [AD3] and [AF3] with proper disclosures on [AE3]
and [AG3] respectively. Record also the Beginning Cash Balance* on [AQ3].
2.
Record honestly the
amount of Unrestricted Cash Receipts received in Cash on [B] and on [C] if it is
on Account.
3.
Record
your expenses on [E-P] 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 5. For the second section, record cash receipts and/or allocations on [T] and [V] then classify them respectively on [U] and [W]. Record Other Cash Payments on [Y] and [AA] then classify them on [Z] and [AB] respectively.
6.
Disclose such
Receivable or Payable on [AE] or [AG] of the particular date.
7.
For
the Section 5 of the Sheet, enter the number of pieces of a certain coin
or bill for the current date on [AU-BC]. Observe the outcome on [AS], and the Difference
and Remarks on [AT] and [AR] 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.
8.
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, just scroll the sheet 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 or more personalized version, just ask the creator.
3.
Don’t
enter abusive or bad words. Just enter what is right and helpful.
4.
Make
necessary actions based on the analysis given.
