8 Signs Electrical Supply Distributors Spend Too Much Time Reconciling the General Ledger

1. Excessive time is spent in reconciling inter-company due to/from accounts because intercompany transactions have to be entered manually for each company. Transactions are re-keyed into multiple databases and there are errors. Sometimes, transactions are not recorded in all companies, or they get recorded incorrectly, resulting in difficulty reconciling the inter-company balances.
2. The reconciliation of bank accounts is manual. It takes too much time to reconcile a bank account.
3. You have a manual process of entering deferred revenue transactions or are using recurring entry transactions to handle the recognition of deferred revenue. Transactions are missed, not recognizing revenue when they should. You have transactions in which the receivable is recorded in one month but the revenue is recognized in a different month or months. Monthly journal entries do not recognize revenue/expense. Subsequent journal entries are not done to correctly recognize revenue/expense.
4. Time is spent re-keying budget data from spreadsheets into the GL. You cannot easily transfer information between the general ledger and Excel for creating and updating budgets. You do not have a mechanism for creating base line or blank budgets utilizing the information within the general ledger. You are not able to link back or drill down from Excel to see more detail on the GL account. This is not related to GL Out of Balance.
5. It takes increasing time to research balances and transactions. It takes too much time and costs too much to create and customize reports to research unusual balances or transactions.
6. It is difficult to setup codes to track transaction activity by project, cost centers, employee, etc. in order to further analyze expenses. Analysis is not always available. The analysis is cumbersome or requires additional software.
7. It is difficult to reconcile control accounts with subsidiary ledgers, and the way you do it today takes too much time.
8. When analyzing data, your accounting staff could mark control accounts (i.e. AR, AP, Inventory) as “No Input Allowed” so that journal entries cannot be made manually (without special security) and control accounts could be reconciled with subsidiary ledgers.

About Optimize Our Inventory

Established in 1988 and Headquartered in Orange County CA, Optimize Our Inventory is a division of aimINSIGHT Solutions, Inc. Our Vision is to serve the mid-sized Electrical Supply and Distribution companies as well as other Wholesale Distribution companies. We specialize in addressing and Bridging the Gap in technology. The goal of providing a Single Invoice, Single Shipment from multiple suppliers sources and Multiple Locations challenges that most Electrical Distributors face. Our team of consultants will visit you onsite and design the solution that fits your unique budget and challenges. We have worked with most of the off the shelf software available today. Our software solution and technology consulting is designed to “Bridge the Gap” that you face. For more information, please visit http://www.optimizeourinventory.com.

Recommended for you:

10 Automation Benefits of an Electrical Supply Inventory Optimization System