Previous | Next | Contents | Index | Navigation | Glossary | Library |
The most common income statement formats are:
Income Statement Type | Report Definition Considerations |
---|---|
Current Year | Row Set: · Define account assignments to group related revenue and expense accounts. · Define calculations for subtotals and totals. Optionally, use display options for totalling account ranges. · Use row set format options for indenting, line spacing and underscores (for subtotals and totals). · Use the change sign feature for revenue accounts, so credit amounts print without negative formatting. Column Set: · Define a custom column set using the amount type YTD-Actual. |
Comparative Time Periods | Row Set: · Use the same row set used for Current Year income statement. Column Set: · Use a standard column set choose from Monthly Comparative YTD; Quarterly Comparative YTD; or Annual Comparative QTD, YTD. Optionally, define a custom column set. |
Comparative Amounts | Row Set: · Use the same row set used for Current Year income statement. Column Set: · Use a standard column set choose from PTD Variance; QTD Variance; or PTD, QTD, YTD Variance. Optionally, define a custom column set. |
Rolling | Row Set: · Use the same row set used for Current Year income statement. Column Set: · Use a standard column set choose from Rolling Monthly or Rolling Quarterly. Optionally, define a custom column set. · Use period offsets and relative headings to synchronize columns with reporting periods. |
Table 1 - 14. (Page 1 of 1) |
The most common balance sheet formats are:
Balance Sheet Type | Report Definition Considerations |
---|---|
Current Year | Row Set: · Define account assignments to group related asset, liability, and equity accounts. · Define calculations for subtotals and totals. Optionally, use display options for totalling account ranges. · Use row set format options for indenting, line spacing and underscores (for subtotals and totals). · Use the change sign feature for liability and equity accounts, so credit amounts print without negative formatting. Column Set: · Use the same custom column set you defined for current year income statement. Optionally, define a new custom column set (using the amount type YTD-Actual) if you need different formatting options. |
Comparative Time Periods | Row Set: · Use the same row set you defined for the current year balance sheet. Column Set: · Use a standard column set choose from Monthly Comparative YTD; Quarterly Comparative YTD; or Annual Comparative QTD, YTD. Optionally, define a custom column set. |
Rolling | Row Set: · Use the same row set you defined for the current year balance sheet. Column Set: · Use a standard column set choose from Rolling Monthly or Rolling Quarterly. Optionally, define a custom column set. · Use period offsets and relative headings to synchronize columns with reporting periods. |
Table 1 - 15. (Page 2 of 2) |
There are two different types of statements of changes:
Statement of Changes Type | Report Definition Considerations |
---|---|
Accrual Basis | Row Set: · Define account assignments for sources of funds. Use DR (debit) and CR (credit) activity types as needed. Apply appropriate accrual accounting rules when grouping accounts and determining what activity types to include. · Use non-displayed row definitions for intermediate calculations. · Define calculations for subtotals and totals. · Use row set format options for indenting, line spacing and underscores (for subtotals and totals). · Use the change sign feature for accounts with credit amounts. Column Set: · Depending on your reporting needs, use one of the custom column sets you used for current year and comparative time period balance sheets. |
Cash Basis | Row Set: · Define account assignment ranges for sources of cash. Use DR (debit) and CR (credit) activity types as needed. Apply appropriate cash accounting rules when grouping accounts and determining what activity types to include. · Use non-displayed row definitions for intermediate calculations. · Define calculations for subtotals and totals. · Use row set format options for indenting, line spacing and underscores (for subtotals and totals). · Use the change sign feature for accounts with credit amounts. Column Set: · Depending on your reporting needs, use one of the custom column sets you used for current year and comparative time period balance sheets. |
Table 1 - 16. (Page 1 of 1) |
A consolidating report can be prepared for virtually any type of financial report, but is most often used for income statements, balance sheets, and statements of changes in financial position.
Consolidating Report Type | Report Definition Considerations |
---|---|
Income Statement and Balance Sheet and Statement of Changes | Row Set: · Use the row set created for your standard income statement, balance sheet, or statement of changes. Column Set: · Define a custom column set using segment overrides, so each column displays only one company. You can use this same column set for all consolidating reports. · Define a column for intercompany eliminations. · Define a column for your consolidated total. Create a calculation to total your separate company columns and add/subtract the intercompany eliminations. |
Table 1 - 17. (Page 1 of 1) |
Operational Report Type | Report Definition Considerations |
---|---|
Sales Analysis | Row Set: · Define account assignments for your sales accounts. Use the expand display option for the greatest detail. · Define calculations for subtotals and totals. · Use row set format options for indenting, line spacing and underscores (for subtotals and totals). · Use the change sign feature for sales accounts, so credit amounts print without negative formatting. Column Set: · Depending on your reporting needs, select an appropriate standard column set or existing custom column set. For example, use your current year income statement column set for a current year sales analysis. Use the Monthly Actual standard column set to produce a sales analysis report for each month in the current period. If needed, define a new custom column set. Other: · Use a content set to create sales analysis reports for each region. · Use a row order to rank sales in descending order by department within the regions defined by the content set. |
Expense Detail | Row Set: · Define account assignments for your expense accounts. Use the expand display option for the greatest detail. · Define calculations for subtotals and totals. · Use row set format options for indenting, line spacing and underscores (for subtotals and totals). Column Set: · Depending on your reporting needs, select an appropriate standard column set or existing custom column set. If needed, define a new custom column set. Other: · Use a content set to create expense detail reports for each cost center. · Use a row order to rank expenses in descending order by department within the cost centers defined by the content set. |
Budgetary | Row Set: · Depending on your reporting needs, use an existing row set. For example, to generate a budgeted income statement, use the same row set used for your income statement. If needed, define a new row set. Column Set: · Choose from one of the standard column sets Monthly Budget or Quarterly Budget. You can also copy an existing column set then modify the amount types for each column definition to use one of the available budget types. Optionally, define a new custom column set. · Use a control value to associate specific budgets with your column definitions. Other: · In your report definition, associate budget names with the control values that are assigned to columns in your column set. |
Encumbrance | Row Set: · Depending on your reporting needs, use an existing row set. If needed, define a new row set. Column Set: · Copy an existing column set then modify the amount types for each column definition to use one of the available encumbrance types. Optionally, define a new custom column set. · Use a control value to associate specific encumbrances with your column definitions. Other: · In your report definition, associate encumbrance names with the control values that are assigned to columns in your column set. |
Variancen | Row Set: · Depending on your reporting needs, use an existing row set. If needed, define a new row set. Column Set: · Choose from one of the standard column sets PTD Variance; QTD Variance; or PTD, QTD, YTD Variance. You can also copy an existing column set then modify the amount types for each column definition to use one of the available variance types. Optionally, define a new custom column set, using a calculation column to compute the variance. · If you define a new column set, use a control value to associate specific budgets with your column definitions. Control values for the standard column set are already defined. Other: · In your report definition, associate budget names with the control values that are assigned to columns in your column set. · If desired, use a row order to rank your variances in ascending or descending order. |
Exception | Row Set: · Select an existing row set. Column Set: · Select and modify an existing column set to include exception columns. Optionally, copy a standard column set and modify the copy. · Define the exception conditions. Other: · Use exception reporting features, as desired, on any of the financial reports previously discussed. For example, you can combine exception reporting with variance reporting to flag any unusual variance amounts. |
Table 1 - 18. (Page 3 of 3) |
Using Financial Statement Generator
Tips for Designing FSG Reports
Frequently Asked Questions About FSG
Performing Multi-Company Accounting in General Ledger
Overview of Encumbrance Accounting
Previous | Next | Contents | Index | Navigation | Glossary | Library |