Spreadsheet For Expenses 33290 | Bsu Financial Statements Templates

Partial file snippet.

Sheet 1: INTRO

	
	
	
		
 
		
		Financial Statements
You will find in this workbook 3 projected financial statement templates. 
- Projected Profit and Loss Template
- Projected Cashflow Template
- Projected Balance Sheet Template
	
	
		

	
	
		

		The Profit and Loss sheet, the Cash Flow sheet and the Balance sheet are all  intended as a GUIDE ONLY and DO NOT constitute financial advice, please always verify and discuss your financial statements with a qualified accountant or financial advisor.   
	
	
		

		

	
	
		

		

	
	
		

		

	
	
		

		

	
	
		

		

	
	
		

		

	
	
		

		

	
	
		

		

	
	
		

		

	
	
		

		

	
	
		

		

	
	
		

		

	
	
		

		  
	



Sheet 2: Profit and Loss

	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
 
		
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Profit & Loss for [Business name] as at [Financial Year]
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		A profit and loss or income statement lists your sales and expenses and is generally recorded on a monthly, quarterly or yearly basis. It tells you how much real profit you're making or losing. A profit and loss statement can help you develop sales targets and an appropriate sales price for goods/services using tools like the break-even and profit margin. See our “financial statement analysis page” for more information about these financial tools.
		
	
		
	
		
	
		
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		PROJECTED PROFIT & LOSS
		July
		August
		September
		October
		November
		December
		January
		February
		March
		April
		May
		June
		Yearly Total
	
	
		Sales
		

		

		

		

		

		

		

		

		

		

		

		

		0
	
	
		less cost of goods sold
		

		

		

		

		

		

		

		

		

		

		

		

		0
	
	
		More…
		

		

		

		

		

		

		

		

		

		

		

		

		0
	
	
		Gross profit/net sales
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
	
	
		Expenses
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Accountant fees
		

		

		

		

		

		

		

		

		

		

		

		

		0
	
	
		Advertising & marketing
		

		

		

		

		

		

		

		

		

		

		

		

		0
	
	
		Bank fees & charges
		

		

		

		

		

		

		

		

		

		

		

		

		0
	
	
		Bank interest
		

		

		

		

		

		

		

		

		

		

		

		

		0
	
	
		Credit card fees
		

		

		

		

		

		

		

		

		

		

		

		

		0
	
	
		Utilities (electricity, gas, water)
		

		

		

		

		

		

		

		

		

		

		

		

		0
	
	
		Telephone
		

		

		

		

		

		

		

		

		

		

		

		

		0
	
	
		Lease/loan payments
		

		

		

		

		

		

		

		

		

		

		

		

		0
	
	
		Rent & rates
		

		

		

		

		

		

		

		

		

		

		

		

		0
	
	
		Motor vehicle expenses
		

		

		

		

		

		

		

		

		

		

		

		

		0
	
	
		Repairs & maintenance
		

		

		

		

		

		

		

		

		

		

		

		

		0
	
	
		Stationery & printing
		

		

		

		

		

		

		

		

		

		

		

		

		0
	
	
		Insurance
		

		

		

		

		

		

		

		

		

		

		

		

		0
	
	
		Superannuation
		

		

		

		

		

		

		

		

		

		

		

		

		0
	
	
		Income tax
		

		

		

		

		

		

		

		

		

		

		

		

		0
	
	
		Wages (including PAYG)
		

		

		

		

		

		

		

		

		

		

		

		

		0
	
	
		More…
		

		

		

		

		

		

		

		

		

		

		

		

		0
	
	
		Total expenses
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
	
	
		NET PROFIT (Net Income)
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Assumptions:
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		 All figures are VAT inclusive.
		

		

		

		

		

		

		

		

		

		

		

		

		

	



Sheet 3: Cash Flow

	
	
	
		
 
		
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Cash Flow for [Business name] in [Financial Year]
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		A cash flow statement can be one of the most important tools in managing your finances. It tracks all the money flowing in and out of your business and can reveal payment cycles or seasonal trends that require additional cash to cover payments. This cycle or pattern can help you plan ahead and make sure you always have money to cover your payments. See Finance for more information on managing and seeking finance.
		
	
		
	
		
	
		
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		PROJECTED CASH FLOW
		July
		August
		September
		October
		November
		December
		January
		February
		March
		April
		May
		June
	
	
		OPENING BALANCE
		

		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
	
	
		Cash incoming
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Sales
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Asset sales
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Debtor receipts
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Other income
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Total incoming
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
	
	
		Cash outgoing
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Purchases (Stock etc)
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Accountant fees
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Solicitor fees
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Advertising & marketing
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Bank fees & charges
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Interest paid
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Credit card fees
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Utilities (electricity, gas, water)
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Telephone
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Lease/loan payments
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Rent & rates
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Motor vehicle expenses
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Repairs & maintenance
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Stationery & printing
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Membership & affiliation fees
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Licensing
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Insurance
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Superannuation
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Income tax
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Wages (including PAYG)
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		More…
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Total outgoing
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Monthly cash balance
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
	
	
		CLOSING BALANCE
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Assumptions:
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		 All figures are VAT inclusive.

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

