You can import payments, either already reconciled to outstanding invoices or not, by clicking on the "Import payments"  button on the top right corner of your Payments Tab. 

Import method

Imported file should be in the following format: csv, xls, xlsx or xlsb.

Please find below the available fields:

  • paymentReference (mandatory): A unique payment reference that should be used if a payment is imported again. This is particularly useful in case of partial payments. 
  • paymentDate (mandatory)): The date should be in the following format: AAAA-MM-DD ( ISO 8601 format)
  • amount (mandatory)
  • currency (mandatory if no invoiceReference specified) : Currency should be in ISO 4217 format (example: "USD")
  • invoiceReference
  • paymentMethod: Should be selected from the following available inputs: WIRE_TRANSFER, CARD, DIRECT_DEBIT, CHECK, CASH

Importing raw payments (non reconciled) into Upflow


If you wish to import unlinked payments in order to perform reconciliation within Upflow (manually), you can simply leave invoiceReference field empty.

If a payment is linked to several invoices, you need to split this same payment into different lines with the right allocation while keeping the same paymentReference.
For example, you have received a wire transfer #1 that pays for invoice #2 (100€) and invoice #3 (200€), the imported file should be filled as follows: 

Templates

Template CSV

Template XLSX

If you have any question, please reach out! 

Did this answer your question?