Katie Humphreys
January 13 2007, 07:48 AM
We track our inquiries, and I have an excel set up to track basic stuff like what date they're interested in, when they actually contacted us, what we quoted them, who the referral was, etc. It's nothing fancy, but it does the trick. We also have a "status" section that helps us keep track of where we're at in the process (ie if we are waiting on email back from them, or if we need to call and set up a meeting, etc.) As far as tracking all this on a monthly basis, we don't really do anything different, but when we book a new client, they get automatically linked into another worksheet of our actual clients and all of the information on there (some slightlly different stuff on that sheet). Linking information within different worksheets has been really helpful so that if I change something on one worksheet, it will automatically change in other places that I am keeping that information.
I don't think you were looking for too much info on financial tracking, but we have a pretty big workbook with a few different tabs in excel set up to track different types of income, etc. Scott, I think you said you are just getting set up on Quickbooks, etc. This is the case wiht us-we are switching to using Quickbooks, and so we're in the middle of doing that. It's a lot of work, but definitely is going to help us have better tracking and reports by going with Quickbooks. I am finding that using Excel and Quickbooks hand and hand has helped us get really clear information and be able to keep track of things really well.
Good question!! I'd love to hear what others track and how they're set up!