Spreadsheet/invoicing/database for cleaning business
Budget: £750 – £1,500 GBP
Hi
We have a domestic cleaning business in South Yorkshire, we clean around 130 clients per week.
Currently we use excel for all our schedules, sales summary, invoices, timesheets but they do not 'talk' to each other, everything is done manually, copying information from one spreadsheet to another.
What I'm looking to do is have a number of spreadsheets that automatically update each other, taking information from our main weekly schedule which will then create a weekly sales summary, weekly timesheet for each employee, update each client record with dates of cleans which in term would hopefully create an invoice for that client/
I've looked at off the shelf software packages but they don't seem to be able to fulfil our requirements.
Some of our clients pay cash/cheque on the day, some via BACS and some are invoiced monthly.
Our weekly schedule show; names of staff, who they clean, length of clean, cost, how they pay.
My hope is that the customer database, staff timesheets, sales summary and invoicing can be automatically updated from this main weekly schedule.
We have a domestic cleaning business in South Yorkshire, we clean around 130 clients per week.
Currently we use excel for all our schedules, sales summary, invoices, timesheets but they do not 'talk' to each other, everything is done manually, copying information from one spreadsheet to another.
What I'm looking to do is have a number of spreadsheets that automatically update each other, taking information from our main weekly schedule which will then create a weekly sales summary, weekly timesheet for each employee, update each client record with dates of cleans which in term would hopefully create an invoice for that client/
I've looked at off the shelf software packages but they don't seem to be able to fulfil our requirements.
Some of our clients pay cash/cheque on the day, some via BACS and some are invoiced monthly.
Our weekly schedule show; names of staff, who they clean, length of clean, cost, how they pay.
My hope is that the customer database, staff timesheets, sales summary and invoicing can be automatically updated from this main weekly schedule.