How to view and add missing accounts to your report layouts

To write a comprehensive and insightful report, it’s advised that you use all the account information available in your General Ledger (GL). To extract accounts from your GL and list them in your report layouts we recommend that you use Account Ranges and Category Codes. However, if additional accounts are added to your GL that fall outside these ranges, they will not reflect in your layouts. You can view omitted accounts and add them to your layouts by using the Missing Accounts feature in the Sage Intelligence Report Designer Task Pane.

Missing Accounts compares the accounts listed in your report layouts with the accounts in your General Ledger, and creates an exception list in a new sheet in your Microsoft® Excel® workbook so that you can copy these accounts to your report layouts. Missing Accounts can be found in the Tools tab of the Task Pane.

Applies to:

• Sage 50 Accounting U.S. Edition 2015.1 Intelligence Reporting
• Sage Evolution Version 7 Intelligence Reporting
• Sage Pastel Partner Version 14 Intelligence Reporting

Method:

1. Check for missing accounts
2. Add missing accounts to report layout
3. Save Excel Template

Checking for Missing Accounts in the Current Layout

1. To view missing accounts from your current layout (the worksheet that is currently active in Microsoft Excel), select the Tools tab from the Task Pane in Microsoft Excel.
2. Select View, Current Sheet.

If there are no missing accounts, a notification message in the Task Pane will indicate that there are no accounts missing from your current worksheet.

If there are accounts missing from your current worksheet, a Missing Accounts worksheet will be generated in the Microsoft Excel workbook to display them. You can copy these accounts into the report layout if necessary or ensure that your account ranges include the missing accounts.

Viewing Missing Accounts for All Layouts

1. To view missing accounts for all the open layouts in your workbook, select the Tools tab from the Task Pane in Microsoft Excel.
2. Select View, All Sheets.

If there are no missing accounts in the open layouts, a Task Pane notification message will indicate that there are no accounts missing.

If there are accounts missing from your open sheets, a Missing Accounts worksheet will be generated in the Microsoft Excel workbook to display the accounts that are missing from each layout. You can copy these accounts into the report layouts if necessary or ensure that your account ranges include the missing accounts.

Adding the Missing Accounts to Your Report Layouts

1. Identify the missing accounts from the new Missing Accounts worksheet.
2. In the report layout(s) you have open, insert blank rows for the missing accounts.
3. From the Missing Accounts worksheet, copy the Account Number, and if needed, the Account Description fields for each of the missing accounts.

4. Paste the missing accounts into the blank rows of your report layout(s).

5. Copy the financial formula from one of the existing accounts in the layout and add it to the new accounts.

6. You can then delete the Missing Accounts worksheet from your report.

Save Excel Template

1. NB: Go back to the Report Manager and save the Excel Template. This will then ensure that the next time you run the report, your missing accounts will be included in your layouts.