My General Ledger Interface with Other Package Is Out of Balance

My General Ledger Interface with Other Package Is Out of Balance

Q - When I go to GL ->  Processing -> Interface from Other Package, I choose to interface with the IM module.  After the interface, my GL Journal transaction shows it is out of balance.  How can this happen?  What should I do?

A - Generally speaking, the interface out of balance can happen due to someone else performing posting while the interface is taking place.  This is especially true if you perform the interface during the day and it takes a long period of time to complete.

How to Prevent Interface Out of Balance in the Future
To prevent this from happening in the future, you can adopt the following strategies:
  1. Do not interface during the day while other users may perform posting.  You should be aware that GL Interface from Other Package can be deferred if you choose to "Print Report."  Many Elliott users perform interfacing overnight through deferred processing and post the interface transactions immediately after in deferred processing.
  2. Coordinate with other users while you perform the interface.  Don't let interface and posting take place at the same time.
  3. If it takes a long time to interface, it means your distribution file is too big and you should consider purging it. When you make the interface run faster, you also reduce the chance of conflict with other users that might perform the posting.
How to Fix the Out-of-Balance Data
Now that this out of balance has taken place, how do you fix this problem?
  1. You first need to verify if the un-interface distribution is out of balance by the same opposite amount. You can do so by going to the module that you interface from, print the G/L Distribution Report, and make sure you answer "N" to "Interface to G/L Status?"  If the result shows it is out of balance by the same opposite amount, then you are on the right track.  For example, if your G/L Journal transaction shows it is out of balance by $100 Dr, and your un-interface distribution report is out of balance by $100 Cr, then you are good to proceed to the next step.
  2. In G/L, post your G/L General Journal Transaction and indicate an allow out-of-balance posting. You may need to go to G/L Setup to turn on "1. Allow Out of Balance Posting ?"  See sample screen at the end of this article.
  3. Perform the interface with the same module one more time.  This time, we expect that it will be out of balance by the same amount in the opposite direction.  Then print G/L General Journal trx edit list to verify after the interface.  If it is out of balance by the amount that you expect it to be, proceed with the out-of-balance posting.
  4. To make sure your G/L is in balance after step 3 above, please go print a G/L Trail Balance report to ensure it is balanced.


EMK



    • Related Articles

    • GLMENU General Ledger Package Overview

      Overview Package Overview How To Use This Manual When most people receive a new product, they want to use it right away. Unfortunately, this is not quite possible when dealing with computer hardware and software. This manual is intended to serve as a ...

    • INTERFAC General Ledger Interface From Other Packages

      Interface From Other Packages Application Overview Interface From Other Packages allows the distribution files of Accounts Receivable, Accounts Payable, Payroll, Job Costing, Inventory Management, and Assets and Depreciation to be transferred into ...

    • GNJINLENT General Ledger General Journal Trx Processing

      Processing General Journal Trx Processing Application Overview The General Journal Transaction Processing application allows for Journal Transaction entries and changes before posting to the General Ledger. Transactions may be keyed directly into the ...

    • GLCTLMNT General Ledger G/L Setup

      Util-Setup G/L Setup Application Overview G/L Setup is not an application that you will be running very often. In this application, you will answer some questions that tailor the General Ledger package to the way you do accounting in your company. ...

    • GLTRIALB General Ledger Trial Balance Report

      Trial Balance Report Application Overview The Trial Balance Report application prints a Trial Balance report in account number or profit center order. These two options provide a detail or summary for a range of accounts that fall within a specified ...