Skip to main content

TTB Distillers Report of Processing Operations Data Sources - Parts I & II

Distillery guide to how Encompass fills Parts I and II (bulk ingredients, finished products) of the TTB Monthly Report of Processing Operations (5110.28). Needs Setting 553 and DSP tax entities; v25.01+.

B
Written by Bailey Naas-Thornton

Minimum Version Required: 25.01

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.28 - MONTHLY REPORT OF PROCESSING OPERATIONS

PART l -BULK INGREDIENTS

1. ON HAND FIRST OF MONTH: Inventory on the given start date of all products where Brand TTB Category 1: Spirit or Wine and Product Type TTB Process Type: Produced or Loss. Should equal Line 25 from the previous month’s report.

2. RECEIVED (Other than line 3): Sum of Products with Brand TTB Category 1: Spirit or Wine and Product Type TTB Process Type: Produced or Loss consumed through Production Order of Production Order Type: Processing Blend

3. ALCOHOL FOR FUEL USE RECEIVED FROM CUSTOMS CUSTODY: Not Supported

4. ALCOHOL, FLAVOR, MATERIALS DUMPED: Sum of Products with Brands TTB Category 1: Spirit and TTB Category 3: Other Material consumed through a Production Order of Production Order Type: Processing Blend and using Production Components of Production Component Type: Raw Material or Wasted Raw Material

5. WINE MIXED WITH SPIRITS: Sum of Products with Brand TTB Category 1: Spirit or Wine and Product Type TTB Process Type: Produced produced by a Production Order of Production Order Type: Processing Blend that consumed raw material products where Brand TTB Category 1: Wine.

6. DUMPED FOR FURTHER PROCESSING: Sum of processing inputs of Production Components: Raw Material, Wasted Raw Material with Brands.TTB Category 1: Spirit and Product Types TTB Process Type: Canned, Racked, Bottled, Packaged consumed by a Production Order of Production Order Type: Processing Blend that produced products with Brands.TTB Category 1: Spirit

7. GAINS: Products with Brand TTB Category 1: Spirit or Wine and Product Types TTB Process Type: Produced reintroduced into inventory through an Invoice using Customer with TTB Tax Code = DRO Processing Loss/Gain

8. TOTAL - LINES 1 THROUGH 7: Sum of lines 1-7

9. BOTTLED OR PACKAGED: Sum of WIP Products with TTB Category 1: Spirit that were consumed by a Production Order of Production Order Type: Packaging in producing Finished Products with Brand TTB Category 1: Spirit

10. WINE MIXED WITH SPIRITS: Matches line 5 from above

11. USED FOR DENATURATION: Not Supported

12. TRANSFERRED IN BOND: Sum of Products with Brand TTB Category 1: Spirit and Wine and Product Types TTB Process Type: Produced produced by a Production Order of Production Order Type: Processing Blend that was removed from inventory through an Invoice using Customer with TTB Tax Code: Transfer Out In Bond

13. WITHDRAWN TAX DETERMINED: Not Supported

14. WITHDRAWN FREE OF TAX: FOR U.S., HOSPITAL, SCIENTIFIC, OR EDUCATIONAL USE: Sum of Products with Brand TTB Category 1: Spirit and Wine and Product Types TTB Process Type: Produced produced by a Production Order of Production Order Type: Processing Blend that was removed from inventory through an Invoice using Customer with TTB Tax Code: Used in Hospital or Science or Education

15. WITHDRAWN WITHOUT PAYMENT OF TAX: FOR ADDITION TO WINE: Not Supported

16. FOR EXPORTATION & TRANSFER TO C.B.W.: Sum of Products with Brand TTB Category 1: Spirit and Wine and Product Types TTB Process Type: Produced produced by a Production Order of Production Order Type: Processing Blend that was removed from inventory through an Invoice using Customer with TTB Tax Code: Export

17. TRANSFERRED TO PRODUCTION ACCOUNT FOR REDISTILLATION: Sum of Products with Brand TTB Category 1: Spirit and Product Types TTB Process Type: Produced produced by a Production Order of Production Order Type: Processing Blend and subsequently consumed through a Production Order of Production Order Type: Distillation

18. WITHDRAWN FOR RESEARCH, DEVELOPMENT, OR TESTING (Including Gov.samples): Sum of Products with Brand TTB Category 1: Spirit or Wine and Product Types TTB Process Type: Produced produced by a Production Order of Production Order Type: Processing Blend removed from inventory through an Invoice using Customer with TTB Tax Code: Research and Development

