cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to run a report that show which credit memo was to on an invoice?

 
Solved
Best answer 12-10-2018

Accepted Solutions
Established Community Backer ***

Open invoice or credit memo and use History (or, Ctl H)....

Open invoice or credit memo and use History (or, Ctl H). For any transaction in QB, here is everything linked to it, and use Go To or print this.

18 Comments
Established Community Backer ***

Open invoice or credit memo and use History (or, Ctl H)....

Open invoice or credit memo and use History (or, Ctl H). For any transaction in QB, here is everything linked to it, and use Go To or print this.

Not applicable

Perfect way! Thanks

Perfect way! Thanks
Established Community Backer ***

"But what I am trying to do is run some kind of Customer...

"But what I am trying to do is run some kind of Customer transaction report that list all invoice and then what credit memo was used on each and every invoice."

The closest you can get is running a Statement.

Not applicable

Thanks, that was helpful! I didn't know I could do that....

Thanks, that was helpful! I didn't know I could do that.

But what I am trying to do is run some kind of Customer transaction report that list all invoice and then what credit memo was used on each and every invoice. 

Example: 

   First line item is the Invoice number

   2nd line item is the Credit memo used on the invoice.

then another invoice followed by the credit memo (if any was applied)

Community Contributor *

Were you able to create the report you wanted? I am wanti...

Were you able to create the report you wanted? I am wanting to create the same report and am having difficulties doing so. Any help would be appreciated.
Established Member

Re: Were you able to create the report you wanted? I am wanti...

I also need a report like this. If anyone found it, please let me know. Thank you in advance.

Established Member

Re: Were you able to create the report you wanted? I am wanti...

I also need a report like that. Did anyone find anything? If so, please share. Thank you in advance.

QuickBooks Team

Hello lilben31,    Thanks for sharing the format and deta...

Hello lilben31, 

 

Thanks for sharing the format and details you want to see on a specific customer report. I can provide some insights about this in QuickBooks.

 

At this time, customizing any kind of customer transaction list reports with the view you need is unavailable. Both invoices and credit memos are called Transaction Types and they are under one column, which is why we can't separate them. You're just able to select either one or both to appear.

 

As what @qbteachmt mentioned above, the closest you can use is the Statement. However, there isn't a way to differentiate these types into two line items. 

 

For more information about how reports work in QuickBooks Desktop, check out the article below:

 

Understand reports 

 

I can see the importance of having such report in the program. The Community recognizes feedback and suggestions from customers like you which can help us improve our product and services to our customers' delight.

 

You can let our product engineers hear your thoughts by going to the Help menu, then selecting Send Feedback Online. I'll do the same thing from my side so we're hitting them through both employee and customer channels. 

 

Be sure to let me know if there's anything else you need, I want to make sure you're taken care of.

 

Have a great day!

QuickBooks Team

Re: Hello lilben31,    Thanks for sharing the format and deta...

Thanks for joining us here, @AWJIN and @mvonhaus

 

I appreciate you letting me know how the report suggested by @lilben31 can also help run your businesses. I have some additional details to share about this. 

 

This type of report isn't yet available in QuickBooks Desktop. @qbteachmt provided great options above which you can use to show both credit memos and invoices. You can't separate them per line items though.

 

Here's an article for more information:

 

Understand reports

 

While this isn't available, you'll want to add up to the suggestions raised by other users about this. The more requests and vote feedback has, the more likely it gets prioritized as a highly requested feature. To add to their voices, go to Help at the top menu bar, then Send Feedback Online

 

Please let me know if there's anything I can do here to help you succeed. I'll gladly help! 

Established Member

Re: Hello lilben31,    Thanks for sharing the format and deta...

I think I may have found the answer to your question:

 

1.  Go to Reports>Banking>Check Detail

2.  Select Customize Report

3.  Click on Filter Tab

4.  Modify Report as follows:

     Account:  All Accounts

     Date:  Specify the date you desire

     Detail Level:  All

     Transaction Type:  Credit Memo

5.  Select OK

 

This should show you the Credit Memos for the date specified and the invoices and items it applied to.  You can also run this for PAYMENTS.  Just change the Transaction Type to PAYMENT. 

 

I hope this helps!

    

 

Community Contributor **

Re: Hello lilben31, Thanks for sharing the format and deta... This feature SHOULD be available in a report of transactions for a customer. Otherwise, how can you see or give a detailed analysis of a customer account balance? Right now, when a credit is applied to an invoice, you have to go to the history of the credit or invoice to see it? Seriously? This is a problem that needs to be addressed. I have seen the workarounds and feel they are not acceptable. If I have to give a customer a report of their account, this needs to be visible and not a mystery that I have to first find myself and then explain to them.

 
QuickBooks Team

Re: Hello lilben31, Thanks for sharing the format and deta... This feature SHOULD be available in...

I appreciate you for sharing your suggestion here in the QuickBooks Community, tsd81. 

 

I understand how the report that shows which credit memos that were linked to invoices would be beneficial to your business. I'll make sure to take note of this and will inform you once we receive product enhancement update about the availability of this option.

 

For the meantime, you may want to consider the workarounds provided by my colleagues on their posts above. 

 

Please know that you're always welcome to post if you have any other concerns. Have a good one. 

 

 

 

 

Frequent Explorer *

Re: Hello lilben31, Thanks for sharing the format and deta... This feature SHOULD be available in...

Hello,

