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 free invoice template designed for firearms shop defined a number of custom fields to fulfill the business requirements. For example, the serial number columns allows you to record the unique number of each invoiced firearm like a pistol, a rifle or shotgun.
Besides the serial# columns, there are also other fields designed especially for the gun stores. For example, the "Order Date" field under the "Bill To" and "Ship To" sections is new (not defined in the standard database shipped with Invoice Manager).
On the bottom of the form, there are fields for 4473# (learn more about ATF Form 4473 - Firearms Transaction Record Revisions), NICS#, CCW (Carrying a Concealed Weapon Application and Policy). These are all important fields.
The summary section on the bottom of the form is also expanded. All items on this invoice form are taxable. So we removed the "Taxable" checkboxes from this template. By default, this template applies one "Sales Tax" at the rate of 8.3. See State and Local Sales Tax Rates 2018.
There is also a "Credit Card Fee" field. If you apply extra fee to credit card payments, fill a non-zero value into the "Credit Card Fee Rate" field. The Formula of the "Total" field is modified too, because it now include credit card fee:
The formula of the "Total" cell includes credit card fee.
=ROUND(oknSubTotal + oknShippingCost + IF(oknTaxType=0,0,IF(oknTaxType=1,oknTax1,oknTax1+oknTax2)),2)+oknCreditCardFee
So if you want to take credit card fee, just enter a non-zero value into credit card fee rate cell. See c4068 Invoice Template with Credit Card Payment Option for a sample that shows credit card details on invoice form. All the formulas and text labels on our templates are editable. See editable invoice templates for excel for more samples.
Format and Specification
|Name||Firearm Shop Invoice Template|
|Category||Sales Invoice Template|
|Release Date||Sunday, November 18, 2018|
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||16.50|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
|Price||Free (0.00 USD)|
|System||Windows 7 and later, and Excel 2007 and later.|