Skip to main content main content
Sharing Is Caring! We do appreciate your efforts to let others know us!

Screenshots and Images

The printed version.

General Purchase Invoice Template (Sales, One Tax)

General Purchase Invoice Template (Sales, One Tax) (c2025)

c2025 now includes the customized invoice template for the latest version of Invoice Manager for Excel. This is what you will see when you open generalpurchase-sales-one-tax.xlsx.

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

General Purchase Invoice Template (Sales, One Tax) - IMFE edition


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.


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

4.43 MBDownload

Without database file. How to download and use

1199 KBDownload

Download this if you have already installed IMFE, but are looking for additional customized templates.

1390 KBDownload


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 (namely Uniform Invoice Software), 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 (namely Uniform Invoice Software), and with the release of Invoice Manager for Excel (namely Uniform Invoice Software), 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 (namely Uniform Invoice Software).

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 (namely Uniform Invoice Software), 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.

Like other form designs here on, General Purchase Billing Template (Sales, One Tax) is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.

Format and Specification

NameGeneral Purchase Invoice Template (Sales, One Tax)
CategorySales Invoice Template
Release DateWednesday, January 20, 2016
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Line Height (Points)39.75
Print Area$D$3:$M$41
Papaer Size / OrientationPortrait
Default Margins (Points)