Barrel ReportDo this from your brew log

Federal excise tax on 5,000 barrels of beer

For a domestic brewer making 2,000,000 barrels a year or less, removing 5,000 barrels taxpaid in one calendar year comes to $17,500.00 of federal excise tax: 5,000 x $3.50 = $17,500.00. Change the figures below to test your own year.

Barrels removed taxpaid5,000 bbl
at $3.50/bbl5,000 bbl
Federal excise tax$17,500.00
Effective rate per barrel$3.50
Per US gallon$0.1129
Per case of 24 x 12 oz$0.254
Per 16 oz pint$0.0141
If this is the whole year$17,500.00
Filing frequency at that annual taxquarterly

Runs in your browser; nothing you type is sent anywhere. Arithmetic for your records, not tax advice.

The arithmetic

All 5,000 barrels fall inside the first 60,000 of the calendar year, so every barrel is at $3.50. 55,000 barrels of reduced-rate room remain in the year. The next barrel removed costs $3.50.

$17,500.00 a year is above the $1,000 annual-filing line (about 285.71 barrels at the reduced rate) and not more than $50,000, so on the thresholds below this falls in quarterly filing. Quarterly filing holds at the reduced rate up to about 14,285.71 barrels a year.

If removals were spread evenly over the year

QuarterBarrels removedBarrels so far this yearTax for the quarterRate
Q11,2501,250$4,375.00all at $3.50
Q21,2502,500$4,375.00all at $3.50
Q31,2503,750$4,375.00all at $3.50
Q41,2505,000$4,375.00all at $3.50

The reduced tier counts barrels removed in the calendar year, not per return, so a large year pays more per barrel in its later quarters.

5,000 barrels in other units

MeasureAmountTax per unit
US gallons155,000$0.1129
1/2 bbl kegs10,000$1.75
1/6 bbl kegs30,000$0.5833
Cases, 24 x 12 oz68,889$0.254
16 oz pints1,240,000$0.0141

Other annual volumes

Barrels a yearFederal excisePer barrelFiling frequency
500$1,750.00$3.50quarterly
1,000$3,500.00$3.50quarterly
2,500$8,750.00$3.50quarterly
5,000$17,500.00$3.50quarterly
7,500$26,250.00$3.50quarterly
10,000$35,000.00$3.50quarterly
15,000$52,500.00$3.50semimonthly
30,000$105,000.00$3.50semimonthly
60,000$210,000.00$3.50semimonthly
100,000$850,000.00$8.50semimonthly

Where the numbers come from

Rates: $3.50 a barrel on the first 60,000 barrels removed in a calendar year and $16.00 a barrel from 60,001 to 2,000,000, for a domestic brewer producing 2,000,000 barrels a year or less (TTB tax rates). One barrel is 31 US gallons (27 CFR 25.11). Filing frequency follows the expected annual tax: not more than $1,000 may file annually, not more than $50,000 quarterly, above that semimonthly (27 CFR 25.164). Tax is on beer removed taxpaid, not on what you brewed. This page is arithmetic for your records, not tax advice: check TTB's own guidance before you file.

Questions

How much federal excise tax is due on 5,000 barrels of beer?

At the reduced rates for a domestic brewer making 2,000,000 barrels a year or less, 5,000 barrels removed taxpaid in one calendar year comes to $17,500.00 (5,000 x $3.50 = $17,500.00). That averages $3.50 a barrel.

What is the tax per gallon and per case on 5,000 barrels?

$0.1129 per US gallon and $0.254 per case of 24 x 12 oz cans, on average across the year.

How often would a brewer owing $17,500.00 a year file the excise return?

On the thresholds in 27 CFR 25.164 (not more than $1,000 a year may file annually, not more than $50,000 quarterly, otherwise semimonthly), $17,500.00 a year falls in quarterly filing. Check TTB's guidance before you file.

Related calculators

Doing this every month by hand?

Barrel Report reads your brew-log spreadsheet or POS export, reconciles the barrels against last period and lays out the report of operations and excise figures for you to review and file. $49/mo, first month free for early signups. No payment now.