Understanding the Visual Chart Organizer
In General Ledger 7, you can define many different ways your accounts will appear on your financial statements by creating multiple visual chart organizer templates. The visual chart organizer is a powerful tool that provides great flexibility in reporting.
- What reports use Visual Chart Organizer templates?
Visual chart organizer templates can be used in all Financial Statements and all GASB 34 reports. Additionally, the Chart of Accounts and Chart Validation reports (in the Accounts reports section) help you display and validate the information in your templates. The Working Capital Schedule report also allows you to pull accounts from selected visual chart organizer templates.
- What is the default template?
A default template contains all the major category headers and totals (i.e., assets, liabilities, equity, revenue, etc.), but little detail. You can use the default template as a starting point for designing a report, or you can start from scratch. You can also recreate a default template at any time. For best results, always validate your visual chart organizer template against a newly created default template to ensure any recently created accounts are included in the template.
- Viewing a Visual Chart Organizer template
Visual chart organizer templates can be viewed two different ways:
- Account View: This view allows you to see headers, detail lines, and totals similar to what will appear on your report, but without financial columns. Use the account view to see your report structure. You can apply fund, category, and department filters to see their effect on the report.
- Design View: This view shows the template structure. Use this view to design and organize your chart of accounts. By highlighting a specific header/total or detail line, you can define further information about a specific line.
- Adding accounts to a Visual Chart Organizer template
You can design your visual chart organizer by starting with the default, copying an existing template , or starting from scratch. However you initially create your template, you can then add accounts, reorder the accounts, and use blank Header/Total lines to create indented lines. For most detail lines you will want to include a range of accounts; however, you can also filter individual lines by fund, account attribute, project, project attribute, or transaction code. Before you can filter individual lines, ensure you enable advanced filters.
- Using the Visual Chart Organizer template
Once your template is complete, validate it against your default template before running your report. To use the template in the report, select it on the General tab of the report.
Before distributing a report run with your new template, ensure that everything is correct. Report parameter selections and visual chart organizer templates may contradict each other and cause totals to be incorrect or accounts omitted from the report. If your report totals are incorrect, review the VCO chart template.