Spreadsheet Resources

Please find below a selection of free spreadsheet templates that may be useful to you in running your business.

Details of each spreadsheet appear below with a link for you to download the template.

Please read the Important Note, Terms of Use and Disclaimer at the bottom of the page before making use of any templates.

Startup Spreadsheet

STARTUP PLANNER

When starting up a business you need to know if you have enough funding in place to cover your initial costs. You also need to know the amount of sales you need to cover your running costs and achieve a profit.This template lets you enter those costs and the funding you intend to use to cover those costs. Then you can see where any shortfall may occur.
 

Budget Spreadsheets

BUDGETING

This template contains templates for an annual budget as well as a monthly budget. It also includes a template for calculating sales and gross profit based on production volume.

CASHFLOW

This is a 12 month cashflow that can help you to see whether your monthly income is enough to meet your expenses.
 

Financial Performance Measurement Spreadsheets

MONTHLY PROFIT AND LOSS

A simple monthly profit and loss statement that allows you to monitor your monthly profit.

PROFIT AND CASHFLOW EFFECTS CALCULATOR

Enter your current sales and cost of sales. Then see the effect that changing volume of sales and margin will have on your profitability.This template will also let you enter your stock, debtors and creditors and the number of days that cashflow is locked up in them. Then consider how you could improve that lock-up time and see how much cashflow could be released.

SALES PERFORMANCE

This is for you to compare actual sales against budget for each month over a 12 month period.

SALES ROLLING AVERAGE CHARTS

Enter your total monthly sales each month and this template will build a chart showing you actual and average sales for the last 12 months, as well as the preceding 12 months.
 

Other Spreadsheets

MILEAGE AND EXPENSES

Forms that you can use with your employees to collect and record business mileage and expenses information.

 
 

Important Note

In order to use these templates you will need to have a spreadsheet application, such as Microsoft Excel, that is able to open ‘.xlsx’ files.

Terms of Use

These templates are provided free of charge for your personal use only and are not to be distributed.

Disclaimer

While we have taken every care to ensure the accuracy of these templates, the nature and editability of spreadsheets makes them prone to error. Their proper use requires a degree of proficiency in using spreadsheets. Therefore your choice to use the templates and rely on any results produced is entirely at your own risk. We will not, under any circumstances, accept liability or responsibility, for decisions you may make as a result of using the templates.

Leave a Reply