Check detail report with Print as Name and not the Vendor name

ema2 · ‎September 13, 2023

I need to pull a daily check detail report that has the "Print As" not the "Pay to the Order of" listed along with check number and amount paid. This is for a positive pay report that is required by the bank. When I print the daily check detail report, it only lists under Name on the check as "Pay to the Order of" but the check is written out to a different name. It has to be the exact name that is printed on the check, not the vendor or "Pay to the Order of". For example: vendor is F/V Ann but check is printed as: Ann Sportfishing. We cannot change the vendor name to match "Print As" due to a different regulatory agency's requirement.

BigRedConsulting · ‎September 13, 2023

QuickBooks won't include the Print As name on transaction based reports, like a list of checks.

However, you can use our BRC PositivePay file Creator - QB Desktop to create positive pay files that do include the Print As name. It supports over 160 file formats tailored for specific banks.

If also offers the ability to customize your own file format, which is useful if your bank's requirements are rather simple and straightforward. .

We're also adding more formats all the time, so if your bank isn't listed we can probably add it for you.

View solution in original post

BigRedConsulting · ‎September 13, 2023

QuickBooks won't include the Print As name on transaction based reports, like a list of checks.

However, you can use our BRC PositivePay file Creator - QB Desktop to create positive pay files that do include the Print As name. It supports over 160 file formats tailored for specific banks.

If also offers the ability to customize your own file format, which is useful if your bank's requirements are rather simple and straightforward. .

We're also adding more formats all the time, so if your bank isn't listed we can probably add it for you.

Mellow3 · ‎July 12, 2024

Once I create the Excel spreadsheet with the list of checks, I just edit the vendor's name to read the payee's name before I save it and upload to Positive Pay.

Mellow3 · ‎July 12, 2024

After I create the Excel spreadsheet of checks written, I edit the vendor name to read the payable to name before I upload it to Positive Pay. A bit of a pain, but better than being contacted via Positive Pay every day. Hope this helps.

PWendt · ‎October 10, 2024

This is absolutely the most disappointing response I've seen so far. Quickbooks is the #1 used accounting software and the answer from QB is to purchase another software to create a report using data that is stored in QB??? This is an absolute ludicrous answer from QB. I believe QB should keep up with the times and security requirements of large market banks. Even our small local banks now require Positive Pay reports on all business checking accounts.

You must do better QB. This information is ALREADY IN YOUR PROGRAM, yet you are requiring end users to do double work after entering the information in your software. Users must either manually adjust the names on their check report, or purchase another software? Unacceptable.

JWT1321 · ‎January 16, 2025

I'm building an exceptions report in Excel that I will use for any Positive Pay report, using a vlookup to replace bad name with Print name as. Still a pain to do it manually but automates some of the process.

I agree, this should be a standard report in QuickBooks!

colleen729 · ‎May 16, 2025

Hey!

I think I have a solution to this question. In the vendor setup you can put the "check payable" to as the "Name Account #" for your vendors. You will have to customize your transactions by account report to include the "Name Account #" in the report. You will have to put your account number in the memo if it needs to be communicated to the vendor. Hope this helps!

PWendt · ‎May 16, 2025

I appreciate your input. Unfortunately we've used QB for over 15 years and have accumulated approximately 4200 vendors, so this would be quite the project for someone to edit all of our vendors. Good idea for a new user though!

Topics

Training

Community

Resources

Check detail report with Print as Name and not the Vendor name