{{ctrl.SSUtilService.getCurrentDateTime()}}

{{ ctrl.SSAlertService.title }} {{ ctrl.SSAlertService.message }}

Access Denied – You do not have permission to view this page. Please contact your administrator if you believe this is a mistake.

Import Manual Interest

Bulk-import historical manual late-payment interest entries for a single property from a normalized Excel/CSV template. Imported rows are created as manual entries and remain eligible for the existing Charge/Waive flow.

The file must have a heading row with these columns:

  • otp_no — the sale Serial (e.g. LCR0001).
  • payment_type_name — the Payment Type name (e.g. S&P, Foundation, RC Frames).
  • value_date — date in YYYY-MM-DD format.
  • daily_interest — net interest amount (must be > 0).

Project: *

Data file (Excel/CSV): *

Accepted formats: .xlsx, .csv (max {{ ctrl.MAX_FILE_SIZE_MB }} MB).

{{ ctrl.fileError }}

{{ ctrl.importFile.name }}

Run a preview first to review the outcome before importing.
Preview (dry-run) Nothing has been saved yet
Total rows
Inserted
Overridden
Skipped — unmatched OTP
Skipped — no matching payment
Excluded — net ≤ 0

No row errors.

Row errors ()
Row Reason
Import result Committed
Total rows
Inserted
Overridden
Skipped — unmatched OTP
Skipped — no matching payment
Excluded — net ≤ 0

No row errors.

Row errors ()
Row Reason