Table validation fund does not net to zero by period





Description of Issue

We are out of Balance on the Trial Balance

Table validation error fund does not net to zero by period



Context
  • Table validation

  • Trial Balance

  • Errors

  • Month end manager

  • Fund



Cause

Old accounts receivable and accounts payable issues at end of year

Manual Journal posted incorrectly



Resolution
  1. Reverse the Journal with the issue. (Often the Journal in question includes other Funds and can have multiple lines associated with it. In this case using option #2 below would be recommended)

  2. Create a one-sided Journal Entry to correct the account that is out of balance



Additional Information

Reconciliation may be necessary to determine the Accounts with the issues. This can be accomplished by using the Account Trial Balance Report or reviewing the Journal detail monthly amounts more closely in Account Inquiry. Use one of the following methods to reconcile

  1. The Troubleshooting Table Validation Errors - 11.2 and Above

Troubleshooting Steps:

Run the Account Trial Balance report for the fund and for both the reported period and for the month immediately following the reported period

If more than one period has been identified, the Account Trial Balance should be run for each period, one at a time, oldest first. (Period 1 than 2, then 3 etc.)

For each period, verify that the beginning and ending balance of each month is 0.00. For any month where the beginning and ending balances are not zero, compare the ending balance of each account to the beginning balance of the same account for the next period. Any time the balances from the end of one month do not equal the beginning balance for the start of the next month, you have identified a problem