Import rows failed
You will know why rows in an Excel import were marked needs review or invalid, how to fix the sheet or the master data, and how to re-import only what failed.
AI › AI Data Import reads an .xlsx or .xls file, maps its columns to ERP fields and shows every row as ready, needs review or invalid. Nothing is saved until you click Confirm, and invalid rows are never saved. A failed row almost always means the sheet refers to something the app does not have yet, or a value is in a form the app cannot read.
Symptoms, Causes And Fixes
Symptom | Likely cause | Fix |
|---|---|---|
Vehicle rows invalid | The Vehicle number in the sheet is spelt differently from the record under Vehicles (spaces, hyphens, letter case), or the vehicle does not exist | Match the spelling to the Vehicles list, or import the Vehicles sheet first |
Booking rows need review on customer | The customer name does not match a record under Customers | Correct the name, or import the Customers sheet first so the ledgers exist |
Fuel or expense rows invalid on payment | The payment scenario or Payment Type named in the row does not exist under Settings › Payment Type | Create the payment type, or change the row to one that exists |
Rows invalid on tax | A tax rate name in the sheet is not under Settings › Tax Rates | Add the rate or change the row to an existing name |
Dates rejected | Mixed date formats in one column, or text where a date is expected | Format the whole column as a date in Excel and use one pattern throughout |
Supplier rows need review | The supplier exists but with a different Supplier Type, or two suppliers share the name | Make names unique under People › Suppliers |
Duplicate number | The LR NO., invoice number or bill number already exists | Remove the row if it is already in the app; otherwise change the number |
Column not mapped | A heading in the sheet did not match an ERP field | Use the mapping step to point the column at the right field, or rename the heading |
Everything imported but nothing shows | The rows fell into a Financial Year that is not active, or you did not click Confirm | Check the import job, then the financial-year selector on the list |
Import In This Order
- Customers and Suppliers, so the ledgers exist.
- Vehicles, by registration number, and Drivers.
- Bookings, then Expenses, Fuel Tracking and Bank Transactions that refer to them.
- Purchase Invoice, one product line per invoice.
- Bank statement lines last, for reconciliation.
Re-Importing Only The Failures
- Confirm the ready rows; they are saved. Copy the needs review and invalid rows into a fresh sheet.
- Fix the master data or the values, then import the fresh sheet. Rows already confirmed are not touched.
- Keep one row per record: one booking, one fuel fill, one expense voucher line, one purchase invoice product line.
Need Help?
Chat with the NShine ERP support team on WhatsApp at +91 79950 87755, or ask from inside the app. Last checked 9 November 2026 against app.nshineerp.com.