I have problems with inventory reconciliation.we never reconciled inventory but now I am planning to do an inventory reconciliation but I am not sure how to handle the opening balance differences.Is it a good idea to use non-financial accounts, how these accounts works? Suppose I am debiting non financial account and crediting a regular account in this case the financial reports wont show the non-financial but it will show the regular account right? What is the offset account for this non financial account?
Thanks in Advance
If you are trying to reconcile your inventory, you are in need of a FINANCIAL transaction. Forget about the non-financial. When you say inventory is not reconciled, I assume you mean that the Inventory Trial Balance (a report in the Inventory module) does not balance with the inventory account(s) in the general ledger. If this is the case, you should perform a physical inventory to assure that your inventory valuation is correct in the IM module. Then you should post an adjustment in the general ledger to the inventory account to make it agree with the Inventory module. The offset generally goes to a cost of goods sold account. If the adjustment needed is very large, you may want to capitalize this adjustment over a period of several months, or, in part, to a prior year.
If you are an IT person working with MAS, I would suggest getting together with your accounting staff. If you on the accounting staff, I would suggest beginning a dialogue with your outside accountant.
We started our business from 2005 and never reconciled our inventory ( I am speaking about the Itemzied reconcilation of Physical stock in our Warehouses to MAS 90 not module to moudule reconciliation) The opening difference is huge, so I cant off set this to COGS if I do COGS will show negative balance and increase our current profit.
Thanks in Advance
You will have to affect the profit when you reconcile your inventory. There is not really any way around it. You can either make the necessary adjustments and take the hit now - however you want to define it, or you can do inventory adjustments with a zero value for the "found inventory", at which time you will see higher profits when the zero cost inventory is sold. Likewise, if you are missing inventory, you have to take the loss.
The bottom line is that if you have inventory you didn't know you have, that is "found value" - hence the profit.
Have you reconciled purchase clearing? That is where some of these discrepancies can originate. Also, you should run an inventory valuation report at the end of each month and compare to your GL. They should be the same.
© 2016 The Sage Group plc, its licensors or its affiliated companies. Sage, Sage logos, and Sage product and service names mentioned herein are the trademarks of The Sage Group plc, its licensors, or its affiliated companies. All other trademarks are the property of their respective owners. For more information, visit www.sage.com.
Community Terms of Service | Community Guidelines | Blog List | Community Help