How To Import Payments

How to Import Payments

Follow the steps below to import payments into the system using a CSV file.

 

Step 1: Navigate to Payments

From the left-hand navigation menu, click Payments to open the Payments screen.

Step 2: Open the Import Payments Window

Click Import Payments in the top-right corner of the Payments screen.
This will open an import window where you can access the required CSV template.

To download the template, click Download CSV Template.

Step 3: Complete the CSV Template

Enter your payment details into the CSV template.
The following columns are required before the file can be imported:

• Date

• Account

• Payment Type

• Amount

• Transaction Reference Number

Important formatting rules:

• Payment Type (Column F) is case-sensitive and must be entered in ALL CAPS (for example: ACH, WIRE). If not, the file will be rejected.

• Amount (Column G) must be entered as a numeric value without dollar signs or symbols. Including $ will cause the file to be rejected.

Optional Columns

• Client Name and Debtor Name (if provided) must be an exact, case-sensitive match to the values in the system. If an exact match is not found, the file will be rejected.

• Invoice Number (Column K) can be used to specify which invoice(s) the payment should be applied to.

  • If entering multiple invoice numbers, separate them using &&.

  • The system will attempt to locate and associate the listed invoices automatically.

Step 4: Upload the File

Once the CSV template is complete:

1. Drag and drop the file into the Import Payments window, or select it manually.

2. Note that only one file can be imported at a time.

3. Click Upload File to begin the import process.

Step 5: Review Imported Payments

If the file is processed successfully and no errors are detected, the payments will be imported into the Unapplied tab on the Payments screen.

From there, you can begin applying the payments as needed.