If you're doing weekly inventory counts but not connecting them to your COGS, you're leaving money on the table. The formula is simple — and once you understand it, weekly counts become your most powerful profit tool.
COGS = Beginning Inventory + Purchases − Ending Inventory
That's it. Three numbers. And if you're doing weekly counts, you already have all three.
Let's say you run a coffee shop. At the start of the week:
COGS = $1,800 + $620 − $1,540 = $880
If your weekly revenue was $4,200, your food cost percentage is 20.9% — right in range for a cafe. If that number was 35%? You'd catch it this week, not at the end of the quarter.
Here's what healthy looks like across business types:
If you're above your benchmark, weekly counts tell you exactly where the leak is — before it compounds into a monthly disaster.
Monthly COGS calculations are a postmortem. By the time you run the numbers, four weeks of shrinkage, over-ordering, and waste have already happened.
Weekly counts give you a rolling view. You catch a spike in usage week 2 — not after 30 days of damage. You adjust your ordering before you're hemorrhaging margin.
The math is the same. The timing is everything.
TrackItWeekly was built around the weekly count workflow. When your team completes a count, the app tracks on-hand, ordered, received, and usage per item — the exact data points that feed your COGS calculation.
No spreadsheet gymnastics. No end-of-month scramble. Just a 30-minute weekly process that keeps your numbers current.
Start your free 14-day trial — no credit card required.
COGS (Cost of Goods Sold) is the direct cost of the products you sell or use in your business. For restaurants, it's food and beverage. For retail, it's the wholesale cost of merchandise. It's calculated as: Beginning Inventory + Purchases − Ending Inventory.
Weekly is best for food service and retail. Monthly is the minimum. Operators who calculate COGS weekly catch margin problems 3–4 weeks earlier than those who run monthly reports.
For restaurants and cafes, 28–35% is healthy. Bars typically run 18–24%. If you're consistently above your benchmark, look at portion sizes, waste, theft, and supplier pricing.
Yes — if your app tracks beginning inventory, purchases, and ending inventory per count cycle, you have everything you need. TrackItWeekly captures all three in a 30-minute weekly count.
Variance in COGS usually comes from shrinkage (waste or theft), inconsistent portion sizes, supplier price changes, or over-ordering. Weekly counts let you isolate which variable is driving the change.