upload RV - NAAP.xlsx • 836 Records • Total Value: AED 375,653.68
Total Receipts
836 Rows
AED 375,653.68
Cash & Transfers
757 Rows
Auto-Settled
Cheques
79 Cheques
Matured: Settled
Applied Historical Settlement Rules:
Underpayment Rule: If Job Card total is 500 and received is 450, difference (AED 50) is automatically applied as a Job Card Discount, clearing the balance to AED 0.00 and marking the job PAID.
Overpayment Rule: If Job Card total is 500 and received is 550, the job is marked PAID and the excess (AED 50) is credited as an Advance Payment.
Settlement Status: Cash and Bank Transfers are marked SETTLED. Matured cheques are SETTLED; pending/future cheques are set to PENDING_CLEARANCE.
Single-Use Notice: After you execute this import, this button will permanently disappear from the system to prevent duplicates.