Free Accounting Templates (Excel-Ready)
Fill them in on the page, then download a spreadsheet with working formulas. Cash budget, budget vs actual variance report, and depreciation schedule.
Home › Free Accounting Templates
These three templates are free to use and need no sign-up. Change the sample numbers to your own, watch the totals update instantly, and press Download for Excel to save a .csv file. It opens in Microsoft Excel, Google Sheets and LibreOffice, and the totals are real formulas, so you can keep editing in your spreadsheet. Nothing you type is sent to or stored on our servers.
Cash Budget Template (6 Months)
Enter expected receipts and payments for each month. Opening cash for each month is the previous month’s closing cash. A negative surplus means you will fall below your minimum cash level and need funding. Learn the idea behind it in cash flow and budget.
Budget vs Actual Variance Report Template
List each revenue and cost line with its budget and actual figure. The template works out the variance and labels it Favourable or Adverse correctly for revenue (higher is better) and costs (lower is better). Background: variance analysis.
| Item | Type | Budget | Actual | Variance (Actual − Budget) | Favourable / Adverse | Variance % |
|---|
Depreciation Schedule Template
Enter an asset’s cost, residual value and useful life, and choose a method. Straight-line charges the same amount each year. Reducing balance charges a percentage of the remaining book value. Background: depreciation.
| Year | Opening book value | Depreciation | Accumulated depreciation | Closing book value |
|---|
Frequently asked questions
Can I open the downloads in Excel?
Yes. The files are in CSV format, which opens in Microsoft Excel, Google Sheets and LibreOffice. The cash budget and variance report include working formulas for totals and variances, so you can keep editing them in your spreadsheet. Use “Save as” to keep an .xlsx copy.
Are these templates free?
Yes, they are free to use for study, teaching and your own business planning.
What is the difference between straight-line and reducing balance depreciation?
Straight-line spreads the depreciable amount (cost minus residual value) evenly over the useful life. Reducing balance applies a fixed percentage to the remaining book value each year, so the charge is larger in early years.
What does a favourable or adverse variance mean?
A favourable variance improves profit compared with the budget: revenue higher than planned or costs lower than planned. An adverse variance reduces profit.
Keep learning
These templates are for general learning and planning. Check results against your own records and accounting policies.