Have your TTB excise tax numbers ready before the deadline
Every Monday, WebRun opens Crafted ERP, pulls production volumes, taxable removals, and tax-determined quantities for the prior reporting period, compiles them into a structured Google Sheet summary aligned with TTB Brewer's Report of Operations categories, and posts a Slack alert for your accountant to review before filing.
- No credit card
- Under $0.01 per run
- Cancel anytime
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
app.craftederp.comin a real browser with your saved login - no setup, no API keys. -
1
Crafted ERP - pull production, removal, and taxable quantity data
craftederp.com
WebRun opens Crafted ERP to pull production, removal, and taxable quantity data. - Open Crafted ERP and navigate to compliance or production reporting
- Pull total barrels produced for the reporting period
- Pull taxable removals broken down by tax class (domestic, export, draft, bottled/canned)
- Pull any tax-free removals, transfers to bonded premises, or losses
- Confirm the reporting period covers the correct TTB quarter or semi-monthly window
Done when All production, removal, and tax-determination figures for the period are captured.
-
2
Google Sheets - compile pre-filled tax summary by TTB category
google.com How to Automate Google Sheets
WebRun opens Google Sheets to compile pre-filled tax summary by TTB category. - Open the TTB excise tax prep Google Sheet
- Enter figures into each relevant TTB Brewer's Report of Operations line
- Calculate the total tax liability using current TTB tax rates for each class
- Flag any line where the figure differs from the prior period by more than 20% for accountant attention
- Leave the sheet unlocked for the accountant to adjust before filing
Done when The Google Sheet has a complete set of pre-filled TTB report figures with the calculated liability.
-
3
Slack - alert accountant to review before filing
slack.com How to Automate Slack
WebRun opens Slack to alert accountant to review before filing. - Post a Slack alert to your finance or compliance channel
- Include total barrels produced, taxable removals, and calculated liability for the period
- Add a link to the Google Sheet and note any flagged variances
- Prompt the accountant to review the sheet and file before the TTB deadline
Done when Accountant has a Slack prompt with the period totals and a link to the prep sheet.
How do I automatically prepare my TTB brewery excise tax report?
WebRun pulls production volumes, taxable removals, and tax-class breakdowns from Crafted ERP every week, enters them into a structured Google Sheet aligned with TTB Brewer's Report of Operations categories, calculates the estimated liability, and alerts your accountant in Slack to review the figures before the filing deadline.
- TTB report prep is ready days before the filing deadline with no manual data pull
- Period-over-period variances are flagged automatically for accountant review
- Filing remains a human action so accuracy and compliance stay in expert hands
Built for craft breweries · craft distilleries · wineries · compliance managers · brewery accountants
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Will it file the TTB report automatically?
No. WebRun prepares and pre-fills the summary sheet, then alerts your accountant to review the figures. The actual TTB filing is done by a human after reviewing the prep sheet.
Which TTB report does it prep for?
It targets the TTB Brewer's Report of Operations, covering production, taxable removals, and tax-free removals. Distillery and winery versions can be configured to map to the equivalent TTB reports for those producer types.
What if a figure looks wrong compared to last period?
Any line in the Google Sheet that differs from the prior period by more than 20% is flagged automatically in the sheet and noted in the Slack alert, so the accountant knows where to focus their review.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.