Keeping track of progress and payments

[WWilts]

Does anyone recommend particular spreadsheets or software that will:

 

Track part completion of each build stage or build activity

Track invoices / payments

Track expenditure vs budget (already have detailed quote / budget)

Without having to enter any info more than once.

 

I set up a simple google spreadsheet and form to enter invoices and payments. But I still have to go in manually to copy the amounts across to the expenditure vs budget sheet.
Would be great to have it automated within some software (free or affordable)

[WWilts]

For those going down this route,

 

it appears that Google spreadsheets has a Query function that can automate what I wanted automated. But it's taking a bit of time and effort to learn.

[Kelvin]

In Excel you can link cells between sheets (or whole sheets) I hunted around for some software to do all this for me but in the end I’ve been slowly building up a rather crap Excel workbook but it will have all the detail in it.