When you work with a group of entities, there may be situations where one entity within the group sells or buys from another. If you want to adjust your reports to account for these inter-entity transactions, you can do this automatically in Spotlight Forecasting.
There are two ways in which you can eliminate values for an account; for a single entity, or for all entities which contain that account. If required, you can also make a manual adjustment to the eliminated actuals for accounts receivable/payable accounts.
The value for the account(s) for each relevant entity is reduced to zero in the data grid.
Once you've saved the changes, each account which is being eliminated is marked with an 'E'. If required, you can click the plus sign alongside the account to check which individual entities are eliminated.
Once you've saved the changes, each account which is being eliminated is marked with an 'E'.
If you need to, you can enter specific values to adjust the amounts eliminated for accounts receivable / payable during periods of actuals.
Note: Before using this option to adjust the amounts eliminated for accounts receivable and accounts payable, you must have added an elimination for the account in at least one entity. For information about how to do this, please refer to the previous sections.
The data grid is updated to incorporate your adjustments.
The elimination is removed and the data grid once again reflects the value in the account.
This happens when the values in the accounts selected for elimination do not cancel each other out. To resolve this, check that all relevant accounts have been set up with eliminations, and that no incorrect accounts have been added. If there is still a value on the Elimination Adjustments line, one possible cause is a variation in the exchange rate.
When you eliminate a value, this is removed from the data grid in Customise Data immediately. This is so that the data grid reflects what will be shown on the final report.