QuickBooks and Your Warehouse System: What Actually Syncs

The short answer: QuickBooks should get documents and totals from the warehouse, not a copy of the floor. QuickBooks Online counts stock per item and moves it when someone enters an invoice, a sales receipt or a bill. The warehouse system counts stock per bin and moves it when someone scans. Those two clocks will never agree minute by minute, and an integration that tries to force them to agree, usually by overwriting quantities every night, creates accounting entries nobody asked for.

This guide is for the operations side of that conversation: what QuickBooks actually stores, when it thinks stock moved, what the warehouse should send it, and how to reconcile the two without guessing.

Does QuickBooks track inventory at all?

It depends on the edition. Intuit's help center says "Inventory features are available for QuickBooks Online Plus and Advanced." Simple Start and Essentials do not track inventory quantities without an add-on or an upgrade.

When inventory tracking is on, Intuit's item setup asks, among sales and purchasing details, for a name and SKU, an initial quantity on hand, the as-of date you started tracking, a reorder point, and three accounts: the inventory asset account, an income account for the sale, and an expense account set to Cost of Goods Sold. The setup article shows no field for a warehouse, a bin, a lot or serial number, or a unit of measure.

QuickBooks Online does have location and class tracking, which Intuit's QuickBooks Online Advanced page lists as unavailable in Simple Start and Essentials. Intuit's inventory release notes describe linking "a location and/or class with an inventory quantity or starting value adjustment", which labels the adjustment; none of the Intuit pages we read describes holding a separate quantity per site. Intuit Enterprise Suite is outside the scope of this guide.

QuickBooks Desktop is different at the top end. Intuit sells Advanced Inventory for QuickBooks Desktop Enterprise, listing "Multiple location inventory", "Bin or lot tracking", "Serial or lot numbers" and "Bar code scanning" among its features, and states that "Advanced Inventory is included in the Platinum and Diamond subscriptions only." Even there, a company file tracks serial numbers or lot numbers, not both: "You can only choose one."

For most brands that run their own floor, then, QuickBooks holds one number per item, and the warehouse holds that number broken down by where it physically is. The detail lives in the warehouse system. The difference between a WMS, an OMS and an ERP is mostly this: who owns which version of the truth.

When does QuickBooks think stock moved?

When a document says so. Intuit's article on tracking inventory in QuickBooks Online states that QuickBooks "decreases what's on hand by the amount on the invoice or sales receipt." Stock goes up when you record the purchase on a bill, check or expense: "the quantity on hand automatically increases by the number of items you receive." And: "A purchase order itself does not change your inventory levels."

Put that next to what happens on the floor and the gaps are obvious:

Two of those rows often explain the arguments between operations and finance. Stock that is on the shelf but not yet billed is real to the warehouse and invisible to QuickBooks. An order invoiced before it ships has already left QuickBooks while it is still sitting at the pack station.

Intuit also warns about overselling: "You don't always get a warning message on invoices when you oversell an item." If an invoice takes quantity below zero, QuickBooks "adjusts the Inventory Asset and COGS accounts based on the next purchase." In practice, a late bill does more than fix the count; it settles the cost of sales that already happened, and if the bill is dated in a later month, that cost may land in the later month. That is our reading of Intuit's wording, and your accountant should confirm how it lands in your periods.

What should the warehouse send to QuickBooks?

Send the events that change money, each one once, from the system that owns it.

• Receipts, to check the bill. The bill should mirror the supplier's invoice, so finance can match it to the statement. The dock's received quantity is what finance checks it against, alongside the purchase order. When the supplier bills for units that never arrived, the fix is a dispute or a vendor credit, not a quietly edited bill.
• Sales, from exactly one system, at one moment. If the storefront already posts sales receipts or invoices to QuickBooks, the warehouse system must not post them again, or every order decrements QuickBooks twice. Decide too whether the sale document is created at checkout or at shipment. Creating it at shipment removes the invoiced-but-not-shipped gap; creating it at checkout keeps it, and the reconciliation below has to account for it.
• Count adjustments and write-offs, with a reason. Intuit's quantity adjustment "automatically records appropriate adjustments to your Inventory Asset and Cost of Goods Sold", against an adjustment account you choose; Intuit's example is Inventory Shrinkage, a sub-account of Cost of Goods Sold. Editing or deleting one later "can greatly impact your accounting". One rule covers it: recount, supervisor approval, then post with a reason code. Units moved to scrap, damage or expiry belong here too.
• The item list. Name and SKU need to match exactly in both systems. Cost should come from bills, not from the warehouse.

