Financial report rows are part of a Financial Report Definition. Whereas the column definitions determine the period and ledger to report on, the financial report rows determine the row data to be displayed in the report rows.  
 
Financial Report Row Types
Below is a list of the key fields for types of rows and the functions they serve:
  • GL Account - The majority of the rows will be GL Account rows. This type of row will display data for the GL Account selected. GL Accounts can be added one at a time in which case a user can use the GL Account look up to select GL accounts. Alternatively, GL Accounts can be 'mass added'. See below. 
  • Reporting Group - Select a reporting group to display aggregated data for the GL accounts that make up the reporting group.
  • Type:
    • Description - Use the description row type to provide a place holder for a description for the rows that follow the description row. For example, if your report lists all the sales revenue accounts, then a description row could be placed above those accounts with the heading "Sales Revenue." 
    • GL Account - Shows a single GL account.
    • Reporting group - Shows a consolidated group of GL accounts for which data is to be aggregated. There is more on reporting groups below.
    • Blank- Use blank to create a blank space between rows.
    • Calculation Number- A formula field with a number as the result. The formula identifies the rows and the mathematical functions to be applied to the values in the rows. The formula can be as simple as adding or subtracting values in rows or it can involve more advanced calculations. For information on the format used for calculations see the calculation section of the help. 
    • Calculation Percentage-A formula field with a percentage as the result.  
  • Row Label - This is how the row will display on the report. For instance, if the row is a GL Account for cash then it would make sense to create a row label "1000-Cash" (The GL Account name.) If the row is a description (section heading for the GL accounts that follow), then enter the description of the section header.
  • Position - This determines the order the rows will appear in. Use increments of 5 or 10 in case new GL  accounts are added and may need to be added to reports. 
  • GL Account Variables - If the row type is a general ledger account, then general ledger account variables can be selected. If selected, it will filter only transactions that have that variable. 
  • Calculation - If the field is a calculation number or percentage, then enter the calculation into this field. 
  • Normal Balance - Value is positive if debit is selected and the normal account balance is a positive; Value is negative if credit is selected and normal account balance is negative. It appears negative if these conditions are not met.
  • Indent - Indent will indent the row title to the right. Select 1-5 to indent to a varying degree.
  • Underline - Select this to underline the row.
Adding Financial Report Rows
 
A report generally contain rows that are Section Headers, such as "Revenue" and "Expense", rows with GL account values, blank rows (to create spaces between groupings of rows) and summary rows with calculated values, such as "Total Revenue", "Total Expense", and "Net Income". A good strategy for adding the rows is first to 'mass add' the GL accounts to be included in the report and then to add the individual header, summary and blank rows, setting the row number position values of these rows to ensure the correct ordering of the rows in the report.
 
Mass Add GL Account Rows:
  1. From the Financial Report Definition screen, Click on the Mass Add Rows button. The Mass Add Rows button allows you to select and add a subset of your GL Accounts as rows in your Financial Report Definition rather than adding each GL Account one at a time. If you have Financial Suite 3.6 or earlier, the Mass Add Rows button is not available. 

  2. In the Mass Add Rows screen the Beginning Row Number and Increment Row Number fields default to 10. In general, you can accept these values. The results section of the screen defaults to display all of your active GL accounts. You manually enter checks in the checkboxes to select the GL accounts you want to display in the report or you can use the filters section to select GL accounts by Type or a combination of Type, Sub Type 1, and Sub Type 2. 

  3. Once you have selected all the GL accounts you want in the report, Click the Create Rows button.


 

The Report Definition now has the rows defined for all the GL accounts you want in the report. 
 
To add the header, calculated, and blank rows, follow the steps below. 
 
Steps to Add Section Header Rows
  1. From the Financial Report Definition screen, Click on New Financial Report Row button.
  2. In the Financial Report Row Edit screen, the Financial Report Definition Field defaults to the name of the report you are building.
  3. Enter a Row Label for the Header Row. For example, enter "Revenue".
  4. For the Type select "Description".
  5. Enter the Position of the row. 
  6. Leave all other fields blank.
  7. Click Save and New. 
  8. Follow steps 1-6 to add the Section Header rows for any other groups of GL accounts in the report. 
  9. Click Save and New.


Steps to add the Calculated Rows

  1. Enter a  Row Label. For example, Enter "Total Revenue".
  2. For the Type select "Calculation Number".
  3. Enter the row Position.
  4. For Calculation, Enter the calculation using the examples provided in the calculation hyperlink (Note: Right click to open the hyperlink in a new tab). For example, to sum across 3 rows that are in positions 10, 20 and 30, Enter {r10:r30}.
  5. Leave all other fields blank.
  6. Click Save and New.
  7. Follow steps 1-5 to add the other calculated rows in the report. 
  8. Click Save.

Steps to add the Blank Rows

  1. For the Row Label, leave the field blank.
  2. For the Type select "Blank".
  3. Enter the Position for the blank row.
  4. Leave all other fields blank.
  5. Click Save and New.
  6. Follow steps 1-4 to add other blank rows. 
  7. Click Save.

Check Your Work

After adding all the rows, the Financial Report Rows Definition page should look like something like the screenshot below.

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.