June 27, 2026
How to Calculate COGS from Your Weekly Inventory Counts (The Simple Formula Small Business Owners Actually Use)
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.
The COGS Formula Every Small Business Owner Should Know
COGS = Beginning Inventory + Purchases − Ending Inventory
That's it. Three numbers. And if you're doing weekly counts, you already have all three.
Stop Doing This Manually.
14-day free trial. No credit card. No POS needed.
Track My First Week Free →A Real Cafe Example
Let's say you run a coffee shop. At the start of the week:
- Beginning inventory value: $1,800
- Purchases made during the week: $620
- Ending inventory (counted Friday): $1,540
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.
Stop Doing This Manually.
14-day free trial. No credit card. No POS needed.
Track My First Week Free →COGS Benchmarks by Vertical
Here's what healthy looks like across business types:
- Restaurants & cafes: 28–35%
- Bars: 18–24%
- Food trucks: 25–35%
- Retail boutiques: 35–50%
- Gyms (retail/supplement): 20–35%
- Salons/spas (retail products): 15–25%
If you're above your benchmark, weekly counts tell you exactly where the leak is — before it compounds into a monthly disaster.
Stop Doing This Manually.
14-day free trial. No credit card. No POS needed.
Track My First Week Free →Why Weekly Beats Monthly for COGS
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.
How TrackItWeekly Connects to This Formula
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.
Break Up With My Spreadsheet.
14-day free trial. No credit card. No POS needed.
Ditch the Spreadsheets Free →Frequently Asked Questions
What is COGS in a small business?
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.
How often should I calculate COGS?
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.
What's a good food cost percentage?
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.
Can I calculate COGS from my inventory app?
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.
Why does my COGS percentage keep changing?
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.
Think you know your inventory vocabulary? Prove it.
Six free games built for operators. No signup.