Download
| Description | Size | Download |
|---|---|---|
The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them. How to use:
| 499 KB | Download |
License: Private Use (not for distribution or resale). See our Terms of Use.
Screenshot
Detail
This template is designed for firearms shops. It includes a number of custom fields to fulfill the business requirements. For example, the serial number column allows you to record the unique number of each item.
There are also other fields designed for gun stores. For example, the "Order Date" field under the "Bill To" and "Ship To" sections is new.
On the bottom of the form, there are fields for 4473# (learn more about ATF Form 4473, Firearms Transaction Record Revisions), NICS#, and CCW (Carrying a Concealed Weapon Application and Policy).
The summary section at the bottom of the form is also expanded. By default, this template applies one "Sales Tax" at the rate of 8.3. See State Tax Data.
There is also a "Credit Card Fee" field. If you apply an extra fee to credit card payments, fill a non-zero value into the "Credit Card Fee Rate" field.
The formula of the "Total" cell is updated to include the credit card fee.
=ROUND(oknSubTotal + oknShippingCost + IF(oknTaxType=0,0,IF(oknTaxType=1,oknTax1,oknTax1+oknTax2)),2)+oknCreditCardFee
If you want to charge a credit card fee, just enter a non-zero value into the credit card fee rate cell. See the Invoice Template with Credit Card Payment Option (c4068) for a template that shows credit card details.
Format and Specification
| Template# | c6038 |
| Belongs to | |
| Format (XLS or XLSX) | .xlsx |
| Columns | 6 |
| Lines | 12 |
| Line Height (Points) | 16.50 |
| Print Area | $F$3:$N$49 |
| Papaer Orientation | Portrait |
| Default Margins (Points) | |
| Left | 7.20 |
| Right | 7.20 |
| Top | 12.24 |
| Bottom | 15.12 |
| Price | Free |
