How do I download an Excel receipt template?

Select Download Excel Template on one of the previews. Open the XLSX file in Excel and save a working copy for this payment. Keep a blank original so you can reuse the layout without carrying over customer details.

Will the Excel template calculate every amount for me?

Check the formulas in the workbook you downloaded before relying on them. A calculated line amount should use that row's quantity and unit price. After adding items, review the subtotal, tax, discount, and payment figures together.

Should I subtract an earlier payment as a discount?

No. A discount reduces the charge; an earlier payment is money you already received. Record earlier payments separately from the price calculation. A later receipt confirms only the new payment.

What should I check after inserting another item row?

Make sure the new line amount uses the correct quantity and price, and that the subtotal includes it. Review the print area too, so the added item and the Notes appear in the finished receipt.

Can I use a formula for the current date?

Use a fixed payment date on the receipt. A formula that always returns today's date can change the record when you reopen it. The receipt date stays the date you received payment, even when you prepare or send the receipt later.

How do I send the Excel receipt as a PDF?

Review the print area and save or export the receipt as a PDF. Open it to check every item, the amount received, and the Notes. Send that copy to the customer and keep the XLSX for your records.

Are the Excel receipt downloads separate from Docelf?

Yes. The free XLSX downloads are separate files. The Create Receipt Online button starts a receipt in Docelf instead. A change in the workbook does not change a Docelf receipt.

Free Excel Receipt Template

Edit an Excel receipt without fixing formulas

Skip setting up formulas and formatting the receipt by hand in Excel. The online option calculates the totals and gives you and your customer a clear payment record.

Prefer to work in Excel? Use a free XLSX template below.

Create Receipt Online

14-day free trial. No credit card required.

Download a Free Excel Receipt Template

Choose a preview to download its XLSX file. Save a blank original, then work in a copy for the payment you received. Create Receipt Online opens Docelf rather than downloading a spreadsheet.

Looking for an hourly or itemized layout? See six more Excel receipt templates below.

How to Fill In an Excel Receipt

Open your working copy and replace the sample details. The picture shows the main receipt fields; their positions may differ in the Excel layout you downloaded.

For a payment on an existing Docelf invoice, you can record the payment and create a receipt in Docelf. Docelf reuses the customer and item details. For the Excel option, fill in your downloaded copy using the steps below.

Your Business: Enter your business name and contact details.
Your Logo: Add your logo without covering the receipt details.
The Customer: Replace the sample customer with the person or business that paid.
Number and Date: Use a new receipt number and the date you received payment.
Items and Prices: Enter each description, quantity, and unit price.
Totals and Payment: Check tax and formulas. Enter this payment and any balance.
Notes and Review: Note the payment method. Check the receipt and save your copy.

Check the Item Amounts, Tax, and Total Paid

The line amounts add up to the subtotal. Add any tax and check that the total paid matches the payment you received.

This fictional tool order uses US dollars. For illustration, an 8% tax applies to the whole subtotal, rounded to the nearest cent. The customer paid in full by card on September 18, 2026, so that is the receipt date.

QTY	Description	Unit Price	Amount
2	Claw hammers	$24.00	$48.00
4	Safety goggles	$8.50	$34.00
3	Measuring tapes	$12.00	$36.00

	Subtotal	$118.00
	Sales Tax (8% illustrative)	$9.44
	Total Paid	$127.44

The $118.00 subtotal plus $9.44 tax comes to $127.44. The card payment settles the sale. Use the tax treatment that applies to your sale.

Explain the Payment in Excel Receipt Notes

A short order reference helps you match the receipt to the sale. Use Notes to confirm the payment method and what the payment covers.

The Notes below confirm the tool-order payment. If your file has sample payment terms, replace them with a Notes heading and a short payment confirmation. Keep the note within the print area so it appears on the copy you send.

Example: Notes

Received $127.44 by card for order TOOL-418 on September 18, 2026.
Paid in full.

Create the Next Receipt Without Spreadsheet Setup

Docelf calculates the charges and keeps payment details with the receipt. Reuse saved items instead of copying another workbook. Email the finished receipt or download a PDF.

