training

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.