Excel Refund Import
Batch import refund data from ERP exports or manual Excel files
Click to upload Excel file
.xlsx or .xls · Maximum 10MB
Full import with preview, duplicate detection, and row-level error reporting — Phase 4
Required Excel Columns
customerName
contractNumber
workerName
nationality
packageType
refundReason
originalAmount
approvedRefundAmount
scheduledPaymentDate
status
customerPhone
notes
Matching logic: contractNumber + customerName → contractNumber + requestDate → flagged for review
Import History
| Batch ID | Date | File | Total | New | Updated | Failed | Status |
|---|---|---|---|---|---|---|---|
| IMP-003 | 01 Mar 2025 | refunds_march_2025.xlsx | 24 | 14 | 8 | 2 | completed |
| IMP-002 | 01 Feb 2025 | refunds_feb_2025.xlsx | 18 | 12 | 5 | 1 | completed |
| IMP-001 | 05 Jan 2025 | refunds_jan_2025.xlsx | 31 | 28 | 3 | 0 | completed |