Job time tracking for invoicing consultancy fees
For a consultancy company,
we built two spreadsheets, the first called 'Timesheet'
recorded the time spent working for each client giving a
running total. The spreadsheet then produced a
Timesheet Statement which would then be attached to the
client invoice.
The
second spreadsheet called 'Timer Sheet' ran in the
background on a computer, and when a client rang for
support, a button on the spreadsheet was clicked which
recorded the start time to the second. When the
support call finished, another button on the spreadsheet
is clicked which recorded the finish time to the second.
Details were then entered of the client and the topic.
The spreadsheet then produced a Timer Sheet Statement
which would then be attached to the client invoice.
