Download

DescriptionSizeDownload

The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.

How to use:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
451 KBDownload

License: Private Use (not for distribution or resale). See our Terms of Use.

Screenshot

screenshot for Canadian ADP Invoice

Detail

This template features a number of custom fields that are added specially for vendors for the ADP Assistive Devices Program (ADP).

Related template:

The 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 #", and "Benefit Code". All these are defined as custom fields, so they can be saved to the backend database when you click "Save To DB".

This Excel form has 8 columns in the detail section: "Product ID", "Side", "Description", "Qty", "Unit Price", "Extended Price" (usually called "Line total" or "Amount"), "Client", and "ADP". The "ADP" column is calculated automatically based on "Extended Price" and "Client", using an Excel formula like this:

= oknLinetotal_? - oknClient_?

Note that the question mark here indicates the line number in the detail section.

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 ribbon tab, and then go to the "Taxes" tab.

Format and Specification

Template#c8006
Belongs to

Sales

Format (XLS or XLSX).xlsx
Columns8
Lines12
Line Height (Points)15.75
Print Area$F$3:$Q$42
Papaer OrientationPortrait
Default Margins (Points)
Left18.00
Right18.00
Top75.60
Bottom75.60
PriceFree