Free Excel Templates for Accountants: P&L, Balance Sheet, Bank Rec and Close Checklist (No Signup)
Search "free Excel templates" and most of what comes back is not a file. It is a gallery that shows a spinner, then a grid of tidy thumbnails, and every thumbnail opens in somebody's web app behind a sign-up. You wanted an .xlsx on your desktop at 17:40 on the last working day of the month. You got an account.
This page is the opposite arrangement. Four templates, four direct .xlsx links, no email, no login, no "open in". Under each is what is actually inside — the sheets, the cells that calculate, the formula doing the work, and the case it gets wrong — so you can judge the fit before you spend a click. After that: the schedules worth building yourself, and how to audit any workbook a stranger hands you.
What "free" should mean before you download anything
A template is a small piece of software you are about to trust with a number that ends up in a management pack. Six things separate a usable one from a thumbnail.
| Test | Why it matters |
|---|---|
| It is a real file | An .xlsx you can save, email and version — not a web canvas that expires with the trial. |
| No account required | An email wall on a spreadsheet is a lead form wearing a costume. |
| Formulas, not values | Totals typed as numbers look identical to totals that calculate — until a line changes. |
| No macros | An .xlsx cannot contain VBA. A "free template" arriving as .xlsm asking you to enable content is a decision, not a download. |
| Ranges you can extend | A SUM that stops at row 20 quietly ignores row 21. |
| Stated limits | Every template gets something wrong. The honest ones tell you which. |
All four below are .xlsx, all four calculate, and each names what it cannot do.
1. Profit and loss statement
Download the P&L template — 2 sheets, no macros.
Two sheets: P&L and Transactions. The P&L runs a conventional five-block statement — revenue (rows 8-10), cost of sales (14-16), gross profit, operating expenses (23-30), net profit — with a period label in B4 and five columns: line item, this period, prior period, variance, variance %.
What calculates: B11 totals revenue with =SUM(B8:B10), B17 cost of sales, B19 gross profit as =B11-B17, B31 the eight overhead lines and B33 net profit as =B19-B31. Column D is the absolute variance (=B8-C8), column E the percentage change, guarded against a nil prior period:
=IFERROR((B8-C8)/C8,"")The margin cells are B20 and B34, both =IFERROR(B19/B11,"") in shape — gross and net profit over revenue, updating as you type. One quirk before you label a printed pack: on the two profit rows (19 and 33) column E carries the margin, not the period-on-period change, so head it "Var % / margin" or blank those two cells for a board pack.
To use it: type this period's figures into column B, last period's into column C, and rename the eight expense lines in column A to your own chart of accounts. Add lines at the bottom of a block rather than inserting mid-block, then extend the SUM range above.
The Transactions sheet is the reason this beats a static form. Headers are Date, Description, Category, Amount, and F2 carries the pattern that wires the statement to a pasted ledger export:
=SUMIFS(Transactions!$D:$D, Transactions!$C:$C, "Marketing")Paste your GL export there, then replace the typed figure in each expense cell with a SUMIFS pointing at its category, and the statement rebuilds itself every time you repaste. Two checks on a fresh export: amounts arriving as text (=SUMPRODUCT(--ISTEXT(D2:D5000)) should return 0) and category spellings that drifted — see cleaning messy data in Excel.
Limits: single entity, single currency, no consolidation, no budget column. Full walkthrough: building a P&L statement in Excel.
2. Balance sheet
Download the balance sheet template — 1 sheet, no macros.
One sheet, two comparative columns (this year / last year), an "As at" date in B4, and five blocks: current and non-current assets, current and non-current liabilities, equity.
The subtotals: B12 current assets, B18 non-current assets, B20 total assets as =B12+B18; B27 and B32 for liabilities with B34 as =B27+B32; B40 for equity. The row that earns the download is the check at the bottom:
B42: =B20-B34-B40
B43: =IF(ROUND(B42,2)=0,"OK - balanced","OUT BY "&TEXT(B42,"#,##0.00"))So row 43 reads either OK - balanced or OUT BY 1,240.00, in both columns. The ROUND(...,2) is deliberate: figures carrying fractional pence would otherwise sit at 0.0000001 and report themselves broken forever.
The one trap: row 16 is Accumulated depreciation and it sits inside =SUM(B15:B17), so enter it as a negative. Type 48,000 instead of -48,000 and total assets overstate by 96,000 — which the check row reports exactly, though people have been known to plug that difference into retained earnings rather than read it.
To use it: enter this year in B, last year in C, and stop when row 43 says OK in both columns. If it does not, work the usual suspects — a sign, a line in the wrong block, B39 disagreeing with net profit on the P&L, or opening retained earnings never rolled forward.
Limits: no cash flow statement, no note disclosures, no roll-forward from the prior year. Structure, equation and what to do when it will not balance: balance sheet template in Excel.
3. Bank reconciliation
Download the bank reconciliation template — 3 sheets, no macros.
Three sheets: Reconciliation, Bank statement, Ledger.
The Reconciliation sheet is the classic two-column proof. Bank side: closing balance per statement (B5), plus deposits in transit (B6), less outstanding cheques (B7), giving B8 = B5+B6-B7. Book side: balance per ledger (B10), plus unrecorded bank credits (B11), less unrecorded charges (B12), giving B13 = B10+B11-B12. Then:
B15: =B8-B13
C15: =IF(ROUND(B15,2)=0,"RECONCILED","OUT BY "&TEXT(B15,"#,##0.00"))The other two sheets do the line work. Both have Date, Description, Amount, Matched? headers and a flag formula pre-filled to row 201 — 200 lines a side. On the Bank statement sheet:
=IF(C2="","",IF(COUNTIFS(Ledger!$C:$C,C2)>0,"matched","UNMATCHED"))and its mirror on the Ledger sheet, looking back at 'Bank statement'!$C:$C. Filter either column D to UNMATCHED and you have your investigation list in about four seconds.
Three things amount-only matching gets wrong, and the template says so on the Reconciliation sheet itself:
- Sign conventions. If the bank exports outflows as -500.00 and your ledger records them as 500.00, nothing matches. Normalise one side first — a helper column of
=-C2, pasted back as values, is enough. - Duplicate amounts. Two payments of 250.00 on the bank side against one on the ledger side:
COUNTIFS(...)>0is true for both, so both read "matched" and the missing one hides. The difference in B15 still catches it, which is why you reconcile the total as well as the lines. - One-to-many. A deposit of 9,400 covering four invoices will never equal any single ledger line, so it stays UNMATCHED and needs a human or a name-based match — see fuzzy matching in Excel for the "ABC Corp" versus "ABC Corporation" problem.
To use it: paste the statement on one tab and the ledger on the other, both with amounts in column C, then work the UNMATCHED lines into the four adjustment cells (B6, B7, B11, B12) until C15 reads RECONCILED. Past 200 lines a side, copy D201 and paste down. Method and worked adjustments: bank reconciliation in Excel.
4. Month-end close checklist
Download the month-end close checklist — 1 sheet, no macros.
Twenty tasks in close order across # / Task / Owner / Status / Due day / Notes, in rows 8-27, with a period label in B4.
The tasks are the ones that actually hold up a close, sequenced Day 2 to Day 8: sales invoices raised and supplier invoices entered (Day 2), bank and card reconciliations, the payroll journal and a GRNI accrual (Day 3), deferred revenue, AR aging, prepaid release, bonus and leave accruals, asset additions and disposals (Day 4), bad-debt provision, depreciation and the stock count (Day 5), VAT/GST control account and intercompany elimination (Day 6), variance explanations and balance sheet movement review (Day 7), management pack and period lock (Day 8).
Status is a real data-validation dropdown on D8:D27 with four options — Not started, In progress, Done, N/A — and progress sits in E4:
=IFERROR(COUNTIF(D8:D60,"Done")/COUNTA(A8:A60),0)Two consequences worth knowing. Tasks marked N/A stay in the denominator, so a month with three inapplicable tasks tops out at 85% — accept it as a convention or delete the rows you never use. And the ranges run to row 60 while the dropdown covers only D8:D27, so a task 21 added in row 28 needs an existing status cell copied down to bring the validation with it (how the dropdown is built).
To use it: set the period in B4, put a name in every owner cell — an unowned task is not a task — adjust the due days to your timetable, and save one copy per month rather than overwriting. The reasoning behind the sequence: the month-end close checklist.
Wiring the four into one close pack
They hand off to each other. Put all four in a folder named for the period, then run them in this order:
- Bank rec first — task 1 on the checklist is the reconciliation, and nothing downstream is trustworthy until the cash line is proved.
- Ledger export into the P&L's Transactions sheet, expense cells on SUMIFS.
- P&L, then carry net profit from B33 to the balance sheet's Current year profit cell, B39.
- Balance sheet until row 43 reads OK - balanced in both columns.
- Checklist updated as you go, so E4 is the honest status when someone asks.
Keep the prior month's folder untouched. Comparatives re-keyed rather than carried forward are a common reason a variance column is wrong before anyone has looked at it — see variance analysis in Excel.
The schedules to build rather than download
We ship four templates because those are the four we maintain. For the rest, a downloaded workbook is usually the wrong answer anyway: a depreciation register or a revenue schedule encodes your policy, and a stranger's assumptions buried in row 40 are harder to find than a formula you wrote yourself.
Fixed asset and depreciation register. One row per asset — description, cost, date in service, method, life, residual — then a periodic charge with SLN, DB or a manual straight-line calculation, plus a net book value column that must agree to the balance sheet's property and equipment block. Part-year conventions and mid-life disposals are where most inherited registers stop reconciling: depreciation schedule in Excel.
Deferred revenue schedule. One row per contract, contract value spread across the recognition months, columns footing to the deferred balance. Genuinely dangerous to download, because the recognition pattern is a policy judgement rather than a formula: deferred revenue schedule in Excel.
AR and AP aging. A SUMIFS grid over an open-items list, bucketed 0-30 / 31-60 / 61-90 / 90+ on invoice date. Fifteen minutes from an export you already have, and it stays current because it recalculates rather than being re-typed.
Cash flow forecast. Thirteen weeks across, receipts and payments down, opening rolling into closing. A downloaded one rarely matches your payment runs, payroll dates or VAT quarters — the three things that decide whether it is worth reading.
Anything with a percentage column. Common-size statements, margin schedules, growth rates: quick mechanics, but the base is a judgement and the traps are real (percentage formulas for accountants).
How HISAB 360 helps
The templates hand you the structure. The tedious part surrounds them: getting the ledger out of the accounting system, into the shape the template expects, and doing it again next month.
HISAB 360 is a paid add-in for Windows desktop Excel with an AI chat panel docked inside the workbook. It connects to six accounting systems — QuickBooks Online, Xero, Zoho Books, Odoo, FreshBooks and Sage Accounting — and pulls invoices, bills, GL activity and contacts straight onto a sheet: the Transactions tab of the P&L template, populated without an export-download-paste cycle. It writes back too, creating invoices, bills and journal entries in the ERP from the workbook.
From there the panel builds. Ask it for a P&L or balance sheet from a trial balance and it constructs the statement in the sheet rather than describing one; ask for a depreciation register or an aging grid and it writes the formulas into the live workbook. Bank reconciliation runs as an automation with fuzzy matching on descriptions and amounts, so the name and amount variations an exact-match COUNTIFS cannot see get picked up rather than left to the eye — review what it matches before you post it. It also turns a PDF bank statement or invoice into a table, removing the retyping the templates otherwise assume.
Honest limits: Windows desktop Excel only (Microsoft 365 or 2016+, 64-bit) — not Mac, not Excel on the web — and paid, with a 15-day trial that includes 50 AI credits and no card. Everything it generates deserves the review you would give a junior's schedule.
Which one to start with
| If your problem is | Start here |
|---|---|
| The bank line will not agree | Bank reconciliation |
| You need a P&L for a lender or a board | P&L statement |
| Year-end and the balance sheet is out | Balance sheet |
| The close takes too long and nobody owns tasks | Close checklist |
Auditing a template someone else gave you
Whatever you download, five minutes of checks before it carries a real number:
- Show the formulas. Formulas tab > Formula Auditing > Show Formulas, or Ctrl+`. Every total should be a formula; anything typed as a constant where you expected a calculation is a plug.
- Find the hardcodes. F5 > Special > Constants > Numbers highlights every typed number at once. Inside a calculating block, that is your list of things to question.
- Check the SUM ranges reach the bottom. Click each subtotal and read its range against the block above it. A
=SUM(B8:B10)sitting under eleven rows of data is the commonest template defect there is. - Trace one number end to end. Select a total, Formulas > Trace Precedents, follow it back to an input. If the trail leaves the workbook to a file you do not have, stop.
- Confirm the file type.
.xlsxcannot hold a macro;.xlsmcan. If a template arrives macro-enabled and you were not expecting it, ask why before enabling anything.
None of that proves a template is right for your entity. It does mean you know what it is doing, which is more than a thumbnail in a gallery ever tells you.
Frequently asked questions
Are these Excel templates really free, with no signup?
Yes. The four links above are direct .xlsx downloads — no email, no account, no trial, no "open in" web app. They are the four we maintain and the four we will tell you the limits of. We deliberately do not publish a large gallery of templates we cannot support, which is why the sections above show you how to build the rest rather than promising files that do not exist.
Will these accounting templates work in Google Sheets or Excel for Mac?
The formulas are standard — SUM, SUMIFS, COUNTIF, COUNTIFS, IF, IFERROR, ROUND, TEXT — and as of 2026 they open fine in Excel for Mac and, after an import, in Google Sheets. The data-validation dropdown on the close checklist usually survives the Sheets import, though import behaviour changes over time; check it before relying on it. The HISAB 360 add-in described above is Windows desktop Excel only, but the templates themselves need no add-in.
Which bookkeeping templates should a small business start with?
The bank reconciliation and the close checklist, in that order. Reconciliation is the control that catches missing transactions, duplicated payments and unrecorded bank charges, so it makes everything else trustworthy. The checklist turns an improvised month-end into a repeatable one with named owners. The P&L and balance sheet are outputs — worth less until the inputs behind them are proved.
Can I edit the templates and add my own accounts?
Yes, and you should — the line items are placeholders. Rename freely in column A. When adding rows, insert them inside an existing block rather than directly above a subtotal, then click the subtotal and confirm its SUM range grew to include the new row. Excel usually extends it; it does not always, and a total that silently skips a line is worse than one that errors.
Try HISAB 360 on your own workbook
HISAB 360 is an AI assistant inside Excel for accountants and finance teams — it writes macros, Power Query and formulas from plain English, and connects two-way to QuickBooks, Xero, Zoho Books, Odoo, FreshBooks and Sage. The 15-day trial is the full product, no card required.