Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI'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.
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.