Do you Struggle

HereIstheSolution1

No Monthly or Annual Fees.

One time payment ONLY!

Why do you need a Cash flow Statement01

WhatIsthisCashflow

Below is a demonstration how this Cash flow Statement works

This is one of the reports (weekly report)

Cash flow TemplateDaily Cash flow Statement is a handy expense manager spreadsheet software for your computer or tablet. With the help of this cash flow statement spreadsheet software you can keep an eye on your income, expenses, credit cards and bank accounts. It is specially build for small businesses and home users. You can easily maintain, calculate, lets you take control, analyze, manage and keep a track of your household or any expenses in general, on a daily, weekly, monthly and annual basis easily. This expense manager spreadsheet software can be downloaded to Windows PC. This software offer various features, like:  manage and analyze your household daily and monthly expenses, keep a track of your daily, weekly, monthly and yearly expenses easily, make analysis of your expenses in various categories to create strategy for decreasing your expenses, keep a record of your transactions, generates various kinds of reports and graphs and you can name your spreadsheet files with your different bank accounts, credit cards or even to have a separate workbook for your car expenses, utility expenses etc. etc.

The best part?

Enter information into the lighted yellow cells in the “Input Data” sheet ONLY! Choose from the user form, the date, your Income or Expense category and enter the amount. ALL OTHER CELLS, SHEETS, REPORTS, CUMULATIVES, COMPARATIVES, STATISTICS and CHARTS are AUTOMATICALLY POPULATED. All worksheets are automatically linked together so figures only need to be entered once!

Take your time and have fun learning how the different inputs affect your cash flow statement and your cash balance at any given period of time.

You can save your file with different file names.(as many times as you want)

If you want to manage and analyze your expenses and control your budget in a better way, then you can try out this Daily Cash flow Statement spreadsheet.

Take a look at some of the incredible benefits of this powerful tool:

Features:

  • Use it as an Expense Tracker
  • It is a lightweight spreadsheet software
  • Personalized with your name, bank accounts or credit cards
  • Automatically Calculates your Cash/Bank Balance
  • Use it as an Excel Management Template, as a Check book Register etc…
  • Use to balance to your bank accounts
  • Developed by more than 23 years of experience in VBA, MS Excel, MS Access and MS Word, developer and Financial planning & Data Analyst.
  • For Personal or for Business use
  • It can work with any currency
  • Measures your Inflows and Outflows
  • Finds your Net Cash flow
  • Provides you with an indication of your financial position
  • You get a clear picture of your Financial health
  • Helps you with Budget Planning and Forecasting
  • Make analysis of your expenses in various categories to create strategy for decreasing your expenses
  • Lets you analyze and manage different categories of expenses and income
  • You can keep a track of your daily, weekly, monthly and yearly expenses easily.
  • It can also provide you reports, so that you can also be able to reduce your expenses
  • Monitor, control and manage your budget, income and expenses
  • You can find ways to reduce your expenses by using the comparative reports and graphs
  • This spreadsheet software lets you make various categories of your expenses e.g. expenses on home, education, kids, food, cars etc.
  • You can have as many copies of the spreadsheet as you want, e.g. one for each account, credit cards and bank accounts
  • Lets you know the amount spent by you on various things in the last days, weeks, months and years
  • Unique Management Reports, Statistics and Graphs for any period

Incredibly easy to use!

Save time, money and energy!

Daily Cash flow Statement spreadsheet software generates various kinds of reports for you e.g.:

  • Daily Report – The monthly days may be changed by using the spinner at the left hand side
  • Weekly Report – Transactions are shown on a weekly basis and compares them to the previous weeks values
  • Monthly Report – Transactions are shown on a monthly and annual basis and compares them to the previous years values
  • Basic Charts – Cash Balance at the end on each month, Cash Receipts per month, Cash Payments per month.
  • Pareto Charts – The charts show the Five Largest Expenditure transactions per year
  • 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.

Prints all reports on a A4 paper size (210 x 297mm / 21cm x 29.7cm)

Powerful Tool to Control your Money flows

Stop wasting your Money and Start your Savings!

  • Inflows ( Revenues )

    Inflows ( Revenues )

    This category consists of up to 5 sources of income or revenue descriptions. (examples given can be altered or deleted).

  • Outflows ( Expenses or Payments )

    Outflows ( Expenses or Payments )

    This category consists of up to 27 categories of expenses. (examples given can be altered or deleted).

  • Net Cash flow

    Net Cash flow

    The difference between the cash receipts and the cash disbursements for each period. Day, week, month or year. Inflows minus Outflows, give us the Net Cash Flow. Cash on hand plus Net Cash flow, gives us the Cash Balance at the end of a that specific period.

  • Daily, Weekly, Monthly and Annual Reports

    Daily, Weekly, Monthly and Annual Reports

    Daily, Weekly, Monthly and Annual Reports and compares them to the previous years values.

  • Graphs and Charts

    Graphs and Charts

    Daily, weekly, monthly and Annual Graphs and Charts showing your cash balance and movement along with a Pareto graph showing the 5 Largest Outflows Categories for each year.

  • Statistical Report and graphs

    Statistical Report and graphs

    Daily, weekly, Monthly and Annual comparative statistics for each category.

Finances Are Finally Easy To Control!

With our system, the power is in your hands!

GRAB IT TODAY!

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.

  • Is a Handy Expense Manager Spreadsheet Software
    -
  • It is Specially Build for Small Businesses and Home Users
    -
  • Manage and Analyse your Household Daily and Monthly Expenses
    -

Stop waisting your Time and Money and Start your savings!

No monthly or annual fees. One time payment ONLY!

visaamericanexpressmastercardpaypal

No Monthly or Annual Fees.

One time payment ONLY!