>Hello all....
>
>What are you consultant types using to keep up with your invoices, payments, etc?
>
>Thanks
I use a very sophisticated <g> combination of tools to bill my clients.
To track time, if I do work on my computer, I use Scott Craig's Connect Monitor. This is freeware, and originally meant to track time of Internet use. But it can also be manually started and stopped. I am sure other freeware stopwatches are also available.
Otherwise, I write down the time spent, on a soft and flexible material made from the pulp of a tree.
In either case, I later transfer the information to Excel. I have a spreadsheet with the following columns: Date; Hours spent; Minutes spent; What I charge (= (hours + minutes / 60) * hourly_rate); Payments; Comments.
Right at the top, I have a cell that shows the total: sum(D:D) - sum(E:E) (that is, total invoiced - total payments received). Of course, to avoid circular references, this formula is neither in column D nor E.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
