Estimate COGS before posting
COGS preview uses SKU, quantity, sale date, and the matching cost record to estimate total cost. Missing SKU, missing cost, invalid quantity, and multi-currency cases stay visible as warnings or blocks.
How LedgerSync calculates estimated COGS
- - Identify the SKU on each normalized product or refund line.
- - Resolve any alias to the canonical SKU.
- - Find the effective cost for the transaction date.
- - Multiply quantity by unit cost and reverse where refund COGS can be estimated.
Important limits
- - Missing quantity blocks item-level COGS.
- - Multi-currency cost conversion is not implemented in this phase.
- - Refund reversals are estimated and should be reviewed when order history is incomplete.
Related articles
Keep moving through setup with the next most relevant guides.
Inventory and COGS in LedgerSync
Understand how LedgerSync imports product catalogs, collects cost data, and builds preview-only item-level accounting output.
Import product costs
Add standard cost, manual cost, last purchase cost, or weighted-average-ready rows from forms or CSV.
Review SKU-level profitability
See units sold, revenue, refunds, fees, estimated COGS, and gross margin by SKU for a selected period.
Preview item-level accounting output
Generate preview-only QuickBooks or Xero shaped inventory and COGS entries without calling live write APIs.
Need help? Contact support
Support is the best next step when OAuth, imports, mappings, or reviewer access are blocked.