Construction cost monitoring - how do you do it?

  • Erstellt am 2013-11-12 14:12:10

kaho674

2013-12-15 21:38:37
  • #1

Ha, I have that as well. Additionally, I have a column with the payment date (the bank wants that later), a column indicating which expenses I report to the bank and which I don't, and an assignment to trades (for example, roof, electrical, etc.).
Below that, the current account balance or rainy day funds, etc. are also recorded, the still expected loan disbursements, and of course ultimately the surplus or (hopefully not) shortfall of the overall project.
 

ChristianF

2013-12-17 23:09:45
  • #2
Would one or the other of you be willing to provide me with your Excel file? Of course without amounts etc.

Best regards, Christian
 

Wastl

2013-12-18 11:55:56
  • #3
I sent you my file - it's relatively simple - with a pivot in Sheet 1. At the end, just the breakdown by category, amount, payment date, etc.
 
Oben