Shows a break down of time and material costs plus active order costs for each month compared against actual invoiced amounts. Sorted by month.

To access this report go to Reports > Revenue and select the Year by Month Financial Overview report

Report Filters

You can run this report using the following criteria:

Date Range
Client/Supplier Name
Billable
 Branch

Note: If filtering this report by a date range, it will pull through any data recorded in the date range i.e it will look at the creation date of time and materials entries, orders and invoices.

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 sorted by month and shows time, costs, invoiced amount and profit.

Time Spent

Time spent shows the amount of time (in hours) recorded for each month.

This is based on the date the time entries are created.

Sell Value

Sell Value refers to the value of time on the job.

This is based on the pricing tier rate for the item selected in the time entry.

Time Cost

Time Cost is the cost of the time to your business.

This is determined in the first instance by the cost assigned to the staff member in Setup > System Setup > Users section of Streamtime.

If that is left blank, Streamtime will default to the cost of the item in the Cost Matrix.

Note: If there are no costs in System Setup > Users or in the Cost Matrix there will be no time costs on the report.

Materials Cost

Materials Cost comes from any material entries on a job.

A material is entered like a Time Entry, however the item in the Cost Matrix is set to be sold as a quantity not time e.g. taxis, colour print outs, couriers etc.

The cost comes from the rate entered when making the material entry or from the cost column in the cost matrix.

PO Costs

PO Costs refers to the cost of any active/reportable Orders for the month.

Active Orders in Streamtime refers to any Order given an active/reportable status.

For more information about active statuses in Streamtime click here

Total Costs

Total Costs is the sum of Time Costs, Material Costs and PO Costs for each month.

Invoiced Time

Invoiced Time refers to any time based items in your Invoices for that month.

The report looks at the Category and the Task/Material of the items you have invoiced, adding the Time based items to the Invoiced Time column in this report.

Invoiced Materials

Invoiced Materials refers to any quantity based items in your Invoices for that month.

The report looks at the Category and the Task/Material of the items you have invoiced, adding the quantity based items to the Invoiced Materials column in this report.

Invoiced POs

Invoiced POs refers to all Orders that have been invoiced in that month.

The report looks at the the items you've transferred from the Purchase Orders tab into your Invoice.

Total Invoiced

Total Invoiced is the total amount invoiced for each month, i.e the sum of Invoiced Time, Invoiced Materials and Invoiced POs.

Gross Margin

Gross Margin is Total Invoiced less Total Costs.

Gross Profit

Gross Profit is Total Invoiced less PO Costs.

Did this answer your question?