Inventory As Of
Summary
Reconciling inventory balances with general ledger balancesContent
Hi all,
I would like to share this topic: at month end we have to perform a balance reconciliation between inventory and general ledger.
We use standard cost as evaluation method, thus value is quantity x standard cost.
We have to consider for the reconciliation only transactions within the period, therefore we cannot use inventory on-hand, since this is changing continuously and cannot be frozen at date.
Currently we have built a report to calculate balances at month end from the very beginning, but in time the number of transactions to consider will increase and report duration will increase accordingly. Being a retailer, the number of record per month is several hundred thousands.
Tagged:
0