The inability to run a report to provide as back up with our payments to vendors is a real challenge, and creating issues with our accounting matching the vendor accounting. We can run a Bill Payment Stub to send with our cheque to a vendor, but this report does not list the invoices we cleared with credits. Therefore the vendors are clearing their selection of invoices with credits, and we are clearing a different selection of invoices with credits. The difference between how we are managing the credits on account and how the vendors are managing the credits means they are showing outstanding invoices we've noted as paid, and we are paying invoices they no longer show as outstanding. QB, please update your Bill Payment Stub to list the applied credit transactions that were completed during the pay bill transaction. Thank you.

Moderator

Re: Hello lilben31, Thanks for sharing the format and deta... This feature SHOULD be available in...

Glad to have you back, @mswanson.

 

I can provide a report where you can check on the credits applied to a bill in QuickBooks Desktop.

 

You can pull up and customize the Check Detail report as it shows all the transactions connected to the bill.

 

Let me guide you how:

  1. Click on Reports at the top menu bar.
  2. Select on Banking.
  3. Choose Check Detail.
  4. Enter the date range of the transaction that you wish to pull up.
  5. Click on Customize Report.
  6. Refer to the Filters tab.
  7. Under the Choose Filter tab, choose Transaction Type.
  8. From the Transaction Type section, select Bill.
  9. Go back to the Choose Filter tab, and click on Account.
  10. Under Account, select All Accounts.

Credits applied1.PNG

From there, you can select each bill to see the tally of the payments including credits applied.

 

To give you more insights about customizing reports in QuickBooks Desktop, please check out this link: Customize reports in QuickBooks Desktop.

 

Also, you can check out the What's New section on your QuickBooks for some updates about our product improvements.

 

Here's how:

  1. Click on Help at the top menu bar.
  2. Select on New Features.
  3. Choose New Feature Tour.

Lastly, if you have any concerns that requires live technical support, you can always reach out to our Customer Care Team.

 

There you have it.

 

Please let me know if there's anything else you need about this concern. I'll be around to help you out. Have a great day!

Frequent Explorer *

Report to list Bill Credits and which Bills the Bill Credits were applied to

Hello,

 

Thank you for this information, unfortunately the report didn't show what we are looking for. I added displaying Paid and Pay Method but this didn't help either. I also tried changing the Transaction Type from Bill to Bill Credit. Either way, it did not list the Bills that were 'paid' with Bill Credits. 

 

I ran a report earlier using the method provided in this conversation thread but changed the Transaction Type to Bill Credit, and added a further Name filter to narrow it down to a specific Vendor. It did provide the information we were looking for, but in so much detail that it isn't a usable report to provide vendors as back up to cheque, even after removing several unneeded columns. Often one Bill Credit is applied to multiple Bills, and often there are multiple Items with one Bill. So for example, one Bill Credit with four items lists on the report:

Bill Credit, 1st Item, All invoices cleared with this Bill Credit, then again same Bill Credit, 2nd Item, and All the same invoices cleared with this Bill Credit, then again same Bill Credit, 3rd Item, and all the same invoices cleared with this Bill Credit, etc. So one Bill Credit with 4 items clearing 10 Bills will repeat all Bills cleared with each Item, causing one Bill Credit transaction to span multiple pages of the report. The report display is hard to describe, and I'm not sure I've done it well, so I've attached a sample report. In summary, we need a simple report to share with vendors so they can easily, and simply see which Bills we've cleared with Bill Credits, so they do the same in their system.

QuickBooks Team

Re: Report to list Bill Credits and which Bills the Bill Credits were applied to

Hello mswanson,

 

Thank you for keeping in touch with us here in the Community. I want to help provide additional clarification about the vendor report you need in QuickBooks Desktop.

 

Right now, the only available option you have for the applied credits is to run the bill transaction history. Running a report that will show transactions applied to a bill is unavailable at this time.

 

Here are the steps:

 

  1. Click the Vendors tab at the top menu bar.
  2. Click Vendor Center.
  3. Go to the Vendors tab.
  4. Select a vendor.
  5. Go to the vendor's Transactions tab.
  6. Double-click to open the bill.
  7. Press and hold the Ctrl + H key.

For your visual guidance, please refer to these screenshots:

 

 

 

You can also try to run a custom Transaction Detail report to show your bills and credits through these steps:

 

  1. Click the Reports tab at the top menu bar.
  2. Select Custom Reports.
  3. Click Transaction Detail.
  4. Go to the Filters tab.
  5. Below Filter, click Transaction Type.
  6. Click Multiple Transaction Types.
  7. In the Select Transaction Types, put a check mark on the transactions you want to show.
  8. Click OK.

 

I'll be personally taking note of your request regarding the vendor report to ensure we'll be able to help you and your firm succeed.

 

Fill me in anytime you have clarifications or questions regarding your reporting needs, and the Community will be sure to get back to you.

Frequent Explorer *

Re: Report to list Bill Credits and which Bills the Bill Credits were applied to

Thank you for your time and consideration.

QuickBooks Team

Re: Report to list Bill Credits and which Bills the Bill Credits were applied to

Hi again, mswanson.

 

Let me start by saying how much I appreciate your intent to help improve the reporting feature in QuickBooks Desktop.

 

In addition to the information above, please update your QuickBooks to the latest release to ensure you have the new options and features.

 

Here are the steps:

 

  1. Click the Help tab at the top menu bar.
  2. Click Update QuickBooks Desktop.
  3. Go to the Update Now tab.
  4. Put a check mark on the box beside Reset Update.
  5. Click Get Updates.

For your guidance, please see this sample screenshot:

 


While waiting for the availability of the report, I recommend bookmarking the article about customizing reports:

 

Customize reports in QuickBooks Desktop.

 

Please know I'm always available anytime you have questions or concerns with vendor reports. You have a productive rest of your day.