How do you avoid audit issues due to inventory reconciliation problems?


by John Hilborn, InsightSoftware.com Reconciler Expert and Accountant

Reconcile accurately - before the auditors arrive

Reconcile accurately - before the auditors arrive

It’s audit season, so I am doing some research on how people are addressing the differences between the Inventory Cardex (F4111) and the GL transaction table (F0911). As an accountant, I’ve seen many different workarounds, and I’m curious how people are doing this to avoid audit issues.

How do you manage this? Do you create Excel data dumps of each table, using pivot tables to match up the differences manually?  Do you have a more efficient way of solving this problem?

So far, my research indicates that most financial professionals have created some sort of manual, time consuming process outside of their ERP system, which never really leads to resolving the root cause.

Check out our new webinar on creating lead audit schedules in a snap. Make your auditors happy and your life easier!

Please let me know your experiences  – and I’ll post the results as I continue to dig into this. And if you’re interested in learning more about how to make reconciliation a snap, check out http://www.insightsoftware.com/products/reconciler.

R

Author: john.hilborn

  1. No comments yet.
(will not be published)