Inventory value has to have exactly one owner. Either the inventory system computes it and posts it to QuickBooks, or QuickBooks computes it from receipts and COGS relief while the inventory system supplies quantities, or one platform does both and there is no handoff. Any of the three works. What does not work is two systems each computing value and each posting to the ledger, because they will disagree by a little every month and by a lot after a price change, and the disagreement lands in COGS where it wrecks gross margin.
Finale Inventory, branded on its site as Descartes Finale, is inventory management software for growing ecommerce brands with in-house fulfillment, per finaleinventory.com. ConnectBooks connects Finale Inventory data to QuickBooks or Xero. The ownership decision is what a seller running Finale alongside QuickBooks has to make before the first sync.
Quantity there, value here. The inventory system owns on-hand counts by location and everything operational: receiving, picking, reorder points, transfers. The ledger owns cost. Receipts post to inventory at landed cost, sales relieve FIFO cost to COGS, and a period-end adjustment reconciles the ledger balance to the inventory system's count valued at the ledger's cost. This is the most common arrangement for sellers on QuickBooks Online.
Value there, posted here. The inventory system owns both quantity and cost, computes COGS on each shipment, and posts summary journal entries to the ledger. QuickBooks becomes a passive recipient for inventory and COGS. This works when the inventory system's costing is trusted and nothing else is posting COGS. It fails the moment a marketplace sync also relieves inventory.
Both in one. One platform holds counts, cost layers, and the ledger sync. No reconciliation between systems because there is only one. ConnectBooks tracks inventory by warehouse with FIFO layers and landed cost and posts COGS to QuickBooks or Xero as settlements reconcile, which is this model for sellers who use it as their inventory system.
The choice depends on which system your team lives in and which one your accountant trusts. It does not depend on which one has the better feature list.
Under FIFO, every receipt creates a layer at its landed cost, and sales consume the oldest layer first. A SKU with 400 units at $6.50 and 200 units at $7.70 has two layers. Sell 450 units and COGS is 400 times $6.50 plus 50 times $7.70, or $2,600 plus $385, which is $2,985. Remaining inventory is 150 units at $7.70, or $1,155.
An inventory system carrying a single average cost, $6.90 in this case, would relieve 450 times $6.90, or $3,105, and leave 150 units at $6.90, or $1,035. Over the life of the 600 units the totals converge. In the month of the sale, COGS differs by $120 and inventory by the same. Multiply across 400 SKUs and a supplier price increase, and the two systems drift apart by thousands with no single wrong entry to find. This is why one system computes value and the other does not.
Illustrative numbers. The seller runs the first model: Finale holds quantity, QuickBooks holds value.
Now the inventory system's October 31 count, valued at the ledger's FIFO costs: $185,150.
The gap is $2,250. Reconciling it means finding what one system knows and the other does not.
$1,080 plus $1,170 is $2,250. The gap is explained to the dollar.
The adjustment entry is for the shrink only: debit inventory shrink expense $1,080, credit inventory $1,080. The ledger's inventory balance drops to $186,320. The in-transit receipt is a timing item, not an error; the inventory system will count it in on November 2, and the two systems will agree at that point without another entry. Reconciled figure both sides: $185,150 plus $1,170 in transit equals $186,320.
The entry the seller must not make is a $2,250 plug to force the ledger to match the count. That would write off $1,170 of inventory that is sitting on a truck, and November's COGS would be understated by the same amount when those units sell.
The failure looks like this. The inventory system has a QuickBooks connection and posts COGS on each shipment. The marketplace accounting sync also relieves inventory when settlements reconcile. Nobody turned one of them off.
Illustrative numbers. A sale of 200 units of a SKU carried at $12.00 under FIFO.
Gross margin on that SKU is cut roughly in half. Inventory on the balance sheet runs $2,320 short. And because the two postings used different cost bases, the error is not a clean doubling that someone would spot; it is $4,720 against an expected $2,400, and the extra $2,320 does not match any single transaction anyone can search for. Sellers find this months later, usually when the accountant asks why inventory went negative.
The fix is a rule, not a reconciliation: one system posts COGS. Write down which one. If it is the ledger side, the inventory system's accounting connection sends quantities and nothing else.
Once ownership is settled, the reconciliation takes three steps on the last day of the month.
If step three cannot explain the gap, both systems are computing value, and the routine has found the problem it exists to find.
ConnectBooks reconciles marketplace settlements into QuickBooks Online, Desktop, or Enterprise and carries FIFO inventory value on the accounting side. Finale Inventory data connects to it as a source. The count comes from the warehouse. The value stays with the books.
Running an e-commerce business comes with plenty of challenges, but ConnectBooks is here to make your life easier. With real-time insights, seamless integrations, and detailed tracking of your profitability and inventory, you can stay ahead of the game. Whether you’re selling on Amazon, Shopify, Walmart, TikTok or eBay, ConnectBooks helps you manage your finances with 100% accuracy and confidence, so you can focus on growing your business.
Ready to level up? Start making smarter, data-driven decisions every step of the way. Try ConnectBooks Free Today or Schedule a Demo
