# Physical Inventory Audits
A physical inventory audit compares what is actually on the floor with what the books say, and posts the difference as adjustments. Audits run from Inventory → Product on Hand, one facility and location at a time.
The workflow is split the way the work is:
- On the floor, people count each product and format by area. They write down what they can see, which is the code printed on the unit, and nothing more.
- At the desk, someone with the lot list and the book on screen enters those counts against lots, resolves anything that does not match, and completes the audit.
# Before you start
- Audits require the Inventory Admin role. See Roles & Access.
- Count sheets are printed by count area. Set up count areas for the location in Settings → Inventory Layout first. See Locations within a facility.
- You do not need every movement entered before you count. Counts can be saved while receipts, packaging, transfers and sales for the period are still being caught up. They must all be in before you complete the audit.
# Print count sheets
- Open Inventory → Product on Hand.
- Choose the facility and location to count.
- Open Audits and choose Print Count Sheets.
The packet contains:
- Area sheets, one per count area. Each has space for counter, verifier, start and end time, and a row for each product and format. Counters record the code on the unit, position, stacks, units per stack, loose units, loose packs, a total and notes.
- A Completeness Checklist listing every product and format with stock in the book, and the codes the book expects. Use it to confirm that each SKU was counted, was found to be zero, or does not apply to that area.
The sheets are blind. They do not show book quantities, so counters record what is there rather than confirming a number.
# Start or resume an audit
An audit covers one as-of date, one facility and one location. Select all three on Product on Hand. The main button in the Audits menu then changes to fit that scope:
- Start Audit: no audit exists for this scope yet.
- Resume Audit: a draft for this scope has been saved.
- View Audit: the audit for this scope is complete. It opens read-only.
The button is unavailable while All Facilities or All Locations is selected.
You can also start from Inventory → Audits. New Audit asks for the facility, location and count date, then opens Product on Hand with them selected and the Audits menu open, so the next click is Start Audit. If that location already has an audit for that date, it offers to resume or view it instead. Only Inventory Admins see New Audit.
Starting an audit puts the grid into audit mode and opens the audit panel along the bottom of the page. A dot beside each product and format shows where it stands:
- Not counted.
- Some lots still uncounted, or a saved count that needs review.
- Counted with a variance.
- All lots confirmed at book quantity.
Hover over a dot to see what it means.
On a large audit, choose Needs review above the grid to show only the products with a SKU still to do: not counted, partly counted, flagged for review, a pending package log, or a same-day movement to place. Its badge shows how many SKUs remain. In the rows it keeps, SKUs that are already settled are faded. Choose it again to show every row.
# Enter counts
Click a product and format in the grid to open its count. The dialog lists every lot the book holds for that SKU at this location, with its date code, book quantity, count and variance.
- Enter the Count sheet total: the SKU's total from the paper sheet.
- If the SKU has one lot, that is the count. There is nothing else to enter.
- If it has more than one, enter a Lot Count for each lot from the date codes on the sheet. The lot counts must add up to the sheet total before the counts can be saved. Left to assign shows what remains. Enter 0 for a lot that was not there, or choose Set the rest to 0 once the total is fully assigned.
- Set physical count to book value fills in a lot that matched.
- Choose a Reason for any lot with a variance:
- Cause undetermined
- Damage or breakage discovered
- Prior count error
- Mislocated inventory
- Lot/date-code reclassification
- Unrecorded opening inventory
- Other
- Choose Save Counts.
Bev Deck never splits a sheet total across lots for you. Which lot a unit belongs to is read from its date code, and freshness reporting depends on those per-lot numbers.
# Movements on the count date
A shipment, taproom draw or other movement dated on the audit date may have happened before or after the count. A clock on a grid cell marks a SKU with such a movement still to place. A lot the movement took to zero stays in the grid so it can be counted.
The count dialog lists each one under Same-day movements. For each, choose Before count or After count. Each option shows what the book would be. If the count matches only one of them, the dialog points it out, but the choice is yours.
- A movement with a recorded time defaults to the side of the count time it falls on. You can change it.
- Taproom Consumption with no recorded time is proposed as After count, since taproom tappings typically happen after the count. Change it if this one was earlier. The proposal is kept when you save the SKU.
- Any other movement with no recorded time, or any movement when the audit has no count time, must be placed before the SKU can be saved.
- Each movement is named for where it went: Taproom (Paradise Valley) Delivery, Transfer to Prescott, Delivery (customer) or Pickup (customer).
- Placements depend on each other. Stock can't leave before it arrived, so if a lot was packaged or received on the count date, a shipment from it can only be before the count if the packaging or receipt was too. An option that would take a lot below what was there shows not possible, and the dialog won't save until the placements agree. An audit can't be completed while any lot is left that way.
- A placement applies to the whole movement. A shipment that took several SKUs moves all of their books, and Check Book flags the other SKUs whose saved book changed.
- A movement placed earlier in the audit shows who placed it and when, and names the counted SKUs whose book it sets. Switching it brings up This changes an earlier decision, which lists the SKUs that will change, with a button to keep the earlier choice. Nothing changes until you save.
Tracked casks are counted individually, one line per cask.
Saving stages the counts. Nothing is posted to inventory until the audit is completed.
# Stock that is not on the list
If the count turns up a lot that is not listed for the SKU, choose Add Unlisted Lot:
- A lot that has depleted out of the book: the code on the unit matches a lot the book shows as gone. Pick it from Historical lot, and the count restores it.
- Stock with no readable lot identification: the code is missing or unreadable. Enter the Quantity found and a Reason. A lot recorded this way has no date code, so it cannot be aged for freshness or traced in a recall. If you can read a batch number or package date, use the first option instead.
# Product or format missing from the books
If you find a product and format with no book inventory at this location at all, use Add Missing in the audit panel. Add Inventory Missing From the Books takes the product, format, quantity and reason, and optionally restores a matching depleted lot.
If the quantity matches a packaging run that was never logged, the dialog offers Treat matching quantity as pending package log. This stages a pending package-log exception instead of an overage, so the run gets logged properly rather than becoming an audit adjustment.
# Count date and count time
The audit panel shows the date and time the count is true as of. Click either one to change it.
- Change Audit Date moves the audit to the date the count was actually taken. Saved counts are kept. Book quantities must then be refreshed for the new date before the audit can be completed.
- Count Time sets the moment on that date the count reflects. Movements recorded later that day are left out of the book the count is compared against. Movements on that date with no recorded time are counted in the book until you place them. The panel flags them, and each SKU's count dialog asks whether they happened before or after the count. See Movements on the count date.
# Inventory period
The panel also shows which month's inventory the count is for. TTB allows the monthly inventory to be taken up to seven days after a month closes, so a count on October 3 can be September's inventory.
- A count in the first seven days of a month is the prior month's inventory by default. Use the month button beside inventory for to choose the count month instead.
- A count later in the month is that month's inventory, and there is nothing to choose.
- Changing the count date keeps the chosen month if the new date still allows it. Otherwise it resets to the default for the new date.
The inventory period decides where compliance reports the audit's variances. See How variances are reported.
# Check the book
The book can change after you count, for example when a late transfer or a package log is entered for the audit date. Check Book compares the book quantities saved with the audit against the current book as of the count time.
If anything moved, a notice appears in the panel. Review Changes opens Book Inventory Changes, which shows each affected lot's saved book, current book, physical count and new variance. Preserve Counts and Refresh updates the book side and keeps every physical count you entered.
A lot that appeared in the book after you counted cannot inherit a count. It has to be counted before the audit can be completed.
A lot deleted after you counted it, for example when a package log is removed, has no book left. Refreshing sets its book to 0 and keeps the line. If it was counted at 0, it closes as confirmed. If stock was counted against it, restore the lot, or set that count to 0 and record the stock with Add Missing.
# Audit panel
The panel shows:
- Progress: lots counted out of lots required, and how many are still awaiting a count.
- Lot totals: Confirmed, Adjusted and New.
- Shortage and Overage: the gross units short and over across the audit.
- Notices: anything that blocks completion or needs a look, such as changed book lines, new lots that need a count, saved counts on lots that dropped to zero, and movements on the audit date with no time.
# Complete the audit
Complete becomes available once every lot in the book has been counted, the book has been refreshed after any changes, and no saved count is waiting for review.
Before completing, make sure all receipts, packaging, transfers, sales and other movements through the audit date are entered, then use Check Book one last time.
Complete Physical Inventory Audit shows the gross shortage and overage. Confirm the attestation that the counts are accurate and that all known movements through the audit date are entered, then choose Post Adjustments and Complete.
Completion locks the audit. The variances are calculated against the book as of the count time, and the adjustments post today. Inventory reports and the stock ledger show them on the posting date.
# How variances are reported
The quarterly TTB report places a variance by the count, not by the posting date:
- A count taken on or before the close of its inventory period is reported on its count date.
- A count taken after the close, within the seven grace days, is rolled back to the last day of its inventory period. Each location is rolled back from its own count date. An October 3 count for September reports its shortages and overages in the quarter that ended September 30.
- Stock that did not exist at the close cannot be short at the close. When a rolled-back shortage is larger than what the book held for that lot at month end, or an overage is on a lot packaged after the close, that part is reported on the count date instead. Nothing estimates when the rest went missing.
Only a count for the quarter's last month can anchor that quarter's ending inventory. A count outside the grace days cannot stand in for it. Its variances belong to the period it was counted in.
If a bonded location has no qualifying count, a compliance manager can choose File on book for that location on the compliance report. The location is then filed on its book ending. Finalizing the return still requires an explained override, and the filing records which locations were filed on book.
# Drafts
An audit stays a draft until it is completed. Drafts are listed in two places:
- At the top of Inventory → Audits, each with Resume.
- Under Draft Audits in the Audits menu on Product on Hand, with a badge showing how many are open.
Resuming a draft opens it on Product on Hand where you left off.
To abandon a draft, use the delete icon beside it in the menu. Discard Draft removes the draft and its staged counts. A draft that already has posted adjustments cannot be discarded.
# Audit records
Inventory → Audits lists every audit for the account, with facility, location, date, status and BBLs. View All Audit Records in the Audits menu on Product on Hand opens the same list. Click a completed audit to open its record. Clicking a draft resumes it instead.
An audit completed with this workflow opens as a Physical Inventory Audit record. It shows:
- The date, facility and location, and the status.
- Confirmed and adjusted lot counts, and the shortage and overage in units and BBLs.
- Who attested the counts, and when.
- Every lot counted: product, format, date code, book, physical and variance, with the reason, any note, and any corrections made after completion.
Accounts that used the earlier audit tool also have records from it in the same list. Those open in the earlier audit view, which shows them as they were recorded.
# Correct a completed audit
Choose Correct when a count turns out to be wrong after completion. Typical causes are a misread code or a sheet found later. Correct is on the audit panel when you open a completed audit with View Audit, and beside each lot in its audit record.
In Completed Audit Correction:
- Choose the Inventory lot. The dialog shows its book quantity and current effective count.
- Enter the Corrected physical count and a Correction reason.
- Write a Correction explanation naming the record or operational fact that establishes the corrected count. The explanation is required.
A correction posts on the original audit date, not today, because it fixes what was on hand at the time of the count. For compliance it is reported with the audit it corrects, in the same inventory period. The original attestation and counts are kept. The panel shows how many times the audit has been corrected, and earlier corrections are listed under Prior Corrections.
# Movements entered after an audit completed
Sometimes a movement dated on or before a completed count is entered after the audit completed. A typical case is a sale from mid-March that was missed and is recorded after the March 31 count closed. The count already reflects that stock leaving, because the units were gone when they were counted. Until the audit is updated, the movement is double-counted:
- The variance the audit posted still includes the units the sale explains.
- The book now deducts them a second time.
For example, 10 half-barrel kegs are on the books, the count finds 3, and the audit posts a shortage of 7. A 3-keg sale dated March 15 is then recorded. For the quarter, the sale reports 1.5 BBL removed for sale, the audit still reports a 3.5 BBL shortage, and ending inventory falls to 0, even though 3 kegs are on the shelf.
# The warning when you enter it
When a movement's date is on or before a completed count at its source or destination location, the movement form shows Dated on or before a completed count. This is a warning only. A backdated movement is often the correction itself, so saving is never blocked. The warning does not appear for a movement that reached inventory before the audit posted, because that movement was already in the book the count was compared against.
# Re-true the audit
After saving the movement, open the audit from Inventory → Audits. When the book at the count has changed, the record says so and offers Re-true. Re-true needs the same access as Correct.
Re-true does the following:
- Keeps every count as attested. Only the book side moves. Each changed lot shows its original book struck through beside the new one, and the variance is recalculated against the new book.
- Works lot by lot. Each lot's adjustment equals the change in that lot's own book at the count. Nothing is spread across lots. If the late sale drew a different lot than the one the count found short, that lot shows an overage and the other keeps its shortage. Entering the sale on time would have produced the same result.
- Posts beside the original adjustment. Re-true adjustments post on the audit's posting date, so they offset the original on the same day. For compliance they are reported with the audit, in the same inventory period. An audit's adjustments and re-trues net into one variance per lot.
- Reports lots it cannot fix. A lot that now has stock at the count but was never counted is listed, not adjusted. Re-true does not guess a count for it. Count it, or correct the movement.
- Runs once per change. A second re-true with nothing new to apply changes nothing.
Re-true audits oldest first. Each count's book includes every earlier audit at that location. Re-truing a later audit first measures it against an earlier variance that is about to change, so it would need a second re-true.
A re-true that removes stock can leave the lot below zero after later movements. For example, the count found nothing but a delivery went out the next day. When a later completed count of the same lot at the same location exists, the re-true still posts, and the record names that audit. That later count pins the lot's balance, so re-truing it next brings the lot back to what was counted. If there is no later count, re-true stops. The message names the lot, the location, the book change and how much stock remains. Correct or reallocate the later movements first.
In the example, the re-true moves the lot's book from 10 to 7. The variance against the count of 3 becomes −4. The quarter then reports 1.5 BBL removed for sale, a 2 BBL shortage, and 1.5 BBL ending inventory. This is the result you would have had if the sale had been entered before the count. A count taken in the grace days and rolled back to the close gives the same result.
On the compliance report, an audit that needs a re-true shows up as a coverage mismatch: the book at the count no longer matches the audit's book. Re-truing clears the mismatch.
# Filed quarters
Re-truing an audit in a quarter that has already been filed changes that quarter's computed figures. The filed return is not changed. The next quarter still opens on the filed ending inventory, and the difference shows up when the quarters are reconciled.