Positive Pay File wth Name printed on check

Hey, @MichelleSCR.

I hope your day is going well. After looking through reports and researching this request, I've discovered that this option isn't available at the moment. I can see how this would be helpful for you and your unique business. That's why I'm going to personally submit feedback to our Product Developers so they can consider this feature in one of the new updates for QuickBooks.

This is an extra link that may come in handy for your business about customizing reports.

If you have any other questions, please don't hesitate to ask. Enjoy the rest of your day.

Has this situation been rectified yet with the Positive Pay reports and the name as printed on the checks.   I use Quickbooks Enterprise contractor edition and have to edit several vendor names before submitting my upload document to the bank.  It's very time consuming considering I send out over 100 checks  per week.

How is this not done yet? It shouldn't take a year to develop this. There are third party options but we shouldn't have to resort to that. Any updates?

Here is how I run reports for positive pay.  WARNING: You need MS Excel skills to accomplish this task as I describe below:

1) You will create two memorized reports:

         a) Select the QB default Transaction Detail by Account Report:

                 i) Only Columns needed: "Num"; "Amount"; "Date"; "Name" (in this order from left to right)

                 ii) Dates to run report I have set for "today" because I do it for the same day, but you set up the date range that you do the work.

                iii) Sort by Name (A-Z)

               iiii) Memorize, name, and organize this report in a way that makes sense to you.

         b) Select the QB default Vendor contact list report:

                  i) Only Columns needed: "Vendor"; "Print on Check as"; (in this order from left to right)

                 ii) Filter for ONE bank account.

                iii) Sort by Vendor (A-Z)

               iiii) Memorize, name, and organize this report in a way that makes sense to you.

2)  Run both newly memorized reports each time you need to upload a file to your PositivePay system.  Export them both into excel via .csv file format.  Open both files in excel.

3) Now, in excel:

          a) Combine both files into one file (workbook).  So you go from two workbooks with one spreadsheet each -  to one workbook with two spreadsheets.

          b) Delete row two (which is the name of your bank account listed in QB)

          c) In column E of the transaction report/spreadsheet, run a VLOOKUP formula.  The lookup value is going to be the "name" column in the transaction report. The table reference is both columns of the vendor list, column will be the number 2 and then "FALSE" for exact match.  Hit enter and copy the formula down to the end of the transaction report.

          d) If you have a "0" result, then there is nothing entered in the "print on check as" of the vendor report.  Find those and fix them in both QB and the excel file you are currently working on.

          e) Copy and paste-value column E to replace the "name" in Column D.  Delete column E.

           f) Add your account number, fix the date format, fix amounts, and add your positivepay action to your excel file.

           g) upload to PositivePay site.

Good luck and I hope this helps!

Yet another year has passed - quickbooks still CAN'T give me what I need for a positive pay file?

Actually, you would want to run an Xlookup with a comma zero on the end so you only pick up exact names.

The option is not really a good option.  Quickbooks should fix the reports already.   Uploading the vendor ID field in positive pay is wrong for so many reasons. 

Are you still able to run the Vendor contact list report and add the "print on check as" field?  The options I have for the columns have every field in the Vendor contact file EXCEPT print on check as. 

This is a huge PITA.  By now, QB should be able to automatically send the data over to the bank instead of all the report generation, data monkeying and uploading.

Thanks for reaching out to us regarding this requested feature in QuickBooks Desktop, @Hthree.

We recognize the need to have additional data preferences in QuickBooks Desktop. 

I want you to know that the changes in the program are released based on several factors. You might have waited for this long enough, but regretfully, we're unable to provide the turnaround time on when new features are released in QuickBooks. Any updates are internally handled by the Developers Team. 

For this, we continue asking for product suggestions so our developers can review how many requests we have for a certain feature. To add your product suggestions to our developers, go to the Help menu and select Send Feedback Online.

For now, you can follow all the workarounds from this thread to complete your task.

We ask for your patience while this feature is not yet available. Reach out to back to me if you need further assistance while working with QuickBooks sale forms. I'm always here to help. Have a great rest of the day.

It's been years since this was asked for. In the meantime, more and more banks are suggesting/requiring positive pay reports due to the amount of check fraud. We need reports that show the name as it's printed on the check. Workarounds for this long is ridiculous. I tried using the fax number field as a substitute but there is a character limit. It takes way too much time to correct the report so it can be sent to the bank if you do any volume of checks.

Utilize an exporter tool as a workaround. Before beginning, ask the bank for their specific layout requirements for the file.

https://transactionpro.grsm.io/qbd

I don't think I should have to use a workaround when all they have to do is add a field option for a report. That said, I'm using the Excel report(s) suggested above by JMBanker. Again, we should not be required to use a workaround in order to generate a basic report in QuickBooks.

Do you have to do this every time you send a positive pay report to the bank?

or is this formatted .cvs saved somehow

Has this feature still not been added to quickbooks? We use positive pay to send to our bank and I print hundreds of checks each week. It is extremely time consuming to change every name to the correct "print on checks as." Will this be a feature soon?

