Back to Home

DoodHisaab Case Study — Offline Dairy Ledger App

DoodHisaab is a custom Flutter mobile application built for rural dairy businesses and milk collection centers in Punjab (Bathinda and Muktsar). It functions as a complete milk ledger, featuring an offline-first SQLite database that allows milkmen to track daily collections, manage customer accounts, and calculate monthly profit margins instantly without requiring an internet connection.

Project Core Metrics

  • Tech Stack: Flutter, Dart, SQLite, Local State Management (Provider).
  • Target Area: Muktsar, Bathinda, and Faridkot districts, Punjab, India.
  • Operational Benefit: 100% manual calculation error reduction, zero monthly cloud server hosting fees.

Problem Statement & Context

Dairy farming and milk collection form the economic core of rural Punjab. However, local milk collection operators and milkmen traditionally record twice-daily collections in physical paper notebooks. This manual ledger method is highly prone to mathematical errors, payment disputes, and lost data due to damaged notebooks. Because cellular connectivity is highly unstable in the outer fields of Muktsar Sahib and Bathinda, any standard cloud-hosted SaaS tool is completely unusable during active collection hours.

These connectivity constraints mean that milk collection centers need a solution that runs locally on simple mobile hardware while matching the operational realities of local cooperatives.

The Engineering Solution

To resolve this connectivity gap, I architected DoodHisaab as an offline-first mobile database application. Built with Flutter, the app utilizes a local relational SQLite database embedded directly inside the device sandbox. This guarantees that data is written immediately, even without internet access.

  • Fat/SNF Math: App applies base pricing slabs to compute milk value dynamically, depending on FAT and SNF parameters.
  • Multi-Client Profiles: Supports profiles for hundreds of farmers, storing chronological transaction histories locally.
  • PDF Receipts: Generates neat summary statements locally, which operators share over WhatsApp when network resumes.

SQLite Database Schema and Data Integrity

The underlying database is built using a normalized schema that links clients (farmers) to daily collections. The main collections table tracks volume, milk FAT percentage, SNF (Solids-Not-Fat) parameters, rate-per-liter, and the calculated total cost. To prevent concurrency conflicts when writing morning and evening records, the database triggers use automated transaction blocks.

Operational Outcomes & Direct Impact

Since deployment at select collection centers in Muktsar, DoodHisaab has delivered measurable efficiency improvements:

  • Saved 1.5 hours daily: Collection operators no longer spend hours at night recalculating entries in physical books.
  • Zero payment disputes: Automatic calculations based on transparent fat pricing slabs eliminated customer complaints.
  • 100% Data Preservation: Even when phones are dropped or changed, localized SQLite exports ensure database state remains safe.

UI/UX Design Tailored for Rural Mobile Operators

Software interfaces designed for urban office users fail immediately when deployed in hot, dusty rural milk collection centers. To make DoodHisaab usable under field conditions, I designed the user interface around high-contrast themes and simplified input mechanisms.

Instead of typing parameters on standard, small alphanumeric mobile keyboards, operators use customized, large numeric pads with single-tap selections. Every input (like entering fat content or quantity) triggers localized audio signals in Punjabi, confirming success and preventing keystroke errors. Visual graphs show monthly milk collections and payments per farmer, helping dairy owners communicate billing parameters clearly.