Closing Entries from Analysis View Entries

Incomes and expenses must be analyzed over time intervals including several accounting periods. In order to obtain accurate data, month closing entries must be excluded from these analysis. Analysis by Dimension functionality does not exclude these entries when run over several accounting periods. A development was needed in order to exclude closing entries from Analysis by Dimension functionality.

How to set up and run an Analysis View for Excluding Closing Entries

1. Choose the Tell Me Icon, enter Analysis Views, and then choose the related link.On the Analysis View List page, choose the New action.
2. In General tab fill in:

• Code – code of the new analysis by dimension;
• Name – description of the new analysis by dimension;
• Account Source – G/L Account;
• Account Filter – to include transactions only for Income Statement G/L Accounts;
• Exclude Closing Entries – select this option in order to exclude closing entries for this analysis at update.

3. In Dimension tab select values for Dimension 1 Code, Dimension 2 Code, Dimension 3 Code and Dimension 4 Code. After creating this new analysis, click Update button.
4. After finishing the set up, the Analysis View List must be run from the Tell Me Icon.
5. From Analysis View List select the analysis excluding closing, and select Analysis by Dimension button.
6. In Analysis by Dimension select in General tab:

• Analysis View Code – code of the analysis excluding closing entries;
• Show as Lines – G/L Account;
• Show as Columns - the first dimension from Analysis Card

7. In Analysis by Dimension select in Filters tab:

• Date filter- a time interval that includes more than two accounting periods and closing dates;
• Account Filter – default value from analysis by dimension card.

8. Select Show Matrix button.

Expected Results

Calculated values from Analysis View entries don't include closing entries for the G/l accounts included in the Income Statement.