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

Can I generate a credit memo report to track all credits in the account? Thanks! Sue

 
Solved
Best answer October 15, 2018

Best Answers
Kristine Mae
Moderator

Can I generate a credit memo report to track all credits in the account? Thanks! Sue

Hello Sue,

You can pull up the Transaction List by Customer report, and customize it to show the credit memos only. Here's how:

  1. Go to Reports
  2. Choose the All Reports tab.
  3. Go to Review Sales.
  4. Select Transaction List by Customer.
  5. Click Customize.
  6. Click the arrow next to Filter.
  7. Click the Transaction Type drop-down arrow, then choose Credit Memo.
  8. Click Run report.
I have attached a screenshot for your reference.

Let me know if you need something else. All the best! 

View solution in original post

18 Comments 18
Kristine Mae
Moderator

Can I generate a credit memo report to track all credits in the account? Thanks! Sue

Hello Sue,

You can pull up the Transaction List by Customer report, and customize it to show the credit memos only. Here's how:

  1. Go to Reports
  2. Choose the All Reports tab.
  3. Go to Review Sales.
  4. Select Transaction List by Customer.
  5. Click Customize.
  6. Click the arrow next to Filter.
  7. Click the Transaction Type drop-down arrow, then choose Credit Memo.
  8. Click Run report.
I have attached a screenshot for your reference.

Let me know if you need something else. All the best! 
Bluemanta
Level 2

Can I generate a credit memo report to track all credits in the account? Thanks! Sue

How can I add totals to this report? Is there similar report with totals?
bythesea
Level 1

Can I generate a credit memo report to track all credits in the account? Thanks! Sue

How is this done in QB Desktop 2018?

Rose-A
Moderator

Can I generate a credit memo report to track all credits in the account? Thanks! Sue

Hey there, @bythesea.

Allow me to help you with generating a credit memo report in QuickBooks Desktop.

 

You can also pull up the Transaction List by Customer report and customize it to show the credit memos only.

 

Let me show you how:

  1. Click the Reports at the top menu bar.
  2. On the drop-down (▼) list, click Customers & Receivables and choose Transaction List by Customer.
  3. Click the Customize Report button.
  4. Go to the Filters tab.
  5. In the filter search box, type, and select Transaction Type.
  6. Under Transaction Type drop-down (▼), choose Credit Memo.
  7. Hit OK.

To guide you through the steps, please see screenshots below.

 

 

I'll be around here in the Community, so please feel free to reach out to me if you have any other concerns. Wishing you a wonderful rest of the week.

Lois J McFadden
Level 1

Can I generate a credit memo report to track all credits in the account? Thanks! Sue

My QuickBooks 2019, Desktop Pro, does not give the option of Credit Memos or Refunds to choose from in the Transaction List. That is the report that I want and cannot get. Can you help? Thanks.

AileneA
QuickBooks Team

Can I generate a credit memo report to track all credits in the account? Thanks! Sue

Hi there, @Lois J McFadden

 

Thank you for reaching out to the Community. I'm here to help you sort this out. We can fix this by performing the Rebuild utility tools in QuickBooks Desktop. This way, it'll return to its default order and automatically fixes minor company file data issues. Though, you need to back up your data first before performing these steps below to save your company data if file damage occur. 

 

Let me show you how:   

 

  1. Click the File tab at the top. 
  2. Select Utilities from the drop-down option. 
  3. Choose Rebuild Data
  4. Click Ok on Rebuild has completed. 

rebuil data.PNGrebuild d.PNG

 

After rebuilding data, we can close and reopen your file to revamp it.     

 

For additional information on these, I recommend the following articles: 

 

 

Please let me know how it works. I want to make sure that everything is taken care of. I'm here to provide any additional assistance if needed. Have a good one!

Thupten
Level 1

Can I generate a credit memo report to track all credits in the account? Thanks! Sue

Why you say All Reports? It is under All Sales. 

KennethA_
QuickBooks Team

Can I generate a credit memo report to track all credits in the account? Thanks! Sue

Thank you for reaching out to us, @Thupten.

 

I'll be happy to help you with your concern related to the Reports.

 

Yes, you're correct, it is under All Sales.

 

You can locate credit memos on the list of transactions customer detail page.

Here's how:

 

1. Select Sales.

2. Choose Customers.

3. In the list, select the Customer you'd like to print the credit memo for.

4. In the Transaction List you can view the credit memo.

5. Click the memo to open it.

6. Select Print or Preview.

 

You can also check this article: Run reports in QuickBooks Online for more information about reports.

 

We're always here in the Community to help if you have other questions related to QuickBooks. Stay safe!

 

 

WhitneyGreenTree
Level 1

Can I generate a credit memo report to track all credits in the account? Thanks! Sue

I'm able to see the credit memo and open balance, but how do I see all of the transactions that they've used their credit memo towards?

WhitneyGreenTree
Level 1

Can I generate a credit memo report to track all credits in the account? Thanks! Sue

I was able to get a report of the credit memo and open balance, but how do I see each transaction that they used their credit towards?

Rasa-LilaM
QuickBooks Team

Can I generate a credit memo report to track all credits in the account? Thanks! Sue

Thanks for joining this thread, WhitneyGreenTree.


