We've grown to five auditors now and I'm drowning in trying to track who's working on what accounts, deadlines, client communications, etc. Currently using a mix of Excel spreadsheets and email which is a nightmare. Looking for recommendations on project management or CRM software that works well for utility auditing businesses. Need something that can track account status, deadlines, savings amounts, and client contact history. Bonus points if it integrates with QuickBooks. What are you folks using to stay organized as you've scaled up?
Software recommendations for managing multiple auditors?
Walt, I feel your pain. We went through the same growing pains about two years ago. Tried a bunch of different solutions and finally settled on Monday.com with some custom fields. It's not perfect but handles project tracking well and the team collaboration features are solid. Cost runs about $40/month for our team of six. The key was getting everyone to actually use it consistently - took about three months to break the old email habits. We track each audit as a project with status updates, file attachments, and deadline reminders. The reporting features help me see who's overloaded and which accounts are falling behind.
We use Salesforce but it's probably overkill for most audit shops. The advantage is it's incredibly customizable - we track everything from initial client contact through final payment. Set up custom objects for each utility account with fields for rate schedules, audit history, savings amounts, etc. The downside is it's expensive and has a steep learning curve. We're paying about $150/month per user. Only makes sense if you're doing significant business development and need the full CRM capabilities. For pure project management, Monday or Asana would probably serve you better at a fraction of the cost.
Have any of you tried building something custom? I've got a programmer friend who thinks he could build a specialized system for utility auditing businesses. Would include client management, project tracking, deadline alerts, and some basic reporting. Thinking it might be worth it to have something designed specifically for what we do rather than trying to adapt generic project management tools. Anyone gone the custom route? Curious about costs and whether it's worth the complexity.
Sylvia, I looked into custom development about three years ago. Got quotes ranging from $15K to $45K for a basic system, and that was before ongoing maintenance costs. The problem is you become dependent on that one programmer, and if they disappear or get busy with other projects, you're stuck. Plus every time you want a new feature or change, it's more development costs. I'd recommend sticking with established platforms that have active development teams and user communities. The off-the-shelf solutions have gotten pretty good and the costs are predictable.
Thanks for all the input. Vivian, can you share more details about your Monday.com setup? What custom fields did you create? I'm leaning toward trying that first since it sounds like it has the right balance of features and cost. Also curious how you handle file storage - do you keep audit files in Monday or use separate cloud storage?
Sure Walt. Our main board has columns for Client Name, Account Number, Utility Company, Audit Type, Assigned Auditor, Start Date, Target Completion, Status, and Estimated Savings. For status we use: Not Started, Data Gathering, Analysis, Report Writing, Client Review, and Complete. We also have a Priority column (High/Medium/Low) and a Notes column for quick updates. For file storage, we use Google Drive with a folder structure that matches our Monday projects. Monday has decent file attachment capabilities but we found it easier to keep the heavy files in Drive and just link to them from Monday. The key is having a consistent naming convention so anyone can find files quickly.
We've been using Airtable for about eight months now and it's been solid. More database-like than Monday but easier than Salesforce. Really good for tracking relationships between clients, accounts, and audits. The views feature lets each auditor see just their assignments while I can see everything. Built-in calendar views help with deadline management. Pricing is reasonable - we're paying about $20/month per user. The learning curve was pretty minimal, most of the team picked it up in a week or two. The form feature is handy for client intake - sends data straight into our database.
Whatever system you choose, make sure you plan for growth. We started with a simple solution when we had three people and had to migrate to something more robust when we hit eight auditors. The data migration was a nightmare and we lost some historical information in the process. Also consider integration capabilities early - we needed to connect with our accounting software and client portal, which ruled out some otherwise good options. I'd recommend making a list of must-have features versus nice-to-have, and think about where you want to be in three years, not just where you are now.
Update: We ended up going with Monday.com based on the recommendations here. Three months in and it's made a huge difference in our organization and communication. The team loves the visual project boards and I can finally see our full workload at a glance. Thanks for all the advice - saved me a lot of trial and error!
Glad it's working out Walt! We've been watching this thread with interest as we're hitting similar growing pains. Just signed up for Monday.com trial based on your success. Quick question - did you import your existing client data or start fresh? We've got about 200 active accounts in various spreadsheets and I'm dreading the data cleanup process.