Use RFMS Check Register Data for Positive Pay

Use this article if your bank offers Positive Pay and you need to pull check information from RFMS. RFMS does not provide a dedicated Positive Pay report or a bank-ready Positive Pay export file. However, you can export check register data to a CSV file and edit that file outside RFMS to meet your bank’s requirements.

Export Check Data from RFMS

1. Go to Accounting > File > Bank > Add-edit checks.
2. Click the find/filter button, , to open the Banking Filter.
3. Select the transaction type and enter the needed dates, check numbers, supplier, or payee.
4. Click OK to show only the records you want.
5. Click Print and choose to export to a CSV file.
6. Save the file to the location you want.

Fields that are Included in the Export

The bank register CSV export includes these fields:

• Check Number
• Date
• Payee
• Supplier
• Withdrawal
• Deposit
• Balance
• Transaction Type
• Status

How to Edit the CVS Export

After exporting the file from RFMS, open the CSV in Excel or another spreadsheet editing program.

From there, you can edit the file to match your bank's Positive Pay requirements.

RFMS provides the check register data, but any bank-specific formatting must be completed outside RFMS.