cancel
Showing results for 
Search instead for 
Did you mean: 
JamesAndrewM
Moderator

Positive Pay File wth Name printed on check

I'll provide you with information to help you achieve your goal today.

 

First, generating the positive pay file for your bank isn't available. You may consider looking for a third-party app that lets you do so.

 

Then, you can pull up the Vendor Contact List and customize it to have the Vendor and Company Name column. The Vendor column indicates the Vendor's Name, while the Company Name will display the information below the amount from the check. Also when you Print the check, you will have the option to include the Company Name and Address.



 

You can refer to the attached screenshots below together with the steps:

 

  1. Go to Reports.
  2. Click List and choose Vendor Contact List.


     
  3. Select Customize Report.
  4. On the Displays page, customize the columns and put a check in the Vendors and Company.


     
  5. Click OK to apply customization.
  6. Tick Refresh.

 

You can utilize this article for future reference: Customize reports in QuickBooks Desktop.

 

For additional QuickBooks-related concerns, don't hesitate to post them here in the Community. We're always available and willing to lend a hand to your queries. Have a great day ahead.

Fiat Lux - ASIA
Level 15

Positive Pay File wth Name printed on check

@MattL 

Do you need to generate something like this one?

RefNumberBankAccountVendorPrintOnCheckNameTxnDateLocationAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryPrivateNoteToBePrintedCurrencyExchangeRateExpenseAccountExpenseDescExpenseAmountExpenseBillableStatusExpenseBillableEntityExpenseClassLineItemLineDescLineQtyLineUnitPriceLineAmountLineBillableStatusLineBillableEntityLineClass
101CheckingJoe's Coffee 01/10/2020 12 Main StreetSuite 102  AlbanyNY12345  N  General SuppliesGeneral Supplies85.21           
102CheckingCostco 01/10/2020 PO Box 1000   DallasTX28456  N  General SuppliesGeneral Supplies125           
103CheckingProperty Mgmt Assoc 01/10/2020 PO Box 1800   AlbanyNY12345 Mar 2011 RentN  RentRent1000           
MattL
Level 3

Positive Pay File wth Name printed on check

That's probably more details than I need.  I'm looking for a report I can download daily of our written checks for that day. The report needs the following: 

1. Issued Date -the date the check was issued (recommended format mm/dd/yyyy)
2. Check Number – the check serial number (recommended format is to have no leading zeros)
3. Check Amount - the amount of the check (recommended format 999999.99 with no leading zeros)
4. Payee Name – the name from the payee line on the check

Fiat Lux - ASIA
Level 15

Positive Pay File wth Name printed on check

1. Issued Date -the date the check was issued (recommended format mm/dd/yyyy) = TxnDate
2. Check Number – the check serial number (recommended format is to have no leading zeros) = RefNumber
3. Check Amount - the amount of the check (recommended format 999999.99 with no leading zeros) = ExpenseAmount
4. Payee Name – the name from the payee line on the check = PrintOnCheckName

 

CMIIW

JessT
Moderator

Positive Pay File wth Name printed on check

Hi MattL,

 

I can see that we got good information coming from Fiat Luz – ASIA. I also want to add that you can run the Check Detail report. It will give you the information you need, such as the payee, transaction date, amount, and transaction number of your check transactions.

 

  1. From the Reports menu, choose Banking.
  2. Select Check Detail.
  3. Set the From and To dates and click Refresh.

 

 

You can pull up the same report everyday. Just change the report dates. You can also customize the report further or export it to Excel to remove some information that you don't need.

 

Let me know if you need more help with creating a check report. Take care and have a good one!

BigRedConsulting
Community Champion

Positive Pay File wth Name printed on check

@JessT  Your report does not show the name as printed on the check. That is the very thing the customers want, and you just ignored their requests and showed them how to do what they already know how to do, to print a report with the name as it appears on the names lists.

 

Dude, this isn't rocket science. If you would read the customer's questions before answering, that would probably help.

jaylyons
Level 2

Positive Pay File wth Name printed on check

STOP IT!!! Just STOP IT Intuit!  Stop with the canned fluff language about "I can see how important it is..."  Either DO this SIMPLE FIX that was first requested almost FOUR YEARS AGO or just shut up about it!  You obviously make decisions internally about what you're going to add/fix and not, and what your existing customers need is not the determining factor, it's about getting more customers or capturing more revenue from existing ones.  I have been asking to be able to import a budget by class since Quickbooks Online was first released - what is it, 15 years ago now?  Just stop pretending you care what we need and just tell us to suck it up and find a workaround, because you might get to it some day, but probably not.  For me, I'm looking for a bigger workaround - not using Quickbooks anymore.

