Cash Management System (November) v6.1.1

Hello there, the cash management system is a Macro-enabled Microsoft Excel spreadsheet file that I use everyday for my daily transactions as a student. I made this system so that I would be able to manage my cash properly and be aware of my expenses in a day.

I started creating my Cash Management System (CMS) on February 2014 and it was still on-going because it was effective for me.

I was upgrading the system for my convenience and to make it more systematic and reliable to me.

By the way, I am sharing the system to you that is why I start today posting on the latest upgrade of my CMS.

For the month of November 2014, I am introducing the Cash Management System H. This is the v.6.1.1 of my CMS.



What is "H"?

The "H" stands for "Halloween." Because of this, the system is covered in dark colors with "Chiller" font.

Contents:
For  this version, it has:
* 4 Sheets
* The row where the active cell is located within the system is highlighted with a blue and black fill.

Note!

In this post, I have the following terms: Divisions and Category. I also use some legends that helps me lessen the words.

[A] = a column in the first sheet

(A)= a column in the second sheet

[A1]= a cell in the first sheet

(A1)= a cell in the second sheet

First Sheet
* The First sheet is the 'Daily Transactions' sheet that enables me to record my transactions in a certain day. It has 27 columns and 50 rows.

First view

Second View

For the v6.1.1, The following columns are presented:

A-B. Date (2014)

   [A] Day and [B] 'Date' number

C-E. Cash Receipts COLUMNS
    C. Cash Receipts (Allowance)
    D. Cash Receipts (Prepayments)- Cash received as payment for prepaid items.
    E. Cash Receipts (Advances)- Cash Received in advance. It needs to be extinguished because it

         is your liability.

F-P. Cash Payments COLUMNS
    F-I. Food Division
        F. Breakfast
        G. Lunch
        H. Dinner
         I. Snack
    J-M. Miscellaneous Division
         J. Load/Water
         K. School Needs
         L. Fare
         M. Uncategorized (Does not fit any of the given categories)
    N-P. OTHERS Division
         N. Obligations (These are expenses paid by your savings)
         O. Prepayments (Expenses paid in advance thus it is receivable)
         P. Extinguishment (Expenses that extinguishes cash receipts advances)
Q. Total Cash Payments- shows the total cash paid in a day.
R. Cash Receipt Balance- shows the cash receipts remaining
S. Cash on Hand Balance- shows the cash on hand remaining. This is the computed cash balance.
T. Percentage Increase(Decrease)- shows the rate of increase or decrease in the cash balance based

    on the beginning cash balance of the week.

U. Total Cash Payments before Others Division
V. Cash Receipts (allowance) Balance
W. Percentage Earnings- shows the rate of earnings on the allowance.
X. Receivables
Y. Payables

   * [X] and [Y] shows their balances automatically based on your record on the previous columns.

Z-AA. Disclosures on
    Z. Accounts Receivable

    AA. Accounts Payable

Found at the bottom of the first sheet are the average and rates rows that gives analysis on my transactions. Descriptions about the rates are found at the bottom of the cash receipts columns.

First view

 

Second View

Second Sheet

 The second sheet is the 'Comparison Table' wherein I can compare the computed cash balance to my actual cash on hand.

 For the second sheet, There is an open space where I can enter the number of pieces of the coins or bills indicated on the 2nd top row.

Once completed, the actual cash balance will be shown on (K).

The difference will be shown on (M). This shows the difference of the Total and Cash on Hand Balance.

The remarks will show the type of difference incurred if it is loss or gain. If the difference is zero, it will show 'Equal'. If no cash count was done on a day, the system will not show any remark but once the row is selected, the remarks will show 'NCC' which means No Cash Count.

Third Sheet

The Weekly Analysis Table 2

The third sheet is the 'Weekly Analysis' Sheet is a table showing the analysis of transactions on a weekly basis.

The descriptions are shown on the table.

Fourth Sheet

The Financial Statement Sheet

 The Fourth Sheet is the financial statement sheet that shows my Statement of Earnings and Financial Position.

It includes also a project and budget table wherein I can record your plans and wants that will use my earnings.

Here, I can record the Estimated Price of the item I am planning to buy. Once purchased,  I can record the purchase price of the item and the Gain (Loss) will show.

For those who want to have a copy of the system.Click this link.

Once downloaded, open the file and enable macro in able for row highlight will function.

For instructions, click here

Any suggestions for improvements? Just comment in this post.