Open Reports and choose Member Finance. The Project Finance Report adds money up by project. This report adds the same money up by person.
Read it
Set the dates first: the report opens on this month, and a range can be up to 400 days. Then narrow it with All Members, All Statuses or Search members....
The cards add up every member in the table, on every page of it:
- Cost of the team: what the team is paid for the hours tracked in the range, at each member's own pay rate, or the project's pay per hour when they have none.
- Earned by their work: what clients are charged for those hours at the project's bill rate. Fixed-price projects are left out, because they are billed as a set fee.
- Difference: earned less cost, with the margin.
- Outstanding pay: pay invoices not yet paid, from any date. It ignores the date range.
- Hours tracked: the hours in the range, across all members.
The table has one row per member: Hours, Avg rate, Cost, Earned, Difference and Margin, then Paid and Outstanding from their pay invoices. It is sorted by cost, highest first. Click a column heading to sort by it, and click a name to open that member's page.
Match it to the Project Finance Report
- Same dates. Member Finance opens on this month and the Project Finance Report on the last 30 days, so pick one range in both.
- Cost by project. In the Project Finance Report, keep Include past projects ticked and read Spent.
- Cost by member. Cost of the team in Member Finance is the same amount.
If any project has manual expenses, Spent is higher by exactly those expenses. They belong to a project, not to a person, so Member Finance does not count them.
The two match because this is not a second calculation. Member Finance takes the hours the Project Finance Report priced and adds them up by person.
Rows to know
- People who have left show last, muted and tagged Left or Deleted. Their hours cost money, so they count. Include past members in the members list is ticked when the page opens.
- UNASSIGNED marks time with no member attached. It is counted so the totals still match.
- FIXED beside the hours means some were on fixed-price projects. They count toward Cost, not Earned.
- A warning sign beside a figure means some hours had no rate in effect, so the figure is short by those hours.
- Unknown means none of the member's hours had a client bill rate, so what they earned cannot be worked out. They are left out of Earned, Difference and Margin, and the Earned card says how many members that is.
One member's page
Click a member's name. Where the cost went lists each project they worked on, with their hours, pay rate, cost, the client rate and what the work earned. The same cost, split by rate shows which days each rate covered when their rate changed. Their pay invoices and Their pay rate history follow.
Who can see it
Member Finance shows pay rates and costs, so only admins have it by default. A custom role can switch on Member finance report with Own, to see only their own row, or All. Clients are refused it whatever their role. See Build a custom role.
The report is part of Finance. If your plan does not include Finance, its link shows a padlock and the page offers an upgrade.