Automated Challan Management System Development

via Freelancer ·

Budget / Salary₹12,500–37,500
TypeFreelance project
LocationRemote
Posted1 hour ago
Hello,
I need a complete automated challan management system for my legal/business work.
My requirements:
Extract challan details automatically from uploaded PDF files using OCR/AI.
Store extracted data in Google Sheets.
Compare Bill and Urgent sheets using Challan Number.
Urgent sheet: Column C = Challan Number, Column G = Status.
Bill sheet: Column G = Challan Number, Column K = Settlement Amount.
Identify matching challans where Urgent status is "clear" and Bill settlement amount is ₹0.
Automatically highlight only the relevant Challan Number cells in Bill Column G.
Detect duplicate challans, missing records and OCR errors.
Process new PDFs daily with minimum manual work.
Provide a simple dashboard and error report.
I do not want to manually operate complicated formulas or scripts.
Please first review a sample of my actual files and demonstrate a working prototype with 50–100 records.
I will pay for a complete, reliable solution after testing.
Please quote:
Development cost
Monthly running cost, if any
Delivery timeline
Maintenance/support charges
Data security arrangements
Regards vikas sharma
php visual basic excel software architecture ocr data extraction google sheets automation
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.