training

Cursor Implementation Summary – Station Expense Ledger Report
Objective

Implement a Station Expense Ledger Report where Station is the primary reporting entity. The report should provide a complete financial view of all expenses incurred for a station across Operations, Site Development, and Maintenance, with a ledger-wise breakdown. The design follows common accounting practices where expenses are posted to ledger accounts and analyzed by cost center/project.

Business Requirement

Provide a report that answers the following questions:

How much expense was incurred for a station?
Which Classification generated the expense?
Which Ledger (Expense Head) was used?
Which employee incurred the expense?
How much advance was received?
How much expense was claimed?
How much expense was approved?
What amount is still pending?
What is the total expense for the station?

Important

Expense Approval applies only to expense claims.
Cash Advance approval is NOT part of this report.
Advance Received is shown only as a reference amount.
Report Hierarchy
Station
├── Classification
│ ├── Ledger
│ │ ├── Employee
│ │ │ ├── Expense Entries

Example:

Station Jaipur DC-01

Operations
Electricity
Rahul
₹5,200

Amit
        ₹3,500

Travel
        Rahul
        ₹1,800

Maintenance
Machine Repair
Mohit
₹15,000

Site Development
Civil Work
Kunal
₹85,000
Filters
Station
Station
Station Code
Classification
Operations
Site Development
Maintenance
Ledger

(All Expense Heads)

Employee
Employee
Employee ID
Status
Draft
Submitted
Approved
Rejected
Hold
Paid
Date
Expense Date
Claim Date
Date Range
Amount Range
Report Columns
Station Information
Station Name
Station Code
Classification
Ledger
Ledger Name
Ledger Code
Employee
Employee Name
Expense Details
Expense Date
Voucher Number
Expense Description
Financial Details
Advance Received
Claimed Amount
Approved Expense Amount
Paid Amount
Pending Amount
Balance
Summary Cards

Display:

Total Station Expense
Total Claimed
Total Approved
Total Paid
Total Pending
Total Advance Received
Grouping

Support grouping by:

Station
Classification
Ledger
Employee
Month
Drill Down
Station

→ Classification

→ Ledger

→ Employee

→ Individual Expense
Export
Excel
CSV
PDF
Backend Requirements
Create a new reporting API with server-side filtering and pagination.
Support aggregation by Station → Classification → Ledger → Employee.
Calculate summary totals dynamically based on filters.
Optimize queries for large datasets using indexed fields (Station, Classification, Ledger, Employee, Expense Date, Status).
Ensure ledger names are sourced from the master ledger configuration for consistency and auditability. Expense reporting should retain clear links between expense lines, users, and ledger postings.
Acceptance Criteria
Station is the primary reporting entity.
Expenses are grouped by Classification → Ledger → Employee.
Ledger-wise totals are displayed for every station.
Advance Received is displayed separately and is not treated as an approved expense.
Approved Amount includes only approved expense claims.
Users can filter by Station, Classification, Ledger, Employee, Status, Date Range, and Amount.
Users can drill down from Station → Classification → Ledger → Employee → Individual Expense.
Summary totals update dynamically based on filters.
Reports support export to Excel, CSV, and PDF.
The report performs efficiently for large datasets using server-side filtering and pagination.