Trial Balance settings / Trial Balance does not balance to zero

Trial Balance Settings

1. Go to General Ledger > Financial Reports > Trial Balance. 

2. Check the report settings.  The below images are the default settings for a TB with a header level of 3 and detail level of 4, converting all accounts to the GBP currency.

• After selecting the correct settings, click the Floppy Disk Save Icon and run the report.

• Ensure Purchase Orders under the Actual to Date Calculation is unticked.

Open

• All boxes under Options are unticked 

  • Exclude Zero Budget _EFC should not be ticked

Open

Grouping accounts under headers:

Tick the ‘Consolidate’ box in order to group lines under a single header. For example, accounts with different currencies can be consolidated under a single header selecting this box.

• Ensure the Sequence Range tab is the same as below.

If the Trial Balance is not balancing for a production, you should check the following

Chart of Account Settings

1. Check the Chart of Accounts module.

• Look out for any accounts that are at level 0. Accounts set at level 0 are excluded by the report engine. To correct these accounts, you need to assign them an appropriate detail or header level.

• Check for any Initial Balance figures. Any values in here will throw off your TB balance.

Cross Currency Postings

2. Check if there are any transactions that have been incorrectly posted across currencies/locations by looking at your ledger and journals. 

If you have multiple currencies and locations, the easiest way to find that you have incorrectly done a currency transfer is to run the consolidated Trial Balance in Native Currency instead of a Base conversion. If the Trial Balance equals zero when running at Native then an incorrect cross currency transfer is the issue. 

Check this article for how to properly post across currencies: How to transfer cross-currency between bank accounts

You will then need to find which currency and location combo have the cross-currency error by a process of elimination (run each combination your Trial Balance in a Native conversion until you find the Trial Balance combinations that do not balance).

Once you have the incorrect currency and location you will need to scour your Ledger for the incorrect entries. The easiest way to do this is to start off with an Excel Export of Journals from Ledger Inquiry Reports.

Hidden Episode Codes or Location Codes

3. Check for items posted to different Episode Codes and Location Codes codes that are not selected or shown on the Report options. This usually occurs when the user has created incorrect chart of accounts by using the wrong episode or location code.

Check the Episodes and Locations set up in the Control Table → Episodes and Control Table → Location modules.

Then open up your Chart of Accounts Navigation module and sort your accounts by Episode or Location code, comparing the values to what is setup in the Episodes or Location modules.

Budget Worksheet Chart Rebuild

4. Finally if none of the previous solves the problem, run a chart rebuild from the Budget Worksheet, Setup Options tab. Tick Rebuild Chart Totals and click Refresh. This could take some time to run. Click through all the messages and if the first message doesn't equal zero, please email support.