We currently use google sheets to keep track of project budgets (this is fed data from a complex set of estimating/budgeting sheets plus quickbooks. The quickbooks part is manual).
I want to be able to bring all our project budgets into one sheet.
We already use airtable to track subcontractor costs, as well as other items by project, so we have the database of projects well developed.
Does anyone have any ideas for how we might now associate this estimated vs actual cost data? We could even add an actual revenue line. I’m imaging tracking this data across projects by cost code or drilling into each cost code.
It’s important that:
-We can view it in a compact interface
-Data entry is no more difficult
-Ideally we get “snapshots” over time. (I have created a pay schedule before when tracking employee hours so the idea of advancing ‘schedules’ is something I’m familiar with)
If it’s too difficult, I’ll probably just use IMPORTRANGE in google sheets to create a summary view… womp womp.