Throwback! Cash Management System v2 series

Hello there guys!

      It's another throwback of my experience using the Cash Management System (CMS) but now I am sharing the Cash Management System v2 series. (Take note! Series meaning it covers few months)



      To start with, The CMS v2.0.0 for the month of March, I created a brand new version for the month of March although I created a table in the previous version (pertaining to CMS v1.0 Beta Test File) because of the problems I personally encountering when managing my cash.

      The CMS v2.0 has 2 sheets in total namely Daily Transactions and Cash Count.

       The Daily Transactions sheet was modified making the sheet a little bit colorful and more systematic and organized.

At the right-end of the sheet, there are additional columns namely Cash Receipts, Cash Payments, and Balance of Dues. Here, you manually record the cash received or paid in advance resulting in a receivable or payable indicated below. The system will show the net receivable or payable.

     At this time, the birth of the Cash Comparison Table happened. The Cash Count (v2.0 name for Cash Comparison Table) sheet was created to compare the current cash balance to the actual cash on hand. There is the Remarks, Difference and the range of amounts but as you can see in the picture above, it is not yet organized and there were still flaws when it comes to formats.

    With the Cash Management System v2.0.0, there is a large improvement compared to Cash Management System v1.0 BTF. But I have listed the issues that arise upon my usage of the system.

- Loss (amount and remark) can be seen at the dates where no cash count happened.
- Actual cash receipts are not recorded and other obligations are not recorded.
- Php 112 is irrelevant to the actual total and balance.

     Since April up to May is our Vacation, I created a cash management system that suits my needs at that time. Presenting the CMS Vacation Spending Version (v2.1.0)

CMS Vacation Spending Version (April)

CMS Vacation Spending Version (May) <right below April>

        As seen on the pictures above, Cash Payments consist of four categories and there is a new column which indicates Loss or Gain. Reminders Column is added to make records of Accounts (Receivable or Payable)

             The second sheet is the previous version's Cash Count Sheet but now it includes Materiality Column which gives 'Material' when incurring loss greater than Php 50 otherwise 'Immaterial'. Aside from these additions, blank cells are covered in black and so with the Difference column when no Cash Count is done on that day.

              As for my experience, I listed the following issues.
-Loss (remark) is still seen when no cash count is done
-No proper way of recording Receivables and Payables


            The last in the v2.0 series is the CMS v2.0.1 for the month of June. That is right! it is back to the basic version but with a little modification.

CMS v2.0.1 (June)

               This version gives a more livelier ambiance because the UI is more colorful. There is one legacy that this version leaves in the history of CMS. The Division is now here. As for this version, it has two (2) Divisions: FOOD and MISCELLANEOUS.

                       The Cash Count of the v2.0.0 is adopted and so with v2.1.0 format on the difference. Materiality column is not adopted.

                    As for the issues, format improvements on the second sheet might upgrade the experience.

*****

                   That's all for the throwback of the v2.0. Expect for another wave of Throwback the following days so that you would be able to know how the current version was created. Stay tuned!
                  Also expect for the teasers in the upcoming CMS 2015. Do you have an idea regarding the upcoming version? Share your thoughts by commenting in this post. Thank you.