Skip to main content
How can we help?
Table of Contents
< All Topics
Print

Exporting transactions

Updated

XEFT transactions can be used to export transactions from RPM for payments to clients, payments to vendors, and Export Transfer transactions. Payments to clients and Export Transfers can be exported to a debit card or another bank account. The overall process is outlined below.

Enter routing and account numbers

A routing number and account number can be entered for each client on the Personal tab of the Clients screen.

Routing and account numbers can be entered for each vendor on the Vendors screen. You can default the payment method for a vendor to XEFT.

Tip: To set a default payment method for all new vendors, use the System Settings screen.

Schedule and process

To create exportable transactions, you can schedule and process XEFT payments or Export Transfer transactions.

XEFT Payments

On the Schedule Pmts tab on the Clients screen, use the XEFT payment method for any scheduled payment you want to export to a client or a vendor.

Like other payments, scheduled XEFT payments must be processed to create actual transactions using the Process Scheduled Payments screen.

Once they are processed, you can see the XEFT payments on the Transactions screen. The “Exp.” column will be checked when the payments have been exported.

Export Transfer transactions

On the Schedule Xfer tab on the Clients screen, use the Export Transfer payment method for any transfer you want to export. Transfers can be exported if they are between different accounts, not within the same account.

Like other transfers, scheduled Export Transfer transactions must be processed to create actual transactions using the Process Scheduled Transfers screen.

Once they are processed, you can see the Export Transfers on the Transactions screen. The “Exp.” column will be checked when the transfers have been exported.

Export transactions to a file

Use the Export XEFT Transactions screen under File > Import/Export to export the transactions to a file. That file can then be sent to your bank.

Select date range and account/bank

At the top of the screen, begin by selecting the date range of the transactions you wish to export. Next, select the appropriate account or bank that the transactions will be paid from.

The “Bank” selection is most useful for exporting transactions to a single file from multiple accounts at the same bank.

Templates

In the upper right of the screen, select a template from the list to switch between saved export formats.

  • Templates – click to open a list of all currently saved export setting templates. Use this screen to update template names and delete unwanted templates from the list.
  • Save New – click to save the currently selected settings as a new template.
  • Save – click to save the currently selected settings in the selected template. This will overwrite any existing saved settings for the selected template.

Select file format

Two standard file formats are available (CSV and NACHA file), which you can select based on the requirements of your bank.

If the NACHA file type is selected, additional NACHA file selection options will be available to the right. Confirm with your bank which selections are appropriate.

Select transactions to export

Before exporting, choose which type(s) of exportable transactions to include in this export file.

  • All – all outstanding XEFT and Export Transfer transactions
  • Payments to Clients – only XEFT payments to clients
  • Payments to Vendors – only XEFT payments to vendors
  • Transfers – only Export Transfer transactions

Tip: The “Transactions Not Exported” table at the bottom of the screen will display a list of all groups of transactions waiting to be exported. Use this as a guide when selecting your export options.

Export file location

To tell RPM where to save your export file and what to name it, use the Select File button next to the “Location” field. After you’ve chosen a file path and file name, click Save in the File Explorer dialog. The “Location” field will update with your selected path.

Update dates before exporting

Click Update Dates to open the Update Transaction Dates screen. This screen can be used to update the dates of XEFT and Export Transfer transactions before exporting, either one at a time or all at once.

This is an optional step in the export process. A file can just as easily be created with various transaction dates.

Report before exporting

Click Report to see a report of the transactions currently selected for export. Use this to confirm your selections are correct and complete before exporting.

Export!

After confirming your selections are correct, click Export to send your selected transactions to an export file.

The file will be created in the location you selected earlier in the “Select Export File” Location field. Navigate to that location on your computer to find the file. From there, send it to your bank or payment processor.