6 min read

How to Make a Receipt in Excel

A step-by-step guide to building a reusable receipt in Microsoft Excel, using formulas to total items and tax automatically, with tips for turning it into a template.

How do I make a receipt in Excel?: Receipt Caker skips the formula-building entirely and totals everything for you, but if you prefer Microsoft Excel, add a header with your business details, receipt number, and date, then build an item table with description, quantity, unit price, and line total columns. Use a formula like =B8*C8 for each line total, SUM for the subtotal, and a rate multiplication for tax before exporting to PDF.

Lay out the header

Open a blank Microsoft Excel workbook and reserve the top few rows for the header. Put your business name in a large, bold cell, then your address and a contact detail beneath it. To the right, add two labelled cells: one for a unique receipt number and one for the date, which you can type or set with a formula like =TODAY() while you are drafting.

Leaving the header in fixed cells means it stays put every time you reuse the file. Merge cells where you want a title to span the width, and keep a blank row between the header and the item table so the receipt does not look cramped when printed.

Build the item table with formulas

Create a header row for the items with four columns: Description, Quantity, Unit Price, and Line Total. Under it, leave several empty rows for line items. In the first Line Total cell, enter a formula that multiplies quantity by unit price — if quantity is in B8 and unit price in C8, type =B8*C8 — then drag the fill handle down so every row calculates itself.

Using a formula rather than typing totals by hand is the whole point of doing this in a spreadsheet: change a quantity and the line updates instantly, with no arithmetic mistakes. Format the price and total columns as currency so figures line up neatly and always show two decimal places.

Add subtotal, tax, and total

Below the item table, add three labelled rows. For the subtotal, use =SUM() across the Line Total cells, for example =SUM(D8:D20). For tax, multiply the subtotal cell by your rate as a decimal — if the subtotal is in D22 and the rate is 8.25%, enter =D22*0.0825. For the grand total, add the subtotal and tax cells, such as =D22+D23.

Because each figure references the ones above it, the receipt recalculates end to end whenever you edit an item. If you handle several tax rates, put the rate in its own labelled cell and reference it in the formula so you can change it in one place. Keep tax on its own visible line, since it should never be hidden inside item prices.

Format, save as a template, and export

Tidy the layout with cell borders around the item table, bold labels for the totals, and consistent currency formatting. Set the print area so the receipt fits a single page, and preview it to confirm nothing is clipped. When it looks right, save the file as an Excel template so opening it produces a fresh, blank receipt each time rather than overwriting the last one.

To send a receipt, export or print it to PDF so the customer receives a fixed, tidy document rather than an editable spreadsheet. Excel is capable but fiddly to maintain, and a stray edit can break a formula. If you would rather not manage that, Receipt Caker gives you the same itemized layout with automatic totals and a clean PDF or image export, no formulas required.

Steps at a glance

1Set up the header block. Add your business name, address, and contact in the top rows, then cells for the receipt number and date.
2Build the item table. Create columns for description, quantity, unit price, and line total across a header row.
3Add the line-total formula. In the line total column, multiply quantity by unit price, for example =B8*C8, and fill it down the rows.
4Total the subtotal, tax, and grand total. Use SUM for the subtotal, multiply it by your tax rate for the tax line, then add the two for the total.
5Format and save as a template. Apply currency formatting and borders, then save the file as an Excel template so each new receipt starts blank.

Frequently asked questions

What formula totals the items on an Excel receipt?

Use two formulas together. For each line, multiply quantity by unit price — for example =B8*C8 — and fill it down the item rows. For the subtotal, wrap those line totals in a SUM function, such as =SUM(D8:D20). Then compute tax by multiplying the subtotal by your rate as a decimal, and add the subtotal and tax for the grand total. Because each cell references the ones above, the whole receipt recalculates automatically as you edit items.

How do I stop the receipt formulas from breaking when I reuse the file?

Save the receipt as an Excel template rather than a normal workbook, so each new receipt opens as a fresh copy and your master formulas stay intact. Only type into the input cells — description, quantity, and unit price — and leave the formula cells alone. Locking or protecting the formula cells prevents accidental edits. Keeping the tax rate in a single labelled cell that your tax formula references also means you change it in one place, not many.

Should I send the customer the Excel file or a PDF?

Send a PDF, not the spreadsheet. Exporting or printing the receipt to PDF gives the customer a fixed document that looks the same on every device and cannot be accidentally altered, whereas an Excel file is editable and may not open cleanly for everyone. Keep the Excel version as your working master for calculations, and share only the exported PDF as the official receipt. This also protects your formulas and layout from unintended changes.

Is Excel the best tool for making receipts?

Excel works well if you already know it and want full control over layout and formulas, but it takes setup and a stray edit can break the math. For occasional or fast receipts, a dedicated generator is usually quicker because the fields, totals, and tax line are built in and cannot be miscalculated. Many people keep a spreadsheet for heavy customization and use a generator when they just need a clean receipt in a minute.

Keep exploring

How to Make a Receipt in Google Docs How to Make Receipts for Your Business