RK Group

Sales Filters

Choose single period or comparison mode, then filter by train, manager, and yard

Dashboard Mode

Single Period Selection

From Date

To Date (Optional)

Period 1

Start Date

End Date

Train

Manager

Yard

Period 2 (Comparison)

Start Date

End Date

Sales Target (P1)

₹0

0 records

Sales Achievement (P1)

₹0

0% achieved

GP Target (P1)

₹0

Gross Profit Target

GP Achievement (P1)

₹0

0% achieved

Sales Achievement (P2)

₹0

Variance: ₹0

GP Achievement (P2)

₹0

Variance: ₹0

Open Complaints

0

0 closed | 0 total

Bank Deposit

₹0

Counter: ₹0

Sales Achievement Buckets (Click to Filter)

Click any bucket to filter trains by achievement percentage

GP Achievement Buckets (Click to Filter)

Click any bucket to filter trains by GP achievement percentage

Sales Trend (Daily) - Click bar to filter

GP Trend (Daily) - Click bar to filter

Yard-wise Sales - Click bar to filter

Top 10 Trains - Click bar to filter

Bottom 10 Trains - Click bar to filter

Manager Contribution (GP) - Click to filter

Train Type Contribution - Click to filter

Top 10 Train Performance

Train	Sales %	GP %	Sales Amt	GP Amt

Bottom 10 Train Performance

Train	Sales %	GP %	Sales Amt	GP Amt

Period Comparison (P1 vs P2)

Comparing selected date ranges

Train Name	P1 Sales	P2 Sales	Sales Var	P1 GP	P2 GP	GP Var

Top 10 Train Managers

Ranked by Sales %, GP %, and minimum complaints

Rank	Train Manager	Sales %	GP %	Complaints	Score

Top 10 Rake Managers

Ranked by Sales %, GP %, and minimum complaints

Rank	Rake Manager	Sales %	GP %	Complaints	Score

Rake Manager Sales, GP and Salary Summary

Accumulated by Rake Manager for selected dashboard period

Rake Manager	Mobile Number	ADHAR Number	Account Number	IFSC Code	Bank Name	Trains	Entries	Total Sale	Total GP	Total Rake Manager Salary

Train Rank Table

Weighted rank using achievement, deposit discipline, and complaint control

Rank	Train	Sales %	GP %	Cash/GP %	Complaints	Sales Score (40)	GP Score (35)	Cash Score (15)	Complaint Score (10)	Total Score

Complaint Filters

Choose single period or comparison mode, then filter by train, status, and yard

Dashboard Mode

Single Period Selection

From Date

To Date (Optional)

Period 1

Start Date

End Date

Train

All Trains

Status

Yard

Period 2 (Comparison)

Start Date

End Date

Period 1

0

-

Period 2

0

-

Variance (P2 - P1)

0

Positive value indicates increase in complaints

Daily Complaint Trend (P1 vs P2) - 2 line comparison

Train-wise Comparison - Click to filter

Nature-wise Complaint Analysis - P1 vs P2

Rake Manager-wise Complaint Contribution - Top 10 red marked

Yard-wise Complaint Contribution

Complaint Source Mix - Legend shown at right side

Rake Manager-wise Complaint Ranking

Highest to lowest complaint count in Period 1. Top 10 are red marked.

Rank	Train Name	Manager	Total Complaints	Open	Closed

Repeat Complaint Mobile Numbers

Click a mobile number row to filter the dashboard to that customer.

Mobile	Total	Open/In Progress	Latest Date	Latest Train	Latest Nature

Complaint Feedback Calling List

Rake manager and customer contact list for central feedback calls.

Date	Status	Rake Manager	Rake Manager Phone	Customer Phone	Train Detail	Nature	Reference No

Train-wise Complaint Count

Only positive variance values are highlighted in red

Train Name	Period 1	Period 2	Variance (P2-P1)

Nature-wise Comparison

By actual complaint nature

Complaint Nature	Period 1	Period 2	Difference

Sales Data Entry

Enter daily sales and GP achievement data

Train Name *

Train Number

Yard

Departure Date *

Arrival Date *

Cluster Manager

Train Manager

Rake Manager

Train Type

Sales Target

Total Sale *

Achievement %

Store Bill

Base Expenses

Credit Expenses

Cash Expenses

MISC Expenses

Commission (10% Of Sales)

Staff Salary

Rake Manager Salary

E-Catering

GP Target

GP Achievement (Auto)

GP Achievement %

Remarks

PDF of Hisabexcel

No Hisabexcel PDF attached. Max 6 MB for cloud sync.

Arrival Date	Departure Date	Train	Yard	Sales	Total Sale	Supporting	Remarks	Actions

Complaint Management

Track and manage customer complaints

Train Name *

Train Number

Complaint Date *

Status

Complaint ID

Source

Train Type

Yard

Rake Manager *

Rake Number

Rake Manager Phone

Train Manager

Train Manager Phone

Business Head

VP

Complainant Details

Email

Mobile Number *

Reference No *

PNR / UTS Number *

Coach No. *

Physical Coach No.

Berth No.

Train Commencement Date & Time

Complaint Nature *

Complaint Type

Complaint Description *

Action Taken 1

Action Taken 2

Action Taken 3

Action Taken 4

Action Taken 5

Remarks / Resolution Notes

Open Complaints Queue

Every new complaint starts in Open status. Edit to close/update.

Date	ID	Train	Mobile	Reference No	Nature	Status	Action

Date	ID	Train	Mobile	Reference No	Nature	Status	Actions

Cash Deposit Dashboard

Overview of cash collection and deposits

Total Sale To Collect

₹0

