Skip to main content

How to Use the Income Statement Dashboard

Updated over 2 weeks ago

Prerequisites

  • Power BI Desktop is required to use the Coins standard dashboard.

  • Extract parameter "%GLEL2ANAL" must be set. A pipe separated list of GL Element 2 analysis set descriptions to be used (up to eight). If the entry is blank (or not entered) then the analysis field will be omitted from the extract.

  • Ensure "GL Account Balance Function" and "GL Account Movement Function" are both created.

Following entities must be generated, their corresponding SQL tables must be created and their data must be extracted.

  • CoCompany

  • GLPeriod

  • GLAccount

  • GLElement2Anal1

  • GLElement2Anal2

  • GLAccountYear

  • GLAccountPeriod

Create the required "Generic" views

  1. Go to System >> Extracts >> Views.

  2. Filter the Schema for "Generic".

  3. Select all the rows.

  4. Run "Create Views".

Generic.COCompany, Generic.GLPeriod, Generic.GLAccount

Create "IncomeStatement" views

  1. Go to "System >> Extracts >> Views.

  2. Filter the Schema for "IncomeStatement".

  3. Select all the rows.

  4. Run "Create Views".

Note: Views are created based on Coins SQL tables. This means all required SQL tables must already exist when you try to create the views.

Download the "PBIT" template and configuration "XLS" file for "IncomeStatement" report from System >> Extracts >> Reports.

Chart of Accounts set up follows SureStart structure

If you are using SureStart, or inherited the SureStart chart of accounts structure without any change to it, that is:

  • GL Account Element2 Analysis1

  • GL Account Element2 Analysis2

You can use the IncomeStatement dashboard without making any change to the "IncomeStatement.xlsx" and "IncomeStatement.pbit" templates.

After downloading the "XLS" and "PBIT" files from the "Extracts/Reports" menu, follow the steps below:

  1. Place both files in the directory that they should reside.

  2. Open the "IncomeStatement.pbit" template, enter the server Name, Database and Path for Coins IncomeStatement Mapping spreadsheet.

    When this file is opened for the first time, after entering the required details you will also be asked to enter credentials for connecting to SQL server.

  3. Save the IncomeStatement file after loading the data to the template. The saved file will have the ".PBIX" extension.

Did this answer your question?