Understanding Balance Sheet Statements with Net Income or Loss

You can use the OVFS feature to generate a balance sheet statement that shows the net income or loss for a company or companies. To have the system generate a balance sheet with net income or loss, you must use this setup:

  • Select OBJ (Object Account) or AID (Account ID) for all data with grouping element row definitions in the statement definition.

    If you are not consolidating accounts, then the system calculates the year-to-date net income or loss for each business unit within a section.

  • Set up data selection for the data with grouping element row definitions to include all accounts with GLG2 AAI through GLG5 AAI.

    The system calculates the net income or loss by section. All row definitions within a section must include all accounts within the GLG2-GLG5 AAI range, or the calculations will not be accurate.

    If your data selection does not include all accounts within the range of GLG AAIs, your balance sheet statement will not be accurate.

  • If you used Object Account as a grouping element without also using Business Unit as a grouping element, enter a value in the Based on Company field in the version that you use to generate the balance sheet statement.

  • Select the Calculate YTD Net Income or Loss check box in the version that you use to generate the balance sheet statement.

Note: You can use the Balance Sheet case study in this implementation guide to learn more about creating a balance sheet statement that includes the net income or loss.See OVFS Balance Sheet Statement Case Study.