Skip to content
Workflow · People · Opening soon

Project profitability

Export your Harvest time entries, cost rates, and project invoices and expenses. Then match the rows by project and person, add labor cost from hours at each person's rate, and subtract labor cost and expenses from billed revenue.

Early access opens shortly. Check back soon.

Someone typed

“from the harvest time entries, cost rates, and project invoices/expenses, calculate each project's profit and margin, show project names the usual way, and status Agrees at 20% margin or higher, Low margin otherwise”

The agent read it as

From the Harvest time entries, Harvest cost rates, and Harvest project invoices and expenses, calculate each project's profit and margin, show project names the usual way, and status Agrees at 20% margin or higher, Low margin otherwise

What the agent built

7 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    Harvest time entries
    CSV export · 42 rows
  2. File
    Harvest cost rates
    CSV export · 8 rows
  3. File
    Harvest project invoices and expenses
    CSV export · 6 rows
  4. Step
    Clean time entry keys
    Step 2
  5. Step
    Clean rate person keys
    Step 1
  6. Step
    Clean invoice project keys
    Step 5
  7. Join
    Add hourly cost rates
    42 of 42 paired
  8. Step
    Total labor cost by project
    Step 4
  9. Join
    Add project labor costs
    6 of 6 paired
  10. Step
    Calculate project profit and margin
    Step 7
  11. Result
    Project Profit Margins
    6 rows · 1 flagged
  12. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 6 rows came out, and the join paired 42 of 42 rows; the join paired 6 of 6 rows.

What you get back

The result of that run, the rows to look at first.

Project Profit MarginsSample data6 rows
5 agrees1 low margin
ProjectProfitMarginStatusBilledExpensesLabor cost
Delta Mobile2,767.5012.9%Low margin21,40012,6006,032.50
Apex Launch21,227.5074.1%Agrees28,6501,8505,572.50
Beacon Rebrand9,717.5056.5%Agrees17,2002,4005,082.50
Cedar Portal24,59577.3%Agrees31,8001,5005,705
Ember Support14,322.5073.6%Agrees19,4509004,227.50
Fusion AI28,222.5078.9%Agrees35,7502,2005,327.50
6 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Project Profit Margins workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Project Profit Margins: questions

How do you calculate project profitability?
Export your Harvest time entries, cost rates, and project invoices and expenses. Then match the rows by project and person, add labor cost from hours at each person's rate, and subtract labor cost and expenses from billed revenue. The result shows profit, margin, and a status for each project.
Which export files should you use?
Use the export that has time entries, the export that has cost rates, and the export that has project invoices and expenses. The workflow needs the rows that show project names, people, hours, rates, billed revenue, and expenses.
What happens to rows that do not match?
Rows that do not match a key are left out of the calculation for that step. You can clean the key values first, then rerun the workflow so more rows line up the way you expect.
How do you change the rules?
Edit the steps in words, for example, change how keys are cleaned, how labor cost is calculated, or what margin counts as a status. Then run the workflow again with the same export files or new ones.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.

Workflows like this

Match payroll to time sheets, track headcount and hiring, and see what changed since last month.

All people and payroll workflows →