Invoice excel template free download

broken image

Add on any Sales Tax to the Subtotal, and enter the result into the TOTAL cell. Sum both the Total Products and Total Labor cells and enter the value into the Subtotal cell. Sum the Amount column and enter the result into the Total Labor cell. Similar to above, enter the following in the “Labor” table: Sum the Amount column and enter the result into the Total Products field. Phone number (the client’s mobile or home phone)īegin entering the parts that were purchased for the repair, starting with the Quantity (number of parts), a brief Description or serial number, the Unit Price of a single part, and the total Amount of each type of part (Quantity X Unit Price).Street address (leave blank if not necessary).Due date (write “upon receipt” if the client has to pay immediately).

broken image

Enter the information as shown (as applicable): Company website – if the repair shop has a website, write it’s URL here.City, state, and ZIP – continued from the street address above.Street address – this is the address that vehicles are repaired at.Email address – the company (or mechanic’s) email address.Fax number – leave blank if there is none.Phone number – can be a mobile or landline.If a field doesn’t apply, leave it blank. The top of the invoice is for listing the mechanic or repair shop’s contact info.

broken image