Per-project profitability analysis in Google Sheets
Reading time: 6 min
Updated: June 15, 2026
Guide contents
1. Revenue per project
Classify each invoice by project. In services, associate billed hours and the corresponding amount to their project.
2. Direct and indirect costs
Allocate direct costs (staff, tools) to each project. Indirect costs are distributed with an allocation key (by hours or revenue) to calculate the full margin.
3. Make decisions
The per-project profitability report must feed decisions: renew contracts, raise prices, or divest from low-margin clients.
Want to automate this process?
Connect all your QuickBooks accounts to Google Sheets with FinBoard and forget about copy and paste.
Try FinBoard Free