Skip to main content
Client ProjectCustom Software DevelopmentMedia Distribution

Meera News Agency — Newspaper Distribution, Returns & Billing System

Daily newspaper distribution, returns and monthly billing for a Bengaluru agency: a web dashboard plus a vendor app with UPI payments, in daily use since 2022.

Designed and developed by Canny Technologies AI Labs for our client.

Client and industry

Project type
Client Project
Service
Custom Software Development
Industry
Media Distribution
Client
Meera News Agency (newspaper distributor, Bengaluru)
Region
Bengaluru, Karnataka, India
Developer
Canny Technologies AI Labs

The problem

A newspaper agency lives on thin margins and very high volume: every morning it receives bundles of several publications, splits them across distribution centres and vendors, and every evening takes back the unsold copies. Meera News Agency was tracking daily supply and returns per centre in books and spreadsheets, so the next day's order to the publishers was estimated rather than calculated, month-end bills for each vendor took days to prepare, and outstanding balances were hard to reconcile. Vendors had no way to see their own account and paid in cash, which meant more collection rounds and more disputes over what was supplied and what was returned.

What the client needed

  • Record daily supply and returns for every distribution centre
  • Calculate the next day's publisher order from real data
  • Month-end vendor bills without days of spreadsheet work
  • Vendors able to see their own accounts and pay digitally

What we built

We built a web dashboard for the agency and a mobile app for its vendors on one shared database. The agency sets up its distribution centres, vendors, publications, prices and packages once. Each day staff record the copies supplied to and returned by every centre in a centre book, and the system produces the indent report — the next day's order to the publishers — from that data. At month end the billing module turns supply minus returns into a bill per vendor with running balances, receipts and sales invoices, applies each subscriber's margin, and prints or exports everything to Excel. Vendors use the Android app to check their own supply and returns, view their bills, see their payment history and pay by UPI.

Features

  • Centre book of copies supplied and returned per publication
  • Indent report for the next day's publisher order
  • Monthly billing with running balances, receipts, invoices and vendor margins
  • Sales, centre and indent reports with print and Excel export
  • Android vendor app: supply book, bills and payment history
  • UPI payments from the vendor app

Architecture

  1. 1React web dashboard with data tables, charts, printable invoices and Excel export
  2. 2React Native Android app for vendors: supply book, bills, payment history and UPI payments
  3. 3Node.js + Express REST API shared by the dashboard and the vendor app
  4. 4MySQL database with tables for firms, centres, vendors, items, prices, packages, centre supply, returns, billing and users
  5. 5Day-by-day centre book of copies supplied and returned per publication
  6. 6Indent report calculated from actual supply and return history
  7. 7Monthly billing engine with running balances, receipts, sales invoices and vendor margins
  8. 8Sales, centre and indent reports with print and Excel export

Integrations

  • UPI payments
  • Excel export
  • Chart.js dashboards

Screenshots

meeranewspaper.cannytechnology.com
Meera News Agency — Newspaper Distribution, Returns & Billing System: Dashboard — today's sales, supply and unsold copies, per-centre totals and the monthly sales overview
Dashboard — today's sales, supply and unsold copies, per-centre totals and the monthly sales overview
meeranewspaper.cannytechnology.com
Meera News Agency — Newspaper Distribution, Returns & Billing System: New Billing — per-vendor supply, return and subscription copies by publication, with amounts and approval status
New Billing — per-vendor supply, return and subscription copies by publication, with amounts and approval status
meeranewspaper.cannytechnology.com
Meera News Agency — Newspaper Distribution, Returns & Billing System: Sales (Centre) — day-by-day sales and return detail for each publication, by centre and vendor
Sales (Centre) — day-by-day sales and return detail for each publication, by centre and vendor

Tech stack

  • React
  • React Bootstrap
  • Chart.js
  • React Native
  • Node.js
  • Express
  • MySQL
  • UPI Payments
  • Excel Export

Timeline

Duration / status: In daily use since 2022

  1. Phase 1

    Masters and centre book

    • Firms, distribution centres, vendors, publications, prices and packages
    • Daily centre book of copies supplied and returned
    • Node.js + Express API on MySQL
  2. Phase 2

    Billing and reports

    • Monthly vendor billing with balances, receipts and sales invoices
    • Indent, sales and centre reports with print and Excel export
    • Subscriber margins and dashboard charts
  3. Phase 3

    Vendor mobile app

    • Android app for vendors to view supply, returns and bills
    • Payment history and UPI payments from the app
    • Rolled out to a second news agency

Results

2022

In daily use since

2

Apps — agency dashboard and vendor app

11,900+

Copies sold in a single day across centres

Daily

Supply and returns tracked per centre

UPI

Vendor payments via UPI in the app

11

Relational tables on one schema

Meera News Agency has run its daily distribution and monthly billing on the system since 2022. The next day's publisher order is worked out from real supply and return figures instead of guesswork, vendor bills come straight from the centre book instead of a month-end spreadsheet exercise, and vendors can see their own account and pay by UPI from their phone. The same platform has since been set up for a second news agency, showing it fits how newspaper distributors work rather than one agency's habits.

“Before Canny, our centre books, returns and month-end bills were all done by hand, and closing the month took days. Now every centre's supply and returns go in once a day, and the bills and outstanding report are ready whenever we need them. Our vendors check their own accounts and pay by UPI from their phones. The system has run our distribution every single day since 2022 without trouble, and whenever we need a change the Canny team turns it around quickly. I would recommend them to any newspaper agency.”
— Chandranna Narayanappa, Meera News Agency

Live link

Related Services

Discuss a Similar Project

Planning something like this? Talk to the team that built it about scope, timeline and a fixed-price estimate.

All case studies