| | Create, modify, and print the Standard Financial Report |
| Description | - Different customization options are available, depending on the type of report selected in the first wizard window.
- The standard financial reports now include several usability improvements. You can view quarter-to-date income statements and set segment or roll-up codes.
- The user can choose to print account numbers, currency symbols, zero balances, or apply a percentage mask.
- Financial reports can only be run on existing fiscal periods and cannot be run on a "by date" basis. For the latter, the user should explore the GL Detail report or Sage Intelligence options.
|
| Resolution | ▼ Creating a new financial report - Open, General Ledger, Reports, Financial Reports.
- View the Financial Reports window with a list of existing reports.
- Use the three default reports. You can't change them.
- Click New Financial Report (bottom-left corner).
- Click Next.
- Type the report name and title.
- Choose a report type: Income Statement, Quarterly Statement, Balance Sheet, Trend Report, or Cash Flows.
- Choose a report group (optional).
- In Income Statement Type, choose one:
- Combined Statement – shows all full accounts
- Combined Summary – shows all main accounts
- Other types – show sub account or roll-up code descriptions
- Select a Column Format from the drop-down list.
- Choose Quarter to Date, Year to Date, or Both. Click Next.
- Choose a Column Data Format and Financial Period. Click Next.
- If you selected Trend Report, check Use Run Time Trend Period Options to change periods when printing.
- Choose number format options. Click Next.
- Check Print G/L Account Numbers and/or Print Accounts With Zero Balance if needed. Click Next.
- Enter a financial footnote if needed. Click Next.
- Use up to 1,024 characters for the footnote.
- Check Allow Footnote to be Changed at Run Time to edit the footnote when printing.
- Select account number ranges to print if needed.
- Check Use Run Time Ranges to define selection criteria at print time.
- Skip this window for cash flow statements.
- Review all settings. Click Finish to save and close the wizard.
- See the new report in the Financial Reports window. It’s selected for printing by default.
▼ Create a departmental financial report This option is only available for Income Statements, Quarterly Statements and Trend Reports - Open General Ledger, Setup, Sub Account Maintenance.
- Select the segment and sub account you need.
- Select Print Financial Reports.
- Click Accept.
- Open, General Ledger, Reports, Financial Reports.
- View the Financial Reports window with a list of existing reports.
- Use the three default reports. You can't change them.
- Click New Financial Report (bottom-left corner).
- Click Next.
- Type the report name and title.
- In the Income Statement Type field, choose the Sub Account description and/or Roll-up code description. See the example below.
- Choose the Column Format from the drop-down list.
- Select Quarter to Date, Year to Date, or Both, then click Next.
- Select a Column Format from the drop-down list.
- Choose Quarter to Date, Year to Date, or Both. Click Next.
- Choose a Column Data Format and Financial Period. Click Next.
- If you selected Trend Report, check Use Run Time Trend Period Options to change periods when printing.
- Choose number format options. Click Next.
- Check Print G/L Account Numbers and/or Print Accounts With Zero Balance if needed. Click Next.
- Enter a financial footnote if needed. Click Next.
- Use up to 1,024 characters for the footnote.
- Check Allow Footnote to be Changed at Run Time to edit the footnote when printing.
- Select account number ranges to print if needed.
- Check Use Run Time Ranges to define selection criteria at print time.
- Skip this window for cash flow statements.
- Review all settings. Click Finish to save and close the wizard.
Example - Account Structure= 4-2-2 (Main - Department - Location) 4000-01-02
- 4000 = Main
- 01 = Department
- 02 = Location
- Types available in the drop-down list are Department and Location
▼ Income Statement Trend Report - Open General Ledger, Reports, Financial Reports.
- Click the New Financial Report button (bottom-left corner).
- Click Next on the first screen of the wizard.
- Type a report name.
- Select Trend Report from the Report Type drop-down list.
- In the Set Trend Report Format window, choose the type of trend report and column data format.
- Select the Use Run Time Trend Period Options check box.
- Click Next and make selections in each window.
- Click Finish.
- Select the report you just created to run it.
- In the Print Financial Report window, on the Main tab, select the reporting year and period.
- On the Trend tab, make your selections.
- Select the number or range of periods to print
- Choose Trailing Number of Periods to print periods before the current one
- Pick a value from 1-12
- Choose a Specified Range of Periods to set a start and end period
- Select periods in the First Period and Last Period fields
Check the Use Run Time Trend Period Options box to use the Trend tab options. Example - If the current period is period 5 and you want to print information for periods 1-4
- Select Trailing Number of Periods option and then select 4
▼ Modify a report created through the wizard By design you can't modify Standard financial reports. - Open General Ledger, Reports, Financial Reports.
- Select the applicable report you’re modifying in the Financial Reports window.
- Click Modify button (the middle icon located on the right side).
- This will launch the Financial Reports Wizard with the previously defined settings.
- Modify all information except the Report Name and Report Type.
▼ Printing financial reports - Open General Ledger, Reports, Financial Reports.
- Select Print check box for the desired report.
- Click Proceed, to open the Print Financial Reports window.
- Select desired options on the Main tab.
- If you selected Use Run Time Ranges in the wizard, select options on the Select or Trend tabs.
- Click Print or Preview button.
Notes: - Some print options aren't available, depending on selections made in the wizard
- If you select multiple reports, each report will print separately
- When you preview the report, close the first report so the next report will display
- You can export reports at the preview screen. Click the Export Report (envelope) button at the top of the preview window
▼ Deleting financial reports - Open General Ledger, Reports, Financial Reports.
- Select the report you wish to delete.
- Click Delete Row button.
- By default, you can't modify or delete the Standard Financial Report group
|
|