Topic Overview

System Five e-Bound Book's combined abilities of tracking, searching, and reporting give licensed manufacturers, dealers and retailers access to required information quickly. This reduces the effort, time and money spent in the day-to-day management of ATF record-keeping and makes ATF audits a breeze.

System Five e-Bound Book is a self-contained electronic system that allows you to access detailed reporting information easily, without relying on paper/manual systems for any of the required information.

The bound book report displays committed entries in two formats: the Audit Trail format and the FADR (Firearms Acquisition and Disposition Record) format. Both formats have robust query options and filters that are customizable to your business needs and that are particularly handy during an audit by your ATF inspector. The report can be easily printed or exported to (*.xls) format with just a click of a button.

Audit Trail Format

Access

To access the Audit Trail report:

  1. Navigate to Bound Book Report and click the [Report] tab.
  2. Click [Build] to generate the report (Figure 1).

Figure 1. Generating The Audit Trail Report

By default, the Audit Trail Report displays a history of firearm entries that are ordered based on sequence number (i.e., audit trail number) (Figure 2). The sequence number is permanent and is generated in the order in which the entries were created. The first two digits of the sequence number represent the department that completed the transaction.

Figure 2. Default Display of Audit Trail Entries

You can either print the Audit Trail report by clicking the [Print] button or export it to (*.xls) format by clicking the [Export]   button on the toolbar menu.

Key Information

The Audit Trail report is a comprehensive solution that provides unit information, transaction dates, as well as acquisition and disposition account details. The report displays firearm transactions by type (Table 1).

Figure 3 identifies key information displayed on the Audit Trail report.

Figure 3. Key Information Displayed on Audit Trail Report

Transaction Type

Description

Purchased

Firearm acquired through a Purchase Order. 

Sale

Firearm disposed to the customer. 

Returned to Supplier

Firearm returned to the supplier through a Purchase Order.

Trade-in

Firearm brought in for trade (typically offset against a new purchase).

In for Repair

Firearm brought in for repair. 

Out after Repair

Firearm previously sent for repair has been disposed to the customer.

Table 1: Transaction Types Displayed on Bound Book Report

Query Options

You can query the Audit Trail report to show acquisitions, dispositions, specific serial numbers, FFL/NICS numbers, and transaction types, depending on your business needs. After selecting a query option, click the [Build] tab to re-generate the report based on the newly applied filter criteria.

  • The [Show Held Only] query option displays only the firearms that are still in your possession (Figure 4).

Figure 4. [Show Held Only] Query on Audit Trail Report

  • The [Show Disposed Only] query option displays only the firearms that have been disposed of (i.e., are no longer in your possession) (Figure 5).

Figure 5. [Show Disposed Only] Query on Audit Trail Report

  • The [Filter Options] query option allows you to sort your acquisitions and dispositions by either including or excluding transaction types (trade-ins, purchases, or returns to suppliers) and/or FFL and NICS numbers. (In the example illustrated in Figure 6, the report output is based on the inclusion of trade-ins only.)

Note: If you are not getting the desired results for your query, check for any filter(s) that may be affecting how the report displays.

Figure 6. [Filter Options] Query on Audit Trail Report

  • The [Serial Search] query option allows you to look up a specific serial number. (In the example illustrated in Figure 7, the report output is based on the inclusion of serial number 130 only.)

Figure 7. [Serial Search] Query on Audit Trail Report

Comments

The Audit Trail report displays the comment(s) entered either at the time of the review of non-committed entries or after committing the entries to the bound book. You can also enter comments directly on the Audit Trail report (Figure 8) as follows:

  1. Click the [Comments] tab to call up the Bound Book Notes dialog box.
  2. Enter the comment in the Bound Book Notes dialog box. To add more than one comment, click the [Add] button.
  3. Click [OK] to record the comment(s).

Comments are displayed in the lower portion of the transaction entry (for an example, see Figure 9) and are date-stamped.

Figure 8 Entering Comments on Audit Trail Report

Figure 9 Comment Displayed on Audit Trail Report

Edit History

