21 Free Templates
Free Business Finance Templates for Excel & Google Sheets
Financial statements, bookkeeping, expense tracking, and business planning tools.
About These Business Finance Templates
Financial statements, bookkeeping, expense tracking, and business planning tools. Each template includes a dashboard with key metrics, formula-driven calculations, and realistic sample data. Download any template instantly - they work in Microsoft Excel, Google Sheets, and LibreOffice Calc with no setup required.
All Business Finance Templates
Cash Flow Statement
A line per movement across one period, arriving with sample entries, and what you expected sitting beside what actually happened. The Free Cash Flow Statement spreadsheet template takes inflows positive and outflows negative so a single column nets out, and the strip at the top carries both totals and whether the period finished cash positive. Sixteen lines with free-text labels, so the list matches your business. Google Sheets or Excel. No macros, no VBA, no sign-up.
Profit & Loss Projection
Revenue and costs sit on the same list, told apart by sign, with a projected figure in one column and an actual in the next. The Free Profit & Loss Projection spreadsheet template runs sixteen lines to net income both ways, and its Difference column reads correctly whether the row is income or expense. Projected and actual net income are restated at the top. Google Sheets or Excel. No macros, no VBA, no sign-up.
Sales Forecast
A line per product or service, forecast across four quarterly columns, with a year total derived on each line and every quarter totalled down the page. The Free Sales Forecast spreadsheet template holds fourteen lines, so revenue splits by what you sell rather than sitting as a single number, and it puts first quarter, last quarter and the year total on a strip at the top. One working sheet, Google Sheets or Excel. No macros, no VBA, no sign-up.
Startup Costs
Sixteen lines, each with what you budgeted beside what it actually came to and the gap between them worked out as budgeted less actual, so a positive number means the line came in under. The Free Startup Costs spreadsheet template ships with sample lines for the costs people forget, permits, deposits and first-year insurance among them, and totals at the foot and again on the strip at the top. Google Sheets or Excel. No macros, no VBA, no sign-up.
Business Plan Workbook
Three years of projection on one sheet, a line per item tagged revenue or expense, with revenue positive and costs negative so each year's total is simply the net. The Free Business Plan Workbook spreadsheet puts year one and year three on the strip at the top, and leaves the year columns free of a currency marker because they are periods, not amounts. Sixteen lines. Google Sheets or Excel. No macros, no VBA, no sign-up.
Depreciation Schedule
Fourteen rows for the assets you own, each with a cost, a purchase date and a useful life, and the annual straight-line charge falling out of cost divided by life. The Free Depreciation Schedule spreadsheet template totals the cost of the asset base and the yearly charge in a strip above the register, and leaves the asset names as free text. One working sheet, Google Sheets or Excel. No macros, no VBA, no sign-up.
Petty Cash Log
An opening balance at the top, then sixteen rows of movement with deposits and withdrawals in columns of their own. The Free Petty Cash Log spreadsheet template carries a running balance down the sheet, so the last filled row is what should be in the tin, and takes a free-text category on every entry. Replenishments go in like any other money in. One working sheet and a How to Use tab. Google Sheets or Excel. No macros, no VBA, no sign-up.
Expense Report
Sixteen expense lines, each with the date, what it was for, its category, the amount, and whether it went on a corporate card or your own money. The Free Expense Report spreadsheet template totals the claim in a strip above the list and counts the entries beside it, with the How to Use guide on a second tab. Google Sheets or Excel, one file. No macros, no VBA, no sign-up.
Mileage Tracking Log
Odometer at the start, odometer at the end, and the distance comes from those two readings rather than being typed. The Free Mileage Tracking Log spreadsheet template holds sixteen trips, keeps the rate per mile in a labelled cell above the log so every deduction reads from it, and puts a purpose against each trip, which is what a log is judged on. How to Use on a second tab. Google Sheets or Excel. No macros, no VBA, no sign-up.
Rental Property Cashflow
One rental, one month, 15 lines, with what you budgeted set against what actually happened and a difference on every line. The Free Rental Property Cashflow spreadsheet template takes income positive and costs negative so the foot of the sheet is net cashflow, and includes reserve lines for maintenance and vacancy. How to Use on a second tab. Google Sheets or Excel, one file. No macros, no VBA, no sign-up.
Small Business Bookkeeping
Dated entries with a description, a category, and either money in or money out - one amount per row, both columns totalled at the foot with the net underneath. The Free Small Business Bookkeeping spreadsheet template holds sixteen ledger rows on a single working sheet and leaves the categories as free text, so the filing is yours. Google Sheets or Excel, one file. No macros, no VBA, no sign-up.
Etsy Seller Spreadsheet
A row per order - what it sold for, what came off in fees and postage, and what was left. The Free Etsy Seller Spreadsheet template gives you sixteen order rows, derives the net from the sale price, and carries gross sales and net revenue on the strip at the top. Nothing states Etsy's rates: you enter what actually came off. A currency dropdown beside the title relabels the money columns. Google Sheets or Excel, one file. No macros, no VBA, no sign-up.
Airbnb Rental Tracker
A line per booking - guest, arrival date, nights, what came in, what the platform took, what was left. The Free Airbnb Rental Tracker spreadsheet template derives the net from the gross and the fees rather than asking for it twice, and carries nights, gross and net across everything logged on a strip at the top. Sixteen rows on one working sheet, quick enough to keep current through a season. Google Sheets or Excel. No macros, no VBA, no sign-up.
Freelancer Finance Tracker
A row per project: the client, the start date that puts the pipeline in order, a free-text status for where the work stands, and the fee. The Free Freelancer Finance Tracker spreadsheet template gives you sixteen of those rows on one working sheet, totals the amounts underneath, and keeps its How to Use guide on a second tab. Google Sheets or Excel, one file. No macros, no VBA, no sign-up.
Price List Template
A row per item on one working sheet, each with a category, the unit it is sold by, a regular price and a sale price beside it. The Free Price List Template takes free-text item names and categories, so the filing is yours, and keeps its How to Use guide on a second tab. A list of prices rather than a quoting tool. Google Sheets or Excel, one file. No macros, no VBA, no sign-up.
Accounts Receivable Tracker
A line per invoice with the customer, the date you raised it, the date it is due and the amount - and a Paid column that takes it straight out of the outstanding figure. The Free Accounts Receivable Tracker spreadsheet template keeps everything invoiced and everything still owed as two separate numbers, and leaves the invoice number free text so your own numbering carries over. Sixteen rows, one working sheet. Google Sheets or Excel. No macros, no VBA, no sign-up.
Accounts Payable Tracker
A line per bill with the vendor, their bill number, the amount and the date it falls due, and a Paid column to mark once it is settled. The Free Accounts Payable Tracker spreadsheet template reads a status off those two columns rather than asking you to type one - overdue, due soon or upcoming - and works it out again every time the file opens. Sixteen rows on one working sheet. Google Sheets or Excel. No macros, no VBA, no sign-up.
Project Budget
Fourteen cost lines, each with what you budgeted and what it actually came to, and a difference column reading budgeted less actual so a positive number means under. The Free Project Budget spreadsheet template keeps internal and contractor labour as separate lines and leaves the contingency figure for you to set. One working sheet, Google Sheets or Excel. No macros, no VBA, no sign-up.
Balance Sheet
Thirteen lines across assets, liabilities and equity, arriving with sample entries and a marker on every row saying which of the three it is. The Free Balance Sheet spreadsheet template enters assets positive and liabilities and equity negative, so the column nets to zero and the balance check reads zero when the books tie - the one number worth looking at first. One working sheet, an entry count beside it. Google Sheets or Excel. No macros, no VBA, no sign-up.
Break-Even Analysis
Total fixed costs, a price per unit and a variable cost per unit go in. Back comes the contribution margin - what each sale leaves toward the fixed costs - that margin as a share of the price so it compares across products, and the break-even point in units. The Free Break-Even Analysis spreadsheet template holds the whole calculation on one working sheet. Google Sheets or Excel. No macros, no VBA, no sign-up.
Business Budget
Category lines arrive already labelled, carrying what you budgeted against what actually went through, with the difference on every one - so an over-run shows even in a period that looks level overall. The Free Business Budget spreadsheet template takes income positive and costs negative, which makes the foot of the sheet your profit rather than a number to work out. Sixteen lines, one working sheet. Google Sheets or Excel. No macros, no VBA, no sign-up.
Need more advanced features?
Our premium spreadsheet templates include multi-sheet dashboards, advanced formulas, native charts, and ongoing updates.