Project

General

Profile

Bug #2814

User Ledger Report with Debit, Credit & Running Balance

Added by Prashant Jain 1 day ago. Updated about 14 hours ago.

Status:
New
Priority:
Normal
Start date:
07/08/2026
Due date:
% Done:

0%

Estimated time:
8.00 h
Spent time:

Description

Description:

Develop a User Ledger Report to provide a complete transaction history for each user, including all debit and credit entries with a running balance.

Requirements
Filters
Date Range (From Date – To Date)
User (Optional)
If no user_id is selected, display ledger data for all users.
If user_id is provided, display the ledger only for the selected user.
Station (Optional)
Transaction Type (Debit/Credit/All)
Voucher Number (Optional)
Status (Optional)
Report Columns
Transaction Date
Voucher No.
User ID
User Name
Station Name
Transaction Type (Debit/Credit)
Debit Amount
Credit Amount
Opening Balance
Running Balance
Closing Balance
Reference No.
Description/Remarks
Created By
Report Logic
Calculate Opening Balance based on the balance before the selected date range.
Display all debit and credit transactions in chronological order.
Maintain a Running Balance for each transaction.
Calculate Closing Balance at the end of the selected period.
Support consolidated reports for all users as well as individual user ledger reports.
API Requirements
Support filtering by:
from_date
to_date
user_id
station_id
transaction_type
voucher_no
status
Pagination support.
Sorting by transaction date.
Export to Excel and CSV.
Expected Outcome

Users should be able to view a complete ledger containing all debit and credit transactions, voucher details, opening balance, running balance, and closing balance. The report should support both consolidated and user-specific views and be suitable for finance, audit, and reconciliation purposes.

Also available in: Atom PDF