Designing FSVs for Reporting in SAP FICO

In SAP FICO, the Financial Statement Version (FSV) is used to structure and report financial statements in a customized manner. The FSV allows businesses to define how financial data will appear in reports such as the balance sheet and profit and loss statement. By designing and customizing FSVs, companies can align their financial reports with their internal and external reporting requirements. This article outlines the process of designing FSVs for reporting in SAP FICO, step-by-step, along with examples for clarity.

Step 1: Access FSV Configuration in SAP

To design an FSV, you need to access the configuration settings for Financial Statement Versions in SAP. This can be done via the SAP Customizing Implementation Guide (SPRO).

  1. Go to transaction code SPRO to access the SAP Customizing Implementation Guide.
  2. Navigate to: Financial Accounting → Financial Accounting Global Settings → Ledgers → Financial Statements → Define Financial Statement Versions.

Example: After entering the SPRO transaction code, you find the configuration option for defining Financial Statement Versions, allowing you to start the design process.

Step 2: Create a New Financial Statement Version (FSV)

Once you access the configuration settings, you can create a new FSV or modify an existing one. The FSV determines how the financial statement will be structured, grouping accounts into specific categories.

  1. Click on New Entries to create a new Financial Statement Version.
  2. Enter a unique name for the FSV (e.g., "FSV1") and a description (e.g., "Balance Sheet and P&L for 2024").
  3. Click Save to create the new FSV.

Example: You create a new FSV called "FSV1" for the company’s financial statements, which will include the balance sheet and profit and loss statement for the year 2024.

Step 3: Define Account Groups for FSV

Next, you need to define the account groups that will be used in the FSV. These account groups will categorize the GL accounts into sections like assets, liabilities, revenues, and expenses.

  1. Under the FSV configuration, navigate to Account Grouping.
  2. Select Insert and add the account group that corresponds to the financial statement section you want to define (e.g., "Assets", "Liabilities", "Revenue", "Expenses").
  3. Link the appropriate GL accounts to each group.
  4. Click Save to save the account groupings.

Example: You define an account group "Assets" and assign GL accounts like "Cash", "Accounts Receivable", and "Inventory" under this group. Similarly, you define the "Liabilities" account group and link relevant liability accounts such as "Accounts Payable" and "Loans".

Step 4: Define Hierarchy and Structure of the FSV

After defining the account groups, you will set the hierarchy of how these groups and accounts will appear in the report. The FSV allows you to create a detailed structure, specifying how each account and account group should be displayed.

  1. Under the FSV configuration, click on Hierarchy.
  2. In the hierarchy screen, define the main categories of the financial statement, such as "Current Assets", "Fixed Assets", "Current Liabilities", "Equity", etc.
  3. For each category, assign the appropriate account group from the previous step.
  4. Click Save to save the hierarchy structure.

Example: You create a hierarchy where "Current Assets" and "Fixed Assets" are under the "Assets" section, while "Current Liabilities" and "Long-Term Liabilities" fall under the "Liabilities" section. Then, within each category, you assign the corresponding account groups defined earlier.

Step 5: Assign GL Accounts to the FSV

Next, you need to assign the relevant General Ledger (GL) accounts to the FSV. These accounts will populate the report based on the hierarchy and account groupings defined in the previous steps.

  1. In the FSV configuration screen, go to Assign GL Accounts.
  2. Choose the GL accounts that should be included in each section of the report (e.g., cash accounts under "Current Assets", revenue accounts under "Income").
  3. Assign the GL accounts to their respective account groups and sections based on the defined hierarchy.
  4. Click Save to save the account assignments.

Example: You assign the GL account "100000 - Cash" to the "Current Assets" section, the account "400000 - Revenue" to the "Income" section, and the account "200000 - Accounts Payable" to the "Current Liabilities" section.

Step 6: Define Display Settings for the FSV

Once you have defined the structure and accounts for the FSV, you can adjust the display settings to ensure the report looks as needed. These settings control how the data will be presented in the report, including the level of detail and subtotals.

  1. Navigate to the display settings section within the FSV configuration screen.
  2. Specify whether you want the report to show detailed data for each account or if subtotals should be displayed at higher levels (e.g., total current assets, total liabilities).
  3. Define the layout for the financial statement, such as whether to display the data in a vertical or horizontal format.
  4. Click Save to save the display settings.

Example: You choose to display the total for each category (e.g., total assets, total liabilities) and configure the report to show each GL account under its respective category in a vertical format.

Step 7: Generate the Financial Statement Report

After setting up the FSV, you can now generate the financial statement report. SAP provides various tools to do this, including running reports from the SAP GUI or using transaction codes.

  1. To generate the report, use transaction code F.01 (Financial Statement Version) or go to: Accounting → Financial Accounting → Financial Reporting → Financial Statements → Balance Sheet/P&L.
  2. Select the FSV you created and specify the fiscal year, period, and other parameters.
  3. Click Execute to generate the report.

Example: You generate the financial statement report for FSV "FSV1" for fiscal year 2024, period 12. The system generates a balance sheet and profit and loss statement based on the structure and accounts you defined in the FSV.

Step 8: Review and Adjust the Report (Optional)

After generating the report, review it to ensure it meets your reporting needs. If needed, you can adjust the structure, account assignments, or display settings and regenerate the report.

  1. If necessary, go back to the FSV configuration and make adjustments to the layout, account groupings, or display options.
  2. Rerun the report to reflect the changes.

Example: Upon reviewing the report, you find that you want to add a subtotal for "Long-Term Liabilities". You go back to the FSV configuration, add the subtotal, and regenerate the report.

Conclusion

Designing Financial Statement Versions (FSVs) in SAP FICO is an essential task for generating customized and structured financial reports. By following the steps outlined in this article, you can create an FSV that meets your business's reporting needs. Whether you're working with a balance sheet, profit and loss statement, or other financial reports, FSVs in SAP provide the flexibility to design and customize reports to match your requirements.




Advertisement