What's the best way to record monthly inventory adjustments in QuickBooks Online?
Go to Products & Services in QuickBooks Online, select the inventory item you need to adjust, and click Adjust Quantity. Enter the actual count from your physical inventory. QBO compares that number against what the system thinks you have and calculates the difference automatically. You don’t need to figure out the variance yourself.
The adjustment posts to an expense account. By default, QBO uses an Inventory Shrinkage account. Some businesses rename this to Inventory Adjustment to capture both gains and losses, but either way it hits the same place on your profit and loss statement. If you want a different account, you can change it during the adjustment. Just make sure you’re consistent so your reports are comparable month to month.
Do this after every physical count, not just when something looks off. Monthly is a good rhythm for most small businesses carrying inventory. Waiting until year-end to reconcile physical counts against QBO means you’re running your business on inaccurate numbers for months. You can’t make good purchasing decisions if your system says you have 40 units but the shelf has 28.
When you enter adjustments, add a memo or note explaining the reason. Spoilage, theft, damage, miscounts from receiving, or vendor shortages are all common causes. This detail matters when you’re reviewing trends. If shrinkage keeps climbing, you need to know whether it’s a receiving problem or a loss prevention problem. A note that just says “adjustment” tells you nothing useful three months later.
For businesses with a large number of SKUs, consider adjusting by category or location rather than trying to count everything in one session. QBO lets you filter and adjust items individually, so you can spread counts across the month. Count beverages one week, dry goods the next. The important thing is that every item gets counted on a regular cycle.
If your inventory accounting feels like guesswork, the issue is usually that physical counts aren’t happening consistently or adjustments aren’t being recorded when they should be. The QBO feature itself is straightforward. The discipline of counting and recording is where most businesses fall short.
One thing to watch for is the impact on your cost of goods sold. Every inventory adjustment flows through to your financial statements. Large or frequent adjustments can distort your margins and make it harder to understand true profitability. If you’re seeing significant variances every month, that’s a signal to look at your receiving process, storage practices, or how items are being tracked at the point of sale.
A small business bookkeeper who understands inventory can help you set up the right accounts, establish a count schedule, and review your adjustment trends so the numbers in QBO actually reflect what’s on your shelves.
Central Florida's Trusted Bookkeeping Firm
Start Here:
A 30-Minute Consultation
Tell us about your business and what's going on with your books. We'll figure out exactly what you need, and give you a straightforward quote.
More Questions
How do I use QuickBooks classes to track profit and loss per rental property?
In QuickBooks Online Plus or Advanced, create a class for each property and assign it to every income and expense transaction. Then run the Profit and Loss by Class report to see exactly how each property is performing.
Read answerWhat should I expect during the first month after hiring a new bookkeeper?
The first month is mostly onboarding and assessment. Expect a lot of questions, access requests, and an honest evaluation of where your books stand before regular monthly work begins.
Read answerHow does a food truck owner handle bookkeeping differently than a restaurant?
Food truck bookkeeping revolves around tracking revenue by location, managing vehicle expenses, handling commissary kitchen costs, and staying on top of variable event fees and permits. The mobility that makes the business model appealing is exactly what makes the financial tracking more complex than a fixed-location restaurant.
Read answerWhat financial reports should a restaurant owner look at every week, not just every month?
Restaurant owners should review their cash position, labor cost percentage, food cost estimates, and sales trends weekly. Waiting until month-end to spot problems in a restaurant is waiting too long.
Read answerWhat are the most common bookkeeping mistakes restaurant owners make in their first year?
The biggest mistakes include mixing personal and business finances, not tracking food costs at the item level, falling behind on sales tax, and failing to reconcile POS reports with bank deposits. Most of these are preventable with the right systems from day one.
Read answerHow should a property management company set up bookkeeping for multiple properties?
Use QBO classes to track each property individually, keep owner funds and security deposits in separate trust accounts, and produce per-property owner statements every month. Your management fee is your revenue, not the rent you collect.
Read answer

