Table validation fund does not net to zero by period
We are out of Balance on the Trial Balance
Table validation error fund does not net to zero by period
Table validation
Trial Balance
Errors
Month end manager
Fund
Old accounts receivable and accounts payable issues at end of year
Manual Journal posted incorrectly
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)
Create a one-sided Journal Entry to correct the account that is out of balance
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
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