What should stay in the warehouse: bins, lots, serial numbers, pick and pack status, moves between ordinary bins, and unit-of-measure conversions. A move from one shelf to another does not change the value of stock, and the QuickBooks Online item setup has no field to hold it. If you buy by the case and sell by the unit, convert before you send, so QuickBooks always receives the unit it counts.

Why does a nightly quantity overwrite go wrong?

Because every difference becomes an accounting entry. A common shortcut is to set QuickBooks quantity equal to the warehouse quantity at midnight. In QuickBooks Online that is an inventory quantity adjustment, posted against the adjustment account, which usually sits under Cost of Goods Sold.

Now replay the table above. A truck put away on Tuesday and billed on Thursday makes the warehouse higher than QuickBooks for two nights. The overwrite records a gain on Tuesday. Then the bill adds the same units again on Thursday, and the next overwrite records a loss to bring the count back down. An order invoiced on Friday and shipped on Monday does the same: a gain on Friday, a loss on Monday. An order shipped before it is invoiced does the reverse. None of it is shrinkage, but all of it reads like shrinkage in the books. Worse, the adjustment is valued at the cost QuickBooks holds that day and the bill at the supplier's price, so the gain and the loss need not cancel, and the leftover stays in cost of sales. This is our reasoning from Intuit's documented posting rules, not something Intuit states, and it is the strongest argument for sending documents instead of numbers.

Which costing method does QuickBooks use, and does the warehouse care?

Check your own company settings before you assume. Intuit's current article on cost accounting offers "two options": FIFO and Moving Average Cost. It warns, "Choose your costing method carefully because it can't be changed later," and says items created before a method was chosen default to FIFO. Another current Intuit article, on inventory assets and cost of goods sold, describes QuickBooks valuing stock at "the weighted average cost". The two articles do not say the same thing, and the first does not say which editions offer the choice, which is a good reason to ask your accountant which method your file actually uses.

On QuickBooks Desktop Enterprise you can switch from average cost to FIFO, and Intuit notes that "QuickBooks recalculates all inventory-related transactions starting on the date you enter." Pick that date with finance, not on a whim.

Either way, the cost QuickBooks assigns, a FIFO layer or an average, is not tied to the unit your picker took. QuickBooks Online does not know which lot or which pallet shipped. Physical rotation, such as FIFO or FEFO on the shelf, is a warehouse rule. The cost method is a bookkeeping rule. They can differ without either being wrong.

How often should the two systems sync?

As documents close, plus one reconciliation a day. Intuit's developer documentation sets the QuickBooks Online API limit at "500 requests per minute per realm ID" and "10 requests per second, per realm ID and app", and says you will see HTTP status 429 when throttling occurs. Those limits are plenty for documents. Scans do not need to reach QuickBooks at all, because it has no use for a bin move.

A practical rhythm: send the closed receipt to finance for the bill match, post the sale at the moment your owner rule names, and post count adjustments when they are approved.

A reconciliation that holds up

Once a day, per SKU:

1. Sum warehouse on hand across every location holding stock you own and still carry at value. Exclude consigned stock you do not own, and decide explicitly how stock in transit between sites is treated.
2. Subtract units received but not yet billed.
3. Subtract units invoiced but not yet shipped.
4. Add units shipped but not yet invoiced.
5. Adjust for returns and vendor returns not yet matched to their credit documents, in whichever direction your process posts them.
6. Compare the result with QuickBooks quantity on hand.
7. Investigate what is left. Only that remainder should become an adjustment, with a reason, and only after a recount rather than a guess and a supervisor's approval.

A small, scattered remainder is probably real loss or counting error. A large or one-directional remainder on the same SKUs usually points at a document posted twice, a document never posted, or a unit-of-measure mismatch before it points at missing stock.