Payee Positive report

tweingart · ‎November 19, 2020

I am using Premier Non-Profit for desktop.

We have just signed up for Payee Postive checking services with Wintrust.

I need a report containing Check Date, Check #, Check Amount, and Payee Name each time we print checks. I have customized a report, however, the Payee Name defaults to Vendor Name, which in many cases is NOT the Payee Name as we use the Print As field when we have mulitple accounts under one vendor.

All I want to do is to customize the report to either use the actual Payee Name on the check or to add a column for the Print As field so I can manually locate those checks and modify after exporting to Excel. I cannot find the field when I try to customize.

I have searched for answers on this and notice it has been a topic many times. I hope by now there is a solution (other than going to a 3rd party vendor).

BigRedConsulting · ‎April 26, 2023

@tweingart @gfoster

QuickBooks won't include the Print As names on reports nor will it create proper positive pay files.

Instead consider our BRC PositivePay file Creator - QB Desktop - which will do both. It supports about 150 bank formats and you can create custom formats as well.

It doesn't yet support Wintrust, but we can add it if you work with us and send the bank's file specification document. The same is true for any bank it doesn't yet support. We add banks all the time to the tool.

View solution in original post

Pabz_L · ‎November 19, 2020

Let me share some information about customizing a report, @tweingart.

QuickBooks Desktop allows you to customize any report that you generate. You can customize the data, add or delete columns, add or remove information on the header/footer, and even personalize the font and style of the report.

If you want to customize a report containing, Check Date, Check #, Check Amount, and Payee Name, you can use this article as a guideline: Customize reports in QuickBooks Desktop. However, the payee name will always default to the Vendors Name.

If you want the same settings of the customized report to be available for future use, you can create and save a memorized report.

Keep me posted if there’s anything else that I can help with your reports by leaving a comment below. Take care and have a wonderful day!

gfoster · ‎January 27, 2023

Sounds like no easy answer. Same issue here. Bank needs the actual name printed on check. We have a vendor setup several times in QB say for different utility accounts.. i.e. Ameren 1, Ameren 2,... but the checks print for each as just 'Ameren'.

The positive pay report shows Ameren 1, Ameren 2 when we run it. We are having to do some type of workaround to keep our checks from being rejected by bank.

BigRedConsulting · ‎April 26, 2023

@tweingart @gfoster

QuickBooks won't include the Print As names on reports nor will it create proper positive pay files.

Instead consider our BRC PositivePay file Creator - QB Desktop - which will do both. It supports about 150 bank formats and you can create custom formats as well.

It doesn't yet support Wintrust, but we can add it if you work with us and send the bank's file specification document. The same is true for any bank it doesn't yet support. We add banks all the time to the tool.

Topics

Training

Community

Resources

Payee Positive report