How to Make a Receipt on Excel

Receipts are necessary documents for selling merchandise or services to clients. These pieces of paper are proof of financial transactions and serve as official documents. There are different receipt samples, including receipts of payment, store receipts, bank receipts, and rent receipts. It is advantageous to utilize online receipt templates as a reference if the company is looking at its creation. Microsoft Excel is an excellent application to help with receipts, providing necessary formulas for computation. The guide below teaches how to make a receipt on Excel with and without the use of templates.

how to make a receipt on excel

SUMMARY:

  • Using a template: Startup your Microsoft Excel and click on New. Type in “receipt” on the search bar to view the available templates. Click on the receipt template you want to use and select Create.
  • Without a template: Create a Blank Workbook. Ensure that the page layout follows the dimensions of your paper. Create a receipt with company details, receipt number, and other transaction information in tabular form. Input the correct formulas for computation and Save your receipt.

How to Make a Receipt Using Templates On Excel

Microsoft Excel provides its users with a variety of receipts available through Office. Read and understand the guide below to help you make a receipt by using available templates on Excel.

1. Launch the Microsoft Excel application and select New.

2. Search for “receipt” on the search bar to view the available receipt templates you can use.

3. Left-click on the template to select it and click Create to start editing its content.

Receipt

4. Replace all the model texts with the company’s information, including its name, address, and contact information. You can also replace the placeholder image by selecting the item and click the Replace Image button from the Format tab.

Receipt Book

5. Make sure to test your template if the formulas work well and Save your work.

Note: If you are looking for a particular template, you can start browsing online. Template.net provides a wide array of receipt templates on Microsoft Excel you can use and download for your company.

How To Make a Receipt on Excel Manually

In creating a receipt from scratch, be aware of the formulas for the cells for proper computation of accrued services or products of legal tender. The guide below is a step-by-step guide in creating your receipt. Read and follow the steps carefully.

1. Start your receipt by creating a Blank Workbook. Go to the View tab, then Page Layout, and ensure the receipt’s dimensions fit the paper.

2. Insert your business’ information, the word Receipt, receipt number, and transaction date. Ensure that the receipt number shows the zeros by going to the Home menu, changing the option to Text on the Number tab. Use the formula =NOW() for the date to get the live date and time.

Receipt Template

3. On the column headers, insert entries for Items, Units, Prices, Discounts, and Total. For the bottom, indicate the subtotal, tax, and total entries. Add borders and fill colors as you see fit.

Walmart Receipt

4. Start including formulas into the sheet. Select the Subtotal cell, go to the Formulas tab, and select the Autosum icon. Drag your cursor over all the cells in the Total column and press Enter.

Receipt Maker

5. To compute for the tax, select the Tax cell. Insert (=) sign to indicate the start of the formula and click on the Subtotal cell. Input the (*) sign, then insert the tax percentage as a decimal. Press Enter to complete your formula.

Receipt Scanner

6. For computing the Total price, select the Total cell and click the Autosum icon on the Home menu. Select the Subtotal and Tax cells, then press Enter.

Receipt for Rent

7. To compute for the discount, click on the first Total cell. Insert (=) sign, click on the first Unit cell. Then, indicate the (*) sign, selecting the Price cell. Afterward, insert the () sign and select the Discount cell, then press Enter. To duplicate the formula, copy and paste the initial formula to the empty cells.

Read Receipt

8. Finally, test your receipt by inputting entries into the cells for computation. Once everything is set, Save your work or Print it for distribution.

Medical Bill Receipt Layout

medical-bill-receipt-templatesDownload Now

Sample Cash Receipt Template

sample-cash-receipt-templatesDownload Now

Printable Hotel Receipt Template

hotel-receipt-templateDownload Now

Donation Receipt Template

donation-receipt-templatesDownload Now

Contractor Receipt Template

contractor-receipt-templateDownload Now

Basic Daycare Receipt Template

daycare-receipt-templateDownload Now

Restaurant Receipt Template

restaurant-receipt-templatesDownload Now

Invoice Receipt Template

invoice-receiptDownload Now

Receipt Format Template

receipt-format-templateDownload Now

Sample School Receipt Template

sample-school-receipt-templateDownload Now

Tax Receipt Template

tax-receipt-templateDownload Now

Salary Receipt Template

salary-receipt-templateDownload Now

Deposit Receipt Template

deposit-receipt-templateDownload Now

Simple Order Receipt Template

order-receipt-templateDownload Now

Modern Service Receipt Template

service-receipt-templateDownload Now

Freelance Receipt of Payment

freelance-receipt-of-payment-templateDownload Now

Education Receipt Template

education-receipt-templateDownload Now

Editable Spa Receipt Template

spa-receipt-templateDownload Now

Read related blog Articles

See All
How to Make a Flyer in Google Docs

How to Make a Flyer in Google Docs

In need of a simple, easy, and effective way to communicate with your customers? If so, then a flyer made…

Mar 07, 2022
How to Make/Create a Receipt in Microsoft Word [Templates + Examples] 2023

How to Make/Create a Receipt in Microsoft Word [Templates + Examples] 2023

Receipt templates are important documents used as proof of sale or to transfer ownership from one party to another. Business…

Sep 07, 2021
How to Make a Receipt on Excel

How to Make a Receipt on Excel

Receipts are necessary documents for selling merchandise or services to clients. These pieces of paper are proof of financial transactions…

Sep 06, 2021
How to Make/Create a Lesson Plan Template in Microsoft Word [Templates + Examples] 2023

How to Make/Create a Lesson Plan Template in Microsoft Word [Templates + Examples] 2023

A lesson plan as its name suggests is a detailed description of the lessons that a learning instructor aims to…

Sep 06, 2021
How to Make/Create a Mind Map in Microsoft Word [Templates + Examples] 2023

How to Make/Create a Mind Map in Microsoft Word [Templates + Examples] 2023

A mind map is a visual representation of interconnected ideas showing the relationship between each concept. Mind mapping is used…

Sep 03, 2021
How to Make/Create a Schedule in Microsoft Word [Templates + Examples] 2023

How to Make/Create a Schedule in Microsoft Word [Templates + Examples] 2023

Schedules are important tools for time management that can be used by individuals and organizations alike. This provides users with…

Sep 03, 2021
How to Make/Create a Family Tree in Google Docs [Templates + Examples] 2023

How to Make/Create a Family Tree in Google Docs [Templates + Examples] 2023

A family tree is a type of visual structure that shows the relationship between one individual to another. It is…

Sep 03, 2021
How to Make a Family Tree in Excel

How to Make a Family Tree in Excel

Most people would list family as one of their top priorities in life. Some take their heritage or genealogy seriously…

Sep 03, 2021
How to Make a Planner in Excel

How to Make a Planner in Excel

Planners enable people to prioritize and organize their days and routines. From weekly calendars, budget planners, to meal plans, it…

Sep 03, 2021