How it Works

How it works

You enter information into the lighted yellow cells in the Input Data sheet ONLY! ALL OTHER CELLS, SHEETS, CUMULATIVES, COMPARATIVES, STATISTICS and CHARTS are AUTOMATICALLY POPULATED. All worksheets are Automatically linked together so figures only need to be entered once!

This cash flow workbook consists of nine sheets:

Sheet 1. Read this
Sheet 2. Initial set-up
Sheet 3. Input Data

Reports
Sheet 4. Daily Report
Sheet 5. Weekly Report
Sheet 6. Monthly Report
Sheet 7. Basic Charts
Sheet 8. Pareto Charts
Sheet 9. Statistics

Short video Tutorial how to set up and run your daily Cash flow Statement

Sheet 2. Initial Set-up

  1. Enter the name you wish to use (Personal, Company, Acc.#, other).
  2. Enter the starting year.
  3. Enter the starting balance.
  4. Enter the five sources of income (examples given can be altered or deleted).
  5. Enter up to 27 categories of expenses (examples given can be altered or deleted).

Notes

  • Do not use the same name or description for both income and expenditure.
  • Do not change your category descriptions once you have started to enter data, because this will require you to alter the transaction category. If you will do it, then you must replace the old transaction category name with the new name. (You have to use the “Find & Replace…” icon to change the transaction category).
  • You may use the copy/paste area to change the order of the descriptions.
  • The workbook is at manual calculation mode so if for any reason the calculations are not calculating then click the “Refresh” button or go back and forth between the worksheets to calculate the workbook.

Sheet 3. Entering your data

Column 1 choose the date of the transaction.
Column 2 enter a brief description of the transaction.
Column 3 allocate the transaction to the correct category (income as in 4 above and expenditure as in 5 above).
Column 4 enter the amount of the transaction. (i.e. 1254.25, 125, 1.03 etc…)
Column 5 automatically calculates the balance (negative values appear in brackets or with minus (-) sign ).

Sheet 4. Daily Report

  • The report summarizes income and expenditure.
  • Transactions are shown on a daily basis.
  • The monthly days may be changed by using the spinner at the left hand side.
  • Weekends are shown with light yellow shaded columns.

Sheet 5. Weekly Report

  • The report summarizes income and expenditure.
  • Transactions are shown on a weekly basis and compares them to the previous weeks values.
  • The weeks may be changed by using the spinner at the left hand side.

Sheet 6. Monthly Report

  • The report summarizes income and expenditure.
  • Transactions are shown on a monthly and annual basis and compares them to the previous years values.
  • The years may be changed by using the spinner at the left hand side.

Sheet 7. Basic Charts

  • Chart 1 shows the Cash Balance at the end on each month.
  • Chart 2 shows the Cash Receipts per month.
  • Chart 3 shows the Cash Payments per month.
  • The years may be changed by using the spinner at the left hand side.

Sheet 8. Pareto Charts

  • The charts show the Five Largest Expenditure transactions per year.
  • The years may be changed by using the spinner at the left hand side.

Sheet 9. Statistics

  • It is a 5 Years Monthly Comparative Report showing a category of your Income and your Expenditure along with a Chart for that periods.
  • The income and expenditure may be changed by clicking on the light yellow shaded cell.
  • The years may be changed by using the spinner at the left hand side.

Compatibility: 

Please note that this program is designed to run on Windows and requires MS Excel 2007 or higher. This WILL NOT work for Apple MACs.

The Daily Cash flow Statement spreadsheet software is provided in electronic form only.