Is there any way to get an Excel report showing check details like is on the check stub? (I forgot to run an unpaid bills report before a big check run and should be able to run a check run detail report, right?)
Solved! Go to Solution.
I can help you generate a report that displays the check details in QuickBooks Desktop (QBDT), Liberty4All.
Yes, you're right. We can run the check detail report and export it to view the information. I'll guide you on how to do it.
Additionally, if you wish to view the specifics of each transaction, click on the corresponding check.
By running the data and exporting it to Excel, you'll obtain a detailed report showing the check details included in the check stubs, Liberty4All. Let me know if you have other questions by adding a comment below. I'm more than happy to help. Take care!
I can help you generate a report that displays the check details in QuickBooks Desktop (QBDT), Liberty4All.
Yes, you're right. We can run the check detail report and export it to view the information. I'll guide you on how to do it.
Additionally, if you wish to view the specifics of each transaction, click on the corresponding check.
By running the data and exporting it to Excel, you'll obtain a detailed report showing the check details included in the check stubs, Liberty4All. Let me know if you have other questions by adding a comment below. I'm more than happy to help. Take care!
Thank you, Maybelle!! Much Appreciated!!!
It's a pleasure to have you here again, @Liberty4All.
I’m glad that my colleague Maybelle_S was able to help with your concern.
We want you to feel comfortable reaching out to the Community space whenever you have any concerns or questions related to QuickBooks.
If you need tips and resources to manage your QuickBooks Online account and finances, feel free to visit our Support page to learn more. This provides information to help your navigation experience be more effective.
Let us know if you have other questions about managing your account in QuickBooks. We'll be happy to lend a helping hand. Have a wonderful day!
How do you add the "pay to the order of" field to the check detail. For our Positive pay file, we have to have upload the exact name on the check, but i cannot find that information to add to any report with check numbers.
It's good to see you on the thread, blynn1982.
I'd like to provide some information about running the Check Detail report.
Currently, there isn't a feature available to include the Pay to the Order of column in the Check Detail report. Nevertheless, the name associated with the Pay to the Order of transaction will be displayed in the Name column, which is indicated in bold. The name adjacent to it represents the Customer:Job name.
For your visual reference, see the below screenshot.
If you wish to preserve the customized report settings for future use, you can memorize the reports. For additional information, please refer to this article: Create, access and modify memorized reports.
For future reference, here's a great resource to help you close out your current year and prepare for the new year in QuickBooks with your accountant: Year-end guide for QuickBooks Desktop.
If there's anything else you need help with, please let me know by commenting below. I'm always here to answer any questions you may have. Take care.
Does the "Pay to the Order of" field show in any reports? We have to create a positive pay file for our bank that contains the exact name on the check or it will not go through and it often differs from what is on the check detail report.
Hey there, jblynn1982. Welcome to the Community.
The field named Pay to the Order of in reports is currently unavailable in QuickBooks Desktop (QBDT). However, since you wish to include it in your reports, you'll have to export the Vendor Contact List and the Check Detail reports from QBDT for you to make changes.
To export the Vendor Contact List, follow these steps:
To export the Check Detail report, follow these steps:
After exporting and making changes in your Vendor Contact List using Excel, you can import and print them on check. Here's how:
You can also refer to these materials to learn more about how to run a report and import your data in QBDT:
In addition, you may also access our self-help article and see some related articles that can help with your future transactions.
If you have questions other than reports, kindly enter your concerns in the comment section for us to assist you. I'll be around to help.
Vendor credit memos you use when paying invoices are not showing up on the check detail report. The vendor needs to know what open bills and credit memos were used and support the amount of the check payment. How can I get that info? Check detail report just shows a short paid invoice, not that a specific credit memo was applied to the invoice.
Let me guide you through the process of getting open bills and credit memos to appear on your report, PctLogistics.
The Check Detail report only shows the checks you've written, which include the date, payee, and amount, as well as the expense and bill payments created. You can run the Expense by Vendor Detail report to display the information instead. To do so, follow the steps below:
Additionally, QuickBooks Desktop has a feature that allows you to save a report to its current customization setting. To know more, read this article for reference: Create, Access, and Modify Memorized Reports.
I'm all ears if you have any other questions about open bills and credit memos in QuickBooks. Please know, that we're always right here to help you anytime.
Thank you but that's not what I need. The vendor is not seeing how we apply their credit memos when we pay the bills. We have hundreds of bills and at least a hundred credit memos for the year. They want to know on check #1234 what bills did you pay and what credits were applied to those bills. Otherwise they think we are short paying the bills. How can I get them that information on a check by check basis? Thanks.
Thank you for coming back to this thread, PctLogistics. Let me walk you through the process of checking your bills with its applied added credits.
Currently, there's no default option to generate a report that shows bills with their corresponding applied credits on a check-by-check basis. As a workaround, we can manually open each bill to see the credits applied.
To review the bills, here's how:
Additionally, visit this article to customize reports in QuickBooks Desktop based on your preferences and customization. This way, you can personalize the style and content of your reports.
Should you have any other questions or need further assistance about checking bills with its credits in QuickBooks Desktop, please don't hesitate to reply. I'll be around to ensure your concerns are taken care of. Keep safe!
The transaction history just shows a bill with zero paid - it does not show the credit used. See attached.
Really need a report that shows this!!!! The vendor has hundreds of bills and credits and we can't tell them what credits are applied to what invoices. It's a mess!
Thanks for joining, @PctLogistics.
I understand the importance of having a report showing which credits are applied to specific invoices, especially given the volume of bills and credits involved.
Your feedback is constructive, and I encourage you to send your suggestions directly to our development team for consideration. I'm here to share the steps to submit a feature request to make it available. We strive to deliver high-quality service to our users, and our utmost priority is ensuring our product is user-friendly. Here's how:
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
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