BoostExcel main content


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

You are safe to download the resources. We've added our digital signatures to the files.

Description Size Download

Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.

1624 KB Download

Download this if you want this design to be set as the default template by the installer program.

6.81 MB Download

Screenshots and Images

The printed version.

General Purchase Invoice Template (Sales, One Tax)

Open the template in Excel.

General Purchase Invoice Template (Sales, One Tax) (IMFE Edition)


Sometimes an invoice is also referred as purchase invoice from the view of the buyer. This general-purpose Excel-formatted purchase invoice sample includes two editable/fillable columns, Description and Amount, and a Taxable checkbox column.

Like the other sales invoice template here on, c2025 General Purchase Invoice Template (Sales, One Tax) is compatible / work well with Invoice Manager for Excel, which is our invoicing software that connect a front-end Excel-formatted template with back-end database, providing features like management of customers, products, invoices and payments.


As a sales invoice template, this sample template includes the "Ship To" section for you to detail the shipping address of the product sold. The default configuration of this section comprises of 5 fields / fields - oknShipName, oknShipAddress, oknShipCityStateZip, oknShipCountry, oknShipContact. Note that Excel Invoice Manager was renamed to Invoice Manager for Excel, and with the release of Invoice Manager for Excel, custom fields are not only supported in the main database tables like InvHdr, InvBdy, Customer and Product, but also CustomerShippingAddress. By adding custom fields (i.e. user-defined fields), you can add new fields to the Shipping Address section on the invoice form too, and have the newly added fields work with Invoice Manager for Excel.

Several other templates here on have the Taxable options put on the printable form too. This sample, General Purchase Billing Template (Sales, One Tax) differs from others in that it implements the taxable options using the Form Controls. Microsoft Excel, and thus Invoice Manager for Excel, actually supports two types of checkboxes added to a spreadsheet form - i.e. form control and ActiveX control. In case you need to add your own control, visit the Controls group of the Developer ribbon tab. This tab is not visible by default. To display it, first right-click an empty area on the Excel ribbon, choose "Customize the Ribbon" and then check the Developer ribbon tab option.

The formulas of this bill sample are set so that when a Taxable box is checked, the Amount of the current is included when calculating tax. Likewise, if a taxable box is not checked, the amount of the current line is excluded from the tax calculation. This is done by using a array formula of a hidden cell named oknLineTotalTaxable (cell address B35): {=SUM(oknTaxable_1:oknTaxable_6*oknLineTotal_1:oknLineTotal_6)}. Note that the "{" and "}" symbols in the formula, which indicate it is an array formula. For a detailed explanation on array formula visit Guidelines and examples of array formulas.

Format and Specification

Template# c2025
Name General Purchase Invoice Template (Sales, One Tax)
Category Sales Invoice Template
Release Date Wednesday, January 20, 2016
Format (XLS or XLSX) .xlsx
Feature Gallery
Columns 2
Lines 6
Line Height (Points) 39.75
Print Area $D$3:$M$41
Papaer Size / Orientation Portrait
Default Margins (Points)
Left 16.56
Right 36.00
Top 72.00
Bottom 72.00
Price Free (0.00 USD)
System Windows 7 and later, and Excel 2007 and later.


Thumbnail for General Purchase Invoice Template (Service, One Tax)
Thumbnail for General Purchase Invoice Template (Consulting, One Tax)
Thumbnail for Simple Sample - Moving Balance and Payment Cells
Thumbnail for Simple Sample - Moving Item# Column
Thumbnail for Simple Sample - Using Currency Symbol
Thumbnail for Simple Sample - Discount Amount Field
Thumbnail for Simple Sample - Moving Taxable Controls