If you recently started tracking inventory in ConnectStock and run your P&L report by Posted Date, some items may show wrong or missing costs. Here's what's causing it and how to fix it.

ConnectBooks figures out costs based on when an order shipped, not when it posted. So if you started using ConnectStock in 2026 and run a report by Posted Date, any items shipped before that, say in 2025, won't have a recorded cost. ConnectStock wasn't tracking your inventory yet.

Example: Your report shows 100 units posted in 2026.

Because 20 units have no cost, ConnectBooks takes the total cost of the 80 units and spreads it across all 100. This makes the cost per unit look wrong.

Set an Item Cost on the item in ConnectStock.

The Item Cost works as a fallback. ConnectBooks uses it to fill in the cost for any transactions that are missing one. Once it's set, those 20 units from 2025 get a cost, and your P&L report adds up correctly.

To do this: Go to ConnectStock, then Items, open the item, click Edit, enter the Item Cost, and click Save.

The Item Cost fills in missing costs when the report's Cost Type is "ConnectStock Cost with Fallback". You can check this under Customize. "Default Cost" does the same only when your report starts on or after your ConnectStock start date. With "ConnectStock Cost", the missing cost stays blank. Choosing "Item Cost" uses the Item Cost for every unit.

Why does this only happen when I run by Posted Date?

Costs are based on when the order shipped. Orders that shipped before you started ConnectStock but posted after have no recorded cost.

I set the Item Cost but the cost is still blank. Why?

Check the Cost Type under Customize. Use "ConnectStock Cost with Fallback", or "Item Cost" to use the Item Cost for every unit. "Default Cost" only uses the fallback when your report starts on or after your ConnectStock start date.

Where do I enter the Item Cost?

Go to ConnectStock, then Items, open the item, click Edit, enter the Item Cost, and click Save.