PRC Mumbai — Weekly Billing Dashboard

Upload Weekly Reports

📊

Bill Generation

Weekly_Bill_Generation_Summary.xls

📋

Bill Submission

Weekly_Bill_Submission_Register.csv

📂

Unbilled Backlog

Weekly_Unbilled_Booking_Register.csv

Gen & Sub Date Range Date range

Full file

📋 Required columns in each file — click to view

📊 Bill Generation Summary

Bill No
Bill Date
Client Name
Created By
Count LR
Total Amount
Created On
Order No (optional)
Billing Branch (optional)

Format: .xls / .xlsx / .csv
Header row can be anywhere in first 20 rows

📋 Bill Submission Register

Created By
Bill No
Bill Date
Client Name
Total LRs
Total Bill Amount
Submission No
Submission Date
Submitted To (optional)

Format: .csv / .xlsx / .xls
Column order does not matter

📂 Unbilled Booking Register

Billing In Charge
Billing Branch
Billing Client
LR No
LR Date
Trip Amount
Contract Type
Key Accounts Exec
POD Available
Monthly Billing (optional)
Reason (optional)

Format: .csv / .xlsx / .xls
Filter to Mumbai branch applied automatically

Column names must match exactly (case-insensitive). Column order and file name do not matter.

View

Weekly Totals

Sort by Click ＋ to expand clients · Click numbers for detail

SLA Breach Summary — Executive-wise

Executive

SLA Status

Contract Type

Executive POD Filter KAM name

By Key Accounts Manager Click ＋ to expand clients

By Billing Executive

KAM Detail

Search KAM Age

Executive Search

Executive Status Sort by Search