Contact your bank to request file specifications. Not all banks use the same format. Contact your Sage Business Partner or Sage Expert Services for assistance with creating a custom report.

Creating the positive pay text file

We've attached an example of bank file specifications and a report that can produce the file for the bank.

1. Download the *.zip file.
2. Extract the two files into your reports folder on the server.
3. Open this report in Report Designer to modify this report to match your bank's requirements.
4. Print a test of the attached sample design.

Attachment: PositivePay.zip

Changing the payee's name on the report

1. in the Report Designer Field List, click Index.
2. Click Add, and select AP-Vendor.
3. Click Ok.
4. Verify you highlighted AP-Vendor and click OK.
5. Click in the report design where you want to add the field. Select Name from the field list.

If you use AvidXchange to print checks, contact AvidXchange for an add-on package that includes Positive Pay.

Alternate: Use the Bank Register inquiry

Print the Bank Register inquiry as a workaround if you don't have Report Designer or while waiting for a custom report from your consultant.

Changes made to an inquiry don't automatically save. Follow these steps to change the inquiry permanently if you want to keep a copy for this issue.

1. Go to Cash Management, Inquiry, Bank Register.
2. Select the Register file and click OK.
3. Double-click on the Bank Account to get the detail.
4. Add two conditions:
   Type EQ Chk
   AND Accounting date EQ  xxx
   (or GT/LT - it’s typically one date)
5. Add available columns that your bank requires. Examples:
   • The Description column is the Payee
   • If the bank requires that you show that you voided a check, add the Voided field
6. Click the Export to Excel icon and save the file.
7. Open the file in Excel.
8. Arrange the columns as needed per your bank requirements.
9. Add any information that you couldn't find on the inquiry. For example, an I or V on the voided lines.
10. Save the Excel spreadsheet as CSV type or the type required by the bank for uploading.