cancel
Showing results for 
Search instead for 
Did you mean: 
rmitchell2790
Level 1

Report - Name Printed on Check

Good morning! I am looking a report that provides the name that is printed on the check. Sometimes the "PRINT NAME ON CHECK AS" is different than the vendor name. I have not been able to locate a report option that provides this. Thank you in advance!

19 Comments 19
BigRedConsulting
Community Champion

Report - Name Printed on Check

The "Print name on check as" field isn't available on any report, as far as I've been able to determine.

 

What is it you're trying to get done?

rmitchell2790
Level 1

Report - Name Printed on Check

I am having to create a report for the bank that shows: Check Date Check Number Payee Name - as printed on the check Check Amount Thank you!
BigRedConsulting
Community Champion

Report - Name Printed on Check

That sounds like a SecureCheck or PositivePay type file. You've hit a critical QuickBooks limitation regarding creating such files because QuickBooks won't include the Print As name on reports.

 

However, we offer a solution with our BRC PositivePay file Creator - QB Desktop. It creates the required files for about 150 bank file formats, always using the Print As name so the files match the printed checks. We can very likely add your bank on request if it isn't listed. For simpler bank file formats, there's also the ability to create custom formats yourself.

rmitchell2790
Level 1

Report - Name Printed on Check

What makes this program able to capture the payee name if QuickBooks does not offer it?
BigRedConsulting
Community Champion

Report - Name Printed on Check

QuickBooks doesn't make it available when using its report writer. The BRC PositivePay file Creator - QB Desktop doesn't use reports. It gets the data from QuickBooks a different way.

CLambert1
Level 1

Report - Name Printed on Check

Do you make one for QuickBooks Online also? I am needing a positive pay report for the bank and if I can't figure out how to get a report with the name printed on Check I will have to rename hundreds of vendors. 

 

Thanks in advance for any help you can give me on this. 

ssis
Level 1

Report - Name Printed on Check

Doesn't Online offer a vendor report where you can select "Print on Check as"?

 

Create a report that has Vendor and this field, export to excel, save it on a sheet, then export your transaction list of checks, do a vlookup on the vendor to the other tab and return the "print on check as" field and build your export from there.

 

I do this in desktop, not sure if it can be done in Online, but I would figure similar functionality.  This is how I'm building the check positive pay file for our bank.  Or then again, pay for the guy aboves product to do it for you automatically. 

 

Travis

 

PCT-Gtw
Level 1

Report - Name Printed on Check

where can you create a report that has Vendor and this field?  I have not been able to create this on QB Desktop?

PCT-Gtw
Level 1

Report - Name Printed on Check

Where do you find this report?  I use QB Desktop and cannot locate a way to print a list of Venders and "print on check as" file?

BigRedConsulting
Community Champion

Report - Name Printed on Check

You can add the Print on Check as field to any vendor list report, like the vendor contact list report.

Ebenidze
Level 1

Report - Name Printed on Check

Can you please advise how do I add " Print on Check" as field to any report?

RCV
QuickBooks Team
QuickBooks Team

Report - Name Printed on Check

I know a way how to add " Print on Check" as a field on a specific report in QuickBooks Desktop, Ebenidze.

 

The "Print name on check as" field is unavailable on any report. We can follow the recommended solution of 

BigRedConsulting. Just create a custom field in the vendor profile in the additional info tab. From there, enter the Print on Check for your vendor. Here's how: 

 

  1. Go to the Vendor menus, then select the Vendor Center.
  2. Double-click any profile on the list to open and edit it.
  3. Select the Additional Info tab. Then select Define Fields.
  4. Name your custom field in the Label column.
  5. In the Use for the column, select the checkbox to add the custom name field to vendor profiles.

 

 

Once done, you can run a Vendor Contact List report. Then, add the custom field in the report. Let me show you how:

 

  1. Go to Reports on the top menu.
  2. Choose Vendors & Payables.
  3. Click Vendor Contact List.
  4. Tap the Customize Report tab.
  5. Hit the Display tab.
  6. In the Columns field, type Print on Check
  7. Press OK

 

 

 

In this particular situation, I recommend sending a message to the product engineers to let them know you'd like to have the option to add " Print on Check" as a field to any report. Here's how to get your feedback submitted:

 

  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 the Send Feedback Online.

 

For future reference, read through this article: Customize reports in QuickBooks Desktop. It helps you learn about how to use filters so you can get the details you want in a report.

 

Let me know in the comment section if you need more help in accomplishing your other QuickBooks tasks. I'll be right here to keep assisting. You have a good one. 

