Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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:
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.
Do you need to generate something like this one?
RefNumber | BankAccount | Vendor | PrintOnCheckName | TxnDate | Location | AddressLine1 | AddressLine2 | AddressLine3 | AddressLine4 | AddressCity | AddressState | AddressPostalCode | AddressCountry | PrivateNote | ToBePrinted | Currency | ExchangeRate | ExpenseAccount | ExpenseDesc | ExpenseAmount | ExpenseBillableStatus | ExpenseBillableEntity | ExpenseClass | LineItem | LineDesc | LineQty | LineUnitPrice | LineAmount | LineBillableStatus | LineBillableEntity | LineClass |
101 | Checking | Joe's Coffee | 01/10/2020 | 12 Main Street | Suite 102 | Albany | NY | 12345 | N | General Supplies | General Supplies | 85.21 | |||||||||||||||||||
102 | Checking | Costco | 01/10/2020 | PO Box 1000 | Dallas | TX | 28456 | N | General Supplies | General Supplies | 125 | ||||||||||||||||||||
103 | Checking | Property Mgmt Assoc | 01/10/2020 | PO Box 1800 | Albany | NY | 12345 | Mar 2011 Rent | N | Rent | Rent | 1000 |
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
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
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.
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!
@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.
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.
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?
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.
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.
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.
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?
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.
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
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:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here