
Closed
Posted
Paid on delivery
I need hundreds of electricity bills of different states downloaded as PDFs directly from the provider’s website, then analysed month-by-month. I can supply every piece of customer data required to open the online account, but the actual registration and first-time login are up to you. Once inside, pull every available bill, save them in well-named folders, and build a clean spreadsheet that shows: current due amount, previous month’s due amount, the difference, and any penalty or late-fee charged for the period. Highlight any month where a penalty appears or the amount jumps noticeably. Deliverables • Zipped archive of all PDF bills, organised chronologically • Excel or Google Sheet with columns: Month, Due Amount, Previous Due, Difference, Penalty (Yes/No), Penalty Amount Feel free to automate with Python, Selenium, Power Query or another tool—speed and accuracy matter more than how you achieve them. Let me know your estimated turnaround and the approach you plan to take.
Project ID: 40725164
52 proposals
Remote project
Active 3 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
52 freelancers are bidding on average ₹21,263 INR for this job

Automating your bulk electricity bill downloads and building your month-by-month penalty tracker across hundreds of accounts. You need a fully automated pipeline that logs into each state provider portal, pulls every available PDF bill, and surfaces penalties and amount spikes in a clean, analysis-ready spreadsheet — with zero manual effort on your side. Here is my exact execution plan: Portal Automation Engine: Playwright handles registration, first-time login, and bulk PDF download across each state provider, bypassing common bot blocks. Smart File Organiser: Bills saved into chronologically named folders by state and account — zipped and ready to hand off. Bill Parser: Python extracts Due Amount, Previous Due, Difference, and Penalty fields directly from each PDF with high accuracy. Clean Comparison Sheet: Excel output with all required columns, plus conditional highlighting wherever a penalty appears or amounts spike noticeably. I will deliver the complete zipped archive plus the final Excel tracker within 5 days at 22,500 INR. One question before I begin: are all the state provider portals web-based logins, or do any require OTP verification tied to a registered mobile number?
₹22,500 INR in 5 days
7.1
7.1

Hi there, I’ve thoroughly reviewed your project details and am confident I can deliver exactly what you're looking for. I have direct experience with this type of work and can start right away. To show you what I can do, I’d be happy to prepare a quick sample for your review. Let’s connect to discuss the full scope of work so I can provide an accurate project estimate. Best regards, Muhammad Haris
₹12,500 INR in 1 day
6.8
6.8

Hi Sir, I am from Banglore,India. For automating account registration and bill downloads across multiple utility providers, Selenium is the right tool since these portals rarely expose clean APIs — I'd script the login/download flow per provider (each state's electricity board site typically has its own layout), then a scheduled or batch run to pull every available bill and save it into a chronologically organised folder structure. Once the PDFs are in hand, I'd extract due amount, billing period, and any penalty/late-fee line item using PDF text parsing — most utility bills follow a consistent template per provider, so extraction can be scripted reliably rather than done manually. That feeds directly into the spreadsheet with Month, Due Amount, Previous Due, Difference, and Penalty flag calculated automatically, with conditional formatting highlighting any month with a penalty or a notable jump. One thing worth flagging upfront: since different states likely mean different electricity providers with different site structures, each provider needs its own scraping logic — I'd want to know how many distinct providers/portals are involved before committing to a turnaround estimate, since that's the main variable in effort. I have worked here with more than 130+ clients.
₹14,000 INR in 2 days
6.5
6.5

I understand you need a reliable, scalable workflow to access authorized electricity-provider accounts, download hundreds of historical PDF bills, organize them chronologically, and accurately compare monthly dues and penalties. My Approach: I’ll use Python with Selenium/Playwright where appropriate to automate login, navigation and PDF collection, while handling customer data securely and avoiding unnecessary exposure of credentials. I’ll organize bills by state/provider/account and month, then extract due amounts, previous dues, differences and penalty charges into a clean Excel/Google Sheet. I’ll add clear flags for penalties and significant month-over-month increases, validate extracted figures against the PDFs, and maintain an audit-friendly structure. I’ll provide the complete ZIP archive and spreadsheet with a documented workflow. 1. How many states/providers and accounts are involved? 2. Are all portals accessible through standard web browsers? 3. Should “noticeable jump” use a specific percentage/amount threshold? 4. Do you prefer Excel or Google Sheets as the final report? I’ll deliver an accurate, organized and maintainable bill-recovery and analysis workflow.
₹12,500 INR in 7 days
5.7
5.7

Hi, I can automate the end-to-end extraction and comparison workflow for your electricity bills using Python and Selenium. Execution plan: - Portal Navigation & Batch Download: Headless Python script to handle first-time logins, session credentials, and automated downloading of historical PDF bills into clean chronological directory trees. - PDF Data Extraction: Automated parsing using pdfplumber to accurately capture due dates, current due amounts, prior balances, and penalty line items. - Comparative Excel Spreadsheet (.xlsx): Formatted summary with columns for Month, Due Amount, Previous Due, Difference, Penalty (Yes/No), and Penalty Amount, with conditional formatting highlighting noticeable jumps and late charges. - Zipped Bill Archive: Chronologically organized PDF archive matching the spreadsheet rows. Relevant automation work: https://www.freelancer.com/portfolio-items/232036-graphtreon-commentor How many unique provider portals are involved, and do any require multi-factor SMS authentication during login? Looking forward to hearing from you.
₹22,500 INR in 7 days
5.8
5.8

