Reports

Every report in the system, who it is for, and the question it answers. Managers and the bookkeeper live here. Counter staff mostly use the four queue reports at the top of the Gun Shop workspace.

Reports open as a filter bar, a summary strip and a table.

Every report

Report	Route	Who it is for	The question it answers
Firearms In Stock	/app/query-report/Firearms In Stock	Inventory	Which guns do we physically have right now, by serial?
Pending 4473 Orders	/app/query-report/Pending 4473 Orders	Counter, manager	Which parked firearm sales are waiting on a 4473 or NICS?
Pending Transfer Pickups	/app/query-report/Pending Transfer Pickups	Counter	Whose transfer gun is in the safe, and how long has it sat?
Open Special Orders	/app/query-report/Open Special Orders	Counter	Which special orders are still waiting, and has the stock arrived?
Inventory Receipts	/app/query-report/Inventory Receipts	Bookkeeper, inventory	What entered stock this period, from whom, at what cost?
Sales Report	/app/query-report/Sales Report	Manager, bookkeeper	What did we sell, across every channel, and what did we make?
Hand-Asserted 4473 Dispositions	/app/query-report/Hand-Asserted 4473 Dispositions	Manager	Which bound book entries did a person vouch for instead of FastBound?
GunBroker Statement Reconciliation	/app/query-report/GunBroker Statement Reconciliation	Bookkeeper	Does GunBroker's own bill agree with our ledger, order by order?
GunBroker Cash Basis Adjustments	/app/query-report/GunBroker Cash Basis Adjustments	Tax preparer	What bridges the accrual books to the cash-basis return?
Stock Balance	/app/query-report/Stock Balance	Inventory	How many of each item are on hand, per warehouse?
Stock Ledger	/app/query-report/Stock Ledger	Inventory	Every stock movement, one row per entry.

Stock Balance and Stock Ledger are stock ERPNext reports. The workspace links to Stock Balance under the name Stock On Hand.

Stock Balance runs in the background. It opens empty until you set the filters and press Generate New Report.

The four counter queues

Firearms In Stock lists every Serial No with status Active whose Item is a firearm, with manufacturer, model, caliber, condition, warehouse, the acquisition date and source, and a link out to the gun's FastBound item record. Filter by Stock Status, Warehouse or Manufacturer. Two manager actions live on the toolbar: Sync Bound Book compares our in-stock list against FastBound and offers to remove guns FastBound reports as disposed, and Check FastBound differences starts a background field-by-field scan. Managers also get a small $ link beside each serial that opens the correct-cost dialog.

Firearms In Stock is the by-serial floor view.

Consignment guns are held back

A gun out on consignment at a partner dealer is disposed in FastBound and still our stock here, by design. Sync Bound Book never offers to remove one, and says how many it withheld.

Pending 4473 Orders is one row per Draft POS Invoice that has a firearm line, with the 4473 status, the NICS status, days pending, the invoice total and a Transfer flag. The Brady Day 3 column is three business days after the sale was parked. Denied shows red, Delayed shows orange, and a Delayed row past its Brady date has its date highlighted too. Antique firearms are excluded. Filter by NICS Status. See Form 4473 at the counter.

The parked-firearm queue, oldest first, with the Brady date.

Pending Transfer Pickups lists every firearm received for a customer whose serial is still Active, oldest first, with the customer's mobile number and who shipped it. This is the call-the-customer queue. Filter by Customer.

Open Special Orders lists every submitted special order that is not Closed or Cancelled, oldest first, with the items ordered, the order total, the deposit actually collected, an Arrived tick when every line has stock on hand, and the expected date. Anything open more than 30 days shows orange. Filter by Customer.

The back-office reports

Inventory Receipts covers everything that entered stock in a date range, sorted into four categories (Firearm, Ammunition, Accessory, Other) and ten receipt classes (Purchase, Trade-in, Consignment, Intake, Return, Adjustment, Revaluation, Transfer, Custody, Other). It has three views. Receipts is a tree of voucher, then lines, then serial units. Summary rolls up category by class. Units is one flat row per unit and is the grain to export. Internal transfers and customer-custody guns are hidden until you tick Include transfers or Include custody. Summary cards show Cost Received, firearm unit count, ammunition and accessory cost, and two flag counts: no-cost units and units missing an A&D entry.

Inventory Receipts, Receipts view: voucher, then lines, then units.

Hand-Asserted 4473 Dispositions is the standing review queue for every bound book entry a human vouched for rather than FastBound. Two doors write these: a manager forcing a stuck electronic 4473 through, and the counter recording a paper 4473 in Paper 4473 Mode. Each row shows when it was asserted, the serial, the disposition type, the invoice, who asserted it, their stated reason, and whether FastBound has since caught up. It shows the most recent 500 and takes an optional From Date. Read it periodically, or the control it audits means nothing.

GunBroker Statement Reconciliation matches GunBroker's own monthly bill against our ledger, order by order and item by item. Choose the statement (Fee Statement or Sales Tax Statement), the statement period, then either attach the CSV or paste the table into the text box. It never compares monthly totals: an order sold on 30 January and shipped on 2 February belongs to January's statement and February's ledger, so timing is a status of its own rather than a difference.

GunBroker Cash Basis Adjustments is the seven-item schedule the tax preparer works from. It takes a company and a period, and every figure is recomputed as of the period end rather than from today's status, so the same period end always gives the same schedule. Hand it to the accountant with the preamble printed at the top of the page. See Month-end close.

Filtering, saving and exporting

Open a report and the filter bar sits above the table. Change a filter and the report re-runs. Sales Report and Inventory Receipts both have a Period picker with Today, This Week, This Month, Last Month, This Quarter and Year to Date. Editing From or To by hand puts the picker back to Custom.

To keep a filter set, use the menu at the top right of the report page and choose Save Filter, then name it. Saved filters appear in the same menu.

To export, use the same menu and choose Export, then pick Excel or CSV. On the Sales Report the Product view always exports its full tax column set no matter which columns you have hidden on screen.

Report access follows your role. Pending 4473 Orders, Pending Transfer Pickups and Open Special Orders open for counter and stock roles. Firearms In Stock is stock roles only — Stock User, Stock Manager or System Manager. Sales Report needs Sales Manager, Accounts Manager or System Manager. The two GunBroker reports need Accounts Manager or System Manager. See Who can do what.