Results 1 to 7 of 7

Thread: Three easy tips for keeping client info organised

  1. #1
    Email problem KimH's Avatar
    Join Date
    Jul 2010
    Location
    Cape Town
    Posts
    362
    Thanks
    167
    Thanked 63 Times in 52 Posts

    Three easy tips for keeping client info organised

    While browsing the interwebs I came across these very helpful tips on organising client information. (www.traceylawton.com).


    "For many solopreneurs a large part of their business is working one-on-one with clients, and that means having a way of keeping all of their client information organized and easy to access.

    1. Physical: Create a Client Contact Sheet

    For most business owners there will be a physical client file that you’ll need to create. One of the simplest ways of creating this file is by using a manila file folder in which you simply drop your paperwork into. This file will contain things like the agreement form from your client, assessment forms, or details of any projects that you’ll be working on.

    Creating a Client Contact Sheet which contains your client’s name, address, email, phone, fax and any other contact information that you want to keep a record of is a useful template to have. You simply print it out and fill it in each time you take on new client.

    Once you’ve printed out the Client Contact sheet, staple it to the inside left cover of your client folder. This way whenever you need to access your client’s information you just flip open the file and the information is right there.

    2. Digital: Create Client Folders

    As the majority of your communication is probably done via email with documents going back and forth, you’ll also want to create an individual client folder on your PC. It may not be necessary to print out everything your clients send you, but you do need to store the information so that’s it easy for you to find.

    A couple of places where you’ll want to create individual clients folders are:

    In your email program. For each of my clients I have created their own email folder so that any emails that are sent to/from my client goes into their individual email folder. This allows me to keep track of our communications easily, rather than having to sift through hundreds of emails that come into my Inbox each day.

    Tip: In Outlook you can also set up rules so that email is automatically filtered into the appropriate client email folder – saving heaps of time!

    In your main client folder. I’m a big believer in creating main/sub folders for managing my filing system – both for paper-based and PC files.

    3. All Clients: Client Tracking Spreadsheet

    Once you have your physical and digital individual client files created, you’ll want to think about utilizing a client tracking spreadsheet. If you are a coach or other service professional chances are your core programs are working one-on-one with clients during sessions (phone or in-person) so it makes sense for you have a system for tracking where your clients are in their programs.

    In the beginning stages of your business it may be easy for you to keep tabs on just a few clients, but as your business grows and you’re working with more and more clients, you will quickly find yourself overwhelmed if you don’t have some kind of tracking system in place.

    If your clients book a certain number of sessions with you creating a simple spreadsheet that has your client’s names in the left-hand column, and a column along the top for each session will allow you to easily see how many sessions they have already booked and how many sessions they have left.

    By setting up a client tracking spreadsheet that shows you at a glance exactly where your clients are in your programs will give you a ‘big picture’ view of your business."

    Comments:

    When I first started the business I tried out a few different time sheet programmes and soon found them to be time consuming (not a good thing when your stock in trade is time ) - so I designed a simple spreadsheet, tab 1 is for timesheets and tab 2 is a day by day record of each client and the hours worked - each clients hourly rate is included and it calculates exactly how much each client owes me at any given time. Invoicing is a breeze and each client receives a detailed timesheet at month end. I can also see how productive I am throughout the month and this helps me plan for the following month.
    "If at first you don't succeed, do it like your mother told you."

  2. Thank given for this post:

    Mark Atkinson (12-Aug-11), rfnel (12-Aug-11)

  3. #2
    Diamond Member wynn's Avatar
    Join Date
    Oct 2006
    Location
    east london
    Posts
    3,338
    Thanks
    548
    Thanked 625 Times in 524 Posts
    What about 'sugar crm'
    "Nobody who has succeeded has not failed along the way"
    Arianna Huffington

    Read the first 10% of my books "Didymus" and "The BEAST of BIKO BRIDGE" for free
    You can also read and download 100% free my short stories "A Real Surprise" and "Pieces of Eight" at
    http://www.smashwords.com/books/view/332256

  4. #3
    Gold Member Mark Atkinson's Avatar
    Join Date
    Jul 2010
    Location
    Melbourne, Australia
    Posts
    796
    Thanks
    212
    Thanked 150 Times in 117 Posts
    Blog Entries
    12
    Great tips, Kim I was pleasantly surprised to note that we are already doing all these things at Red Giant. I think efficiency is something you learn the longer you're in business/doing something. It could be called a learning curve.

  5. #4
    Email problem daveob's Avatar
    Join Date
    Feb 2008
    Location
    Amanzimtoti
    Posts
    655
    Thanks
    107
    Thanked 118 Times in 103 Posts
    I'm a great believer of spending a whole day (if I have to) to automate a simple task that would save me 30 minutes per day, 3 or 4 times a week. It's not about saving the 30 minutes - it's about giving myself extra time to concentrate on "making the business" instead of "running the business".
    Watching the ships passing by.

  6. #5
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    22,649
    Thanks
    3,305
    Thanked 2,676 Times in 2,257 Posts
    Blog Entries
    12
    Quote Originally Posted by KimH View Post
    3. All Clients: Client Tracking Spreadsheet

    Once you have your physical and digital individual client files created, you’ll want to think about utilizing a client tracking spreadsheet.
    That might be OK if you have a small client base, but it's going to get really cumbersome really quick as your client base grows.

    Quote Originally Posted by wynn View Post
    What about 'sugar crm'
    My thought exactly - at least for all the "digital organisation" part.

  7. #6
    Bronze Member rfnel's Avatar
    Join Date
    Jun 2011
    Location
    Germiston
    Posts
    196
    Thanks
    120
    Thanked 41 Times in 31 Posts
    Blog Entries
    4
    Quote Originally Posted by daveob View Post
    I'm a great believer of spending a whole day (if I have to) to automate a simple task that would save me 30 minutes per day, 3 or 4 times a week. It's not about saving the 30 minutes - it's about giving myself extra time to concentrate on "making the business" instead of "running the business".
    I'm a big fan of automating simple tasks. It saves a lot of time in the long run, and usually, it greatly reduces the possibility of human error.
    "Fortune favours the bold" - Virgil
    Riaan Nel
    Freelance Software Development | LinkedIn | Skype

  8. #7
    Email problem
    Join Date
    Aug 2011
    Location
    Pta
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts
    another very important thing worth mentioning is that, one should perform backups continuously.

Similar Threads

  1. WANTED: Accounting\Book keeping services
    By AmithS in forum Business Finance Forum
    Replies: 6
    Last Post: 15-Dec-17, 08:50 AM
  2. Poor time keeping
    By sterne.law@gmail.com in forum Labour Relations and Legislation Forum
    Replies: 21
    Last Post: 10-Feb-10, 09:41 AM
  3. Can driving under the influence be considered organised crime?
    By Dave A in forum South African Politics Forum
    Replies: 4
    Last Post: 15-Nov-06, 07:01 AM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •