Free Excel Receipt Templates and Trackers

By Andy Marker | March 9, 2022

This article is a collection of the most useful free, online-fillable, downloadable, and printable receipt templates in Microsoft Excel format for a variety of uses. 

Included on this page, you’ll find a simple receipt template, a cash receipt template, and a payment receipt template. You can also download a petty cash receipt template and a rent receipt template, among others. In addition, you’ll find a list of helpful tips for completing these downloadable and fillable Excel receipt templates.

Simple Receipt Template

Download Simple Receipt Template – Microsoft Excel 

Use this basic receipt template to simplify your receipt-generating process for any product sold or service rendered. This all-inclusive receipt template allows you to enter receipt date and number, as well as provide descriptions and line-item totals for each receipt item. This template automatically provides a subtotal based on all item totals. You can add a tax rate, shipping and handling (if applicable), and any receipt-related remarks or instructions. 

Take a look at this collection of free business receipt templates resources to help ensure that you have a solution for all your receipt needs.

Sample Editable Receipt Template

Sample Editable Receipt Template

Download Sample Editable Receipt Template – Microsoft Excel 

As a small business, you need a reliable way to provide customers with receipts for their purchases. Use this receipt template with editable sample text to fill in all receipt-specific details, so you can give customers an official, detailed receipt. This template auto-calculates each line item and includes a tax rate to apply to the subtotal for a comprehensive payment receipt. With generous space for line-item descriptions, this receipt template is perfect for keeping receipt-by-receipt records of payment of products or services rendered, and providing customers with comprehensive receipts.

Use any of these free Excel invoice templates to ensure that you accurately account for every purchase.

Cash Receipt Template

Cash Receipt Template

Download Cash Receipt Template – Microsoft Excel 

Use an all-inclusive cash receipt template to provide a receipt to cash-paying customers. Enter payment-to, date, receipt number, and amount paid details for each cash payment. This template allows you to select whether a customer’s payment was made using cash, a money order, or a check; who the payment was received from; who it was received by; and a description of what the payment was for. This template also includes an Account Info section, in the event of a customer paying in installments, and allows you to enter the account balance, amount for current payment, and remaining balance due.

Payment Receipt Template

Payment Receipt Template

Download Payment Receipt Template – Microsoft Excel 

Use this versatile payment receipt template to standardize customer receipts for goods purchased or services rendered. With three receipts per page, this template serves as a receipt book, where you can keep a sequential and chronological list of issued receipts for your records. These receipts can be filled out online, downloaded, and printed to provide customers with a unique receipt number, date, subtotal, tax rate, and total amount for their purchases. 

For bill of sale resources, see this article on bill of sale templates.

Petty Cash Receipt Template

Petty Cash Receipt Template

Download Petty Cash Receipt Template – Microsoft Excel 

For the petty cash your small business keeps on hand for reimbursements, payments, or small purchases, you need an accurate way to track these one-off transactions. This petty cash receipt template helps you keep petty cash-related receipts. Using a receipt can help you maintain accurate and up-to-date records. Anyone you’ve paid (or has paid you) will also have an equally detailed document of the transaction. Enter date, receipt number, amount issued, and dispersed-to details. You can also include information relating to the purpose for the petty cash disbursement, who dispersed it, and who authorized the amount issued.

Customer Receipt Template

Customer Receipt Template

Download Customer Receipt Template – Microsoft Excel 

Use this detailed customer receipt template to document the costs of products sold to or services provided for your customers. Enter receipt date and number, salesperson, payment information, item number, description, quantity, and unit price. All line items’ totals are auto-calculated for a grand total, including tax rate and shipping/handling fees (if applicable). This template includes editable sample text to guide you through the customer receipt-making process.

Rent Receipt Template

Rent Receipt Template

Download Rent Receipt Template – Microsoft Excel 

For landlords, this easy-to-use rental receipt template is the perfect business tool. It provides your tenants with month-to-month rental receipts and ensures timely rental payments, as it serves as a contractual remittance for occupation of a residence. This template comes three to a page, and includes space for property owner, receipt number, payment method, received from, payment date, and amount paid. It also includes space for a property-location description, the rental period, and any additional information related to tenant- or payment-specific details.

Business Receipt Template

Business Receipt Template

Download Business Receipt Template – Microsoft Excel 

Keep your business running full steam ahead and provide customers with comprehensive receipts using this easy-to-fill business receipt template. Item-by-item fields allow you to enter a description of the product or service you provided to the customer, quantity, unit price, and item-line total. A total amount section includes auto-tallying, subtotal, discount, tax rate, shipping/handling, and any other factors before rendering the total amount. You’ll save time by generating business receipts with this easily fillable, reusable, and printable template that you can fill out online, or download and print and send to your customers for proof of purchase and for your own payment-received records. 

View this collection of purchase order-related payments and invoicing templates for more options.

Goods and Service Tax (GST) Receipt Voucher Template

GST Receipt Voucher Template

Download GST Receipt Voucher Template – Microsoft Excel 

Use this Goods and Services Tax receipt voucher template to provide customers with detailed GST-specific receipts for products or services you have provided. This template enables you to factor in GST destination-specific tax based on State Goods and Services Tax (SGST), Central Goods and Services Tax (CGST), and Integrated Goods and Services Tax (IGST) for correct intrastate and state-by-state sales of goods and services. This unique GST receipt voucher template includes comprehensive payment and tax-related details, as well as space for signatory name and signature.

Warehouse Receipt Template

Warehouse Receipt Template

