Basic Receipt Template in Excel

General Blue provides free receipt templates which you can use when dealing with various business transactions. All receipt sample templates featured are free to use, print, edit, or download.

This receipt template in Excel will record whatever transactions are made between you (as a seller) and your customers (as the buyer).

The template has sections for the receipt number, date of purchase, salesperson, payment method, company details, sold to (buyer), item description, quantity, price per item, total, subtotal, shipping and handling costs, tax rate, tax amount, and total purchase amount.

Our blank receipt in Excel has built-in formulas which automatically calculate the total amount for all goods or services sold. You may get this version and let the template handle all necessary calculations for you.

Instructions:

1. Fill out the receipt number, date of purchase, salesperson, and payment method. This is indicated at the top section of the receipt template. Here, you need to indicate the receipt number, date when the purchase was made, the person who handled the transaction, and the payment method used by the customer (e.g., cash, credit card, or others).

2. Enter your company information. Enter your name (or company name) and business address in this section. It includes the street address, city, state, zip code, and phone number.

3. Enter the sold-to information. Enter the billing address of the person or company whom you have sold the goods/services to. The sold-to information includes the customer's or client’s name (or company name), their address – city, state, zip code, and phone number.

4. List all the goods/services sold to your client under the item description column.

5. Indicate the quantity and price for each listed item.

6. Enter the tax rate (%).

7. Enter the shipping and handling costs (if applicable). The shipping costs will be automatically added to the total purchase amount along with the subtotal and tax amount ($).