Financial report models

Use the Financial report models form to specify the data in the financial reports that show a summary of your company data. Isah Finance comes with examples of the most commonly used reports, Balance Sheet and Profit & Loss. Financial reports based on report models can be displayed in Power BI. Power BI provides an easy way to share reports within or outside your organization.

The report model allows you to group ledger accounts and to organize subgroups into groups in order to present the best overview of your company data. The amounts of the ledger accounts are added up automatically, and you can choose to add up group amounts. The report model is essentially a tree structure with branches (nodes) and ledger accounts as children.

After you have registered the models, open the Power BI Settings section in the Financial Settings, and then select the models the financial reports should be based on. Also fill in the other report settings.

Examples

Below are some examples of models that you can use to display the gross profit in a financial report.

Gross profit			Node
	Net turnover		Node
		8400 Production turnover	Ledger account
		8500 Stock turnover	Ledger account
	Purchase cost price		Node
		8010 Production costs of parts	Ledger account
		8030 Production costs of equipment	Ledger account
	Operations cost price		Node
		8020 Production costs of operations	Ledger account

Gross profit				Node
	Net turnover			Node
		Machines turnover		Node
			8400 Turnover of machine XYZ	Ledger account
			8450 Turnover of machine ACB	Ledger account
		Services turnover		Node
			8500 Turnover of domestic services	Ledger account
			8550 Turnover of international services	Ledger account

Creating report models

Isah Finance comes with example models that comply with statutory provisions. You can modify them to suit your needs, or you can create reports from scratch.

To use the example reports, follow these steps:

On the Financial report models tab, select a model that does not contain any lines. You will see the models that have been defined in the Central Data, under Financial reports.
Click the Import model button, and select an example report in the folder C:\ProgramData\Isah\IsahFinance\FinancialReportModels.

A tree structure is displayed, consisting of multiple levels. You can add nodes or ledger accounts to the lines and you can change the lines to suit your needs. A report model can consist of the following lines:

The first line is the highest node, which carries the entire structure, including entries and corresponding ledger accounts. This line is always of the type 'Add underlying lines'. The amounts of all entries in the report are added up.
For all other lines, the parent node of the line is shown. The calculation type of the line determines how the line is used in the financial report:
- Add underlying lines: If this calculation type is selected, the amounts of the underlying ledger accounts are added up. In the example models, all lines are of the type 'Add underlying lines'.
- Ledger account: Use this to link ledger accounts to a node in the model. The balance of the ledger account is included in the calculation of the amount of the node. A ledger account can occur only once in the model.
- Text: You may want to add a comment or explanatory note to the financial report. To do so, add a line of the type 'Text'.

Checking and adding ledger accounts

Use the Check ledger accounts option to check which ledger accounts are missing from the report model. The list only shows the ledger accounts that have not been added to the model. To add more ledger accounts to the model, select them in the list.

In the model, select the node you want to check to see whether you need to add any more ledger accounts.
Click the Check ledger accounts button. The Check ledger accounts tab will now open.
Check whether the form contains any ledger accounts you want to add. If so, select the ledger accounts you would like to add.
Click the Add selected accounts button.

Tip: To see only ledger accounts of a particular type, such as Balance Sheet or Profit and Loss Account, filter the ledger accounts by that type.