Free Excel accounting templates
Download ready-to-use spreadsheets for bookkeeping, statements, cash, sales, planning and family money. Every workbook starts with an Instructions sheet and comes with or without sample data.
- No sign-up, no email, no watermark: the file is built in your browser.
- Inputs are yellow, formulas are grey and locked, and check cells say ✓ or ✗ in words.
- Works in Excel, LibreOffice and Google Sheets; formulas use widely supported functions only.
- Nothing is pre-filled with tax rates: you enter the rates that apply to you.
Bookkeeping
Small Business Bookkeeping All-in-One
Keep a full set of books in one workbook: chart of accounts, journal, ledger, trial balance, profit and loss, balance sheet and cash flow, with checks that tell you when something does not add up.
General Ledger
Record journal entries and see any account’s ledger with a running balance.
General Journal
A clean journal with an account dropdown and a balance check on every entry.
Inventory Stock Card
Weighted-average stock card: quantities, average cost and cost of goods out per item.
Payroll Register
Record gross pay, deductions, net pay and employer costs per employee and period. No tax is calculated.
Financial statements
Trial Balance
List account balances in debit and credit columns and check that they balance.
Profit and Loss
Monthly profit and loss with year-to-date totals and % of revenue.
Balance Sheet
Assets, liabilities and equity with an automatic balance check.
Cash Flow Statement (indirect)
Indirect cash-flow statement that ties to your opening and closing cash.
Cash and bank
Cash Book
Record money in and out with a running balance and a month-by-category summary.
Petty Cash Log
Track petty cash vouchers against a fixed float, count the box and see the top-up needed.
Bank Reconciliation
Reconcile the bank statement with your books: adjusted bank balance equals adjusted book balance.
Expense Tracker
Log expenses with category, payment method and receipt status, with a monthly summary by category.
Sales and purchases
Invoice
A printable invoice with per-line tax, totals and the amount due.
Quote / Estimate
A quote with per-line tax, totals and a validity date.
Accounts Receivable Ageing
See who owes you, for how long, in 30-day buckets.
Accounts Payable Ageing
See what you owe suppliers and how overdue it is, in 30-day buckets.
Planning and assets
Depreciation Schedule
Year-by-year depreciation with straight line, double declining balance or sum of the years’ digits.
Loan Amortisation
Payment schedule with interest and principal per period; the final payment brings the balance to exactly 0.00.
12-Month Business Budget
Budget each account by month, enter actuals and see variances with a favourable or unfavourable flag.
Household and family
Household Budget
Plan income and spending by category for 12 months and compare with what actually happened.
Family Money
Four family tools: shared-expense splitter, savings goal, debt payoff plan and a kids’ allowance ledger.
The .ods file is a basic, unstyled version (values and formulas only). LibreOffice users get the full experience from the Excel file.
Educational and record-keeping tools. Not tax, legal or accounting advice. Not certified e-invoicing or filing software. Verify with a qualified professional.