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

766 KBDownload

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

5.84 MBDownload

Screenshots and Images

The printed version.

Firearm Shop Invoice Template

Open the template in Excel.

Firearm Shop Invoice Template (IMFE Edition)

Detail

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:

=ROUND(oknSubTotal*oknCreditCardFeeRate,2)

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

Template#c6038
NameFirearm Shop Invoice Template
CategorySales Invoice Template
Release DateSunday, November 18, 2018
Format (XLS or XLSX).xlsx
Columns6
Lines12
Line Height (Points)16.50
Print Area$F$3:$N$49
Papaer Size / OrientationPortrait
Default Margins (Points)
Left7.20
Right7.20
Top12.24
Bottom15.12
PriceFree (0.00 USD)
SystemWindows 7 and later, and Excel 2007 and later.

Samples

Thumbnail for FET Tax Invoice for Truck Tire Business
Thumbnail for Vendor Invoice Template for California
Thumbnail for Simple Tax Invoice Sample with Tax Rate List
Thumbnail for Mountain Laurel Invoice Template
Thumbnail for Caregiver Billing Form
Thumbnail for Invoice Template with Credit Card Payment Option
Thumbnail for Medical Invoice Template (1)