Exporting Open Inventory from AIMI eBook

Orchid eBound imports your open firearms from AIMI eBook and links each one to your POS inventory and UPC records. Per ATF Ruling 2016-1, only open (acquired-but-not-disposed) records transfer to a new electronic bound book.

Published May 25, 2026 Updated Jun 04, 2026 2 views
AIMI eBook
Note: Some menu paths may vary by version. Your Orchid consultant can confirm the exact steps.

AIMI eBook is an electronic bound book system used by some FFLs. The export uses an Advanced Reporting interface with Crystal Reports-style output.

What Orchid Does With This File

Orchid eBound imports your open firearms from AIMI eBook and links each one to your POS inventory and UPC records. Per ATF Ruling 2016-1, only open (acquired-but-not-disposed) records transfer to a new electronic bound book.

Before You Start

  • Make sure all pending acquisitions are committed before exporting.
  • If you have multiple companies/locations in AIMI eBook, you'll need to export each separately.

Step-by-Step Instructions

  1. Sign in to AIMI eBook and select your company.
  2. Open the Menu and navigate to Reports > Advanced Reporting.
  3. Filter the report to show Status = "Available" (open items only).
  4. Choose the export format: MS Excel 97-2000 (Data only).
  5. In the Excel export options, check: Column width based on objects, Export Page Header and Page Footer, and Simplify page headers.
  6. Save the file. It downloads as an .xlsx workbook.

Expected File Format

Excel (.xlsx) via the Advanced Reporting Crystal Reports export.

Expected Columns

  • Manufacturer / Importer
  • Model
  • Serial Number
  • Type
  • Caliber / Gauge
  • Acquisition Date
  • Acquired From (Name, Address, FFL)
  • Country of Manufacture
  • Condition
  • Notes

Watch Out For

  • The Advanced Reporting export may prompt for a Report Title — you can leave it blank.
  • Report generation may take several minutes for large bound books.
  • The export captures the current state — run it after all pending acquisitions are committed.
CSV Warning: Do NOT open exported CSV files in Excel and save them. Excel silently strips leading zeros from serial numbers and FFL numbers, converts long numbers to scientific notation, and reformats dates. If you need to inspect the file, open it in a plain text editor or use Data > From Text/CSV in Excel with columns set to Text.

This file may contain sensitive information. Send it to Orchid using the secure upload link your consultant provided.

Questions? Reach out to your Orchid implementation consultant, or email implementations@joinorchid.com.

Was this article helpful?

Thanks for your feedback!