Hi I will register, log in, download all PDFs for each state, organize them chronologically, and produce an Excel sheet with Month, Due, Previous Due, Difference, Penalty (Yes/No) and Penalty Amount, flagging spikes. I can deliver within 10 days for your budget. Shall I start with a sample set? Best, Rahul Waiting for your response in chat! Best Regards.
₹25,000 INR in 3 days
5.5
5.5

I can automate the authorized bill-portal workflow, download and organize hundreds of PDF bills, extract month-by-month due amounts and penalties with Python/OCR, and produce a clean Excel/Google Sheet with differences and anomaly flags. I’ll include validation checks, chronological folders, and clear logs; estimated turnaround is 3–5 days depending on portal access and PDF formats.
₹12,500 INR in 2 days
5.6
5.6

I can build something that does an automatic signup. However, I will need to know what the next step is: Is it open a link in an email. If yes, that can also be done. Downloading PDFs and parsing some information from them can also be automated. I would build this using a combination of python, playwright and pypdf.
₹25,000 INR in 7 days
5.3
5.3

Hi, I’ve worked on similar large-scale browser automation and data extraction, so I can handle this without turning it into a manual data-entry job. I can automate the provider websites with Python + Selenium/Playwright, handle the login/account flow using the customer details you provide, download the available bills, and organise the PDFs by customer and month. I can then extract the billing data into Excel/Google Sheets, calculate the month-to-month differences, identify penalties/late fees, and flag unusual increases so the final spreadsheet is easy to review. I previously used Python + Playwright to extract data from 100,000+ contacts and then automated the transfer into another system, so I’m comfortable with high-volume processing, retries, pagination and handling imperfect web pages. I’ll also keep the process organised so it can be rerun if additional bills need to be collected later. Happy to review the provider websites and customer data format first, then I can give you a realistic turnaround. Thanks!
₹25,000 INR in 7 days
4.6
4.6

Automate the account registration, portal authentication, and batch PDF downloading using a headless Python and Playwright pipeline to extract every historical bill WITHOUT MANUAL DELAYS. Once downloaded, an automated Python parser using pdfplumber and Pandas will extract tabular figures from each statement directly, guaranteeing 100% ACCURACY on due amounts, month-over-month variances, and penalty flags. The deliverables will include a cleanly structured ZIP archive organized chronologically, along with an Excel file featuring CONDITIONAL FORMATTING to visually highlight abnormal billing jumps and fees. Having successfully completed over 40 automation and data extraction projects with top ratings, I can deliver the fully verified dataset within 3 days. Are the utility provider portals protected by CAPTCHAs, or will standard automated session handling suffice for the first-time registrations?
₹12,500 INR in 1 day
4.8
4.8

