LEAFLEDGER · GUIDE

Preparing TTB 5210.5 from a spreadsheet.

There's no official workbook — TTB publishes the form, and everyone builds their own sheet behind it. Here is what that sheet has to contain, when it's genuinely enough, and the four ways it goes wrong.

What the workbook has to contain

One tab per product class you report, each in that class's unit — sticks for cigarettes and cigars, pounds for snuff, chewing tobacco, pipe tobacco and roll-your-own. Every tab has the same shape:

Plus a tab holding the conversion factors you use, written down once and referenced — never applied from memory in a formula.

The three checks the sheet must do

1. Roll-forward. Opening + additions − removals = closing, per class, in exact arithmetic.
2. Book to count. Computed closing against the physical inventory. A difference is a finding to explain, not a number to adjust.
3. Tax tie-out. Tax-paid removals × the class rate = the tax on the return for the same month. And the same removal figures feed FDA 3852, so the two agencies see one set of numbers.

The full routine, with the month-end checklist, is in the TTB 5210.5 guide.

When a spreadsheet is enough

One permit, one or two classes, the same person every month, no corrections to prior periods. That's a real situation and a workbook handles it.

The four ways it goes wrong

1. Units. A supplier changes its export from cases to pounds and nobody adjusts the factor. The sheet keeps totalling happily and the filed figure is wrong by a multiple.
2. Rounding. Spreadsheets round to what's displayed. Do that across a year and the tax tie-out drifts by an amount nobody can explain.
3. Back-editing. A prior month gets corrected in place so this month carries forward cleanly. Now the filed report and the workbook disagree, and there's no record of which is right.
4. No trail. A figure on the form can't be traced to the rows it came from, so when TTB asks, the answer is a reconstruction rather than a record. Part 40 expects the records to support the report — that's the standard, not the form itself.