skip to Main Content

Receipt Template

4.67 (3 reviews)

Receipt Excel Template has been formed for the companies who would like to automate documentation process easily and quickly!

Learn more about License Types

Someka refunds icon


Someka one time payment icon


Someka direct download icon



A receipt is a non-negotiable document that proves the sale of a product or service for both parties. As a vendor side, you should prepare a receipt for the delivered product/service. Receipt Invoice Template allows you to create an invoice quickly and efficiently with several clicks.

The solution has a great advantage by populating and calculating most of the data related to your business.  It will be a time saver in every process of your company!

Receipt Template Features

The basic structure of the template is:Receipt-Invoice-Template-S01-1

By using the navigation buttons at the top of the template, you can easily navigate between these pages.


The invoice page is the main page of the template. Here, you will enter all the data you need in the invoice.

Name, Address and Phone number fields next to the logo, are the sections in which you can enter your company data manually. Because your own company information is rarely changed and will be the same for every invoice. Finally, on the right, you can choose a customer from a drop-down list, which you already maintain in the Customer database.



After you choose a customer, all other information about the customer will automatically populate from the database. Also, in the related cells, you can enter the Receipt number and Payment date.

In the main part of the receipt template – in the table below, you can choose a Product Description from a drop-down list, which comes from the Product database. Once you choose the product from the drop-down, all other information in the table will come up automatically (Product ID, Unit of measure, Price per unit and Tax rate).


Here, you only need to enter Quantity which you sold to the customer and after the others like Base amount, Tax amount and Total will be calculated according to the fields that you input with the amount.

At the very bottom, enter the Discount you would like to apply and it will be included in Total calculation. When you enter all the items in the receipt template, the sum will be appearing at the bottom of the Invoice.


Besides the totals, you can enter the Additional notes after the table of items, on the left side.


In the Customer database, you can maintain all customer information, enter the new customer or delete the ones that are not valid anymore. This information will be revealed in the receipt once the customer name is chosen.



Similarly to the Customer Database section, you can maintain all the products that your company has in product database. Again your products will show up in the Invoice once you choose the Product Description (in the Invoice Tab) from the dropdown button.


Receipt Template Features Summary:

  • Easy to fill Receipt Excel Template
  • Product and Customer Database Sections
  • Calculations for Discount, Tax Rate
  • Full Print Ready
  • Informational notes included
  • Informational notes included
  • No installation needed, ready-to-use
  • Works both on Mac and Windows
  • Compatible with Excel 2010 and later versions
  • Does not include any VBA code or macros

Receipt Template is a ready-to-use Excel Template and provided as-is. If you need customization on your reports or need more complex templates, please refer to our custom services.


Watch the video below to see the template in action! Presentantation also includes usage notes, explanations and tips & tricks about the template.



3 reviews for Receipt Template

  1. robert zapata

    I liked this template. We would need you help to develop an excel sheet to make an purchasing requestion as well as a check list for the same, I would also need the data to be in a spreadsheet for us to review. Can we add a checklist to this template?

    • Someka

      Hi Robert,

      Thanks for your interest!

      It is possible to add a checklist to the template for tracking. Once you download the modifiable version of the template, you can add a new sheet for a checklist. But, you might use this for your personal information. If you would like to integrate this checklist with the receipt template itself, you should seek help from a developer. You can visit this page: Hire an Excel Expert. By the way, we recommend a customization process assuming that you do not have advanced knowledge of Excel. Otherwise, please feel free to modify or edit the template by yourself.

      Best wishes,

  2. kh


  3. Özgür

    This is a very useful invoice template for me. Easy to use and nice design. Also free 🙂

Leave a customer review

Only verified users who have downloaded and used the template may leave a review.