sbkw
Level 3

Report - Name Printed on Check

Has anyone made any progress on this in QB Online?  We just signed up for Positive Pay with our bank and keep getting exceptions because the name printed on the check does not match what is in the register.  Instead of waiting for exceptions it would be so helpful to run a report that shows Company name, Vendor display name, and Name to print on checks and find the mismatches.  Otherwise I have to edit every single customer to see if there is a mismatch.  Help!?

travisp
Level 1

Report - Name Printed on Check

Since this was just resurrected again.  I have no idea what RCV is doing and maybe that's a QB Online thing, but they were referencing QB Desktop, not Online.  For the current version of QB Desktop you don't have to create a Custom Field, just go to Reports - Vendors & Payables - Vendor Contact LIst -> Customize -> in the columns box type print, then below "Print on Check as" should show up.  Check it. 

printoncheck.jpg

Viola there's a report of vendors with that field also.  I do not know if it's available in a similar fashion in QB Online.  Once you have this, now you can do a vlookup in excel against the Print On Check As field.  If it exists, use that, if it doesn't, use the Vendor name.  Create your Positive Pay file from that.  You can look up Adevity and we could help you one on one, but as already stated, if you don't know how to do the above you may be better off just buying the previous guys program.

sbkw
Level 3

Report - Name Printed on Check

Thanks for your response.  I just chatted with intuit for a long time and they verified that there is no way to get a report in QB Online that includes 'Name to be printed on check'.  I set up vendor names to be easy for me to recognize when they had payee names that were not helpful.  I just need a download so I can see the ones that are different and make them match.  Otherwise I am stuck opening up each vendor to see the printed name.  

James_AL
QuickBooks Team

Report - Name Printed on Check

I know a report that shows the information you need, sbkw.

 

I'm pleased to have you here in the Community. Let me guide you through creating a report that displays vendor payments, bills/invoices, their respective numbers, and statuses.

 

You can generate the Transaction List by Vendor report in QuickBooks Online. That's the report where you can find all the details you need for your transaction. Ensure to apply filters for the necessary details to be displayed.

 

 

Here's how:

 

  1. Login to your QuickBooks Online.
  2. Go to your Reports menu.
  3. Select Transaction List by Vendor in the search field.
  4. Choose Customize, then filter the necessary details.
  5. Click Run report.
  6. Press the Small gear icon, then mark the A/P Paid.
  7. Select the Print icon.

 

To learn more about our report features in QuickBooks, please refer to this article on running reports. It includes instructions on how to modify and memorize them.

 

In case you need more tips and information on managing your account and business finances. We have available training videos and webinars to help you understand our product features, functions, and benefits of QuickBooks.

 

Please reply to this thread if you have more questions or concerns about reports. We are available at all times to assist you. Take care!

sbkw
Level 3

Report - Name Printed on Check

This report shows the Vendor name but not the Name to be printed on check name that I can find.

travisp
Level 1

Report - Name Printed on Check

Yeah, I was replying to the previous people asking about QB Desktop.  The only thing I can say about Online is that I know I looked a while back and QB Online is supposed to support REST API (I think), so that's an option.  I don't know how hard it is to sign up for a developer account and get keys, etc. to connect to QB Online, but I did something with QB desktop a few years back and it wasn't too bad.  You could find some college kid and give it to them as a project to pull down the info you need.  It's actually disheartening to hear that this isn't available in the online version as I've been looking to move to it and I have to create Check Positive Pay uploads, but I can also say that when we do move to Online we'll be looking into API Access to the company file, etc. for current things we do with desktop.  I'm sure you could reach out to the user above who has the product or if it's "that" big of a deal to you, you can find our company by searching for Adevity and we could potentially help you out with the API stuff.

 

Here's the data for qb online vendor object through the api explorer and print on check is available there...

https://developer.intuit.com/app/developer/qbo/docs/api/accounting/most-commonly-used/vendor#the-ven...

Candice C
QuickBooks Team

Report - Name Printed on Check

Hey there, @sbkw

 

Thanks for letting us know those steps didn't work for you. 

 

Since support gave you information and my colleague's response didn't help, I recommend submitting feedback to our Product Developers. They'll be able to review your account and consider adding your suggestions to the next available update. 

 

Here's how: 

 

  1. Go to the Gear icon in the top right-hand corner. 
  2. Press the Feedback option. 
  3. Enter your suggestions. 
  4. Tap Next to submit them. 

 

If you have any further questions, don't hesitate to ask. Have a great day! 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us