- Shipping & Orders
- Inventory & Warehouse Management
- About Us
Accounting reports and queries need to be accurate. That accuracy can be achieved only when the data received from sales and inventory systems are timely and correct. Using software automation to do this is not giving up control, so much as regaining control over the data.
To see this, let’s review some of the typical ways in which inventory and sales information gets into the accounting system to begin with:
Updating by hand. This is the most time-intensive process, and the one most prone to error. Works only with very, very small numbers of items and infrequent transactions.
Uploading some common format (Excel sheets, for example). Somewhat surprisingly, a large number of companies export data from one system in some common format, like an Excel spreadsheet, and then import that data into their accounting system manually. Not only does this create a potential bottleneck as data waits to be loaded, but errors can creep in when the exported file is not set up in just the right way, as dictated by the accounting software.
Scheduled FTP. Some automation can be had by programming an application to run an FTP on schedule. The FTP application can place exported files from inventory software in a predetermined location for the accounting software to “find.” While this does eliminate some of the human error in the process and guarantee some level of integration, the process does not yield anything near real time data.
Direct integration. This is the ideal situation, where one system has been integrated with the other to the extent that data can be pushed (or queried when needed). This eliminates any steps that a person must do, and so also cuts down on human error (not to mention the time saved). Most direct integrations these days are done with APIs, which enable the highest degree of integration in real time.
So there are two factors here: Time, and the possibility of error. These two factors are correlated in that the same automation that makes real time reporting possible also removes human involvement. (This makes sense, as people tend to be the bottleneck in any business operation.)
Still, many accounting professionals are wary of using automated systems to make entries, generate reports, and so on. Why? Reasons vary by individual, of course. But often the issue comes down to one of control. With a less automated method, accounting professionals feel they have more opportunity to look at the data, make corrections where needed, and generally have a “common sense check” on everything being reported.
This approach makes sense…if one were doing their accounting with the software of 30 years ago. Not only have software packages become more sophisticated, but so have the networks they run on. Indeed, relying on them offers more control than would otherwise be possible. For an analogy, look at how much more control you have over your television via your remote control, compared to the manual channel-changing of a generation back. Both the TV and the remote control are much more sophisticated, but this just gives you, the operator, more control in the end.
All of these benefits assume, of course, that your systems are appropriately set up to implement the integration. This means that general accounting ledger codes must be entered accurately into the inventory management system, for example. Costs for each item must be correct as well. Reconciliation must be done at a time that makes most sense, given the business (for example, a monthly roll-up by product line might make more sense in some cases, whereas a reconcile-per-order might make sense in others).
Given the benefits of accounting integration, however, it is well worth starting the process—and doing it correctly. If your organization has questions about integrating your accounting and inventory management software, please reach out. We have done a number of integrations, and we know what questions to ask to get you on the right track.
We can link to a gated resource within the blog listing if that makes sense to route users to gated content to capture qualifying information.
Want the latest content delivered direct to your inbox? You've got it - sign up below!