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:
- 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?