Society-App
Domains
Tech Stack
Project Summary
Abstract
Society-App is a practical automation script built to remove one of the most repetitive admin chores in local housing society management: copying billing data out of PDF documents into spreadsheets by hand. Instead of treating the monthly bill as a static file, the script converts it into a structured dataset that can be reviewed and shared more easily.
The project is fully Python-based and keeps the workflow intentionally simple. PyPDF2 is used to read and parse bill text from a standard PDF file, while XlsxWriter creates the final Excel workbook. The result is a lightweight command-line utility that fits well into a small-office or personal-computing setup without requiring a larger application stack.
What makes the project worth highlighting is its real-world practicality. It shows how a focused script can save time, reduce transcription errors, and turn a boring administrative routine into a repeatable one-command workflow for monthly billing operations.
What I Built
- A focused PDF-to-Excel pipeline was enough to automate a repetitive housing-society billing workflow.
- Keeping the tool CLI-first and dependency-light made it practical for recurring monthly administration.
Impact
- Saved manual data-entry time and reduced transcription risk in a real local workflow.
- Shows pragmatic automation instincts and the ability to deliver value without overbuilding.
Page Info
PDF Bill Extraction Workflow
Reads a standard BILL.pdf input, parses billing text with PyPDF2, and transforms raw document content into machine-friendly records.
Monthly CLI Utility
Runs from the command line with month-specific input such as python bill.py MAY-2020, making recurring billing conversion fast and repeatable.
Formatted Excel Summary Output
Generates a BILL.xlsx spreadsheet through XlsxWriter so housing society managers get structured monthly summaries without manual copy-paste work.