| Order ID | Cust Code | Date | Customer Name | Company Name | Employee | Products | Sale Type | Subtotal | GST | Total | Received | Balance | Payments | Actions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Loading sales...
| ||||||||||||||
| Order ID | Cust Code | Date | Customer | Employee | Products | Total Amount | Balance |
|---|---|---|---|---|---|---|---|
| Loading... | |||||||
| Order ID | Cust Code | Date | Customer | Employee | Sale Type | Total Amount | Balance | Actions |
|---|---|---|---|---|---|---|---|---|
| Loading... | ||||||||
| Quotation # | Date | Customer Name | Company | Total Amount | Status | Actions |
|---|---|---|---|---|---|---|
| Loading... | ||||||
Track device renewal status for 4G MDVRs and 4G Dashcams
| S. No | Cust Code | Customer Name | CMR | C+1 | C+2 | C+3 | Total |
|---|---|---|---|---|---|---|---|
| Loading renewal data... | |||||||
| Order ID | Cust Code | Date | Customer Name | Company Name | Employee | Contact | Total Amount | Received | Balance | Action |
|---|---|---|---|---|---|---|---|---|---|---|
| Loading... | ||||||||||
| Customer Code | Customer Name | Mobile | Alternate Mobile | Location | Company | GST Number | Status | Created | Actions | |
|---|---|---|---|---|---|---|---|---|---|---|
|
Loading leads...
| ||||||||||
| S. No | Serial No | Model Name | Status | QC Result | In Date | Customer | Dispatch Date | Cust Code | Actions |
|---|---|---|---|---|---|---|---|---|---|
| Loading... | |||||||||
0 Orders Completed | 0 Orders Pending Dispatch
Loading dispatch orders...
| S.No | QC Date | Serial No | Device Type | SD | All Ch | Network | GPS | SIM | Online | Camera | Monitor | Status | IP Address | Actions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading QC reports... | ||||||||||||||
| S.No | Model Name | In Stock | Dispatched | QC Pass | QC Fail | QC Pending | Total |
|---|---|---|---|---|---|---|---|
| Loading... | |||||||
| Order ID | Customer Name | Order Date | Total Items | Dispatched | Remaining | Status | Last Dispatch |
|---|---|---|---|---|---|---|---|
| Loading... | |||||||
| Date/Time | Serial No | Old Status | New Status | QC Status | Changed By | Reason |
|---|---|---|---|---|---|---|
| Loading... | ||||||
Upload CSV or Excel file containing sales records
Headers: S.No, Month, Order Id, Sale Date, Cust Code, Sale Done By, Company Name, Customer Name, Mobile Number, Bill Amount, Amount Rcd, Balnc Payment, Round Off, With Bill, Billing Status, Yes or no, Blank1, P1 Code, 1st Product, P1 Qtty, P1 Rate, Blank2, P2 Code, 2nd Product, P2 Qtty, P2 Rate, Blank3, P3 Code, 3rd Product, P3 Qtty, P3 Rate, Blank5, P4 Code, 4rth Product, P4 Qtty, P4 Rate, Blank6, P5 Code, 5th Product, P5 Qtty, P5 Rate, Blank7, P6 Code, 6th Product, P6 Qtty, P6 Rate, 7th Product, P7 Quantity, P7 Rate, 8th Product, P8 Quantity, P8 Rate, 9th Product, P9 Quantity, P9 Rate, 10th Product, P10 Quantity, P10 Rate, Courier, Total Sale Amount, Transaction Reference Number, Remarks, Payment 1 received, Payment 2 received, Payment 3 received, Payment 4 received, Payment 5 received, Payment 6 received
Key Columns: Cust Code, Sale Date, Sale Done By, Customer Name, Mobile, Company Name, Bill Amount, Amount Rcd, Balance Payment, Products (up to 10 with Code/Name/Quantity/Rate)
Upload CSV or Excel file containing lead records
Headers: Cust Code, Date, Customer Name, Location, Mobile Number, Follow Up Person, Remarks, Cust Email id, Company Name, GST Number, Company Address
All columns are required as per your Google Sheets format
Upload Excel file with device inventory
Required: Device Serial_No, Model_Name
Optional: In_Date, Dispatch Date, Cust Code, Sale Date, Customer Name, Cust City, Cust Mobile, Dispatch Reason, Warranty Provide, If Replace Old S. No., License Renew Time, User id, Password, Account Activation date, Account Expiry Date, Order Id
Match devices and create dispatch records
Headers: Device Serial Number, Device Name, QC Status, Dispatch Reason, Order Id, Cust Code, Customer Name, Company Name, Dispatch Date, Courier Company, Dispatch Method, Tracking ID
Note: System will match devices by Serial Number and create dispatch records automatically
| Employee Name | Current Month Sales | Previous Month Sales | Growth % | Total Sales Count | Average Sale Value |
|---|---|---|---|---|---|
| Loading... | |||||
| Product Name | Total Quantity Sold | Total Revenue | Average Price | Number of Orders |
|---|---|---|---|---|
| Loading... | ||||
| Customer Name | Company | Total Purchases | Number of Orders | Average Order Value | Balance Pending |
|---|---|---|---|---|---|
| Loading... | |||||
Target: ₹5,50,000 per employee | Incentive: 1% of sales without tax (if target exceeded)
| Employee Name | Sales without Tax | Target Amount | Achievement % | Status | Incentive Earned |
|---|---|---|---|---|---|
| Loading... | |||||
Historical incentive records for all employees (past 12 months)
| Month & Year | Employee Name | Sales without Tax | Target Amount | Achievement % | Incentive Earned | Status |
|---|---|---|---|---|---|---|
| Loading... | ||||||
| ID | Full Name | Role | Employee Name | Permissions | Status | Created | Actions | |
|---|---|---|---|---|---|---|---|---|
| Loading... | ||||||||