19. DESTROYED: Sum Of Products with Brands.TTB Category 1: Spirit or Wine and Product Types TTB Process Type: Produced produced by a Production Order of Production Order Type: Processing Blend removed from inventory through an Invoice using Customer with TTB Tax Code: Destroyed

20. USED FOR REDISTILLATION: Sum of input components of Production Component Type: Raw Material with Brand TTB Category 1: Spirit or Wine that was consumed through a Production Order of Production Order Type: Distillation

21. Blank

22. Blank

23. Blank

24. LOSSES: Sum of Products with Brand TTB Category 1: Spirit and Wine and Product Types TTB Process Type: Produced that was removed from inventory through an Invoice using Customer with TTB Tax Code: DRO Processing Gain/Loss

25. ON HAND END OF MONTH: Inventory at the end of the reporting period

26. TOTAL - LINES 9 THROUGH: Sum of lines 9-25

PART II - FINISHED PRODUCTS (In bottles or packages)

27. ON HAND FIRST OF MONTH: Finished Product Inventory on hand at the beginning of the reporting period

28. BOTTLED OR PACKAGED: Copied from line 9

29. RECEIVED: Sum Of Products with Brand TTB Category 1: Spirit and Product Types TTB Process Type: Canned, Racked, Bottled, Packaged received by Purchase transactions not associated with a Production Order

30. INVENTORY OVERAGES: Sum of Products with Brand TTB Category 1: Spirit and Product Types TTB Process Type: Canned, Racked, Bottled, Packaged on Invoices that increased inventory (negative invoice trans) using Customer with TTB Tax Code: Overage or Shortage

31. TOTAL -LINES 27 THROUGH 30: Sum of lines 27-30

32. TRANSFERRED IN BOND: Sum of Finished Products with Brand TTB Category 1: Spirit and Product Types TTB Process Type: Canned, Racked, Bottled, Packaged on Invoices removed from inventory using Customer with TTB Tax Code: Transfer Out In Bond

33. WITHDRAWN TAX DETERMINED: Sum of Products with Brand TTB Category: Spirit and Product Type TTB Process Type: Canned, Racked, Bottled or Packaged removed from inventory through an Invoice using Customer with TTB Tax Code: None

34. WITHDRAWN FREE OF TAX: FOR U.S.HOSPITAL, SCIENTIFIC, OR EDUCATIONAL USE： Finished Products with Brand TTB Category 1: Spirit on Invoices using Customer with TTB Tax Code: Used in Hospital or Science or Education

35. WITHDRAWN WITHOUT PAYMENT OF TAX: FOR ADDITION TO WINE：Finished Products with Brand TTB Category 1: Spirit on Invoices using Customer with TTB Tax Code: Removed Without Payment of Tax to Other Brewery

36. FOR EXPORTATION, VESSELS, AND AIRCRAFT, AND TRANSFER TO C.B.W：Finished Products with Brand TTB Category 1: Spirit on Invoices using Customer with TTB Tax Code: Export

37. TRANSFERRED TO PRODUCTION ACCOUNT FOR REDISTILLATION：

38. WITHDRAWN FOR RESEARCH, DEVELOPMENT, OR TESTING (Including Gov. samples)：Finished Products with Brand TTB Category 1: Spirit removed from inventory through an Invoice using Customer with TTB Tax Code: Research and Development

39. DESTROYED: Finished Products with Brand TTB Category 1: Spirit removed from inventory through an Invoice using Customer with TTB Tax Code: Destroyed

40. DUMPED FOR FURTHER PROCESSING: Same as Line 6, but divided over Bottled and Packaged.

41. Blank

42. Blank

43. Blank

44. RECORDED LOSSES: Finished Products with Brand TTB Category 1: Spirit removed from inventory through an Invoice using Customer with TTB Tax Code: DRO Processing Loss/Gain

45. INVENTORY SHORTAGES: Finished Products with Brand TTB Category 1: Spirit on Invoices (positive invoice trans) using Customer with TTB Tax Code: Overage or Shortage

46. ON HAND END OF MONTH: Finished Products inventory at end of period

47. TOTAL - LINES 32 THROUGH 46: Sum of lines 32-46

Did this answer your question?