Positive Pay Report

Dee Belanger

Does anyone have a solution for creating a report in FE NXT that aligns with the Positive Pay reporting criteria?

Joel McBrayer

Hi @Dee Belanger, we use Positive Pay with our bank. We created an invoice query that meets our bank's upload needs. Your file mapping format might be different than ours so you will need to work with your bank on that. Here are our query settings.

Query Type: Payment Query

Criteria:
Payment Date equals Today (you can change this to whatever date you want)
AND Payment Type equals Computer Check

Output:
Payee Name
Payment Number
Payment Date
Amount
Bank Description (this is because we pay out of multiple bank accounts)
Payment Type

If you have multiple bank accounts that you pay out of you can either make separate queries, one for each bank or you can just copy the export and delete the payments for one bank then do the same for the other.

After you export it you will need to remove any duplicates (sometimes there will be duplicate lines) and then save it as an excel file instead of a CSV and upload it to positive pay. Hope that helps!

Dee Belanger

@Joel McBrayer Thank you! This is super helpful.

Dan Hout-Reilly

@Dee Belanger We start off the same as Joel, using an invoice query to pull the information out of Blackbaud using an export. Our bank wanted us to use a formated text, .prn file format. So we created a template in Excel in which we copy and paste the data from the export spreadsheet in the first tab and the second tab uses formulas to convert the data into the appropriate format. We then save that tab as the .prn file.