Click to select Excel (.xlsx, .xls) or CSV file, or drag and drop here
You will be able to edit cells, delete rows, verify calculations, and check duplicate Job/PO numbers before committing into MySQL.
Data Type
Job Cards
Total Loaded Rows
0
New Records
0
Existing (Will Update)
0
Selected for Import
0
Total Value
0.00 AED
Mode:
Tip: You can click inside any cell above to edit text, dates, rates, or quantities directly before saving.
Showing all rows
Processing records...0%
Close Purchase Order with Bill
Settled Bill is locked.
PO Total:AED 0.00
Billed So Far:AED 0.00
Pending Balance:AED 0.00
Recorded Installment Bills:
Admin Authorization Required
Enter master admin password to proceed
Invalid password! Access denied.
Check Duplications
Consolidate spelling variations into a single master name across all Job Cards & POs.
Scanning database for near-duplicate names...
Noor Al Aala ERP
v13.7
System Release & Deployment Information
Status:
Live on Tasjeel Production
Deployed Date & Time:Sat, 24 Oct 2026 15:28:34 GMT
Build Target:cPanel / Tasjeel Server
Latest Change Log:
v13.7: Completely remove 2025/0 and clean all legacy hardcoded workarounds
2026 Historical Receipt Import & Settlement
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.