Excel Sheet Download 12411 | Cash Flow Forecasting Template R1

Partial file snippet.

Sheet 1: Estimated Cash Flow 

	
	
	
		How to use the template
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Use this worksheet to forecast cash flow. The Estimated vs. Actual worksheet will automatically update with your estimates.
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		1. Type your beginning cash balance in cell B13.
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		2. Type in your monthly figures for cash in and cash out, month by month. 
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Changes in sales income
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Changes in expenses
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		ESTIMATED CASH FLOW WORKSHEET
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Cash in
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Month
		Month one
		Month two
		Month three
		Month four
		Month five
		Month six
		Month seven
		Month eight
		Month nine
		Month ten
		Month eleven
		Month twelve
		Total
	
	
		Cash balance at the start of each month
		

		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		

	
	
		Operating Revenue
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Cash receipts from customers
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Collection of receivables
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		

		$0
		$0
		$0
		$0
	
	
		
		e.g. Commissions etc.

		Other operating revenue received
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Total Operating Revenue
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Other Sources of Cash Inflows
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Proceeds from sale of assets
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		$0
	
	
		Funds borrowed
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Tax refund/rebates
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		
		This can include equity contributions, franchise or royalty fees received etc.

		Other sources of cash inflow
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Total other cash inflows
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Total monthly cash in 
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Cash out
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Inventory (Stock)
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Stock purchases
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Other cost of goods
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Total Cost of Goods
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		General & Administrative 
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Bank charges
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Credit card commission
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Accounting/Legal/Consultant fees
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Office supplies
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		License fees
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Business insurance
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Etc.
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		$0
	
	
		Total General & Administrative
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Marketing & Promotional
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Digital marketing & advertising
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Events
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Public relations
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Etc.
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Total Marketing & Promotional
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Operating Expenses
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Newspapers & magazines
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Parking/Taxis/Tolls
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Entertainment/Meals
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Travel/Accommodation
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Laundry/Dry cleaning
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Cleaning & cleaning products
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Sundry supplies
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Equipment hire
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Etc.
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Total Operating Expenses
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Motor Vehicle Expenses
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Fuel
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Vehicle service costs
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Tires & other replacement costs
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Insurance
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Registrations
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Total Motor Vehicle Expenses
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Website Expenses
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Domain name registration
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Hosting expenses
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Etc.
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Total Website Expenses
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Permanent Employment
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Salaries/Wages
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		PAYE
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Superannuation
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Other - Employee benefits
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Recruitment costs
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Total Permanent Employment Expenses
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Casual Employment
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Salaries/Wages
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		PAYE
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Superannuation
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Other - Employee benefits
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Recruitment costs
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Total Casual Employment Expenses
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Workers compensation insurance
		

		

		

		

		

		

		

		

		

		

		

		

		$0
	
	
		Total Employment Expenses
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Occupancy Costs
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Electricity/Gas
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Telephones
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Property insurance
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Rates
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Rent
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Repair & maintenance
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Waste removal
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Water
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Etc.
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Total Occupancy Costs
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Other Expenses
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Bank Interest
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		GST
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Etc.
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Total Other Expenses
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Other Cash Outflows
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Purchase of assets
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		
		i.e. Establishment fees

		One-off bank fees 
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Principal loan repayments
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		
		e.g. Dividends, repayment of shareholder loans etc.
		Payments to the owner(s)
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Investment of surplus funds
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Other cash inflows
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Total Other Cash Outflows
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Total monthly cash out 
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
	
	
		Net difference † 
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		

	
	
		Cash balance at the end of each month ‡
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		$0
		

	
	
		
 
		
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		†  Net difference shows if more cash came in than went out, or vice versa, and how much.
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		‡  To get the cash balance (last row), add or subtract the Net difference from the Cash balance at the start of the month (top row). This figure becomes the next month's new cash balance.

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet estimated cash flow how to use the template this worksheet forecast vs actual will automatically update with your estimates type beginning balance in cell b monthly figures for and out month by changes sales income expenses one two three four five six seven eight nine ten eleven twelve total at start of each operating revenue receipts from customers collection receivables eg commissions etc other received sources inflows proceeds sale assets funds borrowed tax refundrebates can include equity contributions franchise or royalty fees inflow inventory stock purchases cost goods general amp administrative bank charges credit card commission accountinglegalconsultant office supplies license business insurance marketing promotional digital advertising events public relations newspapers magazines parkingtaxistolls entertainmentmeals travelaccommodation laundrydry cleaning products sundry equipment hire motor vehicle fuel service costs tires replacement registrations website domain name ...

