The Ledger Inventory Audit Report

This report is a reconciliation of the stock units and costs posted to those units that make up the Inventory Value in your Balance Sheet.

Eclipse will credit your Inventory and debit your Cost of Sales by the Inventory Value at time of delivery based off the costs associated to the stock number, so if there are costs in Inventory that are not linked to a stock number, they will get stuck there which results in your Inventory having an incorrect value which also effects the profit made for the month. In the below example we can see a cost posted to the Inventory account which is not linked to a stock number.

If posted like the above, it will display in the report under the Status of Non Stock Post like below.

You also want to make sure there are no costs in Inventory for any finalised sales. If you have handed over the stock unit, you no longer have any inventory. If there are costs in Inventory after finalisation, that means the profit displayed at time of finalisation was incorrect. The sale must be unfinalised and refinalised so Eclipse can push the correct amount to cost of sales. Below is an example showing how the report displays when this occurs.

If costs are posted to Inventory or Reversed after finalisation, they will display in the report like below:

Related Articles

End of month parts valuation report vs ledger balance process

End of month parts to service clearing account process

End of month sublet clearing account process