Account Keeping Plus – Business Administration, Bookkeeping, Compliance News & Tips MYOB Reckon Quickbooks Xero Software Training Small Business

Making Business Books and Accounting Come Alive! MYOB Reckon Xero

Reckon/Quickbooks – Stock on Hand value adjustment

Leave a comment

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


Author: Account keeping plus (Business accounting software

Administration, Bookkeeping and Compliance for small business, and Self-Managed Super Funds (SMSF) Training, trouble-shooting, or we can do the books and payroll for you! Self Managed Superannuation Fund Service Provider, Free support 30 min call 0407 361 596 Australia (+61 drop 0 from overseas) MYOB Certified Consultant, Reckon/QuickBooks Professional Partner.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s