Bug #2372
Implement Account Category and Account Ledger Management in EVCMS
Description
Description:
To improve financial tracking and reporting in the EV CMS (EVCMS), we need to introduce a structured Account Category and Account Ledger management module. This will help organize financial transactions such as electricity expenses, maintenance costs, revenue adjustments, partner payouts, and other operational entries.
The module will allow administrators to create and manage account categories and maintain ledger entries mapped to stations or company-level accounts.
Scope of Work
Account Category Management
Create a master module to manage account categories.
Fields:
category_id
category_name
description
is_active
created_at
updated_at
Account Ledger Management
Maintain ledger entries mapped to categories.
Each ledger entry will track financial transactions related to stations or company accounts.
Fields:
ledger_id
station_id (nullable for company-level entries)
category_id
transaction_type (Credit / Debit)
amount
transaction_date
reference_type (Session, Expense, Adjustment, etc.)
reference_id
remarks
created_by
created_at
Functional Requirements
Admin can create, edit, and deactivate account categories.
Admin can add ledger entries mapped to categories.
Ledger entries should support credit and debit transactions.
Ledger entries should optionally link to stations or sessions.
Ledger records should be available for financial reporting and revenue calculation.
Acceptance Criteria
Admin can create and manage account categories.
Admin can create ledger entries mapped to categories.
Ledger entries support credit/debit classification.
Ledger entries can be filtered by station, category, and date range.
Data is stored with proper audit fields (created_at, created_by).
APIs and UI should support listing and filtering ledger entries.
Updated by Shreya Agarwal about 2 months ago
I worked on DTO Layer for the Account Ledger Module in the EVCSMS Master Data Services . I Created some required DTO classes including , CreateAccountLedgerDto , UpdatedAccountLedgerDto, AccountLedgerResponseDto , AccountLedgerListResponseDto by following the existing project structure . These DTOs were structured to support different APIs operation like creating , updating , retrieving account ledger records.
Updated by Shreya Agarwal about 1 month ago
worked on DTO structure and started implementing on repository layer for the Account Ledger Module in the EVCSMS Master Data Services .
Updated by Shreya Agarwal about 1 month ago
worked on DTO structure , repository and service layer and SQL for the Account Ledger Module in the EVCSMS Master Data Services .
Updated by Shreya Agarwal about 1 month ago
In Account Ledger Controller implemented GET API for the Account Ledger and also worked on Ledger Categories Module in the EVCSMS Master Data Services .
Updated by Shreya Agarwal about 1 month ago
GET API complete in Ledger Categories in the EVCSMS Master Data Services and remaining API in progress
Updated by Shreya Agarwal about 1 month ago
All APIs complete in Ledger Categories and now working on ledgers in the EVCSMS Master Data Services.
Updated by Shreya Agarwal about 1 month ago
All APIs complete in Ledgers and further have the testing of APIs in the EVCSMS Master Data Services
Updated by Shreya Agarwal about 1 month ago
Performed code Pattern analysis in the Audit Rule functionality in Reporting Service where I reviewed the code structure and also made some necessary changes in APIs which I created in Master data service in EVCSMS.
Updated by Shreya Agarwal about 1 month ago
worked on code pattern analysis in the EVCSMS .studied project structure and try to understanding of Authentication , authorization and also dependency injection concept .
Studied how user identity is verified (authentication) and how role based access and permissions are managed(authorization) .
Updated by Shreya Agarwal about 1 month ago
I explored Authentication and Authorization mechanism and Dependency Injection and the role of Program.cs where I analyzed configurations such as CORS , Authentication , Authorization and usage of middleware including session validation and activity logging and also explored Service Extensions.
Updated by Shreya Agarwal about 1 month ago
worked on merging master account changes into the new branch 2372-Implement-Account-Category-and-Account-Ledger. I switched to the working branch, integrated the required code changes, and ensured proper setup by building and running the application successfully.
Along with this, I continued Code Pattern Analysis, where I further explored project structure, API flow, and key concepts