When you enter all the items in the Excel receipt template, the sum will be appearing at the bottom of the Invoice.īesides the totals, you can enter the Additional notes after the table of items, on the left side. Here, you only need to enter Quantity which you sold to the customer and after the others like Base amount, Tax amount and Total will be calculated according to the fields that you input with the amount.Īt the very bottom, enter the Discount you would like to apply and it will be included in Total calculation. Once you choose the product from the drop-down, all other information in the table will come up automatically (Product ID, Unit of measure, Price per unit and Tax rate). In the main part of the Excel receipt template – in the table below, you can choose a Product Description from a drop-down list, which comes from the Product database. Also, in the related cells, you can enter the Receipt number and Payment date. Finally, on the right, you can choose a customer from a drop-down list, which you already maintain in the Customer database of Excel receipt template.Īfter you choose a customer, all other information about the customer will automatically populate from the database. Because your own company information is rarely changed and will be the same for every invoice. Name, Address and Phone number fields next to the logo, are the sections in which you can enter your company data manually. Here, you will enter all the data you need in the invoice. The invoice page is the main page of the template. It will be a time saver in every process of your company! Receipt Template Featuresīy using the navigation buttons at the top of the template, you can easily navigate between these pages. The solution has a great advantage by populating and calculating most of the data related to your business. Receipt Invoice Template allows you to create an invoice quickly and efficiently in Excel with a few clicks.

On the vendor side, you should prepare a receipt for the delivered product/service. A receipt is a non-negotiable document that proves the sale of a product or service for both parties.

Receipt tracker template excel