How to: construction management

Sounds very possible :slightly_smiling_face: Do you mind sharing a bit more info where the data is coming from and what the challenges are exactly?

Yeah sure!
My table is in Spanish… but from left to right the tabs read:
PROYECTS - TASKS - MONEY RECEIVED - EXPENSES - AVAILABLE MONEY

I’m trying to have control over the money the client gives me, the money I hand out to contractors and have a visualization on how much money I have avaible at any given time.

In the TASKS tab I have all of the tasks for the construction process:

• Demolition
• Construction
• Drywalling
• Electrical etc.
  There I have a budget for each task.
  In the GASTOS (Expenses) tab I have linked how much money I’ve given to every contractor, it links to the TASKS tab where it tells what the contractor budget is and via a formula that gives me RESTANTE which means how much money I owe the contractor, because I pay them according to jobs finished.

What I want is the have a tab DINERO DISPONIBLE (Available money) that takes the DINERO RECIBIDO (Received Money) and basically does: Money given to me by the client - All the money I’ve given to contractors = Money available…

Did I make any sense?

checkout fintable 🙂