Financial Report Columns are a component of a Financial Report definition. The Financial Report Columns section is where you will create the columns that will be displayed on the report. Some examples of columns would be:
  • Current
  • Previous Period
  • Calculation totaling or taking the difference of three columns.
Select New Financial Report Column to create a column from the related list on the Financial Report Definition. Key fields on the financial report column are as follows:
  1. Position - If using multiple columns, this field will determine the order they appear in. Number them such as 1, 2, 3, 4. When numbering columns for position it is easier to number them in increments of 10 as opposed to 1, 2, 3, 4, 5. This way if you need to create a new row or column you don't have to renumber everything, as you can just insert it where needed. 
  2. Ledger - To report on actual transactions, select "MainCompany." Otherwise select your budget ledger of choice.
  3. Offset - This field determines which period the column will report on. To report on the selected period enter a "0" (zero). If you would like to report on a previous period insert "-1" for the prior month or a "-n" for the amount of months you would like to report in arrears. 
  4. Type - There are five options to choose for type listed below with explanations.
    • Current Period - Select this for the column to report only on the period you selected.
    • Year to Date - Select this to report on all transactions for the year to date.
    • Calculation Number - Use this to make a calculation using different columns with the result being a number. For example, if one column was showing transactions for January 2006 and the next was for February 2006, a third column could be created to give you the difference between the two. The formula would look like {c1}-{c2}. {c1} would represent column 1 and {c2} would represent column 2. Please see the last section of this knowledge article for more examples of column calculation syntax.
    • Calculation Percentage - Use this to make a calculation using different columns with the result being a percentage. 
    • Header 1 Value - The options available are Text or Period Name. If Period Name is selected then the period being reported on will be listed at the top of the column. Select Text if you wish to type your own text to appear on the column header. 
    • Header 2 Value - This works the same as the Header 1, but will be below Header 1 on the report. 

Below is an example for creating three report columns: one for 'previous accounting period', one for 'zero accounting period', and one for the variance (%) between the first two columns. 

Steps to Define Financial Report Columns

  1. Click on the New Financial Report Column button.


 

  1. In the Financial Report Column Edit screen, the Financial Report Definition field defaults to the name of the report you are creating. Enter values for the other fields as described below.


    • Ledger - The choices are Actual or Budget. Select ‘Actual’.
    • Header 1 Value - The options available are Text or Period Name. If Period Name is selected then the period being reported on will be listed at the top of the column. Select Text if you wish to type your own text to appear on the column header. When you select Text, you enter the column header text in the Header 1 text box below the Header 1 Value field. In this example, Select Period Name and leave the Header 1 field blank.
    • Header 2 Value - This works the same as the Header 1. It displays below Header 1 in the column heading as a sub title. Leave blank.
    • Type - There are five options to choose for type (refer to list above). In this example, Select Current Period.
    • Position - If creating a report with multiple columns, this field will determine the order in which the columns will display. Number them such as 10, 20, 30, 40. Using increments of 10 allows you to add a column at a later point that can be inserted between two existing columns if it’s position number is between the two. For this column, Enter 10.
    • Offset - When you run a report, you must select the "0 Accounting Period" (for example 2016-04). That period defines the zero point from which offsets are calculated. Offsets in either direction (-1, -2, +1, +2, for example) are calculated from the "0 Accounting Period". If the column is for the "0 Accounting Period", enter a "0" (zero). If it is for a period prior to the "0 Period" enter -1 as the offset (or "-n" for each prior period to be included as a column in the report). For this column, Enter -1 (for the prior period to our "0 Accounting Period", which we will select when we run the report).
  1. Click the Save and New button to add the second column.

  2. Enter values as above except for Position and Offset. For Position Enter 20; For Offset Enter 0 ("0 Accounting Period" selected when we run the report).

  3. Click the Save and New button to add the third column.

  4. The third column is the variance column where we are calculating the variance between the current and prior accounting period. For this column, Enter values as above except for the following:

    • Header 1 Value = Text
    • Header 1 = Variance (%)
    • Header 2 Value = Text
    • Header 2 = Current vs Prior Period
    • Type = Calculation Percentage
    • Position = 30
    • Offset = 0
    • Calculation = ({c20}-{c10})/{c10}
  1. In the Formatting Information Section, Click into the the Column Override Row checkbox to toggle it to checked. This should be checked anytime you are creating a column that has a percentage calculation. It ensures that the calculation result displays as a percentage.

  2. Click Save.

After clicking save, you are taken to the column definition record for the final column you defined above (the Variance Column in this example).

 

To return to the Financial Report Definition screen to continue building the report, Click on the Current vs Prior P&L hyperlink in the Financial Report Column Detail section.

 

ASU-banner-4.jpg

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

1 Comments

  • 0
    Avatar
    Jeanae Remala

    I have created a report by date range (ie, our checking account for transactions of current month) and i want the actual date of each transaction to show on the report, not just the accounting period.   How do i get the date field on the report so i can sort it by date?  It seems that since it's a report by date range, i them can't get the report to show the date????

Please sign in to leave a comment.