Society-App

Domains

Automation
Backend
Data
PersonalMay 1, 2020 - May 1, 2020
Society-App

Tech Stack

Python
Git

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.

/projects/society-app/pdf-extraction.svg

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.

/projects/society-app/cli-workflow.svg

Formatted Excel Summary Output

Generates a BILL.xlsx spreadsheet through XlsxWriter so housing society managers get structured monthly summaries without manual copy-paste work.

/projects/society-app/excel-output.svg

    Society-App | Vimal Rajesh | Applied AI and Platform Engineer