Top Menu

sbc-img-temp

Downloadable Excel Financial Spreadsheets

 

Here’s 8 pretty fundamental financial spreadsheets that every small business needs to have. All are in excel. All are templates and all are downloadable.

 

This spreadsheet will help you to prepare a projected profit and loss account as part of your Operating Budget, in a format suitable for inclusion in your Business Plan. Download the Operating Budget Profit and Loss spreadsheet.
This spreadsheet will help you to record and analyse receipts made by your business. Download the Receipts spreadsheet.
This spreadsheet will help you to analyse the overheads your business is likely to incur, in a format suitable for inclusion in your Business Plan. Download the Operating Budget Analysis of Overheads spreadsheet.
This spreadsheet will help you to prepare a projected cashflow for your business, in a format suitable for inclusion in your Business Plan. Download the Cashflow spreadsheet.
This spreadsheet will help you to estimate your business’ likely sales and gross profit, in a format suitable for inclusion in your Business Plan. Download the Operating Budget:Estimate of Sales and Gross Profit spreadsheet.
This spreadsheet will help you to record and analyse petty cash expenses for your business. Download the Petty Cash spreadsheet.
This spreadsheet will help you to record and analyse payments made by your business. Download the Payments spreadsheet.
This spreadsheet will help you to summarise three years’ projected cashflows for your business, in a format suitable for inclusion in your Business Plan. Download the Cashflow:Summary spreadsheet.

Small Business Can Newsletter

Small Business Can is run by businesspeople for businesspeople. We share our experiences, successes and failures. Sign up for our insightful (and sometimes funny) newsletter and stay up to speed with all the latest insights.

  • http://twitter.com/BrianFlanagan1 Brian Flanagan

    The worksheets featured in Fionan’s piece above are useful but limited because they do not offer integration between P&L, cashflow and balance sheets.
    If you need comprehensive tools for financial projections, have a look at Exl-Plan at Dublin-based PlanWare where you’ll find planners to suit all types and sizes of businesses at prices ranging from US$49 to US$289.Versions are available using UK/International and US/Canadian accounting formats.
    More at http://www.planware.org/financialprojectionsoftware.htm

    • afro54

      With a little experience of Excel spreadsheets, even a woman can achieve this integration, without paying $289 (how much!?) to Exi-Plan. Good business doesn’t just throw money at a problem. Skill up, learn it once, and don’t keep paying for silly apps.

  • Pranit

    That is really useful..

  • jgshan

    Thanks Fionan, great free resource, they are helping improve the financial structure of our startup!

  • Monty

    Thanks for this free stuff.. GOD BLESS

  • J

    I can’t download these spreadsheets? File not found?

    • jamjodesign

      Give it a try again now and it should work with a little luck.