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.

8 Responses to Downloadable Excel Financial Spreadsheets

  1. Brian Flanagan October 5, 2012 at 4:22 pm #

    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 March 15, 2014 at 8:05 pm #

      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.

  2. Pranit May 21, 2013 at 1:44 pm #

    That is really useful..

  3. jgshan November 18, 2013 at 9:15 am #

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

  4. Monty December 27, 2013 at 9:23 am #

    Thanks for this free stuff.. GOD BLESS

  5. J May 13, 2014 at 2:53 pm #

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

    • jamjodesign May 13, 2014 at 3:00 pm #

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

  6. Iddrisu ABDUL-RAHIM September 18, 2014 at 3:21 pm #

    thanks very much for all this stuff. It really made my work much easier. Jah bless

Leave a Reply