 |
| She's from one of my favorite game, Grand Chase. No copyright infringement intended. |
Here are some things the users must know before using the Cash Management System 7N.
BASIC GUIDELINES:
These are the legends
that might help you easily understand and locate the cells.
[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 [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].
*Beginning Cash Balance=Cash on Hand End (Previous
Month) less Cash Receipts (Allowance) Balance of the previous month. Use this
formula so that the Cash Receipt (Allowance) would not be equal to zero unless you
intend to make the CRA zero or blank. You may also refer to your previous CMS version and look for the Cash Balance, and Acrrued Accounts Balances.
The previous month’s balance is not automatically
recorded because you might encounter some message box about data conflicts when
using the system.
 | |
| Entering of Beginning Cash Receipts (Allowance) <CRA> Balance |
2. Record honestly the
amount of Allowance Cash Receipts received in Cash on [B] and on [C] if it is
on Account; [X] if it is a payment for Prepaid Items; [Y] if it is a Cash
Advance.
 |
| Entering of Cash Receipts Allowance on January 1, 2015. Currently choosing what type of CRA on Account the Php 120 is. |
3. If
there is something you want to buy in the future with the use of your cash, you
can record the amount you estimated on Column [Z] and disclose it on [AA]. In
effect, there would be an increase in your restricted earnings [AN] and
restricted cash [AQ] but there’s a consequent decrease in your Unrestricted
Cash [AR] and Unrestricted Earnings [AN].
Please take note that the fund that
you have made but not realized within this month will not be recognized next
month so you will have to record the plan again on the next month’s system.
4. Record
your expenses on [E-T] if it is an expense funded by allowance. Classify those
expenses what type of expense it is.
If it is not funded
by Cash Receipts (Allowance), you can enter it on [AB-AE] depending on your
judgment. Remember to put the amount of the item purchased on [AD] with proper
disclosure on [AE] if the item is purchased by your Appropriated Fund [Z].
5. 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.
6. Disclose such
Receivable or Payable on [AH] or [AJ] of the particular date.
F 7. For
the Section 5 of the Sheet, enter the number of pieces of a certain coin
or bill for the current date on [AX-BF]. Observe the outcome on [AV], and the Difference
and Remarks on [AW] and [AU] 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.
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, 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.
