Skip to main content
InvoicingTemplate.com main content
sharing is caring! we do appreciate your time to let others know us!

4-Column without Tax

c4002
4-Column without Tax

This is a variant of the invoice template with 4 columns. The template is set with no tax and shipping address. Visit Sample Invoice Template to download a sample that accepts long product description.

ABN Tax Invoice

c7028
ABN Tax Invoice Format

This template is a revised version of our original designs, Australian GST Invoice Template and Australian GST Invoice Template (2). With this new template, we move the ABN# field to the top of the invoice form, and also modify the layout of the form to make it looks better and works more smoothly with the latest version of Invoice Manager for Excel (namely Uniform Invoice Software).

FET Tax Invoice for Truck Tire Business

c7040
FET Tax Invoice for Truck Tire Business

FET, i.e. Federal Excise Tax, is a tax paid when purchases are made on a specific good, such as gasoline. Excise taxes are often included in the price of the product. But it is also common to list FET tax amount separately, which is what this template will do.

Jamaica Tax Invoice Template

c5072
Jamaica Tax Billing Format

This template, Jamaica Tax Invoice Template, or Jamaica Tax Billing Format, was created with the above requirements in mind. In order to create this layout from the default template shipped with Invoice Manager for Excel (namely Uniform Invoice Software), we moved out the Product# (Item#) column from the detail section of the invoice form, and added a new column "Date Supplied", which is a custom field "DateSupplied" added to the "Invoice Body" database table.

UK Tax Invoice Template

c6005
UK Tax Billing Form

The taxable checkboxes were removed completely, assuming all the products are taxable, no matter whether the Taxable option is checked or not for each product. This avoids an occasionally happened mistake when a taxable product or item must be manually entered on the invoice body, as the Taxable checkbox is not checked by default. The template implements this feature by deleting all the Taxable checkboxes and assigning a value of 1 (TRUE) to all the oknTaxable cells located in the hidden column C.

Recipient Created Tax Invoices Form

c4077
Template for Purchaser Created Tax Invoices

At InvoicingTemplate.com we've already published a serial of Excel invoice templates according to Australian Taxation Office requirements, including ABN Tax Invoice Template, Australian GST Invoice Template and Australian GST Invoice Template (2). Unlike the samples provided by Australian Taxation Office, our invoice templates are provided in both Excel and PDF formats. And of course, the Excel versions works with Invoice Manager for Excel (namely Uniform Invoice Software), which is our Excel-based invoicing software app that combines the power of Microsoft Excel with the back end databases in either Access or SQL Server format, providing features that could hardly be found or implemented with pure Excel templates. Invoice Manager for Excel (namely Uniform Invoice Software) was originally named Excel Invoice Manager, and the first version was released on August 1, 2005. Our continuous improvements based on the requirements from our users make Invoice Manager for Excel (namely Uniform Invoice Software) an easy to use, powerful and unique invoicing tool.

Blank Sales Invoice Layout (Two-tax)

c2020
Blank Sales Invoice Sample (Two-tax)

You should unprotect the "Invoice" worksheet only when you are designing the layout and format of the template. Invoice Manager for Excel (namely Uniform Invoice Software) itself provides a "Design Mode" button on its own ribbon tab. If you push this button, it in fact do 3 things - firstly, unprotect the sheet; secondly, push down the design mode button on Excel's own Developer ribbon tab, and thirdly, switch on gridlines and row/column headings. Click the design mode button again to reverse all these 3 operations.

Mixed Tax Rates (5 Columns)

c5034
Mixed Tax Rates in an Invoicing Form (5 Columns)

For example, if you are selling both beverages and non-beverages products, which must be charged with different tax rates, for example beverage tax must be at 3.0% and non-beverage tax rate must be at 5.0%; or if you are selling both general products (goods) and labor (service) to customers, which are two types of taxable items and should be charged with different tax rates. If you want to add these two types of invoicing items to the default template, you may find the template will fail to calculate the taxes because with the default implementation, the tax items you defined on the default template, no matter one tax or two, will applied to all the items that have the "taxable" option checked.

Simple Sample - Separate City State ZIP