Hello. I can create a software that meets your requirements using python libraries and Custom Tkinter, and then convert it to a .exe file using pyinstaller. Or I can use Dotnet MAUI (C#) for faster result.
₹12,500 INR in 7 days
4.7
4.7

As an enthusiastic and experienced web developer with a strong background in automation and Python, I am confident I can provide you with the solution you need for your Bulk Bill Download & Comparison project. With over 9 years of experience, my team and I specialize in turning complex ideas into practical realities. Python and Selenium would be ideal tools to streamline this task by automating the process of gathering the PDF bills from various electricity providers' websites. My plan includes using Python and Selenium to access each provider's online account using credentials provided by you, downloading all the available bills as PDFs, and storing them in organized folders for easy access. Additionally, I’ll use Power Query to efficiently analyze the data month-by-month, extracting essential information such as current due amount, previous month's due amount, difference, penalty (Yes/No), and penalty amount. Finally, I'll deliver all the renamed PDFs in one zipped archive and provide you with an Excel or Google Sheet containing the structured data. One of advantages of working with us is that we believe in delivering quality solutions at a cost-effective price point. Furthermore, our services don't stop after project delivery; we offer free support for three months after project completion to ensure everything continues to run smoothly. With a track record of reliable, accurate, and efficient projects similar to yours, my team will not only save you time b
₹25,000 INR in 7 days
4.6
4.6

I can automate the end-to-end bill workflow with Python/Selenium: authenticate with the customer-provided details, download every available PDF, organize files by state/account/month, and extract due amounts, prior-month differences, penalties and unusual jumps into a clean Excel/Google Sheet. With 9 years of experience in Python, web scraping, Selenium, data pipelines and analysis, I’ll add robust retries, clear logs, validation checks and a reviewable output so accuracy is easy to verify. I can also document the process and provide the final archive and summary within about 10 days. Approximately how many accounts and bills are expected, and do the provider portals require OTP or CAPTCHA during login?
₹22,000 INR in 10 days
4.4
4.4

Hi, noticed that you are looking for a skilled developer who can automate and download the bills and organise them. I can get it done as i have previously used selenium to automate logins and get data from them. I've used this to automate login in amazon and get required data. So I'm sure that with my experience I'll be able to get it done in no time. Plus if you want I can do this at cheaper price. So let's talk more in DM.
₹12,500 INR in 1 day
3.6
3.6

Hi, I can handle this as an automated bill-retrieval and reconciliation workflow rather than a manual download task. I’d use Python with Selenium/Playwright for account registration, login, navigation, and PDF retrieval where automation is permitted, with retry handling for session timeouts and failed downloads. Bills would be saved in a consistent provider/state/customer/year/month folder structure so the archive remains easy to audit. For analysis, I’d extract each bill’s billing month, current due, previous due, penalties/late fees, and calculate the month-over-month difference. The final Excel/Google Sheet would include the requested columns, conditional highlighting for penalties and unusual jumps, plus validation checks to catch missing or duplicate bills. I’d also maintain a simple processing log showing which accounts and months completed successfully and which require review. Accuracy and traceability would be the priority, with credentials and customer data handled securely throughout the process.
₹15,000 INR in 3 days
3.3
3.3

Every state portal handles registration and login differently, security questions on some, email verification on others, probably a CAPTCHA on whichever hates automation the most. The call before writing any code is whether to build one generic login flow that tries to cover all of them and breaks the moment a portal wants something unexpected, or a separate adapter per portal that takes longer through the first few and then keeps running, which is also what lets this scale if you add states or accounts later. I'd build it the second way. Each portal gets registration and first login handled once, then a scraper that logs back in, pulls every available bill as PDF, and drops it into a folder by provider and account. Once the PDFs are down I pull due amounts into one workbook and flag month over month jumps and anything that looks like a penalty, so you're reading one sheet instead of digging through folders. 55000 INR over 5 days, split so the whole build isn't funded before you see it work: M1: core framework plus first 2-3 portal adapters end to end. 18150 INR, 2 days. M2: remaining portal adapters and folder structure. 20000 INR, 2 days. M3: comparison workbook with flagging logic. 16850 INR, 1 day. That figure is off the brief, the real driver is how many distinct portals end up on the list, since each one adds to M1 and M2. How many separate provider portals are on the list, and roughly how many accounts per portal?
₹55,000 INR in 5 days
3.5
3.5

Hi, I’d be happy to help with this project. I can log in to the electricity provider portals, download all available bills as PDFs, and organize them in month-wise folders with clear file names. I’ll also prepare a clean Excel sheet showing the current due amount, previous month’s due, the difference, and any penalty or late fee. If I notice unusual jumps or missing bills, I’ll flag them separately for your review. I’m comfortable handling large batches and can use automation where it saves time while still checking the final data for accuracy. I’m ready to start as soon as you share the customer details and provider list.
₹12,500 INR in 3 days
3.2
3.2

We can automate the complete electricity-bill workflow using Python/Selenium or Playwright, including provider-site login, bill retrieval, PDF downloads, chronological folder organisation, and month-by-month data extraction. We’ll create a clean Excel/Google Sheet with due amounts, previous dues, differences, penalty status/amount, and automatic highlighting of unusual increases or penalties. We’ll validate the extracted data against the PDFs and provide the complete ZIP archive and spreadsheet with a clear, reproducible process.
₹25,000 INR in 7 days
3.2
3.2

Hi — VSTEQ Softwares builds Python automation for bill download, parsing, and comparison workbooks. We'll download electricity bill PDFs, organize files, extract monthly charges, and produce comparison spreadsheets with validation checks. Share portal URLs and sample bills at kickoff. Bid: ₹23,500. — VSTEQ / @VividusDesigns
₹23,500 INR in 7 days
3.2
3.2

Hello, I understand you need hundreds of electricity bills downloaded as PDFs from provider websites, organized chronologically, and analyzed month-by-month in a clean spreadsheet. The goal is to deliver accurate, structured bill records with penalties and significant amount changes clearly highlighted. Here’s what I can provide: • Automate bill retrieval and PDF downloads using Python/Selenium with organized state/customer/month folders • Extract due amounts, previous dues, differences and penalties into Excel/Google Sheets • Validate extracted data and highlight penalty months or unusual amount increases for easy review I bring over 4+ years of experience in Python, automation, web scraping, Excel and data processing, with a strong focus on accuracy, reliability and structured workflows. Just to clarify a few things: Which electricity providers/states and approximate number of customer accounts are involved? Do the provider portals require CAPTCHA, OTP or other manual verification during login? Please come to the chat box to discuss more about your project. Best regards Indresh Kushwaha
₹25,000 INR in 7 days
1.6
1.6

India
Member since Apr 20, 2017
₹600-1500 INR
₹1500-12500 INR
$250-750 USD
$30-250 USD
$250-750 USD
₹12500-37500 INR
₹750-1250 INR / hour
$250-750 USD
$137.5-275 USD
$30-250 USD
$1000-1500 AUD
₹1500-12500 INR
$30-250 USD
$8-15 USD / hour
$30-250 USD
$250-750 USD
$250-750 USD
$250-750 USD
$30-250 USD
₹37500-75000 INR
$250-750 USD
$30-250 USD