Quote from lynnkissinger on 11/08/07 at 15:22:03:When I compare my inventory gl acct #'s to my inventory value report, the numbers do not equal. The net effect is equal, but the sub categories are not. How do I correct?
I set up an expense account called Inventory Variation and create a journal entry that will charge the GL account for inventory and offset the transaction to Inventory Variation. If the net effect is equal, this will accomplish correcting the inventory GL balances, and the net effect will be shown in Inventory Variation Account.
Also, yes, David, I also reconcile IN-F to GL type for inventory every month. Finished goods is usually within cents; raw material is minimal, the only sizeable differences reside in WIP material. WIP material variation is almost always offsest by WIP Labor variation, because I separate WIP between its components: labor, load and material, via EXCEL spreadsheet using EVO monthly labor (JC-C), and entries to finished goods, JC-Q, to evaluate remaining WIP Labor $.
AFTERNOTE: we also have a few educated EVO users which helps reduce variation, so that inventory transactions are entered properly.