Free Excel Receipt Template (Workbook with a Log Sheet)
This free Excel receipt template is a small workbook, not a single page. The first sheet is the receipt itself — ready to fill, print or save as a PDF — and the second is a log that records every receipt you issue, so numbering stays sequential and last March's receipt takes seconds to find. The line math on the receipt is live: quantity times rate fills each amount, and the lines add themselves into the subtotal. What stays manual, on purpose, is tax — the tax cell is blank for hand-entry — enter the amount that applies, and the total updates. Download it below; it's free, editable, and asks for no email address.
Download the Excel receipt template
Excel Receipt Template (.xlsx)
**Excel receipt workbook (.xlsx).** Two sheets in one file. The Receipt sheet is the printable document: your business details, receipt number and date, who paid and how, an item table with live line math, and a totals block where the tax cell waits for whatever amount applies to you. The Log sheet is the memory: one row per receipt — number, date, payer, amount — so the workbook doubles as your record of everything issued. Opens in Excel, LibreOffice and Google Sheets.
The Receipt sheet prints on US Letter. Formulas are plain =qty×rate and =SUM style — nothing hidden, nothing locked, so you can inspect or change any of them. None of it asks for an email address.
What a receipt template in Excel actually adds
A paper pad or a Word file makes a perfectly good receipt, so the honest question is what the spreadsheet buys you. Three things. First, arithmetic: line amounts and the subtotal compute themselves, which matters most on multi-line receipts. Second, numbering with a memory: because the workbook carries a log, the next receipt number is always one glance away — no more two receipts both numbered 0107. Third, the record itself: every receipt you write leaves a row behind, and that running list — who paid, when, how much — is the thing you actually need at reconciliation time. A one-off receipt doesn’t need any of this. The tenth one does, and by the fiftieth the log is the most valuable sheet in the file.
A tour of the workbook
The Receipt sheet is laid out to print as a clean half-page document. The header holds your business name and contact details, the receipt number and the date. Below it, a short block records who paid and the payment method, then the item table: description, quantity, rate, and an amount cell that computes quantity × rate for each line. Under the table, the subtotal is a =SUM over the line amounts, the tax cell is blank for you to fill by hand, and the total adds subtotal and tax. That tax cell is the one deliberate gap in the automation: rates differ by place and situation, so the template never guesses — enter the amount that applies, or leave it at zero.
The Log sheet is four working columns — receipt number, date, received from, amount — plus a notes column. After you issue a receipt, copy its number, date, payer and total into the next free row. That’s the whole discipline: fifteen seconds per receipt, and the workbook always knows what number comes next and what the month added up to.
A filled example
Here is the Receipt sheet filled in — receipt 0233, a two-line sale, paid on the spot:
Receipt #0233 · July 30 · Received from: D. Okafor · Payment method: cash
Follow the arithmetic the sheet did and the one entry it didn’t. Two service calls at $45.00 computed to $90.00; the filter line came to $35.00; the subtotal summed to $125.00 on its own. The $10.31 of tax was typed in by hand — that’s the amount that applied to this sale, in this place — and the total updated to $135.31 the moment it landed. Then receipt 0233 got its row on the Log sheet: number, July 30, D. Okafor, $135.31. Next receipt, the log says 0234.
| Description | Qty | Rate | Amount |
|---|---|---|---|
| Standard service call | 2 | $45.00 | $90.00 |
| Replacement filter | 1 | $35.00 | $35.00 |
| Subtotal | $125.00 | ||
| Tax | $10.31 | ||
| Total | $135.31 |
Frequently asked questions
Will the formulas break if I edit the template?
Only if you delete the cells they live in. The formulas are plain, so a broken one takes seconds to retype.
How does the receipt numbering work?
You assign it, and the Log sheet remembers it.
Should I start a new workbook every month or every year?
Per year: one file, one log, one January-to-December story that matches how books are kept.
Can I use it on my phone?
Yes, with caveats. The Excel and Google Sheets mobile apps open the workbook and run the formulas.
Excel or Word for receipts?
Excel when you issue receipts repeatedly — the live math and the log are the whole advantage.