Skip to main content

TTB Distillers Report of Storage Operations Data Sources

Distillery guide to how Encompass fills each line of the TTB Monthly Report of Storage Operations (5110.11) from inventory, production orders and TTB tax codes. 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.11 - MONTHLY REPORT OF STORAGE OPERATIONS

Transaction Lines

1. On hand first of month: Sum of Inventory on the given start date of all Products with Brand TTB Category 1: Spirit or Wine and with Product Type TTB Process Type: Produced or Loss. Rows are determined by Brand TTB Category 1 and TTB Category 2 of spirit produced. Should equal Line 23 from the previous month’s report.

2. Deposited in bulk storage: Sum of Products with Brands TTB Category 1: Spirit, Wine either produced and brought into inventory through a Production Order of Production Order Type: Distillation OR received on a Purchase from an outside source or as a transfer from another location.

3. Received from Customs custody: Not Supported

4. Returned to bulk storage: Sum of Products with Brand TTB Category 1: Spirit or Wine and Product Type TTB Process Type: Produced or Loss brought back into inventory on a negative Invoice. Rows are determined by Brand TTB Category 1 and TTB Category 2 of spirit produced.

5. Blank

6. TOTAL (Lines 1 through 5): Sum of lines 1-5

7. Taxpaid: Not Supported

WITHDRAWN FOR - Transaction Lines

8. Use of the United States: Sum of Products with Brands TTB Category 1: Spirit or Wine and Product Type TTB Process Type: Produced or Loss removed from inventory through an Invoice using Customer with TTB Tax Code: Used by U.S. Government without Tax

9. Hospital, scientific educational use: Sum of Products with Brand TTB Category 1: Spirit or Wine and Product Type TTB Process Type: Produced or Loss removed from inventory through an Invoice using Customer with TTB Tax Code: Used in Hospital or Science or Education

10. Export: Sum of Products with Brands TTB Category: Spirit or Wine and Product Type TTB Process Type: Produced or Loss removed from inventory through an Invoice using Customer with TTB Tax Code: Export

11. Transfer to foreign-trade zone: Not Supported

12. Transfer to CMBW: Not Supported

13. Use as supplies on vessels and aircraft: Sum of Products with Brands TTB Category 1: Spirit or Wine and Product Type TTB Process Type: Produced or Loss removed from inventory through an Invoice using Customer with TTB Tax Code: Used as Supplies on Ship or Aircraft

14. Transfer to bonded winery: Sum of Products with Brand TTB Category 1: Spirit or Wine and Product Type TTB Process Type: Produced or Loss removed from inventory through an Invoice using Customer with TTB Tax Code: Transfer to Distillery

15. Transfer to CBW: Not Supported

16. Research, development, or testing: Sum of Products with Brand TTB Category 1: Spirit or Wine and Product Type TTB Process Type: Produced or Loss removed from inventory through an Invoice using Customer with TTB Tax Code: Research and Development

17. Transferred to processing account: Sum of Products with Brand TTB Category 1: Spirit or Wine and Product Type TTB Process Type: Produced or Loss consumed through Production Orders of Production Order Type: Processing Blend

18. Transferred to production account: Sum of Products with Brand TTB Category 1: Spirit or Wine and Product Type TTB Process Type: Produced or Loss consumed through a Production Order of Production Order Type: Distillation

19. Transferred to other bonded premises: Sum of Products with Brand TTB Category 1: Spirit or Wine and Product Type TTB Process Type: Produced or Loss removed from inventory through an Invoice using Customer with TTB TaxCode: Transfer Out In Bond

20. Destroyed: Sum of Products with Brand TTB Category 1: Spirit or Wine and ProductType TTB Process Type: Produced or Loss removed from inventory through an Invoice using Customer with TTB TaxCode: Destroyed

21. Blank

22. Other Losses: Sum of Products with Brand TTB Category 1: Spirit or Wine and Product Type TTB Process Type: Produced or Loss removed from inventory through an Invoice using Customer with TTB Tax Code: DRO Storage Loss/Gain

23. On hand end of month: Sum of Inventory on given end date of all Products with Brand TTB Category 1: Spirit or Wine and Product Type TTB Process Type: Produced or Loss. Rows are determined by Brand TTB Category 1 and TTB Category 2 of spirit produced.

24. TOTAL (Lines 7 through 23): Sum of lines 7-23

Did this answer your question?