Reconciliation Report
RS
Ravinder Sharma
Reconciliation Workspace
SMART FINANCE TOOL
Reconciliation Dashboard
Upload your 3-sheet reconciliation Excel. Dispatch Order is the master list: only orders present in Dispatch Order are displayed. Forward & Reverse Shipping payments are matched to those dispatched orders and the final payout is calculated order-wise and SKU-wise.
Import your Excel file
Use Dispatch Order, Forword Shipping and Revrse Shipping sheets
No file selected
Ready to importExcel select karke Import Excel button dabayein.
Dispatch Rows0Master list
Forward Matched0Orders with forward payment
Reverse Matched0Orders with reverse payment
Exceptions0Missing payment matches
Total Orders
0
Delivered
0
Return
0
RTO
0
Forward Payment
₹0
Final Payout
₹0
Status Overview
FINAL PAYOUT BASED
Delivered0%
Return0%
RTO0%
Dispatch Order Wise Final Payout
0 ORDERS| Month | Dispatch Order ID | SKU | Payment Order ID | Forward Payment | Reverse Payment | Final Payout | Status |
|---|---|---|---|---|---|---|---|
| Import Excel to view order-wise reconciliation. | |||||||
SKU Wise Final Payout
0 SKU| SKU | Orders | Delivered | Return | RTO | Forward Payment | Reverse Payment | Final Payout |
|---|---|---|---|---|---|---|---|
| No SKU data yet. | |||||||
Payment Exceptions
0 EXCEPTIONS
| Dispatch Order ID | SKU | Forward Payment | Reverse Payment | Final Payout | Issue |
|---|
Top SKU Performance
BY FINAL PAYOUT| # | SKU | Orders | Delivered | Return | RTO | Final Payout |
|---|---|---|---|---|---|---|
| Import Excel to view top SKUs. | ||||||
Reconciliation Dashboard • Forward + Reverse = Final Payout