Download Warehouse Receipt Template – Microsoft Excel 

Spend less time performing one-off inventory-related receipts and more time on what you do best: managing your warehouse’s inventory. Use this warehouse-specific receipt template for stock- and supply-related payments for accurate company, interdepartmental, and customer-facing receipts. Enter department, contact person, approved by (e.g., department head, budget approval), received by, date of order, date approved, and item total information for all-inclusive warehouse receipt-related invoicing and recordkeeping.

Receipt Organizer and Tracker Template

Receipt Organize and Tracker Template

Download Receipt Organizer and Tracker Template – Microsoft Excel

This receipt organizer and tracker template serves as a log for your receipts as a whole, so that you can itemize and accurately record all payments. Enter receipt dates, description, and monetary amounts to account for every receipt, and to order them in an easy-to-retrieve format. You can complete this fully customizable template online, or download and print it, as well as attach individual receipts for a complete, single-source, receipt-tracking record.

Daycare Receipt Template

Daycare Receipt Template

Download Daycare Receipt Template – Microsoft Excel 

Use this daycare receipt template to itemize the name of the child, date, drop-off time, pickup time, duration, rate per hour, and total amount for itemized monthly or annual daycare receipts. This template is simple to use and provides you with childcare provider information, as well as bill-to details for invoicing purposes. Upload the unique logo for your daycare center or childcare-providing service to personalize your proof-of-payment process.

Donation Receipt Template

Donation Receipt Template

Download Donation Receipt Template – Microsoft Excel 

With this unique, donation-specific receipt template, you can create accurate and timely receipts for all of your organization’s donors. Upload your organization’s logo, and enter your organization’s details, date, receipt number, and received-by details. A Donor Info section allows you to personalize the receipt, and then add a donation description, quantity, and total-value amount. Select the check box for whether the donation was an item or a cash, check, credit card, or money order transaction. This template includes a separate, detachable donor-details section to keep for your records.

Delivery Receipt Template

Delivery Receipt Template

Download Delivery Receipt Template – Microsoft Excel 

Created specifically with delivery components in mind, this easy-to-fill delivery receipt template provides everything you need to create delivery-specific receipts for your customers. Enter receipt date, receipt number, recipient info, delivery description, quantity, pieces/package, total packages, and the delivery-amount total for accurate, comprehensive delivery receipts. Detach the separate, partible Delivery Receipt stub and keep it for your own records.

Receipt Book Template

Receipt Book Template

Download Receipt Book Template – Microsoft Excel 

With this three-receipts-per-page receipt book template, you can reduce red tape by providing customers with fully descriptive, precise receipts for their purchases. Use this template to document date, receipt number, amount received, for payment of, received by, received from, payment method, and credit/debit card or check number. This all-inclusive receipt book template includes perforations at the bottom of each receipt, so you can separate them for individual customer payments. 

You can find additional receipt templates in Microsoft Word here.

Fillable Receipt Template

Fillable Receipt Template

Download Fillable Receipt Template – Microsoft Excel 

This completely editable and customizable template is the perfect match for creating receipts online or downloading for printing, emailing, mailing, or providing in-person receipts for purchases. You can specify goods or services purchased, quantity, unit price, and item totals, as well as provide a receipt date and number. Additionally, a Remarks/Instructions section enables you to personalize each receipt with details related to each customer’s unique purchase. 

You can find additional receipt templates in Adobe PDF here.

What Is an Excel Receipt?

An Excel receipt is a template that businesses can use to create customer sales receipts for products purchased or services rendered. Use an Excel receipt template to also record sale dates, item or service descriptions, tax rates, and total purchase amounts. 

Whether you’re a startup, an existing business, or a nonprofit, it’s critical to have an accurate method to record transactions, so that customers have a sufficient receipt for their purchase, and you have a record of the sale of the product or service provided. An Excel receipt template enables you to download, print, and record – or fill out online – a detailed receipt. You can use an Excel receipt template to keep records of each individual transaction in an easily ordered, standard manner. 

An Excel receipt template typically includes the following sections for recording customer transactions:  

  • Amount: This is the line-item total amount for each item purchased. 
  • Description: Provide a description of the purchased item. 
  • Payment Date: Add the purchase date.  
  • Payment Method: Add the payment method for the purchase (cash, credit card, check, money order, etc.). 
  • Quantity: Insert the quantity of purchased items. 
  • Receipt Number: This is the unique receipt number for the purchase. 
  • Received By: Write the name of the salesperson who conducted the customer’s sale. 
  • Recipient Info: Fill-in the name, address, phone number, and email address of the customer who made the purchase. 
  • Subtotal: This is the subtotal for the purchased items. 
  • Tax Rate: This is the tax rate for the purchase (e.g., state sales tax). 
  • Total: This is the total amount for all purchased items, including line-item totals, any discount(s), tax rate, and shipping/handling costs (if applicable). 
  • Unit Price: Add the unit price for the purchased item(s).

Easily Manage and Track Your Business Receipts with Smartsheet

Discover a better way to connect your people, processes, and tools with one simple, easy-to-use platform that empowers your team to get more done, faster.

With Smartsheet, you can align your team on strategic initiatives, improve collaboration efforts, and automate repetitive processes, giving you the ability to make better business decisions and boost effectiveness as you scale. 

When you wear a lot of hats, you need a tool that empowers you to get more done in less time. Smartsheet helps you achieve that. Try free for 30 days, today.

 

Connect your people, processes, and tools with one simple, easy-to-use platform.

Try Smartsheet for Free Get a Free Smartsheet Demo