I have the report you need to view your customer's actual notes in the program, @mmk3.
Based on your "notes" filter, it looks like you're using QuickBooks Desktop (QBDT). When adding notes on your transactions, the information will appear on the Detail level reports.
It could be you're running a Transaction level report, such as Transaction List by Customer. That's why the report only shows "has notes".
To help fix this, I'd suggest running and customizing the Sales by Customer Detail or Sales by Item Detail report. This way, you'll be able to see the actual notes for your customer. I'll guide you how.
The screenshot below shows you the last four steps.
Also, I've attached a screenshot below on how the Notes column looks like in the two reports.
Moreover, I recommend running other customer reports in QBDT. These will help you manage your sales and accounts receivable. You can also customize them to get the specific details you need for your business. For more information, visit this article: Customizing Customer, Job, And Sales Reports.
I'll be right here to help if you need anything else. Enjoy the rest of your day, @mmk3.
As another option, utilize the trial periof of TP Exporter to export your Invoice data.
You will get the list like this. Set filters as required.
|Customer||Transaction Date||RefNumber||PO Number||Terms||Class||Template Name||To Be Printed||Ship Date||BillTo Line1||BillTo Line2||BillTo Line3||BillTo Line4||BillTo City||BillTo State||BillTo PostalCode||BillTo Country||ShipTo Line1||ShipTo Line2||ShipTo Line3||ShipTo Line4||ShipTo City||ShipTo State||ShipTo PostalCode||ShipTo Country||Phone||Fax||Contact Name||First Name||Last Name||Rep||Due Date||Ship Method||Customer Message||Memo||Cust. Tax Code||Item||Quantity||Description||Price||Is Pending||Item Line Class||Service Date||FOB||Customer Acct No||Sales Tax Item||To Be E-Mailed||Other||Other1||Other2||Unit of Measure||AR Account||Currency||Exchange Rate||Sales Tax Code|
|Anne's Bakery||01/09/2020||100||Y||#########||Anne's Bakery||One Harbor Street||Anytown||NY||12345||USA||Anne's Bakery||One Harbor Street||Anytown||NY||12345||USA||(123) 456-7890||Non||Cabinets||10||Cabinets||1000||Non|
|Anne's Bakery||01/09/2020||100||Y||#########||Anne's Bakery||One Harbor Street||Anytown||NY||12345||USA||Anne's Bakery||One Harbor Street||Anytown||NY||12345||USA||(123) 456-7890||Non||Hardware||10||Hardware||50||Non|
|John's Barber Shope||02/09/2020||101||Y||#########||John's Barber Shope||1 Main Street||Anytown||NY||12345||USA||John's Barber Shope||1 Main Street||Anytown||NY||12345||USA||(999) 888-8888||Non||Blueprints||1||Blueprints||500||Non|
Thank you so much for trying to help Raymond. I did step by step what you recommended and the notes still aren't showing. As least I believe I have done as instructed. I tried both with customer detail and item detail. Do you see anything wrong with my process below?
There's nothing wrong with the process, @mmk3.
A few factors that we need to consider in filtering report are how it is being added. In your case, you'll want to use the contact list report to see all customers' notes. Let me guide you how.
With these steps, you'll be able to view all customers that have notes. You can also export this report to Excel for more in-depth customization. Just click Excel, then Create a New Worksheet at the top.
We also have a guide on reports and accounting that I'm sure you'll find helpful.
Please know that we're always here to help, so don't hesitate to swing by. Thanks for reaching out and more success to your business.
Thank you for trying to help but this is where I started. I can pull up the report as you instructed but all it says is "has notes", even if exported to Excel; no additional detail. I was hoping for a spreadsheet with the actual notes that have been typed in the notes field on each customer. Is this not possible?
Hey there, @mmk3.
Thanks for following up with us again.
Upon recreating the steps and running different reports myself. I too am getting the "Has notes" in the columns. I've done further research to find that this is product limitation with older versions of QuickBooks. To clarify, what version of QuickBooks are you using. For example, with my testing, I have used 2018.
Once I know which version you're using, I can provide additional information and submit feedback to our product developer team, so this could be considered in a future update.
I look forward to your response. Please let me know if you have additional questions or concerns. I'll be here to help you every step of the way. Take care!
**Say "Thanks" by clicking the thumb icon in a post
**Mark the post that answers your question by clicking on "Accept as solution"
I've given up on trying to get a report with my notes. I was considering moving to quickbooks online (my file is large) but because my note are vital, I will not make the change. I'm going to condense my desktop version and hope not to loose the notes. Do you know if the notes stay? I will be using a condense date 12/31/2017. Will I retain my notes from this point moving forward? FYI-Using QB Desktop Pro 2020
Thank you for getting back here in the Community, @mmk3.
I appreciate you sharing details about your concern. However, when you condense your data and transfer it to QuickBooks Online (QBO) from QuickBooks Desktop (QBDT). It will only carry over those transactions from your file.
For more information about moving your QBDT file to QBO, please refer to this article link: Move your QuickBooks Desktop file to QuickBooks Online.
Also, I've attached here a helpful article that you can read through when switching from QBDT to QBO: What to expect when you switch from QuickBooks Desktop to QuickBooks Online. This includes the things you should know and may notice when converting to QBO from QBDT.
Feel free to leave a reply below if you have further concerns with QuickBooks. I'll be around to help. Stays safe and take care always, mmk3.