Cost, revenue, and billable reporting
Sandtime.io can separate billable and non-billable work and combine that with rates in reports.
Building blocks
- mark projects or activities as billable where appropriate,
- keep non-billable work in dedicated projects when possible,
- set hourly rates where cost or revenue analysis is required,
- use custom reports to group results by project, member, or date.
Where rates live
Cost is what a person costs your organization, so it is set on the member in the organization. Revenue is what their work earns on a particular piece of work, so it is set on the member within a project.
In either place, click Add rate, give the rate a start date and optionally an end date, then fill in Hourly rate, Tax rate, and Currency.
Rates over time
Rates are kept as a timeline rather than a single value, so a raise or a renegotiated rate does not rewrite past reports. The range covering today is marked Active, and a range that has not started yet is drawn with a dashed line.
Working in more than one currency
Different ranges can use different currencies.
When a report covers a period that mixes currencies, Sandtime.io does not convert between them. Each currency is totaled separately, so you get one sum per currency instead of one misleading combined number.
Who can see rates
Members with the User role do not see the rates assigned to them.
Useful metrics
- Billable time
- Non-billable time
- Cost per hour, Revenue per hour, Total cost, and Total revenue if your organization uses rates
Why this matters
This setup helps you answer questions like:
- Which projects consume the most time?
- How much of that time is billable?
- Which month or member drove the most revenue?