Become more organised and environment friendly with paperless Sales Receipts!
Typically, sellers issue a Sales Receipt to their customers at the time of payment which also serves as proof of transaction from the Point-of-sale. This is also one of the most important commercial document that is crucial for tax preparation, requesting reimbursements and also for avoiding any dispute at the time of refunds or returns. For growing businesses, creating Sales receipt on papers is a time consuming task hence Spreadsheet123's has created a Sales Receipt template to make it easier for you to record and manage your receipts.
At the time of sale, you can quickly record the product information, quantity and price along with the payment details. This template can be used by any business that has either just started or have low to medium volume of sales transactions. This template is really a good substitute to an expensive billing software.
Sales Receiptfor Excel® 2003+
How to use sales receipt template
Begin by downloading the template and setting up your company by providing basic details like Company Name, Company Slogan, Company Address. This template provides a provision to select the default currency by selecting a country currency symbol from the drop down menu under the country specific settings. Here you can also set the relevant tax type. It also has a inbuilt design picker, where you can choose a colour that is most appropriate for your company. And if this is not enough you can also use Excel's Themes or colours that can be found in the Page Layout ribbon of Excel 2007 and above.
Once the settings are specified, go to the second sheet named "Sales Receipt" and specify the details of customer who has bought your services or products. After this record the information of the products along with required details like code, quantity and price. In case you are providing some discounts to your customer then you can simply specify discounts at the end of product specification along with details of payment mode and its details.
This template has "Sales Receipt Slip" section at the bottom of "Sales Receipt" that can handed over to customer as a proof of transaction with the name of person or company who received the payment.
There is third sheet in this template that has Printable Sales Receipt in which Sales Receipt details can be recorded in double format. You can print this to give one copy to customer and keep another for your own records.
Sales Receipt with Price List
Modified version of the Sales Receipt, that is featuring same template as the one above except that this one comes with in-built Price List, which allows to create and maintain a list of products that can later be entered on any of the sales receipts directly from the drop-down list of products in the Description area instead of typing in the description of each product while writing your receipts. Product Code fields and Price fields are populated automatically once product is selected. This particular version helps to save a lot of time for you and your customers.
What is Subtotal and Sales Receipt Total? Subtotal is the sum of Amount Column which is total value of purchase done by customer and Sales Receipt Total takes into account the Discount and adds the sales tax to the Subtotal amount.
Just remember not to delete formulas that column Line Amount contains as well as formula from sub-column Sub Total, Sales Tax, Sub Total that contain currency symbols. Once you become more familiar with the template you can simply protect these columns from unnecessary changes using Excel's Protect Sheet option. For recording more products on your list, you can simply insert rows in between, as per your requirement.
We recommend you to send a PDF version of your invoice instead of excel file. You can use PDF converter or printer to create a PDF file for Microsoft Excel 2010 and earlier or use built in PDF converter of Excel 2013. Alternatively you can also print it and send it by mail service or FAX.
Function used in template
- SUM(number1, [number2], [number3], [number4], ...)
- IF(logical_test, [value_if_true], [value_if_false])