Skip to main content

TTB Distillers Report of Production Operations Data Sources

Distillery guide to how Encompass fills the TTB Monthly Report of Production Operations (5110.40) from distillation production orders, brand TTB categories and tax codes. Needs Setting 553 and DSP tax entities; v24.12+.

B
Written by Bailey Naas-Thornton

Minimum Version Required: 24.12

Pre-Conditions

  • Setting 553: Enable Manufacturing, Production Orders & Job Costing = 1, True
    ​
    ​

  • Tax Entities exist for the Distilled Spirits Plant (DSP) permit being reported
    ​

  • Tax Entities are properly applied to Product Types for those Products that are participating in DRO reporting.

Steps

Report Foundation:

  • Calculations are based on data from a chosen Location and its related Tax Entity.
    ​
    ​

  • Invoice Load Sheets must be in Loaded, Returned, Balanced or Verified status
    ​

  • Production Orders must be in Confirmed or Verified status
    ​

  • FIFO Adjustment and Inventory Adjustment Invoices created without a Customer TTB Tax Code are omitted.

Form 5110.40 - MONTHLY REPORT OF PRODUCTION OPERATIONS

PART I - TRANSACTION LINES

1. TAX PAYMENT: Not Supported

2. USE OF U.S.: Sum of Products with Brand with TTB Category 1: Spirit removed from inventory through an Invoice using Customer with TTB Tax Code: Used by U.S. Government without Tax

3. HOSPITAL, SCIENTIFIC, OR EDUCATIONAL USE: Sum of Products with Brand with TTB Category 1: Spirit removed from inventory through an Invoice using Customer with TTB Tax Code: Used in Hospital or Science or Education

4. EXPORT: Sum of Products with Brand with TTB Category 1: Spirit removed from inventory through an Invoice using Customer with TTB Tax Code: Export

5. TRANSFER TO FOREIGN TRADE ZONE: Not supported at this time.

6. TRANSFER TO CMBW: Not supported at this time.

7. USE AS SUPPLIES ON VESSELS OR AIRCRAFT: Sum of Products with Brand TTB Category 1: Spirit removed from inventory through an Invoice using Customer with TTB Tax Code: Used as Supplies on Ship or Aircraft

8. USE IN WINE PRODUCTION: Sum of Products with Brand TTB Category 1: Spirit as Raw Materials input removed from inventory through a Production Order of Production Order Type: Production, Distillation, to produce Wine Products with Brand TTB Category 1: Wine

9. ENTERED IN PROCESSING ACCOUNT: Not Supported because the inventory generated after the completion of the production order always directly enters the Storage Account

10. ENTERED FOR TRANSFER IN BOND: Sum of Products with Brand TTB Category 1: Spirit removed from inventory through an Invoice using Customer with TTB Tax Code: Received in Bond

11. ENTERED IN STORAGE ACCOUNT: Sum of Products with Brand TTB Category 1: Spirit produced and brought into inventory through a Production Order of Production Order Type: Distillation

12. WITHDRAWN FOR RESEARCH, DEVELOPMENT, OR TESTING: Sum of Products with Brand TTB Category 1: Spirit removed from inventory through an Invoice using Customer with TTB Tax Code: Research and Development

13. Blank

14. PRODUCED (Total, Lines 1 through 13): Automatically calculated as the sum of lines 1-13

15. RECEIVED FOR REDISTILLATION: Sum of Products with Brand TTB Category 1: Spirit and Production Component Type: Raw Material and Product Types TTB Process Type: Produced or Loss consumed through a Production Order of Production Order Type: Distillation

16. Blank: Not supported: Samples returned for redistillation

17. PHYSICAL INVENTORY END OF CALENDAR QUARTER:

  • Only populate lines 17a and 17b if the End Date selected is the last day in the quarter.

a. RECEIVED FOR REDISTILLATION: Sum of Products with Brand TTB Category 1: Spirit consumed through a Production Order of Production Order Type: Distillation

b. UNFINISHED SPIRITS: Sum of Products with Brand TTB Category: Unfinished Spirit and TTB Category 1: Spirit produced through a Production Order where Production Order Type: Distillation

PART II - PRODUCTION OF ALCOHOL AND SPIRITS OF 190 PROOF OR MORE BY KIND OF MATERIAL USED

Products consumed through a Production Order of Production Order Type: Production, Distillation, Brand TTB Category 2: Alcohol and Spirits, where the consumed materials are of Production Component Type: Raw Material, Wasted Raw Material and TTB Category 2: Grain and have ProductionOrders.Proof >= 190. Row is determined by Brand TTB Category 2 and TTB Category 3.

PART III - PRODUCTION OF WHISKY BY KIND AND COOPERAGE USED

Matches Production line 11 for Whiskey items, split by Brand TTB Category 2: Whisky, Blended Whiskey, and Domestic Whiskey, categorized by Equipment.

PART IV - PRODUCTION OF BRANDY BY KIND

Products with Brand TTB Category 1: Spirit and TTB Category 2: Brandy produced through a Production Order of Production Order Type: Distillation. Rows are determined by Brand TTB Category 3 of brandy produced.

PART V - USED IN REDISTILLATION

Matches Production line 15, categorized by TTB Category 2

PART VI - MATERIALS USED

USED IN PRODUCTION OF DISTILLED SPIRITS: Products with Brand TTB Category: Material consumed through a Production Order of Production Order Type: Production or Distillation and TTB Category 1: Spirit. Rows are determined by Brand TTB Category 2 and TTB Category 3 of material consumed.

USED IN MANUFACTURE OF SUBSTANCES OTHER THAN DISTILLED SPIRITS, IN PROCESSES YIELDING DISTILLED SPIRITS AS A BY-PRODUCT: Products with Brand TTB Category: Material consumed through a Production Order of Production Order Type: Production or Distillation of Production Component Type: Byproduct with Brands TTB Category 1: Spirit. Rows are determined by Brand TTB Category 3 and TTB Category 2 of material produced.

Did this answer your question?