cancel
Showing results for 
Search instead for 
Did you mean: 
Liberty4All
Level 1

Check Detail Report?

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
Best answer October 18, 2023

Best Answers
Maybelle_S
QuickBooks Team

Check Detail Report?

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.

 

  1. Go to the Reports menu.
  2. Hover over Banking and choose Check Detail.
  3. Click the Excel button at the top.
  4. Choose Create New Worksheet.

 

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!

View solution in original post

13 Comments 13
Maybelle_S
QuickBooks Team

Check Detail Report?

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.

 

  1. Go to the Reports menu.
  2. Hover over Banking and choose Check Detail.
  3. Click the Excel button at the top.
  4. Choose Create New Worksheet.

 

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!

Liberty4All
Level 1

Check Detail Report?

Thank you, Maybelle!! Much Appreciated!!!

Rubielyn_J
QuickBooks Team

Check Detail Report?

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!

blynn1982
Level 1

Check Detail Report?

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.

MirriamM
Moderator

Check Detail Report?

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.

jblynn1982
Level 1

Check Detail Report?

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.

IrizA
QuickBooks Team

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: 

 

  1. Go to the Reports menu. 
  2. Click the Vendors & Payables dropdown and select Vendor Contact List
  3. Press the Excel dropdown and choose Create New Worksheet or Update Existing Worksheet
  4. You'll have to choose what you like to do with your report. Tick if you want to create a new worksheetupdate an existing worksheet, replace an existing worksheet, or create a comma separated values (.csv) file
  5. Click Export

 

 

To export the Check Detail report, follow these steps: 

 

  1. Go to the Reports menu. 
  2. Click the Banking dropdown and select Check Detail
  3. Press the Excel dropdown and choose Create New Worksheet or Update Existing Worksheet
  4. You'll have to choose what you like to do with your report. Tick if you want to create a new worksheetupdate an existing worksheet, replace an existing worksheet, or create a comma separated values (.csv) file
  5. Click Export

 

After exporting and making changes in your Vendor Contact List using Excel, you can import and print them on check. Here's how: 

 

  1. After importing, Go to the Reports menu and select Vendors & Payables
  2. In the Vendors & Payables dropdown, choose Vendor Contact List
  3. Press the Customize Report.
  4. Under the Display Tab, select print on check within the Columns field. 
  5. Press Ok. 

 

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. 

PctLogistics
Level 1

Check Detail Report?

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. 

MariaSoledadG
QuickBooks Team

Check Detail Report?

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:

 

  1. Go to the Reports menu, then select Report Center.
  2. Under the Search bar, type in the Expense by Vendor Detail report.

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. 

PctLogistics
Level 1

Check Detail Report?

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.

JustinDaveC
QuickBooks Team

Check Detail Report?

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:

  1. Under the Vendors tab, select Vendor Center.
  2. From the names list, choose the vendor you want to review the transactions.
    image.png
  3. On the Transactions tab, double left click on the check you wish to review.image.png
  4. Inside the check, go to the Reports tab and click on Quick Report or Transaction History.

image.png

 

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!

PctLogistics
Level 1

Check Detail Report?

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!

AbegailS_
QuickBooks Team

Check Detail Report?

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:

 

  1. Click on the Help menu located at the top.
  2. Select Send Feedback Online, then click Product Suggestion.
  3. Type in your feedback or feature request.
  4. Click the Send Feedback button.

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

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

Need to get in touch?

Contact us