# Reports
Reports are under Reports in the main menu: Production, Sales, Wholesale Depletions, Compliance, Produced vs Sold and Cask Lifecycle. Reports need the Manager role or above. See Roles & Access.
# Saved reports
The production, sales, produced-vs-sold and cask lifecycle reports open from a report menu at the top of the page:
- Standard Reports are the built-in reports.
- My Reports are the ones you saved.
- Company Reports are saved for everyone in the account.
- Custom Report starts from the full set of filters.
To save a report, set its filters and display, then choose Save Report. Under Save For, choose My Views or, if you are an admin, Company Views.
A saved report opens with its filters shown as chips. Choose Customize to change them. From the report's ⋮ menu you can Rename Report, Set As My Default, Delete Report, and, as an admin on a company report, Set As Company Default.
When you open a report page it shows, in order: the report you chose, your own default, the company default, or the built-in report.
# Filters and display
The production and sales reports share one filter bar:
- Sales channel and Facility. Production can be filtered to one facility, so a multi-site account can report each site on its own.
- Group by: none, product type, format or customer.
- More filters: customer, taproom location, format, product type, product, pricing set and package class.
- vs prior year compares each month, quarter or year with the same period a year earlier.
- Net sales nets buybacks out of wholesale and combines taproom orders with taproom POS sales.
- The value menu chooses BBLs, case equivalents, units, dollars or dollars per BBL.
- Export downloads what is shown as a CSV.
# Production Reports
# Barrelage & Efficiency Report
- Shows production volume by status
- Tracks brewing and packaging efficiency
- Includes:
- Total BBLs brewed
- Total BBLs packaged
- Average yield percentage
- Average cellar time
- Scheduled production
- Projected packaging
# Filtering Options
- Time period (Week/Month/Quarter/Year)
- Facility selection
- Package format
- Product type
- Pricing set
- Package classification, including standard and treatment package logs
- Date range customization
# Display Units and Comparisons
- Production report values can be displayed as BBLs, case equivalents (CEs), or units.
- Month, Quarter, and Year views can be compared with the matching period from the prior year.
- Day and Week views do not support prior-year comparison.
- Comparison exports include both current-period and prior-year values when comparison is enabled.
# Report Features
- Interactive bar charts
- Production totals summary
- Export capabilities
- Historical data access
# Treatment Keg Reporting
Treatment kegs are included in normal packaged production volume, inventory, and compliance-facing totals. Use the package classification filter to isolate treatment volume when you want to review small-batch treatment releases separately.
# Cask Lifecycle Report
- Facility-level view of cask movement across production lifecycle states
- Includes:
- Opening on-hand production inventory
- Filled volume
- Finished/consumed volume
- Closing on-hand production inventory
- Reconciliation indicators
- Supports drilldown details so managers can inspect contributing vessel uses and dates behind each total
Use this report for operations reconciliation, logging quality checks, and compliance preparation.
# Sales Reports
# Report Navigation
- Product list with quick selection
- Detailed view for each product
- Historical sales data
- Order details table
# Report Features
- Real-time data updates
- Mobile-friendly interface
- Pagination for large datasets
- Export capabilities
# Display Values
Sales report charts show one value type at a time:
- BBLs
- Case equivalents (CEs)
- Units
- Dollars
- Dollars per BBL
Month, Quarter, and Year sales views can compare the current periods to the same calendar periods from the prior year.
# Taproom Sales in Reports
Sales reports support explicit source views and combined views:
- Taproom POS shows POS sales from Square taproom locations.
- Retail Orders shows self-distribution orders, including orders written to taproom customer records.
- Show All applies each taproom's reporting source policy so POS data and retail orders do not double-count the same taproom.
Configure taproom reporting source policy in Settings -> Facility Management -> Taproom Operations.
# Wholesale Depletions
Reports → Wholesale Depletions shows what your wholesalers sold to their accounts, from the depletion reports they send. See Production Planner for how those reports get in.
Filter by Wholesalers, Premise (on or off) and Customer. The report shows:
- Totals for the period.
- Year over year: accounts buying and case equivalents this year against the prior year.
- What changed: the change in volume split into more or fewer accounts, more or fewer active months per account, and more or less per month. The rows add up to the change in the total.
- Accounts by size: each prior-year account by the size it bought at, and whether it grew, held, shrank or stopped.
- Largest accounts and Points of distribution, the accounts buying each product.
- New accounts, buying after a long gap, and Lapsed accounts, regular buyers who have gone well past their usual gap without buying.
- Coverage: the days each wholesaler has figures for. A short period is missing data, not slow sales.
- Unmapped wholesaler items: items counted under the wholesaler's own name until they are mapped to a product and format.
The account table lists each account's wholesaler, city, premise, rep, first purchase, number of purchases, case equivalents, last purchase, usual gap and days since.
When an account moves from one wholesaler to another it appears under two names. Match accounts lets you confirm which names are the same account, so it counts as one rather than as one stopped and one new. Matches are never made without you.
# Taproom draft loss
Draft loss is recorded per keg when a keg on tap is reconciled. See Draft loss. Draft loss totals by product are not yet reported.
# Produced vs Sold
The Produced vs Sold report includes a periodized view for comparing packaged volume against sold volume.
- Produced volume uses packaged BBLs, because packaged product is what can be sold.
- Sold volume uses the Sales Report "Show All" scope, including taproom source policy.
- The table shows packaged, sold, and net change by period.
- Batch-level produced-vs-sold detail remains available for drilldown and reconciliation.
# Compliance Reports
# Available Reports
TTB Quarterly Operations + Return
- Production tracking
- Sales and removals
- Tax calculations
- Beginning/ending inventory
Arizona Form 835
- Monthly/Annual reporting
- Tracks in-state and out-of-state sales
- Includes wholesale and retail volumes
Arizona Annual Production Report
- Total gallons produced
- Self-distribution volumes
- Multi-facility totals
# Report Generation
- Select report type
- Choose facility
- Select reporting period
- Enter required information:
# Period-end inventory counts
The quarterly report's physical ending inventory comes from each bonded location's count for the last month of the quarter. A count can be taken up to 7 days after the month closes and still be that month's inventory; see Inventory period.
- Late counts roll back to the close. Variances from a count taken after the quarter ends are reported in the quarter it was for, location by location. If rolling a shortage back would take stock below zero at the close, the remainder is reported on the count date instead. See How variances are reported.
- Each location needs its own count. The audit status lists any bonded location without a completed count for the quarter's last month.
- File on book. If a location missed its period-end count, select File on book next to it. That location's book inventory is used for the ending and its next count's variances land in the following quarter. Select Require count to undo. Filing with any location on book requires an override reason, and the filing records which locations were filed on book and their uncounted volume.
# Best Practices
- Keep production records up to date
- Maintain accurate sales data
- Review reports before submission
- Archive generated reports
# Export Options
- PDF generation for official forms
- CSV export for data analysis