How unapplied payments can be mapped to existing invoices via SFTP?

Mapping unapplied payments to existing invoices via SFTP involves a structured approach to ensure accurate and efficient reconciliation. Here's the process detailing how unapplied payments from your existing system can be mapped to invoices in Peakflo:


1. When the invoice number is present in the payment receipt file

  • Payment receipts are received via SFTP from your existing system and imported into Peakflo.
  • The system scans each payment receipt for an invoice number.
  • The invoice number from the payment receipt is matched against the invoice numbers in Peakflo.
  • If a matching invoice number is found, the payment is applied to that invoice.

2. When the invoice number is not present in the payment receipt file

  • If the payment receipt sent via SFTP does not contain an invoice number, the system considers the unapplied amount.
  • The system searches for payments in Peakflo with an outstanding balance that exactly matches the unapplied payment amount.
  • If an exact match is found, the payment is applied to that invoice.