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.
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")
- 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:
If you have any question, please reach out!