Expense Type (Fuel / Service / Repair / Insurance/PUC/Fitness)
DD/EMD/FD/BG/EGRASS Chhlan Entry
In Fever of :
DD/EMD/FD/BG/EGRASS No. :
Paid Amount :
Issue Date
Recived Date
Work Name :
Qualified : yes/no
Remark :
1. Client Master
Store client details (one-time entry)
Fields:
Client ID
Client Name
Work Order No
Work Order Date
Work Start Date 
Work End Date
Mobile Number
Address
GST (optional)
🔹 2. Invoice Entry
Create bills for clients
Fields:
Invoice No
Date
Client Name
Billing Month
Amount
GST
Total Amount
🔹 4. Outstanding Dues (Auto Calculation)
Logic:

Outstanding = Total Invoice – Total Payment
🔹 3. Payment Entry
Record payments received
Fields:
Payment Date
Client Name
Invoice No (optional)
Paid Amount
TDS  (optional)
UTR No
Bank Name
Payment Mode (Cash/Bank/UPI)
🚗 5. Vehicle Expense Management Module
Track vehicle-related expenses (very useful for security agency)
Fields:
Date
Vehicle Number
Expense Type (Fuel / Service / Repair / Insurance/Fitness/Other)
Amount
Notes
Example:
Date
Vehicle
Type
Amount
01-Apr
RJ19 AB 1234
Fuel
₹2000
Fuel Leter
KM
05-Apr
RJ19 AB 1234
Service
₹3500
📊 6. Reports Section (Important)
📌 A. Client Outstanding Report
Client-wise total invoice
Total payment
Pending amount
📌 B. Invoice Report
Monthly / date-wise invoices
Total billing summary
📌 C. Payment Report
Date-wise payments
Client-wise payment history
📌 D. Expense Report
1)All expenses summary
2)Filter by type (Fuel / Repair etc.)
3)Vehicle-wise total expense
4)Monthly fuel/service cost