Skip to main content

Import payments into Upflow

Nolwenn Launay
  • Updated

Important before moving to this article content. This article is specific to organizations using a full API integration. If you use one of our native integrations (i.e., NetSuite, QuickBooks, Chargebee, etc.) this feature will not be available as only transactions synced from your accounting tool can be displayed in Upflow.

 

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: 

 

Templates

Template CSV

 

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! 

Related articles