Typically the entrepreneurs or business owners are the long term customers who expect professional work and bring steady flow of money for other businesses as well. If you have recently started your business and are struggling to create invoices that looks professional to your business customers then Spreadsheet Computer Repair Invoice is an excellent way of creating professional invoices for your business clients. This template allows you records both service and parts on the invoice for your computer repair or electronics repair business.
In this template, we have provided two types of invoice templates, first that allows you to capture the lump-sum amount of your services and the second one allows you to capture the number of hours worked and the hourly rate agreed with the customers, which is especially useful when you have different technicians working on different tasks at different rates or when different services that you provide is charged at different rates.You can also bill your client for the parts replaced or installed. This template can be used by any business who have either just started or have low to medium volume of transactions, which presents a really good substitute to an expensiveinvoicing software. Whether you run your shop single-handedly or you have a team you can use this template to quickly create professional invoices.
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 set the relevant tax type and their percentages on parts and labour. 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.
Once the settings are specified, go to the second sheet named "Invoice A" and record the information of the computer or electronic, you are repairing. After this, you can create a list of jobs performed under the "Jobs Performed" Section along with the amount you want to charge. In case you are providing some discounts to your customer then you can simply add discounts in the last row in each section and enter the amount as a negative value. After this you can record the details of the parts replaced or installed along with their quantity and unit price and amount is computed automatically.
If you work for your clients on hourly basis then go to the third sheet named "Invoice B". Here you can mention the number of hours worked and the hourly rates agreed with client to calculate the labour charges.
You can use the "Comments" area to write any payment terms such as how many days your customers have to pay you and where and how they can pay etc.
What is Total Labour and Total Parts? Total Labour is the sum of the charges of all the jobs listed under the Jobs Performed section and Total Parts is the sum of amount of all the parts replaced or installed during repair.
Why there is more for labour and parts? Some countries/states have different methods for taxation of labour and physical goods, which means that sometimes labour can be taxed differently than parts. So to compensate, we have allowed separate tax inputs for separate sections, but if the tax is same for everything in your country or state then you can simply enter the same tax rate in both fields, this will not double up your tax calculations on the invoice.
What is the Invoice Total? Invoice Total is the sum of Total Labour, Total Parts and the sum of Sales tax which is calculated as per the Sales Tax Rates specified for labour and parts separately.
Just remember not to delete formulas that column Line Total contains as well as formula from sub-column Sub Total, Sales Tax, Total Part and Total Labour 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.
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.