G/L Statement Designer

Overview

Use the Statement Designer to create or edit a report specification for generating financial statements.

When you open the Statement Designer screen and then click the Start button, Sage 300 ERP starts Microsoft Excel with the Financial Reporter add-in.

Important! This add-in is available only when you start Excel from the Statement Designer.

The Financial Reporter add-in is a set of commands that you select from the FR menu on the Microsoft Excel ribbon. For more information, see FR Menu Commands.

Tip: Turn on manual calculation in Excel so that formulas are not updated automatically. You can recalculate FR commands at any time by pressing the F9 key.

Using the Statement Designer to Design Financial Statements

For information on using the Statement Designer to create custom financial statements, see Designing Financial Statements.

For a series of short lessons on using the Statement Designer, see Financial Reporter Tutorial.

For information on the fields that you can use in financial statements, see:

• Account Master Fields
• Transaction Fields

Including Information in Printed Financial Statements

You can include the following options when printing financial statements from the G/L Financial Statement Designer by clicking FR > FR View on the menu bar:

• Report Options
• Audit Information
• Formulas
• DrillDown Information

Report Options

When you select Report Options, the first page of the financial statement displays the following information:

• Statement name
• Fiscal year and period
• Report type (actual or provisional)
• Account processing and sorting order
• Account selection ranges

Including DrillDown Information

On the G/L Print Financial Statements and Statement Designer screens, you can select the DrillDown Information option to add drilldown link comments to the generated report.

For more information, see About FR Drilldown.

Including Audit Information

The Audit Information option is available only when using FR View in the Statement Designer—it is not available on the G/L Print Financial Statements screen.

When you select Audit Information, the statement includes information from the control information columns of the spreadsheet (columns A through D), as well as the report columns that are usually printed.

Including Formulas

The Formulas option is available only when using FR View in the Statement Designer—it is not available on the G/L Print Financial Statements screen.

Usually, when you generate a report from a financial report specification, Financial Reporter inserts balances and net amounts from the database into the generated financial report. However, if you select Formulas, Financial Reporter creates a financial report from the specification with a formula for each general ledger balance or net that appears in the final report. You can then update that financial report with current database values by recalculating the spreadsheet (pressing F9).

The most common type of report that is composed only of formulas is one that keeps financial ratios.

Note: Spreadsheets with formulas are much larger than standard report specifications—and they are less flexible.

Financial Reporter automatically refreshes General Ledger data the next time you load the linked spreadsheet in the Statement Designer. You can also use the G/L Print Financial Statements screen to recalculate and print the report.

If you want to change the report (for example, by adding new accounts in the chart), you must regenerate the report to incorporate the changes in your statement.

Related Topics