Welcome! Please have a seat and login to a computer as yourself. Login to Financial Edge by clicking on , choose All Programs then Financial Edge (Remote), then Financial Edge (Production). Hello, my name is Abacus Owl! I’ll be popping in throughout the presentation today to see how things are going. Bryn Mawr College The Financial Edge: FE Income Statement Presented by the Controller’s Office and TLI FE Income Statement This class is intended for any user of FE who wants to know how to write/update an Income Statement report. This class will cover creating/updating an Income Statement report as well as learning tools available for reports. FE Income Statement - Agenda • Overview of FE Income Statement • General Ledger (GL) Income Statement – Overview – Template – New Income Statement • • • • Other useful GL Reports-Project Reports Learning tools on Blackbaud Training Central Available links on Controller’s Office web page Questions?? FE Income Statement - Overview • An income statement report is a summary of transactions. The summary gives you the total of all transactions in account(s) based on the filters and date parameters selected in the report. When you create or edit an income statement report some columns are automatically included in your output however you can add additional columns from a predetermined list of options. • Bryn Mawr does not use Encumbrances so ignore anything that says Encumbrance. FE Income Statement – GL Income Statement - Overview • Click on Reports then Financial Statements • Then click on Income Statement FE Income Statement – GL Income Statement - Overview List of Income Statements in alphabetical order by Name. To change the column sort in any column click on the column name. Helpful Hint: To widen columns hover in between column then left click and drag (this is the same way you widen a column in Excel!) To only show reports you created click box. FE Income Statement – GL Income Statement - Overview • Income Statement Tabs – General – Select the chart template, to include accounts with no activity or that are inactive. – Filters - Select fields and operators that determine which records are included in the Income Statement results. – Columns – Select the column headings and date ranges for the summary of transactions that will appear in the Income Statement results. – Multiple Column Headings – Create a heading to cover more than one column. Not necessary for most reports. – Format – Change page/printing set up and formatting within the report from standard defaults. Select formats for the report such as report heading, page footer, sorting results, color scheme, etc. FE Income Statement – GL Income Statement - Template • Under Income Statement/Name Helpful Hint: To make your own version of a template follow instructions under Description. – $Income Statement – STANDARD TEMPLATE – Create your own version of this template to run an Income Statement for your own department(s). This template includes prior & current fiscal year budget, actual, difference and variance columns. FE Income Statement – GL Income Statement – New Income Statement • Create a new Income Statement by clicking on New. FE Income Statement – GL Income Statement – New Income Statement • The Income Statement window will appear. -Click File and choose Save. • In Save Report as window enter the following: Helpful Hint: Include your initials in the Report name. -Required Field - Report name. -Optional Fields – Description, uncheck boxes. • Click Save. FE Income Statement – GL Income Statement – New Income Statement • General Tab Options Chart Template – use Default (most common) or click on drop down and choose another template. Uncheck boxes. Recommend you uncheck Include accounts with no activity and leave Include inactive accounts checked. Do not recommend you create an output query. FE Income Statement – GL Income Statement – New Income Statement • Filters Tab Filters are defaulted to include All. Click on All field under Include column for the row(s) where you want to add a filter and choose Selected (most common) or None. FE Income Statement – GL Income Statement – New Income Statement • Filters Tab –add a filter You can choose to Include based on a selected list, range or query (available with some filtersaccount or project type query only). Enter required data in white fields then click OK. Helpful Hint: You can search for the number by clicking on In the example, I chose Range then entered From and To project numbers. FE Income Statement – GL Income Statement – New Income Statement • Columns Tab Helpful Hint: Move order of columns by using blue arrows. Defaults include Account Number, Description and Actual for current month date range. To change a column double-click on the column row or to add another column click New Column. FE Income Statement – GL Income Statement – New Income Statement • Columns Tab-change a column Change the Column heading, Column width, Format, Decimal places. When done making changes click OK. Change Date Range on a column by clicking the Date Range tab. Then use the drop downs to choose from a wide variety of date options. FE Income Statement – GL Income Statement – New Income Statement • Columns Tab-add a new column To add another column click New Column. In the example, I am choosing Adjusted Budget-operating budget. Helpful Hint: Always choose Adjusted Budget when adding a budget column. Then add your Column Heading, Date Range, etc. When done click OK. FE Income Statement – GL Income Statement – New Income Statement • Columns Tab-add a new formula column In the example, I created a difference column so I could see how much $ I had left in my Budget. To do that I added the Budget column (column 3) minus the Actual column (column 4). Helpful Hint: You can get the % of budget used by using GetPercentVariance. To add a formula use the +,-,*,/,(,) buttons at the bottom. There is no need to add a Date Range since it is a formula. When done click OK. FE Income Statement – GL Income Statement – New Income Statement • Columns Tab-Completed Example Helpful Hint: You can hide any column on the report by clicking the box in the Hide? Column. FE Income Statement – GL Income Statement – New Income Statement • Format Tab Change page/printing set up and formatting within the report from defaults. Click on name to see options in each. Page/printing set up – Headings (report heading), Criteria, Page Footer, Report Footer. Helpful Hint: The Sort default is Fund but you can change it to sort by Dept or Project! Formatting within report– Detail, Sort, Miscellaneous, Color Scheme. FE Income Statement – GL Income Statement – New Income Statement • To run report click Preview button Print Export To update report close report results window by clicking on and you will be back on the report set up window. Helpful Hint: When exporting choose Excel 8.0 (XLS), the one that does NOT say extended. FE Income Statement – Other useful GL Reports • Project Reports Recommended Project Budget vs. Actual Report - Provides budget information and reports the actual activity of selected projects and accounts based on a selected date range. Use when you have a project with a budget (i.e.. Operating project or plant project). Project Detail Report – Run summary or detail format. Both provide beginning and ending balance amounts for a project based on selected date range. FE Income Statement – Learning Tools • Blackbaud Training Central website – Self-paced online class • Learning the Basics of Financial Edge Reports • Creating General Ledger Reports • Creating an Income Statement in General Ledger – Knowledgebase • Ask a question and view answers. • Use How to use Blackbaud (Financial Edge) Training Central guide located on Controller’s Office website at http://brynmawr.edu/controller/HowtouseBlac kbaudTrainingCentral912.pdf FE Income Statement – Controller’s Office webpage links • Income Statement documents are located under For Budget Monitors/General Accounting section-Using Financial Edge. FE Income Statement – Controller’s Office webpage links • Recommended links – General Ledger Reports Guide: http://brynmawr.edu/controller/FEGLreportsguide71012.pdf – FAQs – Financial Edge – Queries and Reports: http://www.brynmawr.edu/controller/FAQ.shtml#QueriesReports Questions ???