Key takeaways<\/h2>\n\n- In a single ledger, each sale posts its cost at the moment of sale. In a two-app setup, cost of sales is usually right only after a month-end stock journal.<\/li>\n
- Freight and import duty belong in the cost of the stock, not in a freight expense line. Separate apps often split them, which overstates the margin on every unit sold.<\/li>\n
- A return has two halves: the refund and the restock. If the accounting app only sees the credit note, cost of sales stays wrong until the next adjustment.<\/li>\n
- Two apps are a sound choice when your accountant must work in QuickBooks Online or Xero. Keep one app as the stock master and agree who posts the valuation journal.<\/li>\n
- Before you buy, push one real order through any shortlisted system and check the four numbers in the checklist below.<\/li>\n<\/ul>\n<\/div>\n
One ledger vs two apps: what actually differs<\/h2>\n
In a one-ledger setup<\/strong>, the system that moves your stock also keeps your books. When you receive goods, inventory (an asset) goes up. When you invoice and ship, revenue and cost of goods sold post together. When a customer returns an item, the refund and the restock post together.<\/p>\nIn a two-app setup<\/strong>, an inventory app counts units and a separate accounting app records invoices and bills. The accounting app usually treats products as non-stock lines. Supplier bills go to a purchases or expense account, and the stock value only reaches the balance sheet when someone posts a closing-stock journal from the inventory app’s valuation report.<\/p>\nThat periodic method is legitimate, and many small businesses use it. The formula behind it is simple:<\/p>\n
COGS for the period = opening inventory + purchases \u2212 closing inventory<\/code><\/p>\nThe problem is not the formula. The problem is that each of its three parts comes from a different place. If any part is late, missing or valued differently, the result is wrong. Our guide on aligning your accounting and inventory processes<\/a> covers the wider workflow. Here we focus on the three specific breaks.<\/p>\nThe three things that break when stock and books live apart<\/h2>\n1. COGS timing<\/h3>\n
Without a month-end journal, the accounting app shows the full purchase as cost in the month you bought it. That month looks like a loss and the following months look too profitable. Any profit report you open mid-month is wrong, because the adjustment has not happened yet.<\/p>\n
2. Landed cost<\/h3>\n
The cost of inventory includes the purchase price plus import duties, transport and other costs directly needed to bring the goods to their present location. This is the rule in IAS 2 Inventories<\/a>, and most national standards follow the same idea. The calculation is:<\/p>\nLanded unit cost = (supplier cost + freight + duty + other costs to bring goods to location) \u00f7 units received<\/code><\/p>\nIn two apps, the freight forwarder’s bill usually goes straight to a freight expense account in the accounting app. Meanwhile the inventory app values stock at the supplier price only. The stock is undervalued, the margin per unit is overstated, and the freight hits profit all at once instead of as the goods sell.<\/p>\n
3. Returns<\/h3>\n
A return reverses revenue, and if the item goes back on the shelf, it also reverses cost of sales and adds stock. In two apps, the credit note reaches the books but the restock stays in the inventory app. Your books show the lost revenue straight away but do not show the recovered cost until the next valuation journal.<\/p>\n
Worked example: one order traced through both setups<\/h2>\n\nExample: a shop selling ceramic table lamps online.<\/strong> This business is hypothetical, and all figures are before sales tax to keep the arithmetic visible.<\/p>\n\n- 20 October: 100 lamps arrive at a supplier price of 20 each (2,000). Freight of 300 and import duty of 200 are billed with the shipment (500 in total).<\/li>\n
- Landed unit cost: (2,000 + 300 + 200) \u00f7 100 = 25<\/strong>.<\/li>\n
- 28 October: a customer orders 4 lamps at 60 each. The order is invoiced and shipped the same day (240).<\/li>\n
- 31 October: month end.<\/li>\n
- 5 November: the customer returns 1 lamp in sellable condition and is refunded 60.<\/li>\n<\/ul>\n
In the two-app version, the accounting app expenses purchases and freight, and the bookkeeper posts a closing-stock journal from the inventory app’s valuation report, which uses the supplier price.<\/p>\n
\n
One ledger vs two apps: what actually differs<\/h2>\n
In a one-ledger setup<\/strong>, the system that moves your stock also keeps your books. When you receive goods, inventory (an asset) goes up. When you invoice and ship, revenue and cost of goods sold post together. When a customer returns an item, the refund and the restock post together.<\/p>\n In a two-app setup<\/strong>, an inventory app counts units and a separate accounting app records invoices and bills. The accounting app usually treats products as non-stock lines. Supplier bills go to a purchases or expense account, and the stock value only reaches the balance sheet when someone posts a closing-stock journal from the inventory app’s valuation report.<\/p>\n That periodic method is legitimate, and many small businesses use it. The formula behind it is simple:<\/p>\n The problem is not the formula. The problem is that each of its three parts comes from a different place. If any part is late, missing or valued differently, the result is wrong. Our guide on aligning your accounting and inventory processes<\/a> covers the wider workflow. Here we focus on the three specific breaks.<\/p>\n Without a month-end journal, the accounting app shows the full purchase as cost in the month you bought it. That month looks like a loss and the following months look too profitable. Any profit report you open mid-month is wrong, because the adjustment has not happened yet.<\/p>\n The cost of inventory includes the purchase price plus import duties, transport and other costs directly needed to bring the goods to their present location. This is the rule in IAS 2 Inventories<\/a>, and most national standards follow the same idea. The calculation is:<\/p>\n In two apps, the freight forwarder’s bill usually goes straight to a freight expense account in the accounting app. Meanwhile the inventory app values stock at the supplier price only. The stock is undervalued, the margin per unit is overstated, and the freight hits profit all at once instead of as the goods sell.<\/p>\n A return reverses revenue, and if the item goes back on the shelf, it also reverses cost of sales and adds stock. In two apps, the credit note reaches the books but the restock stays in the inventory app. Your books show the lost revenue straight away but do not show the recovered cost until the next valuation journal.<\/p>\n Example: a shop selling ceramic table lamps online.<\/strong> This business is hypothetical, and all figures are before sales tax to keep the arithmetic visible.<\/p>\n In the two-app version, the accounting app expenses purchases and freight, and the bookkeeper posts a closing-stock journal from the inventory app’s valuation report, which uses the supplier price.<\/p>\nCOGS for the period = opening inventory + purchases \u2212 closing inventory<\/code><\/p>\nThe three things that break when stock and books live apart<\/h2>\n
1. COGS timing<\/h3>\n
2. Landed cost<\/h3>\n
Landed unit cost = (supplier cost + freight + duty + other costs to bring goods to location) \u00f7 units received<\/code><\/p>\n3. Returns<\/h3>\n
Worked example: one order traced through both setups<\/h2>\n
\n
![\"Flow:](\"https:\/\/cashflowinventory.com\/blog\/wp-content\/uploads\/cfi-guides\/inventory-software-with-accounting\/inventory-software-with-accounting-steps.webp\")