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.
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.
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.
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.
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.
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.
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.
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.
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.
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
Download
Sample Cash Receipt Template
Download
Printable Hotel Receipt Template
Download
Donation Receipt Template
Download
Contractor Receipt Template
Download
Basic Daycare Receipt Template
Download
Restaurant Receipt Template
Download
Invoice Receipt Template
Download
Download
Sample School Receipt Template
Download
Tax Receipt Template
Download
Salary Receipt Template
Download
Deposit Receipt Template
Download
Simple Order Receipt Template
Download
Modern Service Receipt Template
Download
Freelance Receipt of Payment
Download
Education Receipt Template
Download
Editable Spa Receipt Template
Download
More in Blog
| How to Make/Create a Mind Map in Microsoft Word [Templates + Examples] 2023 | How to Make/Create a Schedule in Microsoft Word [Templates + Examples] 2023 |
| How To Create/Build a Checklist in Google Docs | How to Make a Snapchat Geofilter on Photoshop |
| How to Make/Create a Family Tree in Google Docs [Templates + Examples] 2023 | How to Make a Checklist in Excel |
| How to Make a Family Tree in Excel | How to Create a Report in Excel |
| How to Make a Planner in Excel | How to Make/Create an Itinerary in Google Docs [Templates + Examples] 2023 |
| How to Make/Create a Cookbook in Microsoft Word [Templates + Examples] 2023 | How to Make/Create a Postcard in Illustrator [Templates + Examples] 2023 |
| How to Make an Invoice in Excel | How to Make/Create an Invoice in Microsoft Word [Templates + Examples] 2023 |
| How to Make a Cookbook Using Google Docs | How To Create/Build a Budget in Google Sheets |
| How To Make/Create a Billboard in Adobe Photoshop [Templates + Examples] 2023 | How to Make a Postcard in InDesign |
| How to Make/Create a Letterhead in Google Docs [Templates + Examples] 2023 | How to Make/Create a Postcard in Google Docs [Templates + Examples] 2023 |
| How To Make/Create an Invitation in Microsoft Word [Templates + Examples] 2023 | How To Make/Create a Postcard in Adobe Photoshop [Templates + Examples] 2023 |
| How to Make/Create a Postcard in Microsoft Word [Templates + Examples] 2023 | How to Make/Create a Rack Card in Microsoft Word [Templates + Examples] 2023 |
| How to Make/Create a Certificate in Microsoft Word [Templates + Examples] 2023 | How to Make/Create a Certificate in Google Docs [Templates + Examples] 2023 |
| How to Make/Create a Voucher in Microsoft Word [Templates + Examples] 2023 | How to Make/Create a Ticket in Microsoft Word [Templates + Examples] 2023 |
| How to Make/Create a Leaflet in Microsoft Word [Templates + Examples] 2023 | How to Create a Shared Calendar in Outlook |
| How to Create a Flowchart in Excel | How to Make/Create a Flowchart in Microsoft Word [Templates + Examples] 2023 |
| How to Make Address Labels in Word | How To Make/Create an Email Signature in Microsoft Outlook [Templates + Examples] 2023 |
| How to Make a Bar Graph in Excel | How To Make/Create a Fillable Form in Adobe PDF [Templates + Examples] 2023 |
| How To Make/Create a Pie Chart in Microsoft Excel [Templates + Examples] 2023 | How To Make/Create a Bar Chart in Microsoft Excel [Templates + Examples] 2023 |
| How to Make/Create a Resume in Microsoft Word [Templates + Examples] 2023 | How to Make a Timeline in Word |
| How To Make/Create a Survey in Google Forms [Templates + Examples] 2023 | How to Make a Fillable Form in Word |
| How To Make/Create a Timeline in Microsoft Excel [Templates + Examples] 2023 | How To Make/Create a Schedule in Microsoft Excel [Templates + Examples] 2023 |
| How to Make a Poster in PowerPoint | How To Create/Build a Resume in Google Docs |
| How To Make/Create a Timeline in Microsoft PowerPoint [Templates + Examples] 2023 | How to Make/Create a Calendar in Microsoft Word [Templates + Examples] 2023 |
| How To Make/Create a Calendar in Microsoft Excel [Templates + Examples] 2023 | How to Make/Create a Survey in Google Docs [Templates + Examples] 2023 |
| How to Make/Create a Form in Microsoft Word [Templates + Examples] 2023 | How to Create a Form in Excel |
| How to Make a Gantt Chart in Excel | How To Make/Create a List in Microsoft Excel [Templates + Examples] 2023 |
| How to Make a Chart in Excel | How to Make/Create a Budget in Microsoft Excel [Templates + Examples] 2023 |
| How to Make/Create Checklist in Microsoft Word [Templates + Examples] 2023 | How To Make/Create a Logo in Adobe Photoshop [Templates + Examples] 2023 |
| How To Create/Build a Chart in Google Docs | How to Make/Create a Label in Microsoft Word [Templates + Examples] 2023 |
| How to Make/Create a Chart in Microsoft Word [Templates + Examples] 2023 | How to Make/Create a Pamphlet in Google Docs [Templates + Examples] 2023 |
| How to Print Labels From Excel | How to Make/Create a Letterhead in Microsoft Word [Templates + Examples] 2023 |
| How to Make/Create a Brochure in Microsoft Word [Templates + Examples] 2023 | How to Make/Create a Pamphlet in Microsoft Word [Templates + Examples] 2023 |
| How to Make/Create a Business Card in Microsoft Word [Templates + Examples] 2023 | How to Make a Flyer in Microsoft Word |
| 50+ Roadmap Samples, Format & Examples 2023 | 50+ Mind Map Samples, Format & Examples 2023 |
| 50+ Family Tree Samples, Format & Examples 2023 | 50+ Email Signature Ideas & Examples 2023 |
| 50+ Media Kit Samples, Format & Examples 2023 | 50+ Receipt Samples, Format & Examples 2023 |
| 50+ Planner Samples, Format & Examples 2023 | 50+ Schedule Samples, Format & Examples 2023 |
| 50+ Quotation Samples, Format & Examples 2023 | 50+ Resume Samples, Format & Examples 2023 |
| 50+ Inventory Samples, Format & Examples 2023 | 50+ Itinerary Samples, Format & Examples 2023 |
| 50+ Email Signature Designs, Format & Examples 2023 | 50+ Analysis Samples, Format & Examples 2023 |
| 50+ Statement Samples, Format & Examples 2023 | 50+ Estimate Samples, Format & Examples 2023 |
| 50+ Memo Samples, Format & Examples 2023 | 50+ Policy Samples, Format & Examples 2023 |
| 50+ Invoice Samples, Format & Examples 2023 | 50+ Meeting Minutes Sample, Format & Examples 2023 |
| 50+ Notice Samples, Format & Examples 2023 | 50+ Budget Samples, Format & Examples 2023 |
| 50+ Checklist Samples, Format & Examples 2023 | 50+ Agreement Samples, Format & Examples 2023 |
| 50+ Catalog Ideas & Examples 2023 | 50+ Plan Samples, Format & Examples 2023 |
| 50+ Lesson Plan Samples, Format & Examples 2023 | 50+ Report Samples, Format & Examples 2023 |
| 50+ Magazine Ideas & Examples 2023 | 50+ Tumblr Banner Designs, Format & Examples 2023 |
| 50+ Pinterest Pin Designs, Format & Examples 2023 | 50+ Whatsapp Post Designs, Format & Examples |
