Cash Flow Template


Free Delivery

Immediate Download

  For professional quality cash flow forecasting 

please review our comprehensive Advanced Cash Flow Forecasting Template. 


Two tier data entry system 'Scheduled' and 'Periodic'

Features 25 separate user definable 'Trading Scenarios'

Automatic Scheduling of Sales and Income streams

Automatic Scheduling of Cost of Sales payments

Automatic Quarterly VAT payment calculations

Caters for Debtor and Creditor balances brought forward

Use of up to 28 separate Overhead Types


The Cash Flow Forecasting Template allows you to tailor your income streams by Profit Margins and Payment Periods 


  Customer Supplier Product Overhead
Set Payment Terms (days)
Set Gross Profit Margins % n/a
Set VAT Rates



The Cash Flow Statement



Create your own 'Trading Scenarios'  (see below) and let the program automatically compute the income and expenditure streams. The system allows you to design up to 25 separate 'Trading Scenarios' which cover SalesCost of Sales and Gross Margins. If you are VAT Registered the system will automatically calculate and schedule your Quarterly VAT Returns


Cash Flow Sales by Product

Cash Flow Cost of Sales by product


The system can accommodate up to 28 user definable Overhead Types. Using a combination of scheduled and periodic payments this section ideal for a comprehensive analysis of your business overheads.

Cash Flow Overheads


Our two tier data entry system allows you to have both Scheduled and Periodic income and expenditure streams. 

These two separate data entry systems then consolidate to produce the final Cash Flow Statement.


The consolidated SCHEDULED Cash Flow 


The consolidated PERIODIC Cash Flow



Additional information and small print 
Mr. Spreadsheet is a registered trading name and division of Heron Accounting Services, Poole, Dorset. This software is protected by international copyright and is sold on a single-user license agreement for the use by the licensee or licensees business only. Unlawful copying and distribution will result in prosecution.We make no warranty or representation, either express or implied, with respect to this software and documentation, their quality, performance, merchantability, or fitness for a particular purpose. This software is licensed ‘as is’, and you, the licensee, by making use thereof, are assuming the entire risk as to their quality and performance. In no circumstances will we be held liable for direct, indirect, special, incidental or consequential damages arising out of the use or inability to use the software or documentation.

Please Choose:

Excel Spreadsheet

Excel Download

Add to Basket: