To automate COGS tracking well, start by looking at what happens when one product sells across three channels. Your Shopify listing might say it costs $14.20, your Amazon listing shows $19.80 for the exact same item, and your wholesale price sheet lists a third number nobody on the team can fully explain. None of those figures can be true at the same time.
That gap does not usually appear because someone made a mistake. It appears because the cost of goods sold gets calculated by hand, often once a month, in a spreadsheet. That spreadsheet was never built to handle freight, duties, platform fees, and returns across three sales channels at once. A purchase order from three weeks ago can sit quietly inside a wrong COGS number. So can a freight invoice that never got allocated or a supplier price change that never reached the inventory system.
For a growing distributor, wholesaler, retailer, or manufacturer, cost of goods sold is not just an accounting line updated at month-end. It connects purchasing, inventory, landed costs, sales, returns, warehouses, e-commerce channels, and the general ledger. When those systems fall out of sync, gross margin can look healthy while the underlying product economics move the wrong way.
This guide breaks down what it actually takes to automate COGS tracking for a multi-channel, multi-warehouse product business. It covers what COGS tracking measures, what multi-channel COGS tracking requires, and how to build automation around it. It also covers where COGS tracking software like Cin7 and Microsoft Business Central fit. And it covers the mistakes that turn automation into a more expensive version of the same broken process.
What COGS Tracking Actually Measures
COGS tracking is the process of determining and recording the cost associated with the inventory that has been sold during a given period.
For a simple business, the calculation may look easy:
Beginning inventory + purchases – ending inventory = COGS
But product businesses rarely operate that simply.
Costs can move through purchase orders, goods receipts, supplier invoices, inventory adjustments, warehouse transfers, manufacturing processes, returns, freight charges, and sales across multiple channels.
The U.S. Internal Revenue Service explains that businesses that maintain inventory generally need to determine beginning and ending inventory to calculate cost of goods sold. Its guidance also addresses costs such as purchases, materials, labour, and certain freight and production-related costs.
Under IFRS, IAS 2 addresses the cost of inventories and states that when inventories are sold, their carrying amount is recognised as an expense in the period in which the related revenue is recognised.
That relationship matters because the timing and accuracy of inventory costing directly affect reported gross profit.
Why Cost of Goods Sold Breaks Down First at Multi-Channel Scale
Manual COGS tracking tends to hold up fine at a single warehouse selling through a single channel. It starts to fail the moment a second or third channel gets added. Each new source of complexity compounds the last one.
Pricing can shift because of purchase quantities, currency movements, discounts, or tariffs. A revised supplier invoice can change things too. If the inventory system still carries an older unit cost, the margin on a sale will not reflect current reality.
Landed cost is the full cost of getting a product into a sellable position, not just the supplier’s invoice price. It includes freight, duties, insurance, and handling. When those costs sit outside the main inventory workflow, finance ends up correcting COGS after the sale has already posted.
Revenue may show up across four different systems. Inventory might sit in one, while the accounting ledger sits somewhere else. If costs and returns do not flow consistently between them, finance spends more time reconciling than analyzing.
The warning sign is rarely one dramatic error. It is a finance team spending several days asking questions like:
- Why did COGS change after the month was already closed?
- Why does inventory valuation not match the general ledger?
- Why is the margin on this SKU different from last month?
- Why does Amazon show one quantity while the inventory system shows another?
- Which warehouse adjustment caused this variance?
When those questions become routine, the problem is usually bigger than the spreadsheet.
The Federal Reserve’s 2025 Small Business Credit Survey covered more than 6,500 employer firms and was published in March 2026. Rising costs of goods, services, and wages was the single most common financial challenge firms reported in the prior 12 months. Seventy-seven percent of firms cited that challenge, tariff-related cost increases, or both. Roughly half of firms said they sourced at least some inputs from outside the United States. Most of those firms saw those input prices rise year over year. When input costs move that often, a COGS number updated once a month is already stale by the time anyone reads it.
What Multi-Channel COGS Tracking Actually Requires
Multi-channel COGS tracking means capturing the true, landed cost of a SKU, or stock keeping unit, once. That same cost then applies consistently everywhere the SKU sells, instead of being recalculated separately for each channel.
U.S. retail e-commerce sales reached 16.9% of total retail sales in the first quarter of 2026. That is up from 16.0% a year earlier, according to the U.S. Census Bureau’s Quarterly Retail E-Commerce Sales report. For a distributor or manufacturer, that growth usually shows up as a second or third selling channel. It gets added on top of an existing wholesale business, rather than replacing it.
Each additional channel adds its own layer of cost, and every layer has to reach the same COGS figure:
- Marketplace referral and fulfillment fees, which vary by category and typically run 8% to 15% of the sale price on top of separate fulfillment charges, based on Amazon’s own published 2026 fee update
- Return and refund processing, which differs meaningfully between a wholesale account, a direct-to-consumer storefront, and a marketplace listing
- Freight and duties on the inbound side, which apply to the SKU regardless of where it eventually sells
- Storage and handling costs that build up differently depending on how long the SKU sits in a given warehouse or fulfillment center
A strong multi-channel COGS process clearly defines:
- Where product master data lives
- Where inventory quantities are controlled
- How sales transactions get imported
- How returns are processed
- How COGS ultimately reaches the general ledger
A landed cost calculated correctly once, and synced to every channel, removes the need to reconcile three separate cost stories at month-end. A landed cost calculated by hand in three places produces three different stories by design, not by accident.
What Happens When COGS Falls Out of Sync
Businesses that never automate COGS tracking usually find out the hard way that the problem does not stay inside the accounting department. It works its way into pricing, purchasing, forecasting, and management reporting.
Gross margin depends on both revenue and the cost assigned to what was sold. If that cost is incomplete or outdated, the margin on a dashboard can look misleading. It can look nothing like the real economics once landed costs are properly accounted for.
A sales team quoting from historical product costs takes on real risk once supplier pricing has moved. Even a small per-unit difference becomes meaningful across thousands of units.
A purchasing manager may see strong sales velocity while finance sees declining product margins at the same time. Both numbers can be technically correct while telling very different parts of the story.
The more manual adjustments a close requires, the longer it takes. That delays the point where leadership sees an accurate picture of product profitability and working capital.
How to Automate COGS Tracking, Step by Step
Automating COGS tracking takes five connected steps: build a reliable product master, connect purchasing to inventory, capture landed costs at the point of purchase, connect sales channels to inventory, and automate reconciliation.
Automation works best as a process design problem, not simply a software purchase. A reliable setup connects the transactions that create inventory cost with the transactions that consume it.
Every SKU should carry consistent information everywhere it is used. That means SKU and product ID, supplier, unit of measure, purchase cost, selling price, warehouse, bill of materials for manufactured items, and costing method. If the same product appears under different codes across systems, automation just moves that inconsistency faster.
Purchase orders, receipts, and supplier invoices need a clear relationship. The system should identify what was purchased, how much arrived, and what the final cost was. This matters most when an invoice arrives after the related goods have already sold.
Freight, insurance, and handling all affect inventory valuation. The exact treatment depends on the transaction and the accounting framework in use. Automation only helps here once the costing method is configured correctly before it runs, whether that is FIFO, LIFO, or weighted average under Accounting Standards Codification Topic 330.
The accounting system needs to know the moment inventory is sold, returned, transferred, or adjusted. For a multi-channel business, that means building reliable integrations between the inventory platform, e-commerce systems, marketplaces, and accounting software, so this chain stays intact:
Product → Quantity → Sale → Cost → COGS → Gross Margin
Automation should not remove controls. It should move repetitive checks out of manual spreadsheets and into structured workflows that flag:
- Inventory-to-general-ledger differences
- Unusual cost changes
- Negative inventory
- Missing purchase invoices
- Unallocated landed costs
- Large or unexpected COGS movements
That gives finance a short list of exceptions to investigate, instead of a full dataset to rebuild by hand.
What COGS Automation Should Actually Connect
The software is only as useful as the data flowing through it. A business that wants to automate COGS tracking well should treat automated cost of goods sold as one connected transaction chain. It is not an isolated finance calculation.
| Business Activity | Data That Matters |
|---|---|
| Purchasing | Supplier, quantity, purchase price |
| Receiving | Quantity received, warehouse, date |
| Inventory | SKU, quantity, location, cost |
| Landed Costs | Freight, handling, insurance, and applicable duties |
| Sales | SKU, quantity, selling price, channel |
| Returns | Returned quantity and original transaction |
| Adjustments | Quantity and reason |
| Accounting | Inventory, COGS, and general ledger entries |
| Reporting | Gross margin, product profitability, and variance |
Choosing COGS Tracking Software That Fits Your Stack
The right cost of goods sold tracking software depends less on brand recognition than on one question. Does it capture landed cost at the SKU level and push it to your general ledger without a manual export step in between?
For a distributor or manufacturer with revenue in the $5 million to $30 million range, a bolt-on inventory tool such as Cin7 is usually the faster path. That is especially true if you are not yet ready to replace your accounting platform outright. Cin7 syncs directly with Xero or QuickBooks Online. Inventory movements, landed cost, and multi-channel order data flow into the accounting ledger automatically, while the accounting software stays the system of record for the general ledger itself.
For a business further up that range, typically $10 million to $100 million, inventory and accounting have often already outgrown a bolt-on connection. If that sounds like your business, it is worth reading about why growing businesses outgrow basic inventory accounting software before you shortlist a platform. A native ERP platform such as Microsoft Dynamics 365 Business Central removes the integration question entirely. It keeps finance, purchasing, and inventory inside one database. There is no export-and-import step between systems, because there were never two separate systems to reconcile in the first place. Getting the underlying setup right, through a proper accounting system setup, matters more than which platform you choose.
Whichever direction fits, the software only works once the groundwork is done. Someone still has to map the chart of accounts, define the costing method, and decide how landed cost gets captured at the point of purchase. Software cannot make those decisions for you. It can only apply them consistently once they exist.
Common Mistakes When Automating COGS Tracking
Most projects to automate COGS tracking that fail do not fail because the software was wrong for the business. They fail because of decisions made, or skipped, before the system went live.
- Automating a Number That Was Already Wrong: If your current cost of goods sold does not reflect true landed cost, automation just moves the same wrong number faster. It also lends that wrong number more apparent authority.
- Leaving Freight and Duties Out of the Calculation: A COGS figure that only reflects the supplier’s invoice price understates true cost on every unit that crosses a border.
- Applying One Blended Cost Across Every Channel: Wholesale, marketplace, and direct-to-consumer sales rarely carry the same fee and return profile. A single blended COGS figure hides which channel is actually profitable.
- Skipping a Parallel-Run Period Before Go-Live: Running the old and new process side by side for at least one full month catches valuation errors early. Otherwise, they compound across a full quarter.
- Treating the Integration as Something That Runs Itself: An automated sync between inventory and accounting still needs someone monitoring it. A silent failure produces confidently wrong numbers instead of an obvious error.
A Simple COGS Automation Checklist
Before you automate COGS tracking, it is worth reviewing the process already in place. Ask yourself:
- Do all sales channels use consistent SKU information?
- Is there one reliable source for inventory quantities?
- Does product cost update automatically when supplier costs change?
- Are freight and landed costs captured correctly?
- Are purchase invoices connected to received inventory?
- Do returns link back to the original inventory transaction?
- Are inventory adjustments reviewed and documented?
- Does COGS reconcile to inventory and the general ledger?
- Can finance explain why COGS changed between periods?
- Can management see product-level gross margin without rebuilding the numbers by hand?
Final Thoughts
Automating COGS tracking is not really a software decision. It is a decision about whether your business is willing to keep pricing and forecasting off a bad number. At best, that number is a few weeks stale. At worst, it is wrong across every channel it touches.
The businesses that get this right treat landed cost as something captured once, at the point of purchase, and trusted everywhere that cost travels afterward. They do not recalculate it separately every time a product changes hands. That might mean a bolt-on tool like Cin7 layered on top of Xero or QuickBooks. It might mean a fuller move to a platform like Microsoft Dynamics 365 Business Central. Either way, the software is only as good as the costing logic and chart of accounts underneath it.
If your cost of goods sold tells a different story depending on which channel you ask, that is worth a direct look. It is better to find that gap now. Otherwise, it works its way into a pricing decision, an investor conversation, or a tax filing.
VNC Global helps manufacturers, wholesalers, distributors, and other inventory-heavy businesses connect accounting, inventory, automation, and advisory processes. That spans platforms such as Cin7 Core, QuickBooks, Xero, MYOB, and Microsoft Dynamics 365 Business Central. Through bookkeeping, inventory sync, and accounting system setup, we connect inventory, accounting, and reporting into one accurate picture, rather than three competing ones. Visit vncglobalgroup.com or book a free 30-minute advisory session to talk through what your business actually needs.
Frequently Asked Questions
Automating COGS tracking means connected inventory, sales, and accounting systems calculate, record, and reconcile inventory cost against sales transactions using defined costing rules. Nobody re-enters it later from memory or a supplier invoice. Cost of goods sold updates as transactions happen, rather than being rebuilt by hand at month-end.
COGS tracking software helps a business record and calculate the cost associated with the inventory it has sold. In a growing product business, this is often part of an ERP, an inventory management platform, or an integrated accounting environment. It is rarely a single standalone application.
Multi-channel COGS tracking has to account for different fee structures, return rates, and fulfillment costs across each channel a SKU sells through. It still applies one consistent landed cost to that SKU everywhere. Single-channel tracking only has to solve for one set of costs. That is why the same manual process often works at one channel and breaks at three.
Not automatically. Automation reduces manual data entry and improves consistency. Accurate results still depend on correct product data, costing rules, integrations, landed cost treatment, and reconciliation controls. A system can be technically capable of automated cost tracking and still produce unreliable numbers if it is configured poorly.
Yes, provided the software is configured for it before go-live. Under U.S. GAAP, Accounting Standards Codification Topic 330 permits inventory to be valued using FIFO, LIFO, weighted average, or specific identification. IRS Publication 538 addresses how these methods apply for tax reporting. Automation applies whichever method your business has already chosen. It does not choose the method for you.
Cin7 Core can form part of an inventory and accounting workflow for tracking product costs and supporting COGS reporting, syncing with Xero or QuickBooks Online. The exact functionality depends on how it is configured and which accounting system it connects to. The integration is worth reviewing rather than assuming a software connection alone guarantees accurate financial reporting.
Business Central includes inventory costing and cost adjustment functionality. It can post costs to inventory, adjustment, and COGS accounts automatically. It can also update historic sales entries when a related purchase cost posts later. How well that works still depends on the company’s costing method, configuration, and reconciliation controls.
The clearest sign is a cost of goods sold figure that changes depending on which channel, spreadsheet, or team member calculated it. If gross margin by SKU cannot be checked in real time, cost of goods sold is very likely stale. If landed cost is only recalculated once a month, it is very likely understating true cost somewhere in the process.
