How to Generate FSG Reports – Part II

Share on facebook
Share on twitter
Share on linkedin
Share on email

In the second tip of the Financial Statement Generator (FSG) report series, we continue to explain how FSG reports can be created that are reusable and easy to maintain. The FSG’s are powerful tools that can be used to produce a variety of traditional reports such as balance sheets, profit and loss statements, income statements, expense analyses and gross margin reports.


Develop master report components that can be combined and reused for generating different reports. Use meaningful names that describe the contents of the component by the row set name. These do not print on the report.

  1. All names must be unique. For example, do not have a row set named “Balance Sheet” and a report named “Balance Sheet”.
  2. Do not use names such as “Test Row Set” or Test 1.
  3. Row Set Names identify which rows are included in the row set. For instance, a row set name might include “Summary of Revenue and Expense Accounts”. The Row Set Name should be followed by an “R” to distinguish it from the report name.
  4. Column Set Names indicate the type of report such as “Company Consolidation”, ”Rolling Monthly”, or “Budget/Variance Comparison”.
  5. Content Set Names should identify the sort criteria, such as “Cost Centers 100-500″ or “Company 01″.
  6. Row Order Names should state which row order display characteristics will be used, such as “Cost Center and Account Values” or “Account Descriptions”.
  7. Report Names should be similar to the row set name (“Balance Sheet,” or “Expense Analysis”). Report Set Names should reflect when the group of reports are usually run, such as “Month-end Closing”, “Yearly Audit”, etc.
  8. Row and Column Names do not print on the report. They are used primarily for identifying the row or column when doing calculations. Therefore, the row name should be descriptive of the type of row (assets header, cash title, A/R detail, shares outstanding hidden, equity calculation, expenses total) or the type of column (Q1, Company 02, YTD, total, etc.)

Leave a Reply

Your email address will not be published.

The Roadmap to Synergy

Companies evolve. While everyone’s story is unique—growth from regional to national or international, mergers and acquisitions, diversification of business lines and product offerings, and disparate regulatory environments—many of these business...

Read More

Preparing for Tomorrow’s Market

Preparing for Tomorrow’s Market There are few constants in this world. The way in which a company does business is not one of them. Instead, companies must actively adapt to...

Read More

Mergers & Acquisitions: Realizing the Value

Mergers and acquisitions carry the added weight of introducing redundant systems that duplicate functionality. Learn how to overcome the value gap to take advantage of emergent synergies by aligning your...

Read More