BoostExcel.com main content

Download

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.

DescriptionSizeDownload

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

1532 KBDownload

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

6.50 MBDownload

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)

Detail

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 InvoicingTemplate.com, 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.

$GroupDescription

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 InvoicingTemplate.com 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
NameGeneral Purchase Invoice Template (Sales, One Tax)
CategorySales Invoice Template
Release DateWednesday, January 20, 2016
Format (XLS or XLSX).xlsx
Feature Gallery
Columns2
Lines6
Line Height (Points)39.75
Print Area$D$3:$M$41
Papaer Size / OrientationPortrait
Default Margins (Points)
Left16.56
Right36.00
Top72.00
Bottom72.00
PriceFree (0.00USD)
SystemWindows 7 and later, and Excel 2007 and later.

Related

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