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
You can run this report using the following criteria:
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.
This report is sorted by month and shows time, costs, invoiced amount and profit.
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 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 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 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 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 is the sum of Time Costs, Material Costs and PO Costs for each month.
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 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 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 is the total amount invoiced for each month, i.e the sum of Invoiced Time, Invoiced Materials and Invoiced POs.
Gross Margin is Total Invoiced less Total Costs.
Gross Profit is Total Invoiced less PO Costs.