The following will show how the Income Statement Detail report should be setup to match values with Balance Sheet Detail and Trial balance Detail report.

  1. Generate Income Statement Detail report from Report Templates. To open Report Templates, go to Financial Reports module > Report Templates.

  2. Select Income Statement Detail and and Income Statement Detail report builder will be generated.

    You can assign a name for the Income Statement Detail report by entering the name of the report in the Assign Name field. If this field is left blank, i21 will automatically provide a name for the report with this format: Income Statement Detail  -  <Date and Time the report template is generated.

    Ex: Income Statement Detail  -  January 25, 2016 12:9:29

  3. The Report Builder record with Rows and Columns designed for a Income Statement Detail will automatically open.
  4. In the Report Builder screen click on the Row field label to open the Row Designer record.  Most of the rows have Filter Accounts row type and are filtered per Account ID. Note on the following rows:
    1. All Income Statement accounts will have an Account Type of IS.
  5. Close the the Row Designer screen to bring you back to the Report Builder record.
  6. In the Report Builder screen click on the Column field label to open the Column Designer record. Here is how each columns are setup by default.  
    1. For Current Year columns, Start and End Offset will show BOT to 0. BOT here stands for Beginning of Time while 0 means the current month, which is setup from the Run Date. Take note also that Start Date will show first day of the month while End Date will show last day of the month. If you are printing a report, these Start and End Offset dates will be computed based on date entered on As Of field of Report Setting screen. This means that current month is the month entered in the As Of field.
    2. For Prior Year columns, Start and End Offset will show BOT to EOY-1yr. BOT here stands for Beginning of Time while EOY-1yr means the End of Year minus 1yr or previous End of Year. Take note also that Start Date will show first day of the month while End Date will show last day of the month. If you are printing a report, these Start and End Offset dates will be computed based on date entered on As Of field of Report Setting screen. This means that current month is the month entered in the As Of field.


The following will show how the Income Statement Detail report should be setup to match values with Balance Sheet Detail and Trial balance Detail report.

  1. Generate Income Statement Detail report from Report Templates. To open Report Templates, go to Financial Reports module > Report Templates.

  2. Select Income Statement Detail and click Generate toolbar button.

    You can assign a name for the Income Statement Detail report by entering the name of the report in the Assign Name field. If this field is left blank, i21 will automatically provide a name for the report with this format: Income Statement Detail  -  <Date and Time the report template is generated.

    Ex: Income Statement Detail  -  January 25, 2016 12:9:29

  3. The Report Builder record with Rows and Columns designed for a Income Statement Detail will automatically open.
  4. In the Report Builder screen click on the Row field label to open the Row Designer record.  Most of the rows have Filter Accounts row type and are filtered per Account ID. Note on the following rows:
    1. All Income Statement accounts will have an Account Type of IS.
  5. Close the the Row Designer screen to bring you back to the Report Builder record.
  6. In the Report Builder screen click on the Column field label to open the Column Designer record. Here is how each columns are setup by default.  
    1. For Current Year columns, Start and End Offset will show BOT to 0. BOT here stands for Beginning of Time while 0 means the current month, which is setup from the Run Date. Take note also that Start Date will show first day of the month while End Date will show last day of the month. If you are printing a report, these Start and End Offset dates will be computed based on date entered on As Of field of Report Setting screen. This means that current month is the month entered in the As Of field.
    2. For Prior Year columns, Start and End Offset will show BOT to EOY-1yr. BOT here stands for Beginning of Time while EOY-1yr means the End of Year minus 1yr or previous End of Year. Take note also that Start Date will show first day of the month while End Date will show last day of the month. If you are printing a report, these Start and End Offset dates will be computed based on date entered on As Of field of Report Setting screen. This means that current month is the month entered in the As Of field.



  • No labels