Vendor Finance Year Settlement Report
Financial Summary Report
Total Sales Value
₹124.5L
Total Settlements
₹98.2L
Fees & Charges
₹12.4L
Net Receivable
₹85.8L
| Report Period | Total Sales Value | Total Settlements | Total Fees & Charges | Total GST | Net Payable/Receivable |
|---|---|---|---|---|---|
| Apr 2024 | ₹12,45,600 | ₹9,82,400 | ₹1,24,000 | ₹68,500 | ₹7,89,900 |
| May 2024 | ₹15,20,000 | ₹12,10,000 | ₹1,45,000 | ₹82,300 | ₹9,82,700 |
| Jun 2024 | ₹11,80,000 | ₹9,25,000 | ₹1,18,000 | ₹64,200 | ₹7,42,800 |
Orders Report
Total Orders
2,456
Gross Order Value
₹45.2L
Total Marketplace Fee
₹6.8L
Net Settlement
₹38.4L
| Order ID / Order Item ID | Order Date | Delivery Date | SKU / XSN / Product Name | Quantity | Selling Price | CGST / SGST / IGST | Order Status |
|---|---|---|---|---|---|---|---|
| ORD-2024-00123 / ITEM-123-01 | 2024-04-15 | 2024-04-19 |
Wireless Bluetooth Headphones SKU: SKU-WBH-001 | XSN: XSN-WBH-8765 |
2 | ₹5,998 | ₹270 / ₹270 / ₹0 | Delivered |
| ORD-2024-00124 / ITEM-124-01 | 2024-04-16 | 2024-04-20 |
Smart Watch Series 5 SKU: SKU-SWT-055 | XSN: XSN-SWT-5432 |
1 | ₹12,999 | ₹0 / ₹0 / ₹1,170 | Delivered |
| ORD-2024-00125 / ITEM-125-01 | 2024-04-17 | 2024-04-20 |
USB Type-C Cable 3m SKU: SKU-CAB-032 | XSN: XSN-CAB-2198 |
5 | ₹1,495 | ₹67.50 / ₹67.50 / ₹0 | Delivered |
| ORD-2024-00126 / ITEM-126-01 | 2024-04-18 | - |
Power Bank 20000mAh SKU: SKU-PWB-018 | XSN: XSN-PWB-7621 |
1 | ₹2,499 | ₹112.50 / ₹112.50 / ₹0 | In Transit |
| ORD-2024-00127 / ITEM-127-01 | 2024-05-02 | 2024-05-06 |
Laptop Cooling Pad SKU: SKU-LCP-001 | XSN: XSN-LCP-9922 |
1 | ₹1,250 | ₹56.25 / ₹56.25 / ₹0 | Delivered |
| ORD-2024-00128 / ITEM-128-01 | 2024-05-05 | 2024-05-10 |
Mechanical Keyboard RGB SKU: SKU-KBD-044 | XSN: XSN-KBD-3344 |
1 | ₹4,500 | ₹202.50 / ₹202.50 / ₹0 | Delivered |
| ORD-2024-00129 / ITEM-129-01 | 2024-05-08 | - |
Gaming Mouse 12000 DPI SKU: SKU-MSE-012 | XSN: XSN-MSE-1122 |
1 | ₹1,899 | ₹85.45 / ₹85.45 / ₹0 | Pending |
| ORD-2024-00130 / ITEM-130-01 | 2024-10-12 | 2024-10-16 |
Monitor 24 inch IPS SKU: SKU-MON-024 | XSN: XSN-MON-5566 |
1 | ₹10,500 | ₹472.50 / ₹472.50 / ₹0 | Delivered |
| ORD-2024-00131 / ITEM-131-01 | 2024-10-15 | 2024-10-20 |
Webcam 1080p HD SKU: SKU-WEB-108 | XSN: XSN-WEB-7788 |
2 | ₹3,600 | ₹0 / ₹0 / ₹324 | Delivered |
| ORD-2024-00132 / ITEM-132-01 | 2024-10-20 | 2024-10-25 |
Bluetooth Speaker 20W SKU: SKU-SPK-020 | XSN: XSN-SPK-9900 |
1 | ₹2,800 | ₹126 / ₹126 / ₹0 | Delivered |
| ORD-2024-00133 / ITEM-133-01 | 2025-01-05 | 2025-01-10 |
External SSD 1TB SKU: SKU-SSD-001 | XSN: XSN-SSD-4433 |
1 | ₹8,999 | ₹404.95 / ₹404.95 / ₹0 | Delivered |
| ORD-2024-00134 / ITEM-134-01 | 2025-01-12 | 2025-01-18 |
Smartphone Charger 65W SKU: SKU-CHG-065 | XSN: XSN-CHG-2211 |
3 | ₹5,400 | ₹243 / ₹243 / ₹0 | Delivered |
| ORD-2024-00135 / ITEM-135-01 | 2025-01-20 | - |
Earbuds with ANC SKU: SKU-EAB-002 | XSN: XSN-EAB-6655 |
1 | ₹3,299 | ₹148.45 / ₹148.45 / ₹0 | Pending |
| ORD-2023-00999 / ITEM-999-01 | 2024-03-25 | 2024-03-30 |
Tablet Case Multi-fold SKU: SKU-CAS-011 | XSN: XSN-CAS-8877 |
1 | ₹850 | ₹38.25 / ₹38.25 / ₹0 | Delivered |
| ORD-2023-00998 / ITEM-998-01 | 2024-03-20 | 2024-03-25 |
Stylus Pen Pro SKU: SKU-PEN-002 | XSN: XSN-PEN-1133 |
1 | ₹1,200 | ₹54 / ₹54 / ₹0 | Delivered |
Non-Order SPF (Seller Protection Fund)
Total SPF Deductions
₹24,560
Claims Processed
18
| Reference ID | Adjustment Type | Amount | Reason |
|---|---|---|---|
| CLM-2024-0782 | Deduction | -₹295 | Lost in Transit |
| CLM-2024-0783 | Deduction | -₹1,534 | Damaged During Return |
| CLM-2024-0784 | Deduction | -₹708 | Wrong Item Swapped |
Storage & Recall Report
Total Storage Fees
₹85,450
Recall Charges
₹12,800
| Listing ID / SKU | Storage Period (Days) | Storage Fee | Recall Charge |
|---|---|---|---|
| LST-2024-8765 / SKU-WBH-001 | 45 | ₹796.50 | - |
| LST-2024-8766 / SKU-SWT-055 | - | - | ₹531 |
| LST-2024-8767 / SKU-PWB-018 | 60 | ₹1,062 | - |
Advertising Spend Report
Total Ad Spend
₹3.6L
Active Campaigns
12
Wallet Balance
₹45,200
| Campaign ID / Name | Ad Spend Amount | Date | GST Amount |
|---|---|---|---|
| CMP-2024-089 / Product Listing Ads | ₹15,000 | 2024-07-05 | ₹2,700 |
| CMP-2024-085 / Sponsored Brand Campaign | ₹12,400 | 2024-07-10 | ₹2,232 |
| CMP-2024-092 / Seasonal Mega Sale | ₹8,500 | 2024-07-15 | ₹1,530 |
TDS (Tax Deducted at Source) Report
Total TDS Deducted
₹42,890
Applicable Section
194-O
| Gross Sales Value | TDS Rate | TDS Amount Deducted | Deposite Date |
|---|---|---|---|
| ₹1,25,000 | 1% | ₹1,250 | 2024-08-15 |
| ₹2,15,000 | 1% | ₹2,150 | 2024-08-22 |
| ₹1,85,000 | 1% | ₹1,850 | 2024-08-28 |
GST Details Report
Net Taxable Supplies
₹12.45L
Total GST Recovered
₹2.24L
| Seller GSTIN | Xotic GSTIN | Taxable Value | CGST | SGST | IGST | Invoice Type |
|---|---|---|---|---|---|---|
| 27AAAAA0000A1Z5 | 27BBBBB1111B2Z6 | ₹5,240.00 | ₹471.60 | ₹471.60 | - | B2C |
| 27AAAAA0000A1Z5 | 27BBBBB1111B2Z6 | ₹12,850.00 | - | - | ₹2,313.00 | B2B |
| 27AAAAA0000A1Z5 | 27BBBBB1111B2Z6 | ₹8,400.00 | ₹756.00 | ₹756.00 | - | B2C |
TCS Recovery Report
Total TCS Collected
₹18,450
Recovery Transactions
24
| Net Taxable Supplies | TCS Rate | TCS Amount Collected | Deposite Month |
|---|---|---|---|
| ₹1,80,450 | 0.1% | ₹180.45 | June 2024 |
| ₹2,15,000 | 0.1% | ₹215.00 | July 2024 |
| ₹1,95,600 | 0.1% | ₹195.60 | August 2024 |
Copyright © 2025 E-47. Design with
by E-47 Ecommerce Pvt Ltd. All rights reserved.