advanced techniques: a fresh look at your general ledger financial statements
DESCRIPTION
Visual Chart Organizer is a template view of how your chart of accounts will look in a financial statement report. In this advanced class, we’ll take a look at the Visual Chart Organizer and evaluate the effectiveness of using account attributes in Visual Chart Organizer groupings. We’ll also explore formula fields to compare actuals to budget in columns. Plus, we’ll show you how to format a single statement file to print multiple statements.TRANSCRIPT
Advanced Techniques: Get A Fresh Look at Your Financial Statements in General Ledger™LOGAN TRAVIS
#bbcon#LearnLab
#FE#LoganTravis
Tweet this now
2 #bbcon
Agenda
• Review the purpose and setup of the Visual Chart Organizer (VCO)
• Discuss account attributes and their purpose in VCOs• Create an income statement with formula columns• Discuss sort options for a financial statement
3 #bbcon
What Does a Visual Chart Organizer (VCO) Do?
4 #bbcon
What Does a VCO Do?
5 #bbcon
What Else Does a VCO Do?
6 #bbcon
How to Create a VCO
7 #bbcon
Ways to Create a VCO
• Account code ranges
• Advanced filters
• Advanced filters using account attributes
8 #bbcon
Advanced Filters
9 #bbcon
Demonstration
10 #bbcon
Additional Ways to Format a Report
11 #bbcon
Income Statement Columns
12 #bbcon
Income Statement Formatting
13 #bbcon
Variations on Our Financial Statement• Change the VCO for new groupings
• Change the levels for more/less detail
• Adjust the columns for different data
• And more…
14 #bbcon
Summary• Review the purpose and setup of Visual Chart Organizer
• Create chart templates that determine the accounts to include in your financial statements and how the financial statements look
• Discuss account attributes and their purpose in VCOs• Attributes are organization specific fields which can be used in grouping
accounts through the VCO• Create an income statement with formula columns
• On the Columns tab of financial statements, you can define the information included in each column of the report
• Discuss sort options for financial statements• Under the Sort area of the Format tab, you can select from a number of
options to customize the sort order and grouping of your financial statements
15 #bbcon
Steps to Create a Financial Statement
1 On the navigation bar, click Reports.
2 On the Reports page, click Financial Statements.
3 Select a report, and then click New.
4 Select or create a Visual Chart Organizer.
5 On the Columns tab, configure the report columns.
6 On the Format tab, click Sort.
7 Select the report formatting options.
8 Define additional report options as needed.
9 On the File menu, click Save.
16 #bbcon
17 #bbcon
Don’t forget to complete a session survey! Each completed survey enters you into a drawing to win a complimentary registration to bbcon 2015 in Austin, Texas*.
*Blackbaud reserves the right to change or withdraw this promotion at any time, without advance notice. Promotion has no cash value and may not be exchanged, applied to, or combined with any other offer.
Are you pumped up and ready to go?
Training and Certification
Make Your Daily Tasks Easier Execute Faster
Increase Your Effectiveness
Visit the Expo’s Training Booth
18 #bbcon