Skip to main content

TTB Excise Tax Return

Brewery/distillery steps in Encompass for generating the TTB Excise Tax Return (Form 5000.24) PDF from BRO or DRO reports, reviewing past returns and correcting them. Needs TTB Reporting access; v26.02+.

B
Written by Bailey Naas-Thornton

Minimum Version Required: 26.02

Pre-Conditions

Before generating a return, reports for the relevant Brewery Report of Operations (BRO) or Distilled Spirits Plant Operations (DRO) reports for the specific tax period should be created and reveiwed. Note: Finalized versions are not required to create the Excise Tax Form but are strongly recommended to maintain integrity in annual taxable volume and effective tax rates.

You must also have the appropriate user permissions to access the TTB Reporting dashboard and the system's document storage.

Steps

Creating the Excise Tax Return form:

The system automates the preparation of Form F5000.24 by pulling data directly from your BRO or DRO reports and applying tax rates based on your annual cumulative taxable volume withdrawals.

  1. Navigate to the TTB Excise Tax Return dashboard.

  2. Set the Start and End Date in alignment with the TTB Filing Period that you are filing for.

  3. Create Report

  4. Locate the option to generate the TTB Excise Tax Return PDF.

  5. Once generated, the system automatically calculates the tax due based on cumulative taxable volume withdrawals and the volumes recorded in the current BRO or DRO report you are creating the form from.

  6. Open the generated PDF to review the auto-populated values. If specific adjustments are required, you may edit the fields directly within the document. Note: This may result in a misalignment with system-calculate taxable removals.

  7. The finalized form is automatically saved to the system's document table for record-keeping and future retrieval.

Investigating past Excise Tax Return forms:

  1. Navigate to the Excise Tax History table

  2. Search for the Filing Period dates you want to review

  3. Click on the TTB Report ID to view the underlying BRO or DRO that contributed to the that period's calculation

Correcting past Excise Tax Return forms:

  1. If an error is identified after the form has been generated, simply create and save a new BRO or DRO report for that filing period and tax entity once the underlying transactions or configuration has been corrected.

  2. Note: This will overwrite the previous Excise Tax History values for that period and tax entity and recalculate annual taxable volume and effective tax rate.

Fields And Definitions

TTB Filing Periods and Tax Rates used by Encompass are sourced from the TTB website.

Best Practices

Always verify that the underlying BRO or DRO reports are accurate before generating the tax return to ensure the most accurate data is used for calculations.

Review the generated PDF thoroughly. While the system automates calculations, the editable nature of the PDF allows you to make necessary manual adjustments to meet specific federal requirements.

Did this answer your question?