How do YOU keep track of clients, invoices, etc? at DVinfo.net
DV Info Net

Go Back   DV Info Net > And Now, For Something Completely Different... > Taking Care of Business
Register FAQ Today's Posts Buyer's Guides

Taking Care of Business
The pen and paper aspects of DV -- put it in writing!

Reply
 
Thread Tools Search this Thread
Old October 30th, 2008, 07:07 AM   #1
Major Player
 
Join Date: Aug 2008
Location: Flint, MI
Posts: 212
How do YOU keep track of clients, invoices, etc?

I was curious on what ways worked best for you. I'm struggling between different thoughts on how to handle my contacts and billing stuff, and stay sane.
__________________
www.styleandmotion.com - Modern Wedding Films based in Michigan
www.miweddingblog.com - Michigan's dedicated wedding blog
Aaron Mayberry is offline   Reply With Quote
Old October 30th, 2008, 08:38 AM   #2
Regular Crew
 
Join Date: Oct 2008
Location: Denver, CO
Posts: 78
Quote:
Originally Posted by Aaron Mayberry View Post
I was curious on what ways worked best for you. I'm struggling between different thoughts on how to handle my contacts and billing stuff, and stay sane.
A good idea would be to make a new excel spreadsheet for every new client you have. In that spreadsheet, describe what services you did and the costs of those services and the dates they took place. That way you have a record. If you sign-up for Google checkout you can also send out invoices that the client can pay through too. :)
__________________
Website: http://rougheditproductions.com/
Vimeo Profile: http://vimeo.com/roughedit
Emrys Roberts is offline   Reply With Quote
Old October 30th, 2008, 10:39 AM   #3
Major Player
 
Join Date: Dec 2007
Location: Pembrokeshire, Wales
Posts: 734
Depends on how much and how complex the work is that you do for each client.
I have a spreadsheet with headings for job name, date, time spent, doing what, cost, mileage, etc. I enter the job when it comes in, and use extra columns for client details - phone & email especially, that I enter only once. Using the data filter, I can find everything to do with that job (or that client, month or whatever).
If you start with something simple and flexible, you can evolve it to fit what you want and ultimately keep an eye out for a contact/job/time/management program that does what you want. If you get the program first, chances are it won't do what you want it to. I tried using Outlook, but though it was supposed to be customisable to what I wanted, I never quite managed to make it work that way.
And don't forget to keep an up to date backup.
Simple things can throw you. The other week I noted that something hadn't been marked as paid in the spreadsheet, even though I was certain the client had paid. It wasn't marked in the diary as paid either. Yet there was the piece of paper that came with the check. Then I looked at the bank account and found I must have paid it in, as the amount on the statement was enough to cover the checks I had marked as paid, plus the one I hadn't - phew - saved me from chasing a payment that had been made! Looks like the check must have arrived as I was about to go to town, so I paid it into the bank and forgot I hadn't marked it elsewhere.
__________________
Canon XH A1; Canon XF100; Nikon D800
Annie Haycock is offline   Reply With Quote
Old October 30th, 2008, 11:44 AM   #4
Major Player
 
Join Date: Dec 2005
Location: Eugene, Oregon
Posts: 222
Take a look at QuickBooks. Great software for invoicing, job costing, etc.

Have fun!

Rob
Rob Neidig is offline   Reply With Quote
Old October 30th, 2008, 12:17 PM   #5
Major Player
 
Join Date: Oct 2007
Location: London, UK
Posts: 795
For tracking and invoicing time and expenses I've been using Fanurio for the last year.
This is all it does and it does it very well. It's flexible enough to handle such things as pre-payments and flat rate jobs too.
I very pleased with it:
Fanurio - Time tracking software for freelancers
__________________
http://www.gooderick.com
Richard Gooderick is offline   Reply With Quote
Old October 31st, 2008, 04:33 AM   #6
Major Player
 
Join Date: Dec 2007
Location: Pembrokeshire, Wales
Posts: 734
Here is the great advantage of being able to download the software for a trial period.

I looked at Fanurio this morning, and it looks great for what it does. I can see some situations where I could use it. And there are some things that it does more efficiently than I do them now. But it doesn't do all the things I need and so I'd still have to have my spreadsheet running alongside it.

This emphasises my earlier point - work out exactly what you need - and then try a program before you buy if you possibly can.
__________________
Canon XH A1; Canon XF100; Nikon D800
Annie Haycock is offline   Reply With Quote
Old October 31st, 2008, 08:34 AM   #7
Regular Crew
 
Join Date: Jan 2008
Location: Zelienople, PA
Posts: 86
Try out freshbooks.com ... I haven’t used it personally but I found out about it thru a banner ad and when I checked the site out I was impressed.

It really looks like something that could be valuable to me and it's only $15 a month ... prices go up from there depending on how many people you want to have accessing the system.

I just signed up for it so I haven’t run it thru its paces just yet.

FreshBooks - Online Invoicing, Time Tracking and Expense Service
George Tasick is offline   Reply With Quote
Old October 31st, 2008, 08:46 AM   #8
Regular Crew
 
Join Date: Jan 2008
Location: Zelienople, PA
Posts: 86
I just called up Fresh Books and asked them about any sort of proposal management and milestone tracking functionality ....

They told me that they don’t have it as part of their service but they work with another company who handles their "time tracking" system and that company does have a whole setup for proposal and milestone management.

Project management, collaboration, and task software: Basecamp
George Tasick is offline   Reply With Quote
Old November 20th, 2008, 09:11 PM   #9
Regular Crew
 
Join Date: Oct 2007
Location: NYC, NY
Posts: 69
Timeslips is really great time and billing software. Lots of features, not only to make invoices but to keep track of everything. I used it when I was the office manager for an internet host that had about 80 clients. It's really customizable, too.
Diane diGino is offline   Reply
Reply

DV Info Net refers all where-to-buy and where-to-rent questions exclusively to these trusted full line dealers and rental houses...

B&H Photo Video
(866) 521-7381
New York, NY USA

Scan Computers Int. Ltd.
+44 0871-472-4747
Bolton, Lancashire UK


DV Info Net also encourages you to support local businesses and buy from an authorized dealer in your neighborhood.
  You are here: DV Info Net > And Now, For Something Completely Different... > Taking Care of Business


 



All times are GMT -6. The time now is 12:39 PM.


DV Info Net -- Real Names, Real People, Real Info!
1998-2024 The Digital Video Information Network