Screenshots and Images
The printed version.
Open the template in Excel.
You are safe to download the resources. We've added our digital signatures to the files.
Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
This Excel invoice template designed for Canadian ADP invoice features a number of custom fields that are added specially for ADP invoicing. If you are a vendor for ADP Assistive Devices Program (ADP), download this form design for free and create invoice easily with the help of Invoice Manager for Excel. Click Service Invoice Template for Canadian Laundromat for a GST sample template.
Assistive Devices Program (ADP) is a beneficial program for anyone needing to access Government assistance for pressure modification devices (compression garments). This Canadian ADP invoice template includes fields for "ADP Claim #", "Health Card #", "Serial #", "Benefit Code". All these are defined as custom field (user-defined field), so they can be save to the backend database when you click "Save To DB" on the "Invoice" worksheet, or click the "Save Invoice" button on the task pane.
This Excel form has 8 columns on the detail section, including "Product ID", "Side", "Description", "Qty", "Unit Price", "Extended Price" (usually called "Line total" or "Amount" on other templates available here on InvoicingTemplate.com), "Client" and "ADP". the "ADP" column is calculated automatically based "Extended Price" and "Client", using an Excel formula like this (note the question mark "?" here indicates the line number on the detail section):
= oknLinetotal_? - oknClient_?
This template has one tax set by default ("HST"). See Canadian Invoice Template with HST (c6020) for another example on this topic. If you need to change the tax calculations, click the "Settings" button on the "Invoice" ribbon tab, and then go to the "Taxes" tab.
On the bottom of the invoice form design, you can find calculation for subtotal, HST rate and amount, shipping cost (this field is manually editable) on creating invoices. These bottom fields are not defined as custom fields, which means you cannot add them to reports before define them as custom fields.
Format and Specification
|Name||Canadian ADP Invoice|
|Category||Sales Invoice Template|
|Release Date||Thursday, June 15, 2017|
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||15.75|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
|Price||Free (0.00 USD)|
|System||Windows 7 and later, and Excel 2007 and later.|
November 14, 2018
- The "Customer Statement" report worksheet was renamed to "Aging".