Shows a break down of income earned against costs incurred and shows the variance between invoiced and costs.
To access this report go to Reports > Time & Money and select the Category Income vs Time Logged report.
You can run this report using the following criteria:
Note: If filtering by a date range, Streamtime will only pull in items that have been invoiced, or created in that date range.
How to view your report
You can choose to preview your report, print it, make a PDF or export your report to Excel so you can use the data to create your own reports.
This report is broken down by time based items and quantity based items, showing invoiced amounts, costs and the variance between the two.
Invoiced looks at all time based items that have been invoiced in the date range and breaks them down by Category (1).
Then it looks at any active orders and any quantity based items that have been invoiced in the date range (2).
Filtering by a date range
Note: If filtering your report using a date range, the Invoiced column looks at invoices that have been created in the date range (1), it then looks at the items invoiced to determine which items are time based and quantity based.
Time Cost Total
Time Cost Total looks at the cost of time entries and breaks them down by Category.
How are time costs calculated?
The cost of time is based first on the cost assigned to the staff member in Setup > System Setup > Users
or if this is left blank, Streamtime will use the cost price for the item in the Cost Matrix.
Note: If you have no costs rates in Streamtime, then the report will return no costs on this report.
Filtering by a date range
Note: If filtering your report using a date range, Time Cost Total looks at time entries that have been created in the date range.
Active Orders Costs
The report then looks at any active orders and any quantity based material entries that have been created.
How are order costs calculated?
For orders, Streamtime takes the cost rate of the item/s as it is on the actual order.
Note: Orders returned in the report will be any order with an active/reportable status. If you create your own Order statuses you need to make sure they are active so they are picked up by the report. For more information on understanding active statuses click here
How are quantity costs calculated?
If there are material entries the costs are calculated from the cost column for those items in the Cost Matrix.
Edit Time Entry
Or directly from the rate added when a staff member adds a material entry on the job.
Filtering by date range
Note: If filtering your report using a date range, active orders costs looks at active orders that have been created in the date range
and Quantity costs looks at the date the material entry was created.
Variance is Invoiced less Costs.
Gross Margin (1) is the total amount invoiced (2) less all costs (3).
Note: All non-home branch figures are converted to the home branch currency using the exchange rate values entered against a branch, unless you search by branch, in which case the result is in the branch currency.