Related files

Share

Help

How to use the template
Use this worksheet to forecast cash flow. The Estimated vs. Actual worksheet will automatically update with your estimates.
1. Type your beginning cash balance in cell B13.
2. Type in your monthly figures for cash in and cash out, month by month.


Changes in sales income
Changes in expenses
ESTIMATED CASH FLOW WORKSHEET
Cash in
Month	Month one	Month two	Month three	Month four	Month five	Month six	Month seven	Month eight	Month nine	Month ten	Month eleven	Month twelve	Total
Cash balance at the start of each month		$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Operating Revenue
Cash receipts from customers	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Collection of receivables	$0	$0	$0	$0	$0	$0	$0	$0		$0	$0	$0	$0
e.g. Commissions etc. Other operating revenue received	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Operating Revenue	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Other Sources of Cash Inflows
Proceeds from sale of assets	0	0	0	0	0	0	0	0	0	0	0	0	$0
Funds borrowed	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Tax refund/rebates	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
This can include equity contributions, franchise or royalty fees received etc. Other sources of cash inflow	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total other cash inflows	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total monthly cash in	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Cash out
Inventory (Stock)
Stock purchases	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Other cost of goods	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Cost of Goods	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
General & Administrative
Bank charges	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Credit card commission	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Accounting/Legal/Consultant fees	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Office supplies	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
License fees	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Business insurance	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Etc.	0	0	0	0	0	0	0	0	0	0	0	0	$0
Total General & Administrative	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Marketing & Promotional
Digital marketing & advertising	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Events	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Public relations	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Etc.	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Marketing & Promotional	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Operating Expenses
Newspapers & magazines	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Parking/Taxis/Tolls	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Entertainment/Meals	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Travel/Accommodation	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Laundry/Dry cleaning	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Cleaning & cleaning products	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Sundry supplies	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Equipment hire	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Etc.	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Operating Expenses	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Motor Vehicle Expenses
Fuel	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Vehicle service costs	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Tires & other replacement costs	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Insurance	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Registrations	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Motor Vehicle Expenses	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Website Expenses
Domain name registration	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Hosting expenses	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Etc.	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Website Expenses	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Permanent Employment
Salaries/Wages	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
PAYE	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Superannuation	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Other - Employee benefits	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Recruitment costs	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Permanent Employment Expenses	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Casual Employment
Salaries/Wages	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
PAYE	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Superannuation	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Other - Employee benefits	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Recruitment costs	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Casual Employment Expenses	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Workers compensation insurance													$0
Total Employment Expenses	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Occupancy Costs
Electricity/Gas	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Telephones	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Property insurance	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Rates	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Rent	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Repair & maintenance	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Waste removal	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Water	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Etc.	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Occupancy Costs	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Other Expenses
Bank Interest	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
GST	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Etc.	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Other Expenses	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Other Cash Outflows
Purchase of assets	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
i.e. Establishment fees One-off bank fees	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Principal loan repayments	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
e.g. Dividends, repayment of shareholder loans etc. Payments to the owner(s)	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Investment of surplus funds	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Other cash inflows	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total Other Cash Outflows	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Total monthly cash out	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Net difference †	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
Cash balance at the end of each month ‡	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0


† Net difference shows if more cash came in than went out, or vice versa, and how much.
‡ To get the cash balance (last row), add or subtract the Net difference from the Cash balance at the start of the month (top row). This figure becomes the next month's new cash balance.

Related files

Share

Share to social media

Help

Login Area