IN THIS SECTION
Overview
The Balancing Indicator works on the Trial Balance, Balance Sheet and Custom Balance Sheet reports and displays a message when the report does not balance.
How does it work
Joiin determines if the report balances by examining the data for the selected report filters (companies, dates, currency etc.), taking into account adjustments and eliminations and checks if the total of Credit accounts matches the Total of Debit accounts.
NOTE: On a custom balance sheet report, the balancing indicator works because it is examining the underlying account data. It does not consider how the groups and formulas are structured within a custom report.
Balancing Advice
When you see the balancing message, click on the LEARN MORE link to get more details about why the report does not balance. These details show you a list of items that Joiin has found relating to the overall balance of the report. It then displays a list of guidelines on how you can possibly fix them.
Factors that may be included in the list are as follows.
| Factor | Description |
|---|---|
| Includes Adjustments | Tells you if the report results include some values that have been adjusted by adding Company Adjustments. |
| Includes Eliminations | Tells you if the report results include some values that have been changed/removed due to Eliminations being applied. |
| Each Company Balances in Home Currency before Adjustments and Eliminations | This will tell you if each individual company you are reporting on, in its home currency, without any adjustments or eliminations, balances. In normal circumstances this should be the case - e.g. a company that comes directly from Xero should always balance in its home currency. If you are using manual Joiin companies though this may not be the case. |
| Each Company Balances in Home Currency after Adjustments before Eliminations | This will tell you if each individual company you are reporting on, in its home currency, balances AFTER any adjustments have been applied but BEFORE any eliminations have been applied. This can help to tell you if any adjustments you have applied have caused an imbalance. |
| Each Company Balances in Home Currency after Adjustments and after Eliminations | This will tell you if each individual company you are reporting on, in its home currency, balances AFTER any adjustments and eliminations have been applied. |
Switching the Balancing Indicator off
You can switch the Balancing Indicator off at any time through the Reporting Configuration page.
- Select Reporting Configuration from the Settings menu at the top right.
- In the Exchange Rate section de-select the Balancing Info check box.
- Click on Save Configuration button to save your changes.