Exempt Transfer Transaction Upload

Exempt Transfer Transaction Upload

Note: This transaction requires the Acquire or Dispose Template

Using the Acquire or Dispose Template, fill in the following data fields:

  1. Item No./SKU - Required
  2. Importer (if applicable)
  3. Manufacturer - Required
  4. Country of Manufacture (only required if Importer was indicated)
  5. Model - Required
  6. Caliber/Gauge - Required
  7. Type - Required (Must be selected from available options)
  8. Serial Number - Required
  9. Disposition Date - Required MM/DD/YYYY format
  10. Disposition Name
  11. Disposed to Address Must match premises address as indicated on ATF issued License or Form
  12. Disposed to City Must match premises address as indicated on ATF issued License or Form
  13. Disposed to State Must match premises address as indicated on ATF issued License or Form
  14. Disposed to Zip Must match premises address as indicated on ATF issued License or Form
  15. Disposed to Country Must match premises address as indicated on ATF issued License or Form
THE FOLLOWING FIELDS MUST BE LEFT BLANK:
  1. Acquisition Date
  2. Acquisition Name
  3. Acquired From FFL
  4. Acquired From Address
  5. Acquired From City
  6. Acquired From State
  7. Acquired From Zip
  8. Acquired From Country
  9. Disposed To 4473 Number
  10. Disposed To FFL
The Notes field is available for any notes related to the serialized items.

Once the template has been filled out with the above information, the file can be uploaded using the steps below.

UPLOADING EXEMPT TRANSFER TRANSACTIONS

  1. Under the Standard Transactions heading click Upload Transactions, or, from any other screen click on Standard Transactions, and select Upload Transactions from the dropdown menu.
  2. Under the heading Select Bound Book to Upload Transactions, select the eBound Book to which you would like to post the transactions.
  3. Under the heading Select Transaction Type to Upload, select Exempt Transfer.
  4. Select the Choose File button, the select the file that was filled out using the transaction data above.
  5. Click Upload to execute the data upload. Do not refresh the page. Once data upload is complete, the page will refresh and repopulate Exempt Transfer Upload History area.
The Upload History area contains the following information regarding data upload(s):
  1. Date/Time: Date and time of processing of data upload
  2. File Name: Name of file processed for data upload.
  3. Acquisitions: Count of rows of data successfully posted as acquisitions to the selected eBound book
  4. Dispositions: Count of rows of data successfully posted as dispositions to the selected eBound book 
  5. Errors: Count of rows of data not processed via the upload due to errors
  6. Results: Click to view exact results for data upload by row

EXPORT RESULTS OF EXEMPT TRANSFER TRANSACTION UPLOADS
  1. Under the Standard Transaction heading click Upload Transactions, or, from any other screen click on Standard Transactions, and select Upload Transactions from the dropdown menu.
  2. Under the heading Select Bound Book to Upload Transactions, select the eBound Book that your recent transactions were uploaded to.
  3. Under the heading Select Transaction Type to Upload, select Exempt Transfer.
  4. The Upload Transaction screen will update and display the results for historic data uploads. Click the Results button next to the specific upload you wish to view the results of.
  5. Upload results will download as CSV export file.

If any data fields (e.g. Serial Number, Zip Code) in the report contain leading zeroes (e.g., 001, 00900ADE, etc.), simply double clicking the file to open in most spreadsheet programs will drop those leading zeroes. This is a function of data in the spreadsheet program, not Orchid eBound Book. To avoid losing the leading 0's in Microsoft® Excel®, follow the steps below:
  1. Open Microsoft® Excel®.
  2. Open the Text Import Wizard.
  3. When the dialog box opens prompting the User to select the file to import, select the .csv file of the eBound Book export.
  4. Select the Delimited radio button. Click Next.
  5. In the Delimiters list, deselect the default delimiter (if applicable), and select Comma. Click Next.
  6. In the screen which prompts the User to select the data format of each column, select the Serial Number column and click the Text radio button to format Serial Numbers as text.
  7. Click Finish.
Other spreadsheet programs will require different steps, please research these steps BEFORE opening the file in your program.

The Exempt Transfer Results file will contain the Import information as provided in the data upload document, as well as a Results column to indicate the results of the upload.  If the data was rejected, the specific reason will be listed in the Results column.

INSTRUCTIONAL VIDEO


    • Related Articles

    • Using the Exempt Transfer Transaction

      This transaction should be used by an FFL to record the Disposition of firearms in FFL-exempt and non-4473 scenarios. This would include, but is not limited to; repair/replacement returns, Dispositions to Law Enforcement, Military, Government ...
    • FFL Transfer Transaction Upload

      Note: This transaction requires the Acquire or Dispose Template Using the Acquire or Dispose Template, fill in the following data fields: Item No./SKU - Required Importer (if applicable) Manufacturer - Required Country of Manufacture (only required ...
    • Paper 4473 Transfer Transaction Upload

      Note: This transaction requires the Acquire or Dispose Template Using the Acquire or Dispose Template, fill in the following data fields: Item No./SKU - Required Importer (if applicable) Manufacturer - Required Country of Manufacture (only required ...
    • Using the Paper 4473 Transfer Transaction

      This transaction should be used by an FFL to record the Disposition of firearms to a non-licensee when a Form 4473 is required. Paper 4473 Transfer Manual Entry Under the Standard Transactions heading, select 4473 Transfer, or, from any other screen ...
    • Assemble Transaction Upload

      This transaction should be used by an FFL to record the assembly of firearms; whether from frame/receiver to finished good, or from one finished good to another (e.g., rifle to short-barreled rifle). This transaction will record a Disposition to the ...