All templates

Automated Brewery TTB Excise Tax Report Prep

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.

Deploy this workflow Browse all templates
Runs on WebRun · Strict Lockdown policy
Every Monday at 8:00 AM WebRunorchestrates each step
1 Crafted ERP pull production, removal, and taxable quantity data
2 Google Sheets compile pre-filled tax summary by TTB category
3 Slack alert accountant to review before filing
In short

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

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens app.craftederp.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Crafted ERP - pull production, removal, and taxable quantity data
    craftederp.com
    WebRun in Crafted ERP: pull production, removal, and taxable quantity data
    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.

  3. 2
    Google Sheets - compile pre-filled tax summary by TTB category
    google.com
    WebRun in Google Sheets: compile pre-filled tax summary by TTB category
    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.

  4. 3
    Slack - alert accountant to review before filing
    slack.com
    WebRun in Slack: alert accountant to review before filing
    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.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.craftederp.com
ScheduleRuns automatically on this cadence
Every Monday at 8:00 AM
DeliveryHow each run's result reaches you
Tax prep sheet · Google Sheets
OutputWhat each run produces - A Google Sheet with pre-filled TTB Brewer's Report of Operations figures, calculated liability, and variance flags, plus a Slack summary for accountant review.
Spreadsheet
Setup & safety

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.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

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.

Keep going

Related templates

Automated Brewery Batch Packaging Alerts
Every morning, WebRun checks Ekos for batches that have hit their target gravity and conditioning time, and posts a packaging-ready digest to Slack so your team knows what to pull today.
Ekos›Slack
Automated Brewery Club Membership Renewal Emails
WebRun finds club members whose renewal is coming up, drafts a personalized renewal email for each, and queues them for your team to review before any message goes out.
Ekos›Mailchimp›Slack
Automated Brewery Distribution Invoice Chaser
WebRun finds overdue distribution invoices in Ekos, drafts a polite payment-reminder email for each distributor, and posts a Slack summary for your finance team to review before any message goes out.
Ekos›Gmail›Slack

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.

Deploy this workflow Talk to us