A receipt is a short document that records a completed payment: who paid whom, what was bought, when it happened, what the totals came to, and how much change was returned. To make a receipt in Excel, you set up a header section with the merchant name, payment date, receipt number, and display currency, then add a line-item table where each row multiplies a quantity by a unit price. After the items, you add formulas for the subtotal, a flat discount, percentage tax on the discounted subtotal, a flat tip, and a final total, and you compare that total to the amount the customer actually tendered. The change owed is simply the tendered amount minus the total. That structure works on paper, and most people build exactly that layout across roughly the first twenty rows of a worksheet. The catch is that Excel's default math uses binary floating-point representation, so naive sums of cents such as 0.10 plus 0.20 can print as 0.30000000000000004, and any layout you build has to be reformatted every time the receipt changes shape.
What "Making a Receipt in Excel" Actually Means
People who search for how to make a receipt in Excel usually want one of three things: a printable layout they can fill in once and hand to a customer, a live worksheet where they type items and let formulas calculate the totals, or a reusable template they save as .xltx and copy for each transaction. All three approaches share the same file structure. The header rows hold fixed information such as the merchant name, address, payment date, and a unique receipt number so each receipt can be told apart from the next. A small table beneath the header holds one row per purchased item, with columns for description, quantity, and unit price, plus a formula column that multiplies those two values into a line total. Below the items, separate rows hold the subtotal sum, a flat discount entered as a positive number that is then subtracted, a tax row that applies a percentage to the discounted subtotal, an optional tip row, and a final total that adds tax and tip on top of the discounted subtotal. A tendered-amount row and a change row finish the document. Everything between the header and the totals is formulas, not hard-coded numbers, so changing a quantity or a price updates the rest of the receipt automatically.
Build a Basic Receipt in Excel Step by Step
Open a blank workbook and put the merchant name in cell B1, the address in B2, and the word "Receipt" in B4 with a larger font. In cells A6 and B6 type "Date" and the actual payment date; in A7 and B7 type "Receipt #" and a number you will increment each time. Label cell A9 "Item", B9 "Qty", C9 "Unit Price", and D9 "Line Total", then in D10 type =B10*C10 and copy that formula down for as many items as you expect to sell. In row 20 label A20 "Subtotal" and in D20 type =SUM(D10:D19). Label A21 "Discount" and put a positive number such as 3 in B21; in D21 type =-B21 so it subtracts from the subtotal. Label A22 "Discounted subtotal" and in D22 type =D20+D21. Label A23 "Tax %" and enter 8 in B23, then label A24 "Tax" and in D24 type =ROUND(D22*B23/100,2); the ROUND is the step that prevents the long decimal tails. Label A25 "Tip" and put a flat tip such as 4 in B25; in D25 type =B25. Label A26 "Total" and in D26 type =D22+D24+D25. Finally, label A28 "Tendered" with a value in B28 and A29 "Change" with =B28-D26 in B29. Format the price columns as currency, widen the columns so descriptions fit, add borders if you want a printed look, and save the file as a template (.xltx) so you can copy it for each transaction instead of rebuilding it.
Where the Excel Method Starts to Break Down
The biggest issue is arithmetic precision. Excel stores most decimal values in binary floating-point representation, so the formula =0.10+0.20 returns 0.30000000000000004, and a column of unit prices like 1.10, 2.20, and 3.30 can sum to 6.600000000000001 unless every step is wrapped in ROUND(...,2). If you forget to round even one cell, the printed receipt will show a stray digit that no real merchant would ever produce. The next issue is layout maintenance. Every time the number of line items changes, the SUM range has to be edited, the print area has to be re-set, and the visual look of the receipt shifts because row heights change. After ten or twenty saved copies, it is hard to remember which file corresponds to which transaction, and a column accidentally typed over (a unit price replaced with a label like "TBD") silently breaks the totals. Excel also has no native concept of a "paid receipt." A workbook will happily print a receipt that says "Total: $31.00, Tendered: $0.00, Change: $0.00" with no warning, which is fine for an estimate and wrong for a receipt. If you want any of those safeguards, exact decimal math, a fixed layout that does not drift, and a guard that refuses to print when the customer has not paid enough, you have to build them yourself or switch tools.
Create the Same Receipt With Receipt Maker
The browser tool Receipt Maker encodes the same Excel layout, but every fragile part of it is handled for you. Each unit price is stored as an integer count of minor units, so 0.10 becomes 10 and 0.20 becomes 20 and the two add up to exactly 30 instead of 30 followed by fourteen stray digits. Each line total is the rounded product of a validated quantity (up to three decimal places) and an integer unit price (up to two decimal places), the flat discount is enforced to be no larger than the subtotal, and the percentage tax is rounded only after it has been applied to the discounted subtotal. If the entered tendered amount is less than the calculated total, the tool refuses to produce a paid receipt; when it equals the total, change is zero; when it is higher, the difference is displayed as change. The tool accepts up to 100 line items per receipt and reports totals that exceed its supported amount range instead of silently writing garbage. Everything is calculated, previewed, printed, and saved inside the current browser; the merchant name, line items, prices, notes, and payment figures do not leave the device. To use it, follow the steps below.
- Enter the merchant name, payment date, receipt number, and select the display currency in the top fields of the tool.
- Add each purchased item as a separate line: a description, a quantity of up to three decimals, and a unit price of up to two decimals. The tool multiplies them into a line total using integer minor units.
- Enter any flat discount, the percentage tax that applies to your transaction, a flat tip, and the amount the customer actually tendered.
- Confirm that the calculated total is less than or equal to the tendered amount. If it is, the difference appears as change and only then is a paid-receipt preview produced.
- Inspect every line item, subtotal, discount, tax, tip, total, tendered, and change value in the preview before printing or downloading.
- Use Print receipt to open the browser's print dialog (window.print, per the MDN Window print reference) for a paper printout or system-provided PDF, or use Download HTML to save a standalone file you can reopen in any browser later.
- Make a fresh receipt after every edit and compare it with the original payment evidence before handing it to anyone else, because changing any field clears the last generated result.
A concrete example keeps the order of operations clear. Two items at $4.50 times 3 = $13.50 and $7.25 times 2 = $14.50 give a subtotal of $28.00 (13.50 + 14.50). A $3.00 flat discount drops the discounted subtotal to $25.00 (28.00 minus 3.00). Tax at 8% applied to that discounted subtotal equals $2.00 (25.00 times 0.08), and a $4.00 tip brings the total to $31.00 (25.00 + 2.00 + 4.00). A $40.00 tendered amount yields $9.00 of change (40.00 minus 31.00). Those are the same numbers the tool would print, and the arithmetic is the same arithmetic Excel would print if every cell is wrapped in ROUND(...,2).
Receipt vs Invoice: Which Document Do You Need?
A receipt is a record of money that has already changed hands. An invoice is a request for money that has not. They look superficially similar; both list items, totals, and tax; but they answer different questions, and confusing them causes real problems. If you give a customer an invoice after they have already paid, the document implies they still owe you money. If you give a customer a receipt before any money has been exchanged, the document implies a payment that did not occur. Receipt Maker is intentionally built for the first case: it refuses to generate a paid receipt when the entered paid amount is below the calculated total. If what you actually need is a document that asks a customer to pay by a certain date, with a balance due and no "change" line, use Invoice Generator instead. If a customer has made a partial payment and you need to track the rest, neither tool is the right fit; you need bookkeeping software that supports payment allocation and keeps an audit trail.
Receipt Fields to Capture
A useful receipt is short and consistent. The table below lists the fields a standard paid receipt should contain and where each value comes from in a typical transaction. These are the same fields Receipt Maker collects and prints, and they map cleanly onto the Excel layout described above.
| Field | What it records | Where it comes from |
|---|---|---|
| Merchant name | Who received the payment | Your business name on file |
| Payment date | When the money changed hands | The actual transaction date |
| Receipt number | A unique reference for this transaction | An incremented counter in your records |
| Line items | What was bought, in what quantity, at what unit price | Each purchased product or service |
| Subtotal | Sum of validated line amounts | Calculated from the line items |
| Discount | A flat amount subtracted from the subtotal | Your promotion or manual adjustment |
| Tax | A percentage applied to the discounted subtotal | The rate that applies to your transaction |
| Tip | A flat amount added after tax | The customer's choice |
| Total | Discounted subtotal plus tax plus tip | Calculated |
| Tendered | The amount the customer actually paid | Cash handed over or card charged |
| Change | Tendered minus total, when tendered is higher | Calculated, or zero when amounts match |
Two reminders belong with this list. First, tax treatment varies by location and by what is being sold, and no general-purpose tool contains every jurisdiction's tax table, exemption list, or rounding mandate. Confirm the rate and the calculation order before you treat the tax line as authoritative. Second, a downloaded or printed page can be edited in any text editor or browser, so it is not a tamper-evident record. For audits, warranties, insurance reimbursements, or any regulated recordkeeping, keep the payment processor's email, the cash register journal, the bank statement line, or the signed agreement as your source of truth.