c4081
Simple Invoice Template - Separate City State ZIP
  1. Backup the template before modifying it.
  2. Open it.
  3. Go to the "Invoice" ribbon tab and click the "Design Mode" button.
  4. Drag your mouse to select 3 custom fields, "oknCustomerCity" (cell address O8), "oknCustomerState" (cell address O9) and "oknCustomerZip" (cell address O10).
  5. Hit DEL key on keyboard to delete the formulas of these 3 cells.
  6. With the 3 cells / fields still selected, right-click on of the selected cell and choose "Format Cells" from the shortcut menu. This opens the "Format Cells" dialog box.
  7. Go to the "Protection" tab. Clear the "Locked" checkbox option.
  8. Click OK to close the "Format Cells" dialog box. This makes the 3 cells editable when the worksheet is protected.
  9. Now click and select the "City, State ZIP" cell in the "Bill To" section (cell address $F$11).
  10. Enter this formula for the cell: = CONCATENATE( TRIM ( oknCustomerCity ) , ", ", TRIM( oknCustomerState ), " ", TRIM ( oknCustomerZIP )). This formula combines the 3 user entered values into one readable and formal "City, State ZIP" value.
  11. Right-click selected cell ($F$11) and choose "Format Cells" from the shortcut menu.
  12. Go to the "Protection" tab.
  13. Check the "Locked" option box.
  14. Click OK to close the "Format Cells" dialog box. This make the cell not editable when the "Invoice" worksheet is protected.
  15. Exit design mode by clicking the "Design Mode" button again on Microsoft Excel ribbon tab.
  16. Save the template by clicking the Save button on Excel quick access toolbar.

Contractor Invoices with Remittance-slip

c5106
Contractor Invoices with Remittance Advice Slip

This free contractor invoice template features a remittance slip or remittance-advice-slip on the bottom of the Excel form. The slip is created by mve the total, paid and total due cell down to the bottom, as well as all the information in the "Bill To" section.

Book Store Invoice Template

c7003
Book Store Billing Form

Discounts could vary by product. Some invoices may have products at 40% discounts, others at 50%, for example.

In order to implement the feature required with this invoicing format, the template uses 3 custom fields (custom columns) on the invoice body.

Backorder Invoice Template (Landscape)

c7020
Backorder Billing Form (Landscape)

Backorder Invoice Template (Landscape) is a variant and customization sample of c7002 Backorder Invoice Template. This Excel invoice template has the similar form layout and design as the original version, but is customized for being printable on standard A4 paper with landscape paper orientation.

Bill Format with Change Calculation

c5021
Bill Format with Change Calculation

The second cell is titled with "Paid". If you click the cell that allows you to enter the payment amount, you'll notice the cell is named "oknPaymentBeforeChange", which differs from default "oknPayments" cell in the default template shipped with Invoice Manager for Excel (namely Uniform Invoice Software). This is the only manually editable one in this section, identified with a special background color.

Child Care Billing Template

c4007
Child Care Billing Template

This child care billing template or babysitting receipt template is a revisited version of the Parenting Service Invoice Template (c4-007) originally published on office-kit.com. Use this free printable Excel format to create and print bills and receipts for your babysitting, day care or childminder services.

Five Price Levels (Service, Amount)

c4013
Form with 5 Price Levels

It was created by simply moving out all the shipping-related fields, including: the "Ship To" section fields, such as Name, Address, City State and Zip, Country and Contact. The icon button for selecting shipping address should also be moved out of the printable area. Moving an ActiveX control, such as the icon button, is a bit more complex than just moving cells. To move an Active X control out of the printable area, you first need to unprotect the Invoice worksheet, this could be done by clicking the Unprotect Sheet command on the Review ribbon tab in Excel 2007, Excel 2010 and Excel 2013, or in Excel 2003 you have to click Excel menu Tools / Protection / Unprotect Sheet.

Television Service

c5120
Television Service Billing Template

The "Shipping Address" section now has a new title, "Service Address".

On the bottom of the detail section, an Excel text box, namely "oknWidget_msg1" is added, which shows text " * NOTICE: By signing below you are confirming that the installation was done to your satisfaction. You also acknowledge all cabling that was installed now belongs to you and is not the responsibility of our company either now or in the future." Another text box underneath it is a placeholder for your "TERMS OF AGREEMENT", which you should fill in before creating your own invoices.

UIS V5.11 Standard Invoice Template and Shortcut Keys

c5094
UIS V5.11 Standard Invoice Template and Shortcut Keys

In Microsoft Excel, and also other Microsoft programs on Windows, such as Word, ActiveX controls are widely supported. Unlike form control, ActiveX controls are standalone programs outside Microsoft Excel. For this reason, using of ActiveX control introduces complexity to an Excel workbook file.

Backorder Invoice Template

c7002
Backorder Billing Form

In the original sales invoice template that is shipped with Invoice Manager for Excel (namely Uniform Invoice Software) setup program, there is only on quantity column on the invoice detail section. This quantity refers to the quantity that the customer ordered, and it is also the quantity that was shipped to fulfill the order. If the quantity ordered is partially fulfilled, you may like to detail all these numbers - quantity ordered, quantity shipped, and quantity backordered. InvoicingTemplate.com offers you this Backorder Invoice Template, which is in Microsoft Excel format, to meet the requirements of these businesses.