Jump to content

Recommended Posts

Posted

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)

Posted

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.

  • 9 months later...
Posted

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. 

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...