We are a property maintenance company and are looking for some sort of solution to manage data. The following is data we need to manage:
**Property ??"** Address, vendor, tenant, letting agent.
**Person** ??" Type (vendor/tenant/letting agent), name, phone, email, address.
**Job done on property** ??" Job no., description, tradesman time in, tradesman time out, access details, date, cost of materials, cost of labour, before pictures, after pictures.
**Cost of material** ??" Description, cost.
**Invoice ??"** Date, invoice no., job no., job description, amount exclude VAT, VAT, total include VAT, invoice to (vendor/tenant/letting agent).
We would like a solution where we can keep track of what work has been done on which property, and whether we have sent out the invoice and if its been paid.
Can you please give us a quote for this?
Alternatively, we have MS Excel but not Access. Can you advise how we would go about building something for this in Excel?