G/L Statement Designer
The Statement Designer lets you create or edit a report specification for generating financial statements.
When you choose the Statement Designer icon from the Financial Reporter folder, Sage ERP Accpac starts the Microsoft Excel spreadsheet program with the Financial Reporter add-in.
It is important to remember that this spreadsheet add-in is available only when you start Excel from the Statement Designer icon.
The add-in adds the FR menu item to the Microsoft Excel menu bar. The FR menu includes the following Financial Reporter commands:
Key Financial Reporter concepts
The Financial Reporter is based upon a few simple concepts:
-
A financial report is a spreadsheet containing functions that read data directly from the general ledger.
You can place Financial Reporter functions anywhere in a spreadsheet. The spreadsheet program looks up the General Ledger values when it recalculates the spreadsheet.
You can also use any other spreadsheet functions to further manipulate that data.
-
A financial statement specification is a structured description of the statement you want to produce. Financial Reporter creates a statement based on the specification and the options you choose when you want to print or view the final statement.
Statement specifications allow you to assign default functions and formulas to columns of the spreadsheet, and to specify that a range of accounts will be expanded to many rows on a final statement.
Statement specifications make statements easier to create and more flexible, but you don't have to use them.
-
Financial Reporter lets you specify at print time the account segments, account group, fiscal period, and fiscal set (actual or provisional amounts) to include in the report.
Keep in mind when designing statements that a generalized financial statement can be printed with the actual or provisionally-posted amounts of any particular department or division.
-
When creating a financial report in Financial Statement Designer, you can enter formulas that allow you to drilldown to associated transactions in the resulting report.
It is our assumption that most of the statements you create will be generated from statement specifications.
See also