MattL
Level 3

Positive Pay File wth Name printed on check

Big Red Consulting, do you offer an automated upload so that the check file will be automatically transmitted from QB Desktop to our bank without having to manually create and upload the positive pay file?  

BigRedConsulting
Community Champion

Positive Pay File wth Name printed on check

@MattL 

Thanks for asking!

 

The BRC PositivePay file Creator - QB Desktop doesn't offer an automatic upload.

 

Still, creating the positive pay file to be uploaded is a huge time-saver in many cases. For some bank file formats, a technical solution to create the required file is really the only way to go, because trying to create the file manually would be practically impossible.

 

Among other niceties, the PositivePay tool will always use the Print As name, will optionally only include new checks in the upload files (some banks won't accept duplicates), and will create a human-readable report with each upload file that details the checks in the file.

 

It also features a free fully-functional 30-day trial period so you can try before you buy.

DavidRose
Level 1

Positive Pay File wth Name printed on check

I have used Big Red.  Easy and inexpensive solution, and it does keep track of the previous uploads for you.  And look how polite they are. 

4Gal
Level 11

Positive Pay File wth Name printed on check

@jaylyons 

I'm looking for a bigger workaround - not using Quickbooks anymore.

 

Unless you don't mind spending a lot of money on data conversion, you may need a workaround to access your historical data with QB Desktop.

boniato2
Level 1

Positive Pay File wth Name printed on check

Can't believe it's been over four years and this is still not available. There is no bank via Positive Pay that will accept reports from Quickbooks as they are. The option to select "NAME PRINTED ON CHECK" is 100% needed. What is Quickbooks waiting for? 

BigRedConsulting
Community Champion

Positive Pay File wth Name printed on check

RE: There is no bank via Positive Pay that will accept reports from Quickbooks as they are.

Do you mean generally how the report can be output, or with the Print As name missing? The workaround posted here for the latter is to make the Vendor and the Print As name the same. It seems that will work for some users.  For the former, though, yes different banks have many different requirements that you'll never be able to meet with a QuickBooks report. For example, it's likely you'll never be able to include the bank account or routing numbers on a QB transaction report, which many banks require.

 

RE: The option to select "NAME PRINTED ON CHECK" is 100% needed. What is Quickbooks waiting for? 

Yes, lots of things customers have asked for for decades are not yet available. Generally Intuit will only add features that they think many/most customers want, and creating Positive Pay files probably isn't one of them. They generally let 3rd parties solve such needs.

 

[Shameless plug...]

Again, if you need to use PositivePay with your bank and doing it manually is time consuming, I think our BRC PositivePay file Creator - QB Desktop , which includes about 170 bank file formats, will save you a lot of time and is a good solution. If your bank isn't listed, we can help you either create a custom file (there's a built in feature to do that) or we can add your bank to the list, usually within about a week.

dalfstad
Level 1

Positive Pay File wth Name printed on check

I can't believe this still isn't available as a standard report out of QB.  Bank of America has been pushing us for years to implement positive pay. How is is possible that such a simple report is still not available? 

 

This is the exact report we need as well.

 

I'm looking for a report I can download daily of our written checks for that day. The report needs the following: 

1. Issued Date -the date the check was issued (recommended format mm/dd/yyyy)
2. Check Number – the check serial number (recommended format is to have no leading zeros)
3. Check Amount - the amount of the check (recommended format 999999.99 with no leading zeros)
4. Payee Name – the name from the payee line on the check

AdonL
QuickBooks Team

Positive Pay File wth Name printed on check

I see how important this feature is for managing your checks, Dalfstad. Let me provide some details about this.

 

QuickBooks Desktop (QBDT) is constantly evolving based on user feedback, so I'll make sure your suggestion is forwarded to the Product Development Team. In this way, our software engineers will be informed about your needs and consider adding them for future product enhancements.

 

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, you can generate the Check Detail report, which will provide essential information like the date issued, transaction number, amount, and payee for your check transactions.

 

Additionally, check out this article where you can find information that can help guide you in managing your QuickBooks file: QuickBooks Desktop Help Articles.

 

You can utilize this article to tailor the data on your reports to your specific business needs, helping you gain relevant and actionable insights: Customize reports in QuickBooks Desktop.

 

If you have more questions, share them here in the Community. We're always here to help with your inquiries.

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

Need to get in touch?

Contact us