Consolidating/summarizing account totals on Financial Report

Consolidating/summarizing account totals on Financial Report

Postby Customer Service » January 30th, 2012, 7:11 pm

How do I consolidate or summarize account totals on financial reports?

You can set up financial reports to consolidate or summarize the account totals into a single total for a caption, rather than showing all the accounts with their individual totals under the caption. Using the same procedures, you can also group accounts in a category into subcategories, printing only the subcategory totals on the financial reports.

The key step is to select the option to suppress caption details in the Caption Properties window. Say, for example, you want to show all salary expenses as a separate total on your Income Statement.

Follow these steps:

1. Run General Ledger/Configure/Financial Report Templates.
2. Open the Income Statement folder and select the appropriate income statement template, if you have multiple templates.
3. Press Tab to move to the right pane for editing the template.
4. Make sure that “Include GL accounts” is set to “explicitly.”
5. Click the Show All button or press Alt+S to show all the captions, categories, and accounts.
6. Highlight “Operating Expenses and either right-click or press F9 and insert a caption.
7. Enter the caption text, Salary Expenses, and select the option to Suppress Caption details. Select any other options you want. Do NOT check “Use bold font” if you want the “summary” caption to look like the other accounts.
8. Click OK.
9. Now move the salary expense accounts you want to include under the new Salary Expenses caption. You may also wish to adjust the indentation of the new caption.
10. Click OK and then click Save changes.
11. Print the Income Statement that is based on this template to see your changes.
Customer Service
Site Admin
 
Posts: 318
Joined: November 15th, 2011, 1:04 am

Return to Financial Reports and Special Forms

cron