How to import payments into Upflow?

What if I need to mass import payments from an external source?

Jean-Malo avatar
Written by Jean-Malo
Updated over a week ago

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.

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) : 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: 


Examples of CSV limitations:

  • The amount imported needs to be exact, if the amount import is > the invoice amount = nothing will happen

  • Credit note management: if you import credit notes payments and also the credit note PDF, you will end up with a duplicate.

  • Payment ID: these needs to be unique.

  • Partial payments: If you import a first payment of $50 on a $100 invoice, how will you import the second payment? It won’t work if you import again $100.

  • You might spend some time to prepare the expected payment file to import

    If you have any question, please reach out! 

Did this answer your question?