Reconciling Inventory to the Balance Sheet in Cetec ERP

During month-end close, it is common to need a part-level inventory list that ties directly to the Inventory and Finished Goods lines on your balance sheet. If you click through from financial statements into the general ledger, you can see the accounting entries, but you still may need the supporting part detail to explain the dollar total.

In Cetec ERP, the practical approach is to pull a month-end inventory sub-ledger report that lists parts and values, then use a BOM-based filter to separate finished goods from non-BOM materials. The key is running and saving the report at month end so the values match what you are closing.

Run List By Bin at Month End

At month end, run List By Bin. This report is the inventory-side companion to AR and AP summary-style sub-ledger reports, and it is designed to give you part-level inventory detail with locations. Navigate to Parts > Lists > List By Bin.

Include Total Value and Review BOM Status

On the List By Bin report, check the Include Total Value option so your export contains the extended value that you can reconcile to your balance sheet. Leave the BOMs filter set to All, submit the report, then configure the output to show the BOM column.

Once exported, you can sort or filter by the BOM indicator in Excel to separate finished goods from other inventory lines. This gives you a part-number list behind the dollar total, with a clear way to explain what portion is BOM-based and what portion is not.

Export Finished Goods and Raw Materials Separately

If you want clean exports that align directly to balance sheet lines, use the BOMs filter to split the report into separate pulls. Set BOMs to Only to export a finished goods list, then set BOMs to None to export a raw materials list.

How to decide: use BOMs = Only when you need the parts that roll into Finished Goods, and use BOMs = None when you need the parts that roll into Inventory as raw materials.

Save Month-End Reports

List By Bin is a perpetual report, which means it reflects current inventory positions. If you need to support prior month balances later, run and export the report on the last day of the month you are closing, then save that export with your close package.

Key Takeaways

• Use Parts > Lists > List By Bin as your part-level inventory sub-ledger at month end.
• Turn on Include Total Value so the export supports balance sheet reconciliation.
• Use the BOMs filter (All, Only, None) to separate finished goods from raw materials.
• Export and save the report at month end, since the report reflects current state and is not retroactive.

Conclusion

If you need part-number detail behind Inventory and Finished Goods on the balance sheet, List By Bin gives you a practical month-end inventory listing you can export and reconcile. Using the Include Total Value setting and the BOMs filter lets you explain the balance with clear, auditable supporting detail.