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.

Report Filters

You can run this report using the following criteria:

Date Range

Billable/Non Billable

Job Number

Branch

Category

Client Manager

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.

Report Overview

This report is broken down by time based items and quantity based items, showing invoiced amounts, costs and the variance between the two.

Invoiced

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

Variance is Invoiced less Costs.

Gross Margin

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.

Did this answer your question?