---
title: "Free Receipt Template (Excel): Payment Received | MCC"
description: "A free payment receipt template for Excel and Google Sheets. Line items, sales tax, amount paid, balance due and how they paid. No sign-up."
url: "https://mcc-solutionsnj.com/bookkeeping/templates/receipt-template"
---

Free template

# Free receipt template for Excel

Give the customer proof of payment and keep a copy for your books. The total and the balance due work themselves out.

[![Intuit ProAdvisor Gold tier badge](/img/credentials/intuit-proadvisor-gold.png)](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)Gold tier in Intuit's ProAdvisor program. [See my Intuit listing](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)

Keeping your own books? Tallyfinch does invoices, bank import and reports on your computer. [See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software)

[Download the Excel file](/downloads/templates/receipt-template.xlsx)Free. No sign-up. Excel file (.xlsx), 8 KB. Works in Google Sheets too.

## What is inside

- **Your details and the customer's** Business name, address and contact, and the received-from block.
- **Receipt number, date and payment method** Pick cash, check, card, bank transfer or other from the list.
- **Ten line items** Description, quantity and price; each amount calculates.
- **Totals** Subtotal, discount, sales tax, total, amount paid and the balance still due.

## How to use it

- Fill in your business details once and save a copy as your master.
- Give each receipt the next number and the payment date.
- Enter what the customer paid for and the amount they paid.
- Print or save as a PDF for the customer, and keep a copy with your records.

## Using it in Google Sheets

- Open Google Sheets and choose File, then Import, then Upload, and pick the downloaded file.
- Choose "Replace spreadsheet" or "Insert new sheet(s)".
- Check the formulas and the dropdown lists after the import. Most carry over, but Google Sheets handles a few functions and formats differently.

## Things to watch

- **Number receipts in order.** A numbered set makes it easy to match receipts to bank deposits and spot one that is missing.
- **Cash needs the most care.** A receipt for every cash payment, with a copy kept, is the record that shows what came in.
- **Record the income in your books too.** The receipt is proof for the customer. Your books still need the sale entered once.
- **Keep copies.** Keep your copies with the month's records. Ask your CPA how long to keep them.

## Questions

**What should a receipt show?**

Your business name and contact, the date, a receipt number, who paid, what they paid for, the amount, how they paid and any balance still due.

**Is a receipt the same as an invoice?**

No. An invoice asks for payment. A receipt confirms a payment was received.

**Can I use it in Google Sheets?**

Yes. Upload the file to Google Sheets and check the formulas and the payment method list after the import.

**Do I need to charge sales tax?**

It depends on what you sell. Check with the NJ Division of Taxation or your CPA, and set the rate on the receipt only if the sale is taxable.

Want a fuller version with worked examples? See [Freelancer Income Tracker](/toolkits/freelancer-income-tracker) in the store. This free template stays free either way.

Want more than a template? See [Freelancer Income Tracker](/toolkits/freelancer-income-tracker).

Want every toolkit? The [toolkit membership](/membership) includes all of them, with a lower rate if you pay yearly.

Related: [Free invoice template](/bookkeeping/templates/invoice-template), [Free income and expense tracker](/bookkeeping/templates/income-and-expense-tracker), [Free invoice generator](/bookkeeping/free-invoice-generator), [Bookkeeping health check](/bookkeeping/health-check), or [all free templates](/bookkeeping/templates).

These templates track your own numbers. They are not tax, legal or accounting advice, and MCC Solutions is not a CPA firm. Ask your CPA how rules apply to you.

Tallyfinch

### Books you keep on your own computer

Tallyfinch does invoices, bills, bank import, reconciliation and the main reports, in a file you own. $99 once, then $5 a month for updates; the app keeps working if you stop the plan. It does not do payroll or sales tax filing. The free download records up to 60 entries.

[See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software) [Download it free](/tools/pro/trial/mccBooks) [Compare the three apps](/software)

## Want the books handled for you?

[See bookkeeping](/bookkeeping/)[Call (908) 444-6373](tel:+19084446373)