How to Customize the Basic Invoice Template in Excel
Microsoft Office has basic free invoice templates that you can download for Excel from the Office website. The design of this free invoice template is straightforward, and you can alter various elements as you see fit by bolding them, changing colours to match your company’s design scheme, or altering font size to call attention to items you want to highlight. Overall, having an Excel template for small business invoicing ready, will make the billing process that much easier.
You can also remove elements from the Excel template that don’t fit your business needs. For example, if you don’t use the “Ship To” section on the template, you can create more space for your company’s logo or another identifying design. If your business logo is too big or too small, you may have to resize it manually or it could end up looking misshapen or out of whack.
You can also alter the formulas in the cells to suit each situation, like sending service invoices or sales invoices. For example, you can set hourly rates for labour with a multiplication formula, then add cells on the right column to derive a subtotal. Don’t forget to add a formula for Canadian sales tax on certain items for invoices over $30. Once you create your invoice template, save the basic format for future use.
Unfortunately, an Excel invoice spreadsheet can be a little confusing, especially when utilizing formulas. If the GST or HST rate changes, for example, Excel doesn’t update it automatically. In addition, if you need to add several lines of text, you may have to repeatedly copy cells over and over until you find the right amount you need.