You can easily view the revenue and expenses of your customers, pipelines and projects in the Profit & Lost section of BI-reports.
Content
- Search and cropping opportunities
- Accessing Profit & Loss data
- Interactive charts
- Profit & Lost table
Description
Heeros PSA provides the ability to view income and expenses graphically displayed in the Profit & Lost section of the BI reports. In addition, you can view future costs and revenues as well as pending and shipped purchase orders.
Permission: BI-reports: Profit & Loss, Projects: Profit & Loss, Accounts: Profit & Loss
Search and cropping opportunities
In the Profit&Lost section searches can be used define the information displayed in the graph and table.
There are application possibilities e.g. time period, customer, sales pipeline and the stage of the selected pipeline and the options provided by the Add filter feature.
In addition, the information displayed in the graphic can be cropped by clicking on the information to be cropped, in which case a line will appear on the information. reactivation, in turn, is done by clicking on the information so that the strikethrough disappears.
Setting the date - eye icon
You can use the eye icon in the upper-right corner of the report to specify the date by which you want to view data in your reports.
In the example below, the report displays the data
-
Invoices: By invoice date
-
Bills: By invoice date
-
Purchase orders: Created by date
Accessing Profit & Loss data
The Profit & Loss Insights dashboard summarizes the revenue, costs, and expenses incurred during a specified period, for a given account and project.
Interactive charts
The text columns below the charts are clickable. This means you can strikethrough any text to display the data relevant for the remaining metrics and this change is reflected in the table below as well.
For example, to view all your Waiting, Scheduled and Automatic invoices, you need to strikethrough the rest of the fields under the Invoicing column.
For more information, hover over the bar.
Profit & Loss table
The table consists of fields showing data on Invoicing, Bills, Expenses and Hours for a specific period of time. Clicking on each field further shows data relevant to the metric displayed in the first column.
You can click on each figure to view the entire data associated with this metric. For example, clicking on the paid invoices figure for June gives a split-up of all the invoices that were paid for the month of June.
Fields explained:
Profit & Loss: The amount of income that remains after accounting for all the bills to be paid, expenses, additional income streams, and operating costs
Cumulative P&L: Total amount of the end of the month according to the search criteria.
Invoicing- The Invoicing tab is a sum total of all your pending, due and paid invoices (i.e. the income)
Bills & Purchase Orders- This is a sum total of all your approved and waiting bills that need to be paid
Expenses- These are all the pending and approved costs associated with the expenses made
Hours- This includes Invoiceable Hours and Internal Hours Costs. The invoiceable hours is counted as income, whereas the Internal Hours are the costs incurred for internal jobs
How to analyze the data in the Profit & Loss table
The Profit & Loss data follows a general form as seen in the picture below. It begins with an entry for revenue, i.e. all invoicing data and then subtracts the costs of doing business, including Bills & Purchase Orders, Expenses and Hours. The difference is referred to as Profit or Loss.
Revenue generated is displayed in green and the costs incurred are shown in red.