Invoice is a document issued by a seller to the buyer for a transaction. It consists of details of services or goods supplied along with rates of services provided or per unit price of goods. An Invoice is issued to the receiver of goods or services for payment, and the record is maintained in accounts receivable ledger.
Excel helps us to create/design a tailored invoice template. A customized template for billing and Invoicing can be downloaded for Microsoft Excel here.
Understanding The Template
Row 1 = Enter Company/Business Name. Cells A1 to H1 are merged cells.
Row 2 = Enter Company Address, Phone No., Fax, Email address and other relevant details. Cells A2 to H2 are merged cells.
Row 3 = Put Heading of template as Invoice or Bill.
Row 4 to Row 13 = Put details of customer like customer name, invoice #, date, customer id, due date of payment and shipping information if required. See table below for layout.
Due date of payment can be set according to the terms with customer. In this template it is set for 30 days from the date of invoice. Formula applied here is (=H5+30) Date + No. of days.
Row 14 = This row consist of sub headings for data input. For example see below:
Description, Quantity, Unit Price, Amount of Bill, and their respective are details to be put while entering data. Amount column = Quantity X price per units/hours of service rendered. Formula applied here is a =IF(F15=””, ROUND(1*G15,2),ROUND(F15*G15,2)).
Row 15 to Row 26: Left blank for data input.
Row 27 = In Cell F27 put Subtotal is calculated by adding all the values in Amount column. Formula applied here is =SUM(H15:H26).
Row 28 = In Cell F28 put TAX if applicable. Mention the tax percentage in cell G28.. Here it is 12.5 % or can be put as required. Formula applied here is =H27*G28.
Row 29 = In Cell F29 put Total, where Total = Subtotal Amount + Tax Amount. Formula applied here is =H27+H28.
Row 30 to Row 32 is set for initials/signatures of the Receiver and the Accountant.
If you have any queries or questions, share them in comments below and I will be more than happy to help you.