Setting Up a Financial Statement Output

  1. Open the Financial Statement Output form.
  2. Specify this information:
    Report ID
    Select the ID of the report you want to print.
    (Description)
    The description of the report is displayed.
    Account Detail
    If you select this check box and a line's Print Line setting is Yes, sequence lines whose Type = Account are printed. If you do not select this check box, sequence lines whose Type = Account are not printed. In both cases, if a line's Print Line setting is Yes, line types of Total, Text and Net Income are printed.
    Unit Code 1-4 Detail
    Use these check boxes to print a separate line for each unique unit code value. Clear the check boxes if you want to sum all amounts in the corresponding unit code range into a single amount.
    Report Type
    Select one of these report types to indicate how you want this financial statement to be run:
    • Main
    • Unit 1
    • Unit 2
    • Unit 3
    • Unit 4
    If the Report Type is anything other than Main, the account balance information on the report is strictly for the range of Unit Codes (1-4) specified on this form. If the Starting Unit Code 1 on the Financial Statement Line Definition form has a value defined, it is used as the starting range of Unit Code 1s for determining the account balance. If it is blank on the Financial Statement Line Definition form, the Starting Unit Code 1 value from the Financial Statement Output form is used. This same logic holds for all Starting and Ending of all four Unit Code types (1-4).
    Currency
    Select the currency you want to use for the amounts in the report. The domestic currency is displayed by default.
    (Currency Description)
    A description of the currency is displayed.
    Current Date
    When you use the current date translation method with financial statements and ledger consolidation, the system uses today's date as the current date. If you need to print a historical statement for a prior period using the current translation method, select the date to use.
    Increment Date (Current Date)
    Select this check box to have the system automatically increment the date range and re-run the report.
    Multi-Site Group
    Select the multi-site group for this output.
    Line Summary Level
    Select the value to use to define the level of output detail for the financial statement:
    • Direct Reports: Shows one line for each account and for each site. If the direct report is an entity, it reports to the current entity and then summarizes all sites for that entity into a single line.
    • Site: Shows one line for each account and for each site.
    • Summary: Shows and summarizes all sites into a single line for each account. Your selection in the Multi-Site Group field determines which sites to include. If this is an Entity database, all sites which report to the database display.
    Year Start
    Select the date you want to use as the year's start date for calculating year-to-date amounts, or accept the date defined on the Accounting Periods form.
    Increment Date (Year Start, Period Start & Period End)
    Select this check box to have the system automatically increment the date range and re-run the report.
    Period
    The number of the current period displayed. Optionally, specify a different period. This is used only if the Period field is blank in a column's definition.
    Period Start/End
    Select the period starting and ending dates for the report, or accept the date that is displayed for the specified period. This field is used for calculating period-to-date amounts. It is used only if the dates are blank in a column's definition.
    From/To Sub-Account
    Specify the range of sub-accounts to include.
    Sort Order
    Define the order by which you want to print the financial statement by.
  3. Click Preview to view the output before running the report.
  4. Click Print to run the report and print the output.
Related topics