Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
M
mmk3
May 15, 2020
Question

Notes

  • May 15, 2020
  • 2 replies
  • 1 view
I need a report that shows my customer's notes. When I run the report and include "notes" as a filter, the report shows is "has notes", but does not display the actual notes. How do I get the note contents to show on the report?

    2 replies

    R
    RaymondJayOQuickBooks Team
    QuickBooks Team
    May 15, 2020

    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. 

    1. Go to Reports from the top menu. 
    2. Select Sales. 
    3. Choose Sales by Customer Detail or Sales by Item Detail.
    4. Click Customize Report.
    5. Go to the Display tab.
    6. Enter Notes in the Columns field. 
    7. Check beside Notes. 
    8. Click OK.

     

    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. 

    M
    mmk3Author
    May 16, 2020

    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? 

    B
    Boss Frog
    February 16, 2022

    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


    I was having the same difficulty, but I finally found the notes that I had placed in each customer center header info or notes tab by using the above directions. If you select "Notes" for column then you get the "has notes" or not message. However, if you select "Note" for column, then you can see that actual customer's notes that you had put in their information section.

     

    I realize this may be too late to help you, but it may help someone else!

    Fiat Lux - ASIA
    Fiat Lux - ASIA
    Level 14
    May 15, 2020

    @mmk3 

    As another option, utilize the trial periof of TP Exporter to export your Invoice data. 

    https:// transactionpro.grsm.io/qbd

     

    You will get the list like this. Set filters as required.

    CustomerTransaction DateRefNumberPO NumberTermsClassTemplate NameTo Be PrintedShip DateBillTo Line1BillTo Line2BillTo Line3BillTo Line4BillTo CityBillTo StateBillTo PostalCodeBillTo CountryShipTo Line1ShipTo Line2ShipTo Line3ShipTo Line4ShipTo CityShipTo StateShipTo PostalCodeShipTo CountryPhoneFaxEmailContact NameFirst NameLast NameRepDue DateShip MethodCustomer MessageMemoCust. Tax CodeItemQuantityDescriptionPriceIs PendingItem Line ClassService DateFOBCustomer Acct NoSales Tax ItemTo Be E-MailedOtherOther1Other2Unit of MeasureAR AccountCurrencyExchange RateSales Tax Code
    Anne's Bakery01/09/2020100    Y#########Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonCabinets10Cabinets1000              Non
    Anne's Bakery01/09/2020100    Y#########Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonHardware10Hardware50              Non
    John's Barber Shope02/09/2020101    Y#########John's Barber Shope1 Main Street  AnytownNY12345USAJohn's Barber Shope1 Main Street  AnytownNY12345USA(999) 888-8888          NonBlueprints1Blueprints500              Non

     

     

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement