|Table of Contents|
The Financial Report Writer enables Users to create Custom Financial Statement Reports within the Office Product. The tool functions similarly to Excel, yet is embedded within the Office Product, allowing Live (Posted) Data to directly feed the reports. Users who have needs in excess of the Stock Financial Reports, are encouraged to learn more about the Financial Report Writer.
This video provides Users with an Overview of the Financial Report Writer tool.
Accessing the Tool
Within the Clubessential Office Product:
Choose Interactive Reports
Financial Report Writer
Functionality - The Basics
After launching the application, Users may choose to create a New report, Edit an existing Report Writer report, Open an existing Excel Spreadsheet, or Delete reports on the page.
Create a New Report
Click “New” to create a new report.
Define Sheet Settings
The area in purple shown above (Columns A and B, Rows 1-4) displays the built-in sheet setting components of the Report Writer, and serves as the reference point (base data) for the values displayed in the Report. The drop-down menus within the cells allow for easy customizable population.
By selecting desired data to populate the sheet settings in cells B1-B4, users define how the report will generate data based on the next stage of columnar and row definitions.
Define Row Settings
The Row Settings are in Columns A and B (beginning with row 5). The Row Settings include Accounts and Departments and must be set in order for the Report Writer to populate data.
The Account Settings allow users to specify the Account, Range of Accounts, or Selected Group of Accounts for which data is requested. Users familiar with the Chart of Accounts may type in Account numbers directly. In addition to direct entry, Users may request assistance (using the Lookup button, or F2), to make their account selection.
When a range or multiple accounts are selected, the Account Description display (if selected) will populate based on the first account in the selection.
The Department Settings allow users to specify the Department, Range of Departments, or Selected Group of Departments for which data is requested. Users familiar with the Department structure may type in Department numbers directly. In addition to direct entry, Users may request assistance (using the Lookup button, or F2), to make their Department selection, and launch the Lookup screen. This may be used to search for, filter, and specify Departments. Note that drop-down lists are available to help with selection.
Selected Department(s) will then populate cell(s) highlighted prior to Department selection.
Define Column Settings
The Column Settings are in rows 1-4, beginning in Column C. The Column Settings include Type, Year, Period, and Value, and must be set in order for the Report Writer to populate data.
The Type Settings include Actual or Budget, and may be selected from the drop-down arrow located on the right side of the “Type” cell. The Type Setting must be specified before Year Setting can be designated.
The Year Settings displayed depend on the Type Settings selected. For Actuals, Years will display up 15 historical, previous, and current. For Budget, Years will also display one future year.
Period Settings include Months, Quarters, Days, or Year to Date. To see all options, scroll down on the options scroll bar.
Value Settings are dependent on Type Settings. If Actual, options are: Starting Balance, Ending Balance, Net change, Account Name, Department Name, Account number, or Rollup Name. If Budget, option is $; the dollar value budgeted.
Once the above settings are specified, and data exists for the desired parameters, results will populate the grid. The data returned can be formatted, however, cannot be replaced with other values.
Save the Report
To save a report, click on the small arrow shown below, Click “Save As” to save a new report.
Once report has been saved initially, clicking “Save” thereafter will update existing report with changes made subsequent to initial save.
In addition to specifying the Sheet, Column and Row Settings, users may utilize cells not populated by the system to add Headings, Subtotals, Formulas, or other Formatting.
In addition to the top tabs, right-clicking on a cell in the customizable portion of the grid, launches familiar functions.
The Drill Down function allows users to identify the information supporting the numbers pulled into the Financial Report Writer. To drill down into a report, click on an amount, and then select Drill Down button, or hit the “F3” key.
General Ledger Transaction Screen will open, and allow for further investigation. Details will be listed below headings, and further drill-down/research (into batches, for instance) may be performed.
In addition to general statistical functions, the product also has unique Clubessential functions built in to report on additional data such as cover counts, rounds, etc. Click on the “Function” key, and look for the “CE” prefix to help identify these functions.
Print the Report
Set Print Area
To designate a portion of the report for printing, highlight the desired area to print. Then, go to the “Page Layout” tab, choose the “Print Area” button, and click the “Set Print Area” option.
Fit to Page
To specify the report print to designated number of pages, check the "Fit to Page" box. Then populate the "Fit Height" and/or "Fit Width" fields as required. In the example below, the report contents will print on two pages; however, all columns of the report will be visible on both pages.
To preview how the report will print, click the icon as shown, and select “Print Preview.”
Note: Page numbers will be displayed in the bottom left hand corner of the screen.
Within the Print Preview screen, click on the “Header/Footer” button to launch the “Header and Footer” screen.
The defined Header(s) and/or Footer(s) display in the Print Preview window.
Once Print Preview appears proper, click “Print” (or click “Quick Print” to automatically send report to default printer).
Once “Print” is selected, choose or confirm desired Printer, adjust any other settings as needed, then select “Print” to send job to specified Printer.
Print Entire Workbook at Once
To print the entire Workbook at one time, go to “Page Setup” tab, and ensure the “All Sheets” button is selected.
Create a Report from Existing Excel Report
To utilize an existing Excel report to get started, click, “Open”, and select Excel report file. Once file opens, Accounts, Departments, and other Parameters may be specified to populate the data within the already formatted report.
Open an Existing Financial Report Writer Report
To Open/Edit an existing Financial Report Writer report, highlight desired file, and click, “Edit.”
Q: What data displays in the Financial Report Writer Reports - posted and unposted batches?
A: While other Reports contain data from un-posted batches, the Financial Report Writer displays only data reflected in posted batches.