In order to bring you the best possible user experience, this site uses Javascript. If you are seeing this message, it is likely that the Javascript option in your browser is disabled. For optimal viewing of this site, please ensure that Javascript is enabled for your browser.
Login  |   On Demand  |   Home  |   qad.com




Setting up the CFO Dashboard
Financial reports for high-level executives involve complex calculations on ranges of general ledger account numbers. For example, if you want to know the return on investment (ROI) metric for a range of financial periods, add up the net operating profit after tax (NOPAT) metric and any interest paid and then divide by the value of total assets. Each of these calculations can involve one or more ranges of general ledger accounts that you identify by account number, sub-account number, entity, or various identifying factors. In some countries, businesses have the freedom to choose their own chart of accounts because there is no mandatory chart of accounts. In such a case, you can customize reports so that every customer has their own numbering system for general ledger codes by importing the custom GL Account information through the CFO Dashboard spreadsheet.
The CFO dashboard contains the following Excel template and text files to customize reports:
CFO Dashboard Template.xlsx. The CFO Dashboard template consists of five worksheets:
The data in the first four worksheets is saved as .txt (text) files. The .txt files are read and their data imported into the BI data warehouse.
ReportLineCalculations.txt
ReportLineRanges.txt
ReportLines.txt
Reports.txt

CFO Dashboard Excel Template and Text Files
The CFO dashboard uses the data that is stored in the GL balance fact table. The GL balance data is grouped by reporting lines. The reporting lines are based on data, which can be a range of GL accounts you refine by sub-account, cost center, and so on, or calculated based on other reporting lines.