Skip to main content

AR Transaction Import

By using the AR Transaction Import utility, you can import an Excel spreadsheet with payment details to fulfill multiple invoices at one time.

Before Starting​

Before using the utility, you need to do the following:

  • Enable the AR Transactions Import security option.
  • Create an Excel file that includes all of the invoice payment details.

To Enable the Security Option​

  1. Go to Tools > System Maintenance. On the Tables tab, select User Security, and then click Open.

  2. Select a User Group from the list, and then click Security.

  3. In the Keyword search box, enter AR TRANSACTIONS. Select AR Transactions Import.

    img

  4. Click OK.

Excel File Example​

img

Starting the Utility​

  1. Go to AR > Utilities > AR Transaction Import.

  2. Click the Browse button and select your Excel file.

    img

  3. Enter the starting line number (default is 2).

  4. Select the Payment Type.

  5. Do the following:

    img

    AExcel ColumnsMap the Excel file by entering the corresponding column letter for each transaction detail.
    BAllow Payments greater than Invoice TotalEnable this option to import transactions that are greater than the invoice total. If disabled, these transactions won't be included in the import.
    CAllow Transactions for Open InvoicesEnable this option to import transactions that are on invoices with the Open status. If disabled, these transactions won't be included in the import.
    DTransaction DatesChoose to import transactions from any date, or restrict the import to only those from the current month or a specific date.

  6. Preview the import or click OK to run the utility.

After the AR Import is complete, an import report opens. You can then run an A/R Posting to preview the applied payments.

See Also​

Updated

June 6, 2025