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

Vendor Credit Memo Report

I first have to say that the way credit memos are handled on the Vendor Payment screen makes me absolutely crazy. It is so tiny, hard to read and limited in information (a memo line would sure be helpful). In any case since it has been this way forever I'm sure it won't be changing anytime soon. 

My issue that I have been dealing with is I have a vendor with no less than 1000 open invoices at any one time and 100's of credit memos to match up to them. To make matters more complicated, I pay these invoices online through the BillTrust system which sucks worse than the QB credit memo screen (I can't apply the CM in QB to the open invoice or I can't find the open invoice and credit memo in BillTrust).

 

In any case, I started putting the target invoice in the memo line of the credit memo I set up, dumb I know, after realizing I can't see the memo line in the CM screen when I am paying bills. So then I though if I could print a vendor credit memo report that would display all the memo lines my problem would be solved. Well, easier said than done. I tried using the Vendor Open Balance report, which will not allow me to filter by transaction type for some reason. So then I tried the Transaction List by Vendor report and again it would not let me filter by transaction type.

Does anyone have a suggestion on how I can run a report by vendor, by transaction type within a date range? I even tried creating a custom report (not my strong point) and I couldn't get that to work either.

If I can't get a vendor credit memo report I will start putting the credit memo info in the target invoice because I know I can get the memo line to show on a Vendor Open Invoice report, but that means I have to start all over and I have 100's of CMs already set up this way :(

 

Thanks for your help!

Solved
Best answer August 26, 2020

Best Answers
Highlighted
QuickBooks Team

Vendor Credit Memo Report

Thanks for posting to the Community, @Txroofer.

 

Let me share with you a few insights on how to sort this kind of report all at once.

 

You mentioned that it doesn't allow you to filter by transaction type. This way, I'd suggest utilizing the verify and rebuild tool in QuickBooks Desktop to find and fix any errors.

 

Once QuickBooks verified and corrected any of these, you can pull up the Transaction List by Vendor and Transaction Detail by Account report. This way, you can customize these reports to show the vendor credit memo.

 

Here's how to run a customized Transaction List by Vendor:

  1. Go to Reports and then select Vendors & Payables, then choose Transaction List by Vendor.
  2. Click the Customize Report button.
  3. Go to Filters and then let's precisely include the customization by using the Search box:
    Date: choose a specified period;
    Detail Level: Summary only;
    Name: All vendors;
    Posting Status: Either;
    Transaction Type: Bill Credit.
  4. Click OK to run the report.

 

Also, you've mentioned earlier that you've added a memo line, the second report will give you the details by following these steps:

  1. Go to Reports and then select Accountant & Taxes, then choose Transaction Detail by Account.
  2. Click the Customize Report button.
  3. Go to Filters and then ensure to include the customization by using the Search box for Date: choose a period; Transaction Type: Bill Credit.
  4. Click OK.

This way, you get track all of your CMs.

 

You can also want to read this article to learn how to memorized reports: Create, Access and Modify Memorized Reports. It includes how to edit and delete a saved report. 

 

Just hit the Reply button if you have any other questions. I'll be right here to help. Take care!

View solution in original post

1 Comment
Highlighted
QuickBooks Team

Vendor Credit Memo Report

Thanks for posting to the Community, @Txroofer.

 

Let me share with you a few insights on how to sort this kind of report all at once.

 

You mentioned that it doesn't allow you to filter by transaction type. This way, I'd suggest utilizing the verify and rebuild tool in QuickBooks Desktop to find and fix any errors.

 

Once QuickBooks verified and corrected any of these, you can pull up the Transaction List by Vendor and Transaction Detail by Account report. This way, you can customize these reports to show the vendor credit memo.

 

Here's how to run a customized Transaction List by Vendor:

  1. Go to Reports and then select Vendors & Payables, then choose Transaction List by Vendor.
  2. Click the Customize Report button.
  3. Go to Filters and then let's precisely include the customization by using the Search box:
    Date: choose a specified period;
    Detail Level: Summary only;
    Name: All vendors;
    Posting Status: Either;
    Transaction Type: Bill Credit.
  4. Click OK to run the report.

 

Also, you've mentioned earlier that you've added a memo line, the second report will give you the details by following these steps:

  1. Go to Reports and then select Accountant & Taxes, then choose Transaction Detail by Account.
  2. Click the Customize Report button.
  3. Go to Filters and then ensure to include the customization by using the Search box for Date: choose a period; Transaction Type: Bill Credit.
  4. Click OK.

This way, you get track all of your CMs.

 

You can also want to read this article to learn how to memorized reports: Create, Access and Modify Memorized Reports. It includes how to edit and delete a saved report. 

 

Just hit the Reply button if you have any other questions. I'll be right here to help. Take care!

View solution in original post

Need to get in touch?

Contact us