I’ll help make sure you can see all transactions the credit memo is used for. Let’s open the sales entry one at a time and click the payment made link to see the complete details.

 

  1. Navigate to the Sales menu on the left panel and select All Sales.
  2. This will take you to the Sales Transactions page.
  3. Click the Filter drop-down to sort the information.
  4. Choose Credit memos from the Type drop-down
  5. Enter the correct period in the Date field.
  6. Press the Apply button for the changes to take effect.cm.png
  7. From the list, click the credit memo you’re working on to open the transaction details.
  8. n the PAID section, press the 1 payment made link and the date to show the Receive Payment page.cm.1.pngcm.1.png
  9. G to the Outstanding Transactions section and check the entries from there.cm2.png

 

I’m also adding a link to help you in the future: Self-help articles. It contains topics about customizing invoices, customer statements, refunds and credits, and other customer-related activities.


Reach out to me anytime if you have other questions about credit memos and other sales transactions. I’m more than happy to answer them for you.

lcdexcavation
Level 1

Can I generate a credit memo report to track all credits in the account? Thanks! Sue

Can this report be generated for vendor bills to see what vendor credits are applied to which bills when paying bills?

Kevin_C
QuickBooks Team

Can I generate a credit memo report to track all credits in the account? Thanks! Sue

I admire you for joining this thread, @lcdexcavation. I'll make sure you can run the report that shows the applied bill payments to bills or credits in QuickBooks Online (QBO).

 

Yes, we can generate a Bills and Applied Payments report. Let me guide you through:

 

  1. Go to the Reports menu.
  2. Scroll down to the What you owe section and look for Bill and Applied Payments.
  3. You can also type in the name of the report in the Find report by name search bar to easily find it.

 

Report.png

Reporttt.PNG

 

Please refer to this link to learn about the reports available for your QBO versions: Reports included in your QuickBooks Online subscription

 

Let me also share these articles that you can check out to learn more about memorizing and customizing reports in QBO:

 

 

Don't hesitate to reach out to us again if you have other reporting questions. We're always here for you. Have a great day ahead!

lcdexcavation
Level 1

Can I generate a credit memo report to track all credits in the account? Thanks! Sue

Thank you Kevin for your response but I am using Quickbooks Desktop Enterprise. 

 

MirriamM
Moderator

Can I generate a credit memo report to track all credits in the account? Thanks! Sue

Hi there, @lcdexcavation.

 

In QuickBooks Desktop (QBDT), we have the Transaction List by Vendor report you can run to see the vendor's payment, bill, and the credit applied.

 

To pull up the report, here's how:

  1. Go to the Reports menu at the top. 
  2. Select Vendors & Payables.
  3. Choose Transaction List by Vendor.
  4. Click the Customize Report button if you'd want to filter the report.

 

To learn more about customizing the report based on your needs, see this resource: Customize reports in QuickBooks Desktop.

 

You can also visit our self-help articles on our QuickBooks help articles page to help you get your QuickBooks task done in no time. 

 

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

Nathan_Sentinel
Level 1

Can I generate a credit memo report to track all credits in the account? Thanks! Sue

I can generate the credit memo report showing all Credit Memos created based on specific dates, but I want to see a report that shows only those credit memos that still have unapplied balances.  For example, a credit memo that has not been applied to any invoices yet, or a credit memo that has partially been applied to an invoice(s).

I am using QB Desktop Pro Plus 2022

The Big Cahoona in CT
Level 1

Can I generate a credit memo report to track all credits in the account? Thanks! Sue

I would like that info also. Can that report show if it's a customer or vendor? Or does that have to be in two separate reports? Many of my Customers are also a Vendors so I have to see both sides A/P & A/R to know where we stand on who owes whom money.

 

Wayne

AileneA
QuickBooks Team

Can I generate a credit memo report to track all credits in the account? Thanks! Sue

Hello, The Big Cahoona in CT. 

 

QuickBooks Online is an excellent accounting software that provides users with powerful reporting tools to help them manage their finances effectively. One of the most popular reports available in QuickBooks Online is the Transaction List by Vendor report, which provides users with a detailed view of all transactions related to a particular vendor. 

 

The Transaction List by Vendor report is a comprehensive tool that allows users to view all transactions associated with a specific vendor, including purchases, payments, credit apply, and expenses. This report can benefit businesses that work with multiple vendors, providing a quick and easy way to track all transactions related to a particular vendor. 
 

In addition to helping users manage their accounts payable, the Transaction List by Vendor report can also identify discrepancies or errors in vendor transactions. By reviewing the report regularly, users can quickly identify any duplicate payments, overpayments, or other issues that must be addressed.
 

Here's how to run the report: 

 

  1. Click the Reports and choose Reports.
  2. Enter the Transaction lists by vendor in the search bar.
  3. Tap Customize and select the info you need, like the date, and filter the data you need.
  4. Press Run report.

 

 

Furthermore, learn how to change your reports' appearance by filtering them to show the correct information you need for your business. Go through this article for reference: Customize Reports In QuickBooks Online.

 

Additionally, you can memorize this report. This feature streamlines the entire customization process and saves you the hassle of redoing it. 

 

I'm available to help you run your reports if you need further assistance. Have a great day!

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

Need to get in touch?

Contact us