The information in this article applies to:
A Data File Integrity Check (DFIC) error 76 indicates the balance for the Retained Earnings account (type "R" account) does not match the calculated retained earnings amount for a specific month. This error can occur as a result of the following:
Although the DFIC error 76 is a self-correcting error, perform the following steps to ensure the integrity of the account balances whenever an error 76 has been reported.
The calculated retained earnings amount is determined by taking the total of all asset account balances for the month and deducting the total of all liability account balances for the same month. The difference between these totals should always match the balance for the Retained Earnings account for that month.
This comparison is performed for every month up through the current month. If the figures do not match, an error 76 is reported. The error 76 will be reported for each month's balance that is incorrect.
When the Data File Integrity Check is run with the Read Only check box selected, it will only report the error 76.
When the Data File Integrity Check is run with the Read Only check box cleared, it will report the error 76 as well as automatically adjust the balance of the Retained Earnings account for that month to match the calculated balance. The old and new balances for the months that were changed will be written to a file named G5DFIC76.LOG.
The following is an example of the contents of a GLS Data File Integrity Check Error Report with an error 76:
Date: 09/27/2009 GLS Data File Integrity Check Error Report Page: 1
Burns, Jensen & Powers, P.C.
Error
Count Code Error Description File Name Field Acct # Key<Ref#> Seq No
1 76 Retained Earnings Mismatch Account Jan 2009 Balance 330.00 247
1 76 Retained Earnings Mismatch Account Dec 2008 Balance 330.00 247
'Key<Ref#>' Legend.
Non-listed files and errors 55, 72, 73, and 74 cause this field to be blank.
Error 69 reports the index number in this field.
File Key represents
---- --------------
Account GLS Account
Journal Entry Record Number
Department Department Number
Journal Name Journal Number
Recurring Entry Record Number
Client Client Number
Verification User ID
--------------------------------------------------
DFIC was started at: 11:35 AM on 09/27/2009
DFIC ended at: 11:35 AM on 09/27/2009
2 error(s) were found
Anytime an automatic adjustment is made to the Retained Earnings account as a result of an error 76, detailed information regarding the adjustment is written to the end of the G5DFIC76.LOG file.
The following is an example of the contents of a G5DFIC76.LOG file:
GLS DFIC Retained Earnings Balance Adjustment Started at: 11:35 AM on 09/27/2009 by (JULIE) Client #1 Jensen, Martin & Anderson, P.C. (Location: ) Account Month Old Balance New Balance ======= ===== =========== =========== 330.00 Jan 2009 73452.80 149003.28 330.00 Dec 2008 70076.80 145587.28
A new heading section is printed for each time the Data File Integrity Check is run with error 76s reported. The (Location: ) label represents the GLS data path specified for the GLS client in the Edit GLS Client program. The same file is written to regardless of which GLS client the error was encountered in. A blank location simply indicates the data is in the same directory as the program files.
Because there are a number of reasons for these discrepancies to exist, please refer to our Knowledge Base article R10984, "Balance Sheet and Trial Balance Do Not Match". This article provides detailed information on how to compare reports to help you identify if additional Balance Sheet account balances are out of balance and provides detailed instructions on how to correct the balances. If you want to verify that account balances from the Income Statement match account balances shown on the Trial Balance and General Ledger reports (e.g., the Chart of Account balances), refer also to R10985, "Income Statement and Trial Balance Do Not Match".
Note: If you find that other account balances are not matching between the reports, you may be able to determine if the cause was due to editing of the Chart of Accounts by viewing the GLS Support Log. To access the Support Log, select View | Log Files | Support Log from the GLS menu. The first section of this file shows the last 30 account balances that were edited, who edited the balances and when they were edited.
THE INFORMATION PROVIDED IN THE SOFTWARE TECHNOLOGY, INC. KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. SOFTWARE TECHNOLOGY, INC. DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL SOFTWARE TECHNOLOGY, INC. OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF SOFTWARE TECHNOLOGY, INC. OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.
© 1999-2010 Software Technology, Inc. All rights
reserved. Terms of Use
The maker of Tabs3 and PracticeMaster
Tabs3, PracticeMaster, and the “pinwheel” symbol (
) are registered trademarks of Software Technology, Inc.
e-Mail Suggestions for the Knowledge Base to: kb@Tabs3.com
Technical Support via e-mail is not available.
Knowledge Base: http://support.Tabs3.com
Web Site: http://www.Tabs3.com