Tracking Construction Costs

  • Thread starter Thread starter StuH
  • Start date Start date
S

StuH

I'm new to this so Ihope my question is appropriate for this group.
I'm having a home built on a cost plus basis and need an excel
spreadsheet that will help me track and manage the construction costs.
Any suggestions?

Stuh
 
Just Jump in

Open Excel, have a list of materials and labour and in the column alongside
the cost, then alongside that if it is cost +10% then enter a formula of

=B2*1.1

this will give you the total to be paid. You can enter payments out as
minus and set up a total somewhere on the sheet with

=SUM(C:C)

Which will total the data in column C (the cost plus column)

Equally you could simply enter Description of labour/material and price in
two columns (using minus for outflow) and then summarise it with a pivot
table, but the simpler route may be the best to start with

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

(e-mail address removed)
www.nickhodge.co.uk
 
The most important thing to remember is not to pay any draws until you see
the bill and signed releases from the subs.
Make categories so that you can get subtotals such as:
framing
flooring
windows
paint
 
Thanks for the response. Actually what I was looking for is an ready
built spreadsheet that I could simply plug my numbers into. Do you know
of any?
 
Thanks for the response. Actually what I was looking for is an ready
built spreadsheet that I could simply plug my numbers into. Do you know
of any?
 
Thanks for the reply but what I'm looking for is an existing
spreadssheet that I can simply plug my information into.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top