Start a project
ServicesWorkProcessAboutInsightsContactStart a project
Work/Lottery Ledger System
Web AppWeb · Fintech

Lottery Ledger System

A server-rendered ledger and reconciliation system for lottery operations — track daily sales and payments, import/export Excel, and generate settlement reports across agents.

Build something like this
ledger.duttatech.com
Lottery Ledger
Daily LedgerAgentsReconcileReports
operator@lottery
Daily Ledger
06 Jan 2025 ▾
↑ Import Excel
↓ Export Excel
Total Sales
₹2,84,500
Total Payout
₹1,92,300
Net Balance
₹92,200
AgentSalesPaidDueStatus
Agent A · Sector 17₹48,200₹40,000₹8,200Pending
Agent B · Civil Lines₹36,500₹36,500₹0Settled
Agent C · Model Town₹52,800₹45,000₹7,800Pending
Agent D · Karol Bagh₹29,000₹20,000₹9,000Pending
Agent E · Rohini₹41,300₹41,300₹0Settled
Excel
Import/Export
Auto
Reconcile
SSR
Fast views
2023
Shipped
Overview

The challenge & the build

A robust Express + Handlebars web application that manages the financial ledger of a lottery business. It records daily sales and payouts, reconciles agent accounts, and handles bulk data through Excel import and export. Built with server-side rendering, session-based auth and a MySQL data layer via Sequelize for reliable, auditable records.

Screens

A look inside

Real screens from Lottery Ledger System — recreated in the product's own interface and palette.

ledger.duttatech.com
Lottery Ledger
Daily LedgerAgentsReconcileReports
operator@lottery
Daily Ledger
06 Jan 2025 ▾
↑ Import Excel
↓ Export Excel
Total Sales
₹2,84,500
Total Payout
₹1,92,300
Net Balance
₹92,200
AgentSalesPaidDueStatus
Agent A · Sector 17₹48,200₹40,000₹8,200Pending
Agent B · Civil Lines₹36,500₹36,500₹0Settled
Agent C · Model Town₹52,800₹45,000₹7,800Pending
Agent D · Karol Bagh₹29,000₹20,000₹9,000Pending
Agent E · Rohini₹41,300₹41,300₹0Settled
Daily ledger + Excel I/O
ledger.duttatech.com
Lottery Ledger
Daily LedgerAgentsReconcileReports
operator@lottery
Reconciliation
Week of 30 Dec – 05 Jan · 5 agents
Closing balance to settle
₹92,200
Reconciled
3 / 5
Agent A₹8,200Pending
Agent B₹0Reconciled
Agent C₹7,800Pending
Agent E₹0Reconciled
Agent reconciliation
ledger.duttatech.com
L
Operator Login
Lottery Ledger · session secured
Username
operator@lottery
Password
••••••••••
Sign in
Session-secured login
Key features

What's inside

01

Daily ledger

Record sales, payments and balances per agent and per draw.

02

Excel import/export

Bulk-load and export data with ExcelJS and SheetJS.

03

Reconciliation

Settlement reports that reconcile agent accounts automatically.

04

Session auth

Secure session-based login for operators.

05

Server-rendered

Fast, SEO-friendly Handlebars views with compression.

06

MySQL data layer

Sequelize ORM for reliable, structured records.

Tech stack

Built with

Node.jsExpressHandlebarsMySQLSequelizeExcelJSMulter
Next project

AI Resume Builder

AI Resume Builder
Let's build

Have a project in mind?
Let's ship it together.

Web, mobile, backend or a full platform — tell us what you're building and we'll map the path to launch.

Start a project See our work