Create Receipt Online

More Excel Receipt Downloads

Use an hourly layout for time-based work or a roomier itemized layout for a longer sale. Each card downloads a separate Excel file.

Keep the Formulas Working as You Edit

A formula uses entries such as quantities and prices to calculate an amount. Update those entries rather than typing over the result. Before editing, check which cells in your copy contain formulas.

Include Every New Item Row

Insert a row within the item area and copy the neighboring row's formatting and formula where needed. Check that the new amount uses its own quantity and price. The subtotal should include the new row too.

Keep Payment Dates Fixed

Enter the actual payment date as a fixed date. A formula that shows today's date would change when you reopen the workbook, which would change the meaning of an old receipt.

Leave Room for Descriptions

Use readable fonts and a small color accent. Widen or wrap a description cell when the item name needs space, and keep your logo clear of the numbers. Review the page layout after inserting rows.

Print the Receipt, Not the Whole Workbook

Your working file may contain sheets or calculations that the customer doesn't need. In desktop Excel, select the receipt cells, then choose Page Layout, Print Area, and Set Print Area.

Use File, then Print to check the layout before printing or saving a PDF.

Include the business details, item rows, payment amount, and Notes.
Check that the right-hand amounts and the last row are visible.
Open the exported PDF and look for blank pages or cut-off text.

Keep the XLSX as your editable record and send the checked PDF. The receipt email guide can help with the short message that accompanies it.

Keep the Next Payment Easy to Find

Save each completed receipt under its own number, such as Receipt-2048-Customer.xlsx. Reuse a blank copy for the next payment so a later edit doesn't overwrite the record you already sent.

In Docelf, you record the payment and let the software calculate the remaining balance. You can also see delivery and opening history for receipts emailed from Docelf.

Prefer to keep that work online? The online receipt guide explains the alternative. Editing the downloaded workbook does not update a receipt in Docelf.

Choose the File Format You Work With

Stay with Excel for a workbook you can save yourself. Google Sheets offers a browser-based spreadsheet, while Word and Google Docs let you edit the receipt as a document.

The receipt format guide compares the file formats and online option.

Check the Payment Record Against a Sample

An itemized example helps with the charges; a finished sample helps you check the receipt as a whole.

Excel Receipt Template FAQs

How do I download an Excel receipt template?

Select Download Excel Template on one of the previews. Open the XLSX file in Excel and save a working copy for this payment. Keep a blank original so you can reuse the layout without carrying over customer details.
Will the Excel template calculate every amount for me?

Check the formulas in the workbook you downloaded before relying on them. A calculated line amount should use that row's quantity and unit price. After adding items, review the subtotal, tax, discount, and payment figures together.
Should I subtract an earlier payment as a discount?

No. A discount reduces the charge; an earlier payment is money you already received. Record earlier payments separately from the price calculation. A later receipt confirms only the new payment.
What should I check after inserting another item row?

Make sure the new line amount uses the correct quantity and price, and that the subtotal includes it. Review the print area too, so the added item and the Notes appear in the finished receipt.
Can I use a formula for the current date?

Use a fixed payment date on the receipt. A formula that always returns today's date can change the record when you reopen it. The receipt date stays the date you received payment, even when you prepare or send the receipt later.
How do I send the Excel receipt as a PDF?

Review the print area and save or export the receipt as a PDF. Open it to check every item, the amount received, and the Notes. Send that copy to the customer and keep the XLSX for your records.
Are the Excel receipt downloads separate from Docelf?

Yes. The free XLSX downloads are separate files. The Create Receipt Online button starts a receipt in Docelf instead. A change in the workbook does not change a Docelf receipt.

Keep the Payment and Receipt Together in Docelf

Record a payment and send its receipt in Docelf

Have another payment to record? Use Docelf for the next receipt and keep it with your other business documents.

Start from an invoice after recording its payment
Show the amount received and remaining balance
Email a receipt or save it as a PDF

Create Receipt Online

Free Excel Receipt Template

Download a Free Excel Receipt Template