cancel
Showing results for 
Search instead for 
Did you mean: 
JamesAndrewM
QuickBooks Team

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 2

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 2

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 10

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.

Need to get in touch?

Contact us