...Sheet intro financial statementsyou will find in this workbook projected statement templates profit and loss template cashflow balance the cash flow are all intended as a guide only do not constitute advice please always verify discuss your statements with qualified accountant or advisor amp for at income lists sales expenses is generally recorded on monthly quarterly yearly basis it tells you how much real re making losing can help develop targets an appropriate price goodsservices using tools like breakeven margin see our ldquo analysis page rdquo more information about these july august september october november december january february march april may june total less cost of goods sold hellip gross profitnet fees advertising marketing bank charges interest credit card utilities electricity gas water telephone leaseloan payments rent rates motor vehicle repairs maintenance stationery printing insurance superannuation tax wages including payg net assumptions figures vat inclusive b...

Related files

Share

Help

	Financial Statements You will find in this workbook 3 projected financial statement templates. - Projected Profit and Loss Template - Projected Cashflow Template - Projected Balance Sheet Template

	The Profit and Loss sheet, the Cash Flow sheet and the Balance sheet are all intended as a GUIDE ONLY and DO NOT constitute financial advice, please always verify and discuss your financial statements with a qualified accountant or financial advisor.


Profit & Loss for [Business name] as at [Financial Year]

A profit and loss or income statement lists your sales and expenses and is generally recorded on a monthly, quarterly or yearly basis. It tells you how much real profit you're making or losing. A profit and loss statement can help you develop sales targets and an appropriate sales price for goods/services using tools like the break-even and profit margin. See our “financial statement analysis page” for more information about these financial tools.




PROJECTED PROFIT & LOSS	July	August	September	October	November	December	January	February	March	April	May	June	Yearly Total
Sales													0
less cost of goods sold													0
More…													0
Gross profit/net sales	0	0	0	0	0	0	0	0	0	0	0	0	0
Expenses
Accountant fees													0
Advertising & marketing													0
Bank fees & charges													0
Bank interest													0
Credit card fees													0
Utilities (electricity, gas, water)													0
Telephone													0
Lease/loan payments													0
Rent & rates													0
Motor vehicle expenses													0
Repairs & maintenance													0
Stationery & printing													0
Insurance													0
Superannuation													0
Income tax													0
Wages (including PAYG)													0
More…													0
Total expenses	0	0	0	0	0	0	0	0	0	0	0	0	0
NET PROFIT (Net Income)	0	0	0	0	0	0	0	0	0	0	0	0	0

Assumptions:
All figures are VAT inclusive.


Cash Flow for [Business name] in [Financial Year]

A cash flow statement can be one of the most important tools in managing your finances. It tracks all the money flowing in and out of your business and can reveal payment cycles or seasonal trends that require additional cash to cover payments. This cycle or pattern can help you plan ahead and make sure you always have money to cover your payments. See Finance for more information on managing and seeking finance.




PROJECTED CASH FLOW	July	August	September	October	November	December	January	February	March	April	May	June
OPENING BALANCE		0	0	0	0	0	0	0	0	0	0	0
Cash incoming
Sales
Asset sales
Debtor receipts
Other income
Total incoming	0	0	0	0	0	0	0	0	0	0	0	0
Cash outgoing
Purchases (Stock etc)
Accountant fees
Solicitor fees
Advertising & marketing
Bank fees & charges
Interest paid
Credit card fees
Utilities (electricity, gas, water)
Telephone
Lease/loan payments
Rent & rates
Motor vehicle expenses
Repairs & maintenance
Stationery & printing
Membership & affiliation fees
Licensing
Insurance
Superannuation
Income tax
Wages (including PAYG)
More…
Total outgoing	0	0	0	0	0	0	0	0	0	0	0	0

Monthly cash balance	0	0	0	0	0	0	0	0	0	0	0	0
CLOSING BALANCE	0	0	0	0	0	0	0	0	0	0	0	0

Assumptions:
All figures are VAT inclusive.

Related files

Share

Share to social media

Help

Login Area