Page History
...
Steps to Create a Financial Report
...
- Row Design – Rows are consistent regardless of date variation.
...
- Column Design – Columns/date variation change per report.
...
- Report/Page Header & Footer - May vary or consistent
...
- Financial Report Builder – Combines Row, Column, and Page/Report Header and Footer.
Row Design
•Financial
- Financial Reports > Maintenance > Row Designer
- The Row Design screen is where you will configure rows for you financial reports.
Row Design Example
Row Design Options
•Verify
- Verify Accounts
- This will show all missing or duplicate accounts by either primary or full account.
Row Design Options•Generate
- Generate Row
- This will generate rows based on the criteria entered.
- The example below will create a row for each full account as calculation type.
Row Design Options•Save
- Save
- Duplicate
- Delete
- Undo
- Fonts
Column Designer
•Financial- Financial Reports > Maintenance > Column Designer
- The Column Designer screen is where you will configure the date ranges or column calculation of the financial report.
Column Designer Example
Column Design Options
...
- Filter Type - Different Date Ranges
...
- Column Calculations
...
- Budget Column
- http://help.irelyserver.com/display/DOC/Budget+CSV+format
- http://help.irelyserver.com/display/DOC/How+To+Import+Budget+from+CSV
...
- Hidden Columns
Column Designer Options
...
- Segment Filter
- •Allows to see Location/Profit Center financials by Column.
Page Header/Footer
...
- Report Header Footer allows to add additional information in regards to the report, such as Report title, segment filter, date, time, page, etc.
...
•Page
- Page Footer prints at the bottom of each page.
Page Header/Footer Options
...
- Fonts
...
- Left, Center, Right alignment
...
- Duplicate
...
- eport Builder
...
- Financial Reports > Maintenance > Financial Report Builder
...
- This will combine and Row Designer, Column Designer, Page/Report Header & Footer to create the financial Report.
...
•I
- I used an existing Row Designer and created a new Column Designer and created a new report.
•If
- If Report Settings indicator is checked in Report Builder, the Report Settings screen will pop up with generating the report.
Report Settings
•As
- As of Date field is ONLY used when Column Designer filter is “As Of” type. However, this will print on the report.
- Segment Filter will allow you to print a consolidated financial report just for a chosen segment/location/profit center.
- Suppress Zero will not print rows with $0 balance
- Audit Adjustment is a journal entry type that is used to included/exclude on a report. Used for year end adjustments.
Overview
Content Tools