Problems & Errors
[IBS Home] [Up]

IBM Server Site

IBS Home Up

 

 

Problems & Errors with G/L Trial Balance

Problems

My Period Trial Closing Balance is Different From My Opening Balance

Cause

  • This is caused with changes are made to closed periods.  After the changes are made a preliminary closing 'MUST' be done again or the figures will not match.

Resolution

  • Run your preliminary close again for the period(s) that are not matching. 
  • After running preliminary closes run your trial balance again

My trial balances don't match the G I (G/L Inquiry) balances

Cause

  • This is normally caused by not entering in the full start/end year date range of your current fiscal year when you run your trial balance report!
  • This can be caused by wrong data entered into the G/L
  • This can be caused by improper close of previous year

Check the date range of your trial balance report

  • Go to GR
  • Select option 2 (Trial balance report)
  • Enter in the full fiscal year for the start and end of your trial balance report
  • Check the figures on the report
  • Continue to researching the problem below if there is still a discrepency! 

Research Your Problem beyond date range of report

  1. First, check to verify that all current periods are closed. 
    • GU Option 16 (or 6) for G/L Control Menu
    • Select Company Identification with a '1'
    • closed periods will have a '2' (Closed) beside them and open periods will show a '1' (Active)
    • Exit back and close any periods that require it
      GU --> Period Processing --> Close period --> [any periods that showed a '1' (active) beside them]
  2. Second, check your trial balance against 1-2 accounts in G I (G/L Inquiry)
    • GR 2 (Trial balance) - this is the balance as of the last closed period
    • GI (G/L Inquiry) - this is the current balance forward from 1st entry to last
  3. Third, if the trial balance and the G/L Inquiry are different run a year end detail report as of the last year ending balance
    • GR 8 (Year ending balance) - this will tell you exactly what the balance was as of the last fiscal year.
      WARNING - THIS REPORT MAY BE SEVERAL THOUSAND PAGES LONG - PUT YOUR PRINTER ON HOLD UNTIL YOU VIEW THE REPORT AND DECIDE IF YOU WANT TO PRINT IT!
    • See the transaction history and compare it with your G/L Inquiry menu (G I). 

      Your [last fiscal year account balance] + [any credits] - [any debits] = your current balance (which should also equal G I)

  4. Next check the account transaction history
    • GU
    • Option 15 (Financials Menu)
    • Option 1 (Chart of Accounts)

      WARNING - DO NOT ACCIDENTLY DELETE YOUR ACCOUNTS WITH AN F4 (Delete) SELECTION
    • Review the data for that account

Resolution

Errors

There have been no reported program errors with running trial balance reports

 
IBS Lumber and Building Material Software  Copyright © 2006 IBS Lumber Software Inc (TM)
Last modified: July 4, 2008

IBS Sales & Support (888) 427-1566
Main Office 1-812-547-4640
Fax IBS  1-812-547-9614

IBS Corporation - Building Materials Software for your Lumberyard

All pages contained in this support website are not intended for general public distribution.  Any material here can be considered private, confidential with various copyrights and restrictions against public release.  You 'the browser' cannot legally release this information for general public distribution.

IBS Webmail | IBS Corporate Site | IBS Homepage
remote support:
http://www.gotomeeting.com | remote support download program