Hi Team,
I am experiencing a specific issue with Inventory Valuation and Cost of Goods Sold (COGS) in Manager.io.
The Issue: Even though I am using the Accrual Basis for reporting and have no Delivery Notes or Goods Receipts enabled, the system is not recording the cost of goods sold at the time of each sale.
Instead, the ‘Inventory - cost’ account stays at zero while I make partial sales. The system only seems to ‘flush’ or record the total cost once the inventory quantity for that specific item reaches zero.
Testing performed:
-
Dates: I ensured the Purchase Invoice date is prior to the Sales Invoice date (no negative inventory at the time of sale).
-
Item Setup: Each item is a proper ‘Inventory Item’ with the correct ‘Inventory - cost’ expense account linked.
-
Inventory Value Summary: The report shows ‘Zero’ for Cost of Sales even when units have been sold and ‘Average Cost’ is visible in the Inventory Items tab.
-
Basics: I have confirmed I am not using Inventory Kits or Production Orders for these tests.
Example Scenario:
-
Purchase: 100 units @ $10 each. (Total $1000)
-
Sale 1: 50 units sold. → Result: Sales recorded, but COGS shows $0.
-
Sale 2: Remaining 50 units sold (Qty becomes 0). → Result: Suddenly, the system records $1000 as COGS.
I want the cost to be recorded progressively (e.g., $500 COGS after the first sale). Could you please advise if there is a hidden setting or a data integrity issue causing this delayed cost recognition?
Thank you.