Welcome to the QuickBooks Community, kendrah. I can see how important the said feature mentioned above is to your business so you can manage your checks. Please know that QuickBooks Desktop is constantly changing and evolving based largely on the requests of users. With this, I'll ensure you can send feedback so your suggestion is forwarded to the Product Development Team.

For now, the feature has still not been added to QuickBooks. Also, we’re unable to provide you with information if the option will be a feature soon or a specific time frame as to when this will roll out. I suggest going to the Help menu inside QBDT and you're able to choose Send Feedback Online from there to start submitting a request about Positive Pay File. Any recommendations are sent to our engineer for consideration in future updates.

Lastly, you may refer to this article to see steps on how you can run a specific report that will tell you where your company stands, in terms of expenses and accounts payable: Customize vendor reports.

I'm always here if you need more help managing your checks. I'm always glad to assist in any way I can. Have a great rest of the day, kendrah.

3 years later - is this feature available yet?

Hello there, @cpweigh. I want to provide some information about getting a report that will show a report with the check display name. 

Currently, the transaction report that will show the check display name instead of the vendor's name is unavailable in QuickBooks Desktop (QBDT). While we don't have the exact time frame on when this will be available, I have a workaround that you may find helpful for the time being.

To do so, you can run the Transaction List Detail and the Vendor Contact List report. The former can be filtered to see all the checks created for your vendors and the latter will show the information entered in the Print on Check as field. Here's how:

1. Select the Reports menu, click Custom Reports and choose Transaction Details.
2. Set the correct date range.
3. In the Display section, go to the Columns field and check the Type option.
4. Next, go to Filters and look for Transaction Type. Choose Check. Then, type name and select All vendors.
5. When done, click OK.
6. After that, export the report to Excel.
7. Go back to the Reports menu, select Vendors & Payables and choose Vendor Contact List. 
8. Select Customize report. From the Columns field, select Print on Check as.
9. Once done, click OK.

Once exported, you can now modify the report's data.

If you have any other concerns about running transaction reports in QuickBooks, please don't hesitate to leave a reply below. Have a good one and stay safe.

This doesn't help with payroll checks and really isn't a work around

Again another year.  I would think with all the check fraud and banks almost demanding Positive pay files, that QuickBooks would have this a priority.  I don't mind creating a custom report to dump to CSV file, but not being able to pull the "Print Name On Check As" field into a check register, seems like a real miss.  

There are lots of people waiting for this, if we need to start posting this in QB formats, message boards, and software reviews and also get everyone we know is waiting for this obvious oversight, to do the same just so QB Development can make this a priority, then we can.  Just seems like a very easy fix and getting the negative publicity would be something QuickBooks Team wouldn't like to avoid.

@Consultant23 

QB Online or QB Desktop?

Hello there, @Consultant23.

I can see how advantageous it is for you and for other users to have the Print Name On Check As field to help manage checks in QuickBooks. However, it is still unavailable. That said, I recommend leaving feedback to notify our software engineers about the feature you need. In this way, they can take it into account for future product improvements.

To send your input, here's how:
 

1. Go to the Help menu and select Send Feedback Online.
2. Click Product Suggestion.
3. Choose a feedback type and product area on the QuickBooks Feedback window.
4. Enter your suggestion or feedback, name, and email address (optional).
5. Select Send Feedback Online.

Moreover, I'll also share this link where you can search for articles that can serve as your reference to guide you manage your QuickBooks file: QuickBooks Desktop Help Articles.

I'm looking forward to having this field added to QuickBooks. Feel free to leave a reply if you have additional QuickBooks-related queries. The Community team always has your back. Keep safe.

@MHawke  Re: It's been years since this was asked for. In the meantime, more and more banks are suggesting/requiring positive pay reports due to the amount of check fraud. We need reports that show the name as it's printed on the check. 

It's unlikely that Intuit will add the Print As name to transaction reports in QuickBooks, just as they haven't added most name fields to those reports.

Even if they did add it, QuickBooks transaction detail reports still wouldn't be suitable for most banks that our BRC PositivePay file Creator - QB Desktop  supports, which typically have quite specific requirements for date formatting, field length limits, the characters that are allowed in memos and name fields, and so on. And QuickBooks absolutely won't create any fixed-length record files, which are commonly required.

In any case, if anyone is interested in trying the tool, it's free to try for a month, and if it doesn't include your bank format - and that format is too specific for the included custom file feature - then if you contact our support team we can usually add your bank to the list of file formats the tool supports within a few days.

After reading this thread, I have two questions:

1) What report are you using to generate the positive pay file for your bank?

and

2) Is there a report that can be generated to show "Vendor Name" and "Print Name on Check"? If so, then one could possibly clean up all  Vendors where "Vendor Name" and "Print Name on Check" do not match. It might require some effort, but it would address the issue of not being able to create a positive pay file with the print name on check field.