Skip to content

Import AR payments

Some insurance companies send a file listing every claim a payment covers. Import the file to create the payment and match each line to a folder automatically.

These files usually arrive by email as Excel spreadsheets, but they’re really tab-delimited text files.

  1. Drag the attachment from the email to your desktop. Don’t open the file.
  2. Change the file extension from .xls to .txt. Don’t change anything else in the name, and don’t open the file.
  1. Go to Accounting › A/R Payments › Import Payments.

  2. Select New on the bottom button bar.

    The Import Payment screen with the New button

  3. On the import screen, browse to the file in File and choose the Template.

  4. Enter the payment details. You’ll find them by expanding the first column of the raw data, or in the body of the email:

    • Date: the date the payment was remitted.
    • Ref No: the payment reference.
    • Amount: the payment amount.

    The Import Payment File screen with File, Template, Date, Ref No and Amount

  5. Select Save.

  6. The payment is loaded and a search list opens. Select the payment, then select the edit button.

    The imported payment in the list, and the edit button

When the file loads, Nexsyis tries to match each line to a folder and estimate. Matched lines show a green check mark.

For a line that isn’t matched:

  1. Type what you know in the search boxes at the bottom: Claim No, Vehicle, Customer or Folder. Select the checkbox next to each one you want to use, then search.
  2. Select the line at the top and the matching folder at the bottom.
  3. Select Apply Payment.

To unlink a line, select Un-Apply Payment. To run the automatic matching again, select Auto-Apply Processing.

Imported lines with green check marks, the search boxes, and Apply Payment

You can save at any time and come back to the payment later. Each time you save, you’re asked whether to write the payment records.

  • Select No to keep working on the import.
  • Select Yes to create the AR payment. After that, you can’t change the import. Make any changes on the payment screen instead.

The prompt to write the payment records

Unmatched lines go to unapplied payments. You can change them later on the AR payment screen.

You can delete the import at any time until the AR payment has been created.