I've been researching automated bill processing systems that can import PDF utility bills and extract key data automatically. Has anyone implemented something like this? I'm handling about 50 accounts now with PPL Electric and manually entering all the bill data is becoming a bottleneck.
Automated bill processing systems - anyone using these?
Sylvia, I looked into this last year but didn't find anything cost-effective for smaller practices. The enterprise solutions are designed for companies processing thousands of bills monthly. For 50 accounts, you might be better off with a good data entry template and maybe hiring a part-time assistant.
There are some newer cloud-based services that might work for mid-size operations. I've been testing one called BillPro that integrates with several Ohio utilities including Duke Energy. Still requires some manual cleanup but reduces data entry time by about 60%.
Cecilia, can you share more details about BillPro? What's the pricing structure like? And how accurate is the data extraction? I can tolerate some errors if it's catching the major line items correctly.
Pricing is per-bill processed, starts around $0.50 per bill for basic extraction. Accuracy varies by utility format - Duke Energy bills work well, about 90% accurate on usage and demand figures. Rate schedule identification is hit-or-miss though, especially for older tariffs.
Have you considered building something custom? I work with a programmer who's familiar with utility bill formats. Might be able to create something specific to PPL's layout for less than the ongoing subscription costs of the commercial services.
Albert, that's an interesting option. What kind of investment would we be looking at for custom development? PPL has been pretty consistent with their bill format over the years, so something tailored might work well.
Ballpark $3,000-5,000 for initial development, depending on complexity. The programmer I work with charges $75/hour and estimated 40-60 hours for a basic extraction tool. Ongoing maintenance would be minimal unless PPL changes their format significantly.
Custom development sounds risky to me. What happens if the programmer moves on or isn't available for updates? I'd stick with established commercial solutions even if they're more expensive. At least you have support and regular updates.
Warren raises a good point about support. The commercial services also handle format changes automatically when utilities update their bills. I've been through several PPL format changes over the years - having someone else deal with those updates is worth the extra cost.
Thanks for all the input. I think I'll trial BillPro for a few months and see how it works with my workflow. If it saves even 10 hours per month, it'll pay for itself pretty quickly. Will report back on how it goes.
Sylvia, definitely interested in hearing your results. I might have enough volume now to justify something like BillPro. Georgia Power accounts are getting more complex with all the new rate options, so anything that speeds up data entry would help.
Following this thread with interest too. PG&E bills in California are becoming nightmares to process manually with all the time-of-use changes and net metering calculations. Automation is definitely the way forward for anyone handling significant volume.