1. One View Financial Statements
  2. Planning Your Balance Sheet Statement

Planning Your Balance Sheet Statement

Before you can setup the OVFS components for a balance sheet statement, you need to know which account balances to include in the statement output, the time frame that you are reporting on, and other factors that determine how the OVFS process generates the financial statement output.

When planning a financial statement, start your analysis by determining how and where you want to view the accounts. In the image labeled #u30190668__BGBDJIHI, the accounts are listed along the left side, which tells you that they are set up at the row level. The accounts listed are balance sheet accounts including assets, liabilities, and shareholder equity, which means that your data selection must encompass your asset, liability, and shareholder equity. In the sample data provided in the JD Edwards EnterpriseOne system, accounts in the range 1000-4999 are the asset, liability, and shareholder equity.

You must also consider the time frame of the account balances to retrieve. In the sample statement, you have columns for current actual, last month end, last year end; and columns for the change for this month and this year. You will set up columns to return the account balances for those time frames.

Other factors that you can view in the sample statement output that you need to consider as you set up the OVFS components include the following:

  • The statement includes the description of the accounts, not the account numbers.

    You will need to set up the row definition to return descriptions.

  • Because this is a balance sheet statement, the output includes a line for year to date income or loss.

    You will need to set up the statement version to return the net income or loss. You also need to assure that the data selection for the data with grouping element row definitions includes all accounts with GLG2 AAI through GLG5 AAI.

  • The accounts are rolled up to level of detail 5 with totals and subtotals in the statement output.

    You will need to set up the parameters in the OVFS components to roll up the account balances to level of detail 5.

  • The columns for the change for this month and this year include values that are not stored in the JD Edwards EnterpriseOne tables; they are calculated amounts.

    You will need to set up the calculated columns in the Layout Editor.

  • The account balances for the liabilities are displayed as positive numbers though the JD Edwards EnterpriseOne system stores the account balances for liabilities as negative numbers.

    You will reverse the sign of the liability account balances when you set up your layout to have them appear as positive numbers in the statement output.

  • You will generate the balance sheet statement for Business Unit 174 for the period ending June, 2018.

    Because you want all account balances from the same business unit and for the same period, you will set up that data selection and parameters in the statement version that you run.

Now that you have determined what to include in your balance sheet statement, you can make more detailed decisions about the accounts, time frame, and summarization levels that the statement will include. The decisions that you need to make before you begin setting up your statement include these factors: