Why do I receive an error or alert message when uploading Hire Purchase Excel file?

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.