Bookkeeping, accounting, and fractional CFO services for small businesses across Central Florida.

Call or Text: (813) 857-5169

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

Do I need to collect Florida sales tax if I run an online business from my home?

If you're selling taxable goods from Florida, yes. Operating from your home still creates sales tax nexus in the state. Whether you actually need to collect depends on what you sell, since Florida taxes tangible products but most services are exempt.

Read answer

What financial reports does my franchisor require and how do I set QuickBooks up to produce them?

Most franchisors require monthly or quarterly P&L statements in their specific format, weekly gross sales reports for royalty calculations, and annual financials. The key to producing these without headaches is setting up your QuickBooks chart of accounts to match the franchisor's categories from the start.

Read answer

What's the best way for a landscaping company to track materials and labor per job?

Code every material purchase and labor hour to a specific job so you can compare actual costs to your estimate. Without job-level tracking, you're guessing at which jobs make money and which ones quietly lose it.

Read answer

How should a cleaning company track revenue and expenses across multiple client contracts?

Use classes or projects in your accounting software to tag every transaction to a specific contract. This lets you see revenue and expenses per client so you know which contracts are actually profitable and which ones are costing you money.

Read answer

How do I calculate the true cost of a menu item including ingredients, labor, and overhead?

Start with the plate cost by totaling ingredient costs per portion. Then layer in labor allocation and overhead. Most restaurants aim for 28-35% food cost on the plate, but when you add labor and overhead the total should stay under 65%.

Read answer

How should a dropshipping business track cost of goods sold when inventory is never on hand?

Track COGS per order by recording the supplier cost plus shipping to the customer for every sale. Set up products as non-inventory items in QuickBooks Online so each transaction captures both revenue and cost automatically.

Read answer

Orlando bookkeeping firm serving small businesses across Central Florida. Full-service bookkeeping, accounting, and advisory services backed by 10+ years of accounting experience. QuickBooks ProAdvisor certified and bilingual in English and Spanish.

Service Area

Serving Orlando, Lake Nona, Avalon Park, Winter Park, Kissimmee and surrounding areas

Client Reviews

5-Star Rated Firm

Social

  • QuickBooks ProAdvisor badge
  • QuickBooks Online Certification Level 1 badge
  • QuickBooks Online Certification Level 2 badge
  • GDA Certificate badge

© 2026 Zacosta Bookkeeping Services