The Audit Trail report creates separate entries for transactions modified after being committed to the bound book. Original entries are retained and displayed in strikethrough text format. Entries that contain edits are listed below the original entries and contain mandatory comments (entered prior to the recommitment) explaining the reasons for the edits (Figure 10).

Figure 10. Original and Edited Entries Displayed on Audit Trail Report

FADR Format

Access

To access the FADR report:

  1. Navigate to Bound Book Report and click the [FADR] tab.
  2. Click [Build] to generate the report (Figure 11).

Figure 11. Generating The FADR Report

By default, the FADR report displays a history of firearm acquisition and disposition entries that are ordered based on transaction date (Figure 12). Unlike the Audit Trail report, the FADR report does not display the sequence number.

Figure 12. Default Display of FADR Entries

You can either print the FADR report by clicking the [Print] button or export it to (*.xls) format by clicking the [Export]   button on the toolbar menu.

Key Information

The FADR report is a comprehensive solution that provides unit information, transaction dates, as well as acquisition and disposition account details.

Figure 13 identifies key information displayed on the FADR report.

Figure 13.  Key Information Displayed on FADR Report

Query Options

You can query the Audit Trail report to show acquisitions, dispositions, specific serial numbers, FFL/NICS numbers, date ranges, and transaction types, depending on your business needs. After selecting a query option, click the [Build] tab to re-generate the report based on the newly applied filter criteria.

  • The [Show Held Only] query option displays only the firearms that are still in your possession (Figure 14).

Figure 14. [Show Held Only] Query on FADR Report

  • The [Show Disposed Only] query option displays only the firearms that have been disposed of (i.e., are no longer in your possession) (Figure 15).

Figure 15. [Show Disposed Only] Query on FADR Report

  • The [Filter Options] query option allows you to sort acquisitions and dispositions by either including or excluding transaction types (trade-ins, purchases, or returns to suppliers) and/or FFL and NICS numbers in conjunction with inventory categories. By using this query, you can generate multiple bound book reports based on specific filters. You can save the query to make it available for future use. (In the example illustrated in Figure 16, the report output is based on new rifles disposed to customers holding NICS numbers.)

    To use the [Filter Options] query option:

  1. Uncheck the [Show all Categories] option;
  2. Select the inventory categories you want to include;
  3. If desired, apply Acquisition/Disposition filters;
  4. Name the query;
  5. Save the query; and
  6. Build the report.

Note: If you are not getting the desired results for your query, check for any filter(s) that may be affecting how the report displays.

Figure 16. [Filter Options] Query on FADR Report

  • The [Transaction Date Filter] query option allows you to retrieve bound book entries for a specific date range. To query the FADR report by a date range, enable this option and then specify the range either by entering the dates manually (MM/DD/YYYY format) or by picking the dates from the drop-down calendar (Figure 17).   

Figure 17. [Transaction Date Filter] Query on FADR Report

  • The [Serial Search] query option allows you to look up a specific serial number. (In the example illustrated in Figure 18, the report output is based on the inclusion of serial number 130 only.)

Figure 18. [Serial Search] Query on FADR Report

Comments

The FADR report displays the comment(s) entered either at the time of the review of non-committed entries or after committing the entries to the bound book. You can also enter comments directly on the FADR report (Figure 19) as follows:

  1. Click the [Comments] tab to call up the Bound Book Notes dialog box.
  2. Enter the comment in the Bound Book Notes dialog box. To add more than one comment, click the [Add] button.
  3. Click [OK] to record the comment(s).

Comments are displayed in the Reviewed column (for an example, see Figure 20).

Figure 19. Entering Comments on FADR Report

Figure 20. Comment Displayed on FADR Report

Edit History

Edits to committed entries are listed in the Disp. Addr/License/4473 Serial column, with added information marked by the [+] symbol. The Comments column displays the trail of edits (original text and modified text) as well as mandatory comments (entered prior to the recommitment) explaining the reasons for the edits. An example of an amended entry is shown in Figure 21.

  Figure 21. Key Information Displayed on FADR Report