Sales Receipt Template
Need a simple yet professional software solution for creating Sales Receipts? If so then try our free Sales Receipt Template for Excel. You can customize this template to meet requirements of your business to match your corporate style. In general this template is very much like our sales invoice and can replace it in place where sales invoice would not need to be presented. For instance, if you are receiving instant payment for the goods that you've sold, then there will be no need for a sales invoice which could be replaced with a simple sales receipt. This spreadsheet is designed in a way that allows to print a simple detachable sales receipt slip to keep for your own records, if you prefer not to print an extra copy.
We have designed our sales receipt from scratch, which lets to use it with nearly every major spreadsheet software with ability to open or import excel files. This spreadsheet is great for a business which involves direct sale of a product, but if you need a different type of receipt, we have also created a rent receipt template.
Printable Sales Receipt Form
If you do not have Microsoft Excel or any similar software installed on your computer, than you may want to try this printable sales receipt worksheets PDF to help when you need to provide your customers with a simple hand-written receipt. Unfortunately this version isn't customizable and it won't perform automatic calculations like the above one, but you could still use it as a simple receipt pad.
Free Sales Receiptfor Excel® & OpenOffice
The sales receipt spreadsheet contains 2 worksheets with almost similar templates, but there is also few major differences. First template contains a sales receipt slip, which is detachable and meant for keeping as a reference for the seller, when the second template contains 2 identical receipts, so that when you fill up the customers part, all information entered will also be transferred to the copy that you keep for your records. Both templates are designed for printing on the standard A4 format.
Customize the spreadsheet for your business, add your business address at the bottom of the sales receipt form and your company name at the top. You would not need to update anything on the sales receipt slip, since all information will get updated automatically, each time you use it for a new customer.
Save your customized for as a template file (.xlt) or standard Excel spreadsheet. Tip: Saving as a template file will prevent auto-saving, which means that you always start from new receipt form and won't have to delete previously entered customer data.
After completing the sales receipt, print a copy for your customer and save a copy for your records. If you prefer to provide your customer with a digital copy of the receipt instead of printing it, the suggested method is to convert it to a PDF file first (may require an additional add-on or a software installed) and send it via e-mail.
by Alex Bejanishvili of Spreadsheet123.com
Sales Receipt ProProfessional Version SR1.05
The professional version of the Sales Receipt contains 2 worksheets with 2 different template on each. First template is very much like our free version of a Sales Receipt which is unlocked, when the second is slightly different.
We have placed all of Spreadsheet123 trademarks, logos, links and copyright notices outside the printing area, so that it won't be visible when printed.
Specifications of the Commercial Version
- Unlocked - so that you can customize it just a little more.
- Contains Fields for: Logo & Company info
- Ability to insert more rows
- Technical Support (for 90 days)
- 3 Bonus Spreadsheet Included
Microsoft Excel® 2002(XP) or Higher
(PC & Mac)
Company Use EULA
Bonus #1: Sales Receipt with Products List
Modified version that includes a list of products (Price List) with catalogue number and unit price. You can create a list to include all products that you sell, then, when it comes to creating a sales receipt for a customer, you'll only need to select products from drop down menu in the Description column and add a quantity in the next. Yes it is that simple.
Buy unlocked version of Sales Receipt Template risk free with 90 day full money-back guaranty!
Configure your browser to allow pop-ups before proceeding to payments screen.
If for any reason you are not able to download this template after making a payment through PayPal, use our Contact Us form to contact us with your Paypal Transaction ID.
Using our Sales Receipt Template
Customizing template to your business.
Values within [brackets] are meant to be replaced with your company (the Seller) or customer (the Buyer) information.
Company Address and Contact Information is located at the bottom of the receipt right above the perforated line, which must be replaced with information of your company.
The Sales Receipt Slip: is a part of the worksheet that updates automatically and doesn't really require any customization, but if you want, you can customize it to include some additional information.
To indicate the method of payment, you would need to enter "x" in the box beside the relevant method, so that when the customer paid with a credit card, cheque or money order the relevant box beside the method is crossed off and the payment reference number is recorded in-to the cell that appears on the right side. If cash is selected as a method there will be no need for a reference. This feature allows to keep a records of the payment methods used for making a payment.
Things that are important to know when using this sales receipt: field "Date" contains formula =TODAY(), which will always display current date every time you open this template so that if you need to enter any other date, simply delete this formula by typing over it.
Remember to enter a new Receipt Number for every new receipt that you create. You can refer to our Small Business Invoicing article, where we've shared few general ideas about how to keep track of receipts.
The amount which appears in "Total" is also converted in to the word-written format that appears at the bottom of the sales receipt form, which also contains the payment method and the payment reference, all in word-written form. Here we would like to show our appreciation to Dr. Jon Wittwer, who has introduced the approach to converting dollar amount to words.