Reckon / Quickbooks – How to adjust stock on hand value
- Details
-
Published on Tuesday, 26 February 2019 13:47
An interesting issue from the Reckon Community – Stock Value Adjustment –
Leanne - We commenced a new clean data file for a small community supermarket store as at 1/7/14. We imported the stock but then learnt that the SOH does not get brought across. The stocktake taken (stock on hand) as at 30/6/14, has been manually entered into a new data file, however for some reason the values do not agree. something was amiss with a couple of average prices. We tried to then do a stock value adjustment whereby we manually compared the stock valuation report from 30/6/14 in old data file to stock valuation report as at 30/6/14 in new file and then entered the correct values where applicable into new data file as at 30/6/14, without adjusting the on hand stock. Then a stock valuation report was printed as at 30/6/14 and the "stock values" did not match. Can you advise if the adjustment is a straight dollar replacement as we have done? If so any clues as to why the values might not agree?
Graham replied - It may be that some items that were on-hand at 30/6/14 have since been made inactive. Reckon Accounts inexplicably (and incorrectly) does not include Inactive items in the Inventory Valuation Summary Report. Are there any items you had on hand at 30/6/14 that are now inactive? You will need to make these active again so the 30/6/14 report reflects their value.
My approach to this whole job would be to generate this report and export to excel in both the old file and the new file, then use excel to do the hard work for you to identify which products have changed qty and/or values. If you haven't got the expertise to do this, I can do it for you on a fee for service basis. It's only a couple of hours work involved, but it could save you hours and hours work if you have a few thousand items.
(Graham Boast Reckon Accredited Consultant)
Need help? Not sure? Call for FREE30min advice / strategy session today!
Call and you also get FREE “Avoid these GST mistakes” – There’s 18 that the Tax Office see regularly – Get them right!
Email
This email address is being protected from spambots. You need JavaScript enabled to view it.
or call 0407 361 596 Australia
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