From selected cash entries

Total Deposit

₹0

Cash + Online

Cash Counter

₹0

Physical deposits

Online Deposit

₹0

Digital transfers

Records Count

0

Cash entries

Pending Shortage

0

Short deposits

Date-wise Cash Collection Summary

Cash deposits, online deposits, and pending amount where sales entry exists.

Date	Sales Entries	Cash Entries	Amount To Collect	Cash Deposited	Online Deposited	Total Deposited	Pending No Deposit	Pending Short	Total Pending

Manager-wise Cash Deposit Summary

Total sale vs cash and online deposit comparison

Manager	Amount To Collect	Cash	Online	Total	Diff	Status

Rake Manager-wise Pending Deposit

Same-day sales not fully collected in cash or online

Rake Manager	Train Manager	Train	Train Number	Rake Number	Date	Amount To Collect	Total Deposited	Amount Pending	Action

Cash & Bank Deposit Entry

Record cash collections and bank deposits

Entry Date *

Arrival Date

Yard *

Train Name

Train Number

Train Manager

Rake Manager

Amount To Be Collected

Cash Deposit (Counter) *

Online Deposit *

Total Deposit

Balance Due

Remarks

Date	Yard	Train	GP	Cash	Online	Total	Reason	Actions

Bank Deposit Date *

Cash Collection Date

Bank Deposit Amount *

Bank Receipt Photo

Remarks

Deposit Date	Collection Date	Amount	Receipt	Remarks	Action

Current Month Targets ()

₹0

Total Sales Target

₹0

Total GP Target

0

Total Trains

0

Yards

Train Master

Manage train details, targets and manager information

Train Name *

Train Number *

Rake Number *

Yard *

Train Type

Cluster Manager

Train Manager

Train Manager Number

Rake Manager

Rake Manager Number

Rake Manager ADHAR Number

Account Number

IFSC Code

Bank Name

Business Head

VP

Sales Target (Period)

GP Target (Period)

Validity Start Date *

Validity End Date

Valid For Days (optional)

Master Values Management

Optional quick-add for suggestion lists. Train/rake mapping is controlled by the Train Master row above.

Add New Yard

Add Cluster Manager

Add Train Manager

Add Rake Manager

Item Rate Master

Upload or maintain item rates used to build Total Sale from item quantity.

Train Manager Master List

Train	Number	Rake No	Yard	Type	Cluster	Manager	Manager No	Rake Manager	Rake Manager No	ADHAR No	Account No	IFSC	Bank	Business Head	VP	Valid From	Valid To	Sales Target	GP Target	Action

Master Entry / Edit Log

Visible only to Super Admin users

Date & Time	User	Action	Train	Train Number	Rake	Rake Manager	Detail

Sales and GP Target Master

Train	Number	Valid From	Valid To	Valid Days	Sales Target	GP Target

User Management

Create and manage system users

Full Name *

Email / User ID *

Password *

Confirm Password *

Role *

Yard Access

Pages User Can Open / View

Pages User Can Edit

Existing Users

Name	Email/User ID	Role	Yard	View Pages	Edit Pages	Status	Actions

Data Backup & Restore

Click to restore from backup JSON

Cloud Sync

Sync data with Firebase cloud storage

Danger Zone

These actions cannot be undone. Use with caution!

Delete From Date

Delete To Date

If date range is blank, Delete All will remove all records for that section.

Reset Sales Data

Delete all sales entries

Reset Complaints

Delete all complaint records

Reset Cash Data

Delete all cash deposit records

Reset Everything (Master Key)

Reset to default data

System Summary

Total Users

0

Train Masters

0

Sales Records

0

Complaints

0

Cash Records

0

Yards

0

Sales Dashboard

Sales Filters

Sales Achievement Buckets (Click to Filter)

GP Achievement Buckets (Click to Filter)

Sales Trend (Daily) - Click bar to filter

GP Trend (Daily) - Click bar to filter

Yard-wise Sales - Click bar to filter

Top 10 Trains - Click bar to filter

Bottom 10 Trains - Click bar to filter

Manager Contribution (GP) - Click to filter

Train Type Contribution - Click to filter

Top 10 Train Performance

Bottom 10 Train Performance

Period Comparison (P1 vs P2)

Top 10 Train Managers

Top 10 Rake Managers

Rake Manager Sales, GP and Salary Summary

Train Rank Table

Complaint Filters

Daily Complaint Trend (P1 vs P2) - 2 line comparison

Train-wise Comparison - Click to filter

Nature-wise Complaint Analysis - P1 vs P2

Rake Manager-wise Complaint Contribution - Top 10 red marked

Yard-wise Complaint Contribution

Complaint Source Mix - Legend shown at right side

Rake Manager-wise Complaint Ranking

Repeat Complaint Mobile Numbers

Complaint Feedback Calling List

Train-wise Complaint Count

Nature-wise Comparison

Sales Data Entry

Complaint Management

Open Complaints Queue

Cash Deposit Dashboard

Date-wise Cash Collection Summary

Manager-wise Cash Deposit Summary

Rake Manager-wise Pending Deposit

Cash & Bank Deposit Entry

Shortage Detected

Current Month Targets ()

Train Master

Master Values Management

Item Rate Master

Train Manager Master List

Master Entry / Edit Log

Sales and GP Target Master

User Management

Existing Users

Data Backup & Restore

Cloud Sync

Danger Zone

Reset Sales Data

Reset Complaints

Reset Cash Data

Reset Everything (Master Key)

Download All Code

Download All Data

System Summary

Previous Complaints

Amount Detail

Supporting Images

Rake Manager Salary Detail

Salary Shortage

Edit Entry