My Excel-based client tracking system is falling apart now that I'm managing 40+ accounts across Alabama Power, Mississippi Power, and Gulf Power territories. Need something more robust to track audit status, deadlines, findings, and follow-ups. Looking at Access, FileMaker, or maybe a cloud solution. What are you all using to manage multiple clients efficiently?
Database recommendations for multi-client tracking?
I built a custom Access database about three years ago and it's been solid. Tracks all my Texas accounts (Oncor, CenterPoint, AEP Texas) with tables for clients, audits, findings, and billing cycles. The learning curve was steep but now I can run reports, track deadlines, and even generate basic invoices. Happy to share the structure if you're interested.
Marcus, I'd love to see your Access setup. I've been limping along with Excel for 15+ Georgia Power accounts but it's getting unwieldy. Zach, have you looked at any cloud-based project management tools? Something like Basecamp or Asana might work better than building a custom database from scratch.
Rachel I haven't really considered project management tools. My main need is tracking utility-specific data - rate schedules, meter numbers, billing cycles, demand patterns. Not sure if generic PM software would handle that kind of detailed utility information. But definitely open to suggestions if anyone has tried that approach.
I use FileMaker Pro and love it. More user-friendly than Access but still powerful enough for complex utility data. I track NV Energy accounts with custom layouts for different rate classes, automated calculations for demand charges, and even photo storage for meter installations. The mobile app lets me update records on-site during facility visits.
For what it's worth, I tried building an Access database and gave up after two months of frustration. Went with a simpler approach - detailed Excel templates with consistent naming and folder structures. Not as fancy as a database but it works and doesn't require learning new software. Sometimes simple is better when you're busy with actual auditing work.
Gail makes a fair point about simplicity. The Access database was a significant time investment upfront. But now that it's running, I can generate monthly status reports for all clients in minutes instead of hours. For 40+ accounts like Zach has, the automation probably pays off. For smaller practices, enhanced Excel might be sufficient.
I'm in the simple camp with Gail. Use a shared Dropbox folder with standardized Excel templates for each client. Works fine for my 25 MLGW and TVA accounts. The key is consistent file naming and folder structure. Client_Name_YYYY_MM_Analysis.xlsx format keeps everything organized and searchable.
Thanks for all the input. Think I'm going to try Marcus's Access approach since I'm already comfortable with Office products. Cliff, the mobile capability with FileMaker is appealing but probably overkill for my current needs. Will start simple and build complexity as I learn what works.
Good choice Zach. I'll email you the basic table structure and some sample forms to get you started. The beauty of Access is you can start simple and add features over time. Begin with basic client info and audit tracking, then add more sophisticated reporting and calculations as your needs grow.
Just saw this thread - another option is QuickBase if you want something cloud-based but more structured than project management tools. I use it for TECO and Duke Energy accounts here in Tampa. More expensive than Access but handles multiple users well and backs up automatically. Worth considering if you plan to grow the business.
Vernon brings up a good point about growth planning. I started with Excel, moved to Access, and now use a custom web application for my California accounts (PG&E, SCE, SDG&E). Each step was necessary as the business scaled. For where Zach is now, Access is probably perfect. But keep future needs in mind as you design the database structure.
One more thought - whatever system you choose, make sure you have a solid backup strategy. I lost six months of client data in 2010 when a hard drive crashed and learned that lesson the hard way. Cloud storage, external drives, or both. Your client tracking system becomes mission-critical once you depend on it.