Follow the steps below to import payments from a CSV file.
Step 1 – Open the import window
- In the left-hand menu, click Payments.
- Click Import Payments in the top-right corner.
- Click Download CSV template.
Step 2 – Complete the template
- Date – must be mm-dd-yyyy.
- Account – the bank account the payment landed in.
- Payment Type – must be ACH, CHECK or WIRE, in capitals.
- Amount – numbers only. A dollar sign will cause the file to be rejected.
- Transaction Reference Number.
Optional columns
- Client Name, Debtor Name and Broker Name may be left blank. If you supply one it must match FactorCloud exactly, including case, or the file is rejected.
- Invoice Number – applies the payment to specific invoices. Separate several with &&.
- Label Name – also accepts several separated by &&.
Step 3 – Upload
Drag the file in or click to select it – one .csv at a time – then click Upload Files.
Step 4 – Review
Imported payments land on the Unapplied tab, ready to be applied.
Troubleshooting
- File rejected – check the payment type is in capitals, the amount has no currency symbol, and the date is mm-dd-yyyy.
- A name won't match – copy it from the Companies list rather than retyping it.