Skip to main content
Liberty4All
Oct 18, 2023 11:14 PM UTC
Solved

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?)

Maybelle_SAnswer
Oct 19, 2023 1:51 AM UTC

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 in thread

13 replies

Maybelle_SAnswer
Oct 19, 2023 1:51 AM UTC

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!

Liberty4AllAuthor
Oct 26, 2023 11:15 PM UTC

Thank you, Maybelle!! Much Appreciated!!!

Rubielyn_J
Rubielyn_J
Oct 27, 2023 12:38 AM UTC

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!

PctLogistics
Sep 19, 2024 9:21 PM UTC

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
MariaSoledadG
Sep 19, 2024 10:33 PM UTC

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
Sep 19, 2024 11:09 PM UTC

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
    Sep 20, 2024 12:59 AM UTC

    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.

    3. On the Transactions tab, double left click on the check you wish to review.
    4. Inside the check, go to the Reports tab and click on Quick Report or Transaction History.

     

    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!

    Terms & ConditionsAccessibility statement