Browse » Home
Monday, August 13, 2012
How to Create Free Receipts
1. Open a Microsoft Excel spreadsheet. Select 'New'. Select a free sales receipt template from the list of available spreadsheet templates.
2. Fill in or delete the specified fields for company information, such as company name, address, company logo, and receipt number.
3. Enter in the sales information for each item, which includes quantity, item number, item description, and the unit price.
4. Enter a value in the discount cell if a discount applies and the discount is a flat number. If the discount is in the form or a percentage off, then enter '=xy*z' in the cell where x = the column letter of the item, y = the row number of the item, and z = the percentage off in the form of a decimal (e.g. 20 percent is 0.20).
5. Enter the sales tax in decimal form (e.g. 8 percent is 0.08) into the sales tax cell on the sales receipt.