The financial report 'Profit & Loss' provides an easy way for you to view and analyze the costs and revenues relating to a company/fiscal year for a particular period. The report model 'Profit & Loss', which is configured in the Power BI Settings section, forms the basis of the report. To see budget details, open Power BI Settings and select the budget to compare the actual values with.
The Isah Finance journal supplies the details of the financial report 'Profit & Loss'. In the journal, the turnover is generally presented as a credit (negative) amount, and the costs as a debit (positive) amount. This means that the profit - the sum of ledger accounts of the type Profit & Loss - is shown as a negative amount in the journal. The actual and budget values in the report 'Profit & Loss' are multiplied by -1, so that a positive total is presented as a positive result.
Settings
Use the settings on the left-hand side of the form to define the contents of the report:
Tree structure
The table shows the structure with various levels of nodes and ledger accounts, as defined in the report model 'Profit & Loss'. For each line, the columns show the actual data, the budget data, or the data of the previous fiscal year (depending on your setting), and the difference between them.
Profit and loss by period
The next tab of the report 'Profit and loss' displays the result by period.
Sales order information
You can retrieve the corresponding sales orders from the Actual values column. To do so, right-click in a cell with actual values (for example, on the line 'Gross profit'), select the 'Drillthrough' option, and then select 'Sales order data' or 'Grouped by sales order'. The 'Sales order data' option displays a list with ledger accounts and sales orders, and the 'Grouped by sales order' option groups the data by sales order.
Charts
The charts provide a quick way to see how the business is performing: