We're growing fast here in Alabama and I need better project management. Currently using Excel spreadsheets to track 15+ ongoing audits for Tennessee Valley Authority and Alabama Power clients. It's getting unwieldy. What software are you all using to manage workflows, deadlines, and client communications?
Software recommendations for managing multiple audits?
We use Basecamp for project management and it's been solid. Helps track where each Idaho Power audit stands, what deliverables are due, client communications in one place. About $50/month for our team size. The key is getting everyone to actually use it consistently.
I tried a bunch of different solutions and ended up building something custom in FileMaker Pro. Tracks each audit phase, calculates savings automatically from our Empire District data, generates status reports. Took time to set up but now it's our competitive advantage.
For what it's worth, we've had good luck with Monday.com for Pennsylvania utility audits. The visual pipeline view helps track where each PPL or PECO audit stands. Clients love getting automated status updates. Worth the monthly cost for the time it saves.
CRM is just as important as project management. We use HubSpot to track our Texas utility client relationships, follow-ups, and referrals. Integration with our project tools makes everything smoother. Don't underestimate the value of organized client data.
Vivian makes a good point about CRM integration. Are you finding that these platforms handle utility billing data well? Some of our TVA audits have massive amounts of interval data that needs organizing alongside the project management workflow.
For the actual billing data, we still use specialized tools. But Basecamp handles all the project coordination, deadlines, client approvals. Keep the billing analysis separate from project management - trying to do both in one system gets messy fast.
Albert, I'd second the advice to keep data analysis and project management separate. We use custom Excel tools for Georgia Power rate analysis but Asana for tracking project milestones. Clean separation of concerns works better than trying to find one tool that does everything.
Has anyone tried Smartsheet? It's like Excel on steroids with project management features built in. Might bridge that gap between data analysis and workflow management that Albert is looking for. We use it for some of our larger Austin Energy commercial audits.
Nancy, Smartsheet is interesting but the learning curve was steep for our team. Ended up going back to simpler tools. Sometimes the best system is the one your team will actually use consistently, not necessarily the most feature-rich.
Great discussion everyone. I'm leaning toward trying Basecamp first since Warren had good results with Idaho utilities. Seems like the consensus is to keep it simple and focus on adoption. Thanks for all the input - this will save us a lot of trial and error.