Receipt · Excel · 3 types + log
Receipt template — totals, tax and balance calculated
Short answer. Pick the receipt you need: sales, rent or a simple payment receipt. Sales receipt: qty × price, discount, sales tax at your rate, change due or balance due (Sales receipt sheet).
We will ask you to confirm this address, then email you the recipient’s reply.
Start typing right in the document — no sign-up. It stays in this browser; save it to your free Layers account to keep it, open it on your phone and share it.
- Give or send the receipttype the date
Check your own case.
Issue the receipt when you receive the payment.
Lida, Layers template assistant
Tell me what you were paid for, and I will total it with tax.
Keep every receipt in the log — numbering stays tidy.
Deadlines
The rules, with the source
| What | Deadline | Source |
|---|---|---|
| Sales receipt | qty × price, discount, sales tax at your rate, change due or balance due | Sales receipt sheet |
| Rent receipt | rent period, rent + late fee + other charges, amount received, balance | Rent receipt sheet |
| Payment receipt | amount in figures and words, e.g. “… and 50/100 dollars” | Cash receipt sheet |
| Records | keep receipts and other supporting documents for your books | IRS Publication 583 |
The template does not decide whether a sale is taxable; enter your state and local sales tax rate. Some states have their own rules for rent receipts.
Step by step
What to do, in order
1
Pick the sheet
Sales receipt, rent receipt or payment receipt.
2
Your details
Business or your name, address, phone, email.
3
Number and date
Use the next number from the Receipt log.
4
Items or amounts
Totals, tax and balance calculate.
5
Sign
Received by and signature lines.
6
Send and log it
Send as PDF and add a line to the Receipt log.
Questions
Is the receipt template free?
Yes. Fill it in online and download Excel or PDF without signing up.
Does it calculate sales tax?
Yes, at the rate you enter. It does not decide which rate applies.
Can I use it as a rent receipt?
Yes — the Rent receipt sheet has the rent period, charges, amount received, payment method and remaining balance.
Does it write the amount in words?
Yes, on the payment receipt: “One Thousand Two Hundred Thirty-Four and 50/100 dollars”.
How do I number receipts?
Use the Receipt log sheet: one line per receipt keeps numbers in order and totals the amounts.
Can I send the receipt to the customer?
Send it from Layers with tracking: you see when it was opened and for how long, and you can set a reminder to follow up.
Official sources
Other documents
Keep the papers in one place
Letters, receipts and notices in one folder you can share with family or a lawyer. The templates and the editor are free; Layers is free for up to 20 people.
A recordkeeping template, not tax or legal advice. Sales tax and receipt rules vary by state.