TB Integrity Checker Help Guide
Is your trial balance out? No need to worry. This helpsheet will take through step by step in finding and fixing the discrepancy. By following this guide you will be able to run the Trial balance integrity checker. Find and understand the error. And more importantly fix them. This is also a good exercise preform even if your balance isn’t out. It will show you any incorrect postings so you can make sure your accounts are nice and tidy.
- Firstly, go to the general ledger and click the TB integrity checker button.
- You will now see the below screen. Next to run the integrity checker click the tick box at the bottom right.
- Once the checker has run you will see any outstanding issues relating to your trial balance
- Please see the below segment on each of the errors you will encounter and how to fix each of them.
- Main Nominal Code S/B a Bank Account (the nominal the payment or receipt is in)
Why does this happen? This means that a bank payment or receipt has been posted to a nominal. This occurs if for some reason a payment gets posted into a nominal. All payments and receipts must be posted into bank accounts as standard.
How can I fix it? The error message is very comprehensive and will tell you the nominal that the error is in. Then if you do an advanced search for the transaction type within that nominal. You will then be able to edit that transaction line and move it to a bank account. Please note you will need to be logged in as the super user to do this.
- Main Nominal Code (nominal the posting is in) Unknown
Why does this happen? This means that one or more transactions cannot be matched against a nominal in the system. Normally this happens if a nominal has been deleted. We would advise setting them to no longer available rather than deleting them as it will put your trial balance out.
How can I fix it? You can fix this by re adding the nominal with the code that the error states. The any transactions will then show back in the nominal. Then you can set it to no longer available if you wish.
- Nominal Brought Forward Balance = (the amount the brought forward balance is out by)
Why does this happen? This means that a brought forward balance on a nominal is incorrect. This would normally happen if you have closed your year end with outstanding issues in the system. This in turn can make your brought forward balances incorrect.
How can I fix it? Firstly, run the trial balance integrity checker. Then run through any issues found in previous years. You will need to contact support to open any previous years. Then work though the errors. Finally, the year end routine for the last year will need to be re ran to update the brought forward balances.
- Journal Out Of Balance By = (the amount the journal is out by)
Why does this happen? This error happens when a journal entry does not balance. The system will only let you post journals if they match. Normally this can only happen if the data has been edited manually or if you are on the TOPSPEED platform a data corruption occurs.
How can I fix it? If the journal is in an open period and you are logged in as the super user you can edit the journal to correct it. If the journal is in a closed period you would need to contact support for this change to be made.
- Bank Payment Out Of Balance By = (the amount the payment is out of balance by)
Why does this happen? This error means that the payment has been processed with an imbalance.
How can I fix it? The error message will give you the transaction number and amount the balance is out by. You will need to perform a nominal export. Then search for the transaction number in the error message. You will then be able to go through the debit/credit and tax amounts to see where the payment is out. You can then go into the system and make the correction as the super user. If for some reason, you are unable to make the correction please contact support.
If you have any further questions on the above please don’t hesitate to contact our friendly support team either by phone, email or live chat.
