An error message during a hire purchase upload typically indicates a data or formatting inconsistency within the Excel file itself. The system validates the file before saving, and any discrepancies will prevent the process from completing.
Common issues include:
- Installment Amount Mismatch: The sum of the installment amounts in your schedule does not match the total principal or expected amount. This is a primary reason for validation failure.
- Incorrect Column Structure: The columns in your Excel sheet may not align with the required template. Ensure all headers are correct and there are no extra or missing columns.
- Corrupted Data or Formatting: Copy-pasting data from another source can introduce hidden characters or formatting issues that interfere with the upload.
To resolve this, it is highly recommended to create a new, clean Excel file from the official template. Manually entering the data instead of copying and pasting can help ensure the file's integrity and successful upload.