Reckon/Quickbooks – Stock on Hand value adjustment

Reckon/Quickbooks – Stock on Hand value adjustment
Reckon/ Quickbooks – Stock on Hand value adjustment

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 where 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 FREE 30min 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 or call 0407 361 596 Australia

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this:
search previous next tag category expand menu location phone mail time cart zoom edit close