Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi,
I am trying to export to Excel a report which contains a summerry of all the invoices issued, with the full contents of the descriptions. ( "memo" field ),
When I try this it just shows the product description for the products in the memo field, but other details in the memo are not shown.
I am on QB Premier 2021 Desktop
Regards
It's great to have you here, Sol. I understand how important it is to have detailed information for your records. In QuickBooks Desktop Premier, the reports generated can differ based on the data source and the specific criteria applied. I'm here to ensure we can accomplish your goal together.
Some reports are designed to display only certain pieces of data. This is why the product description appears in the Memo column instead of showing the detailed memo information you've entered.
We can run two reports and then consolidate both outside of QuickBooks. Let's begin by pulling up the Customer Invoices List. This shows a complete overview of all the associated item descriptions.
Now, let's run the Transactions List by Customer for the Memo descriptions:
Please see the attached screenshot for visual reference.
Once you have both reports in Excel, merge the data to view a comprehensive snapshot of all invoice details, including descriptions and memos.
Here's a helpful article to share tips and information about running and customizing reports: Understand reports.
Moreover, you can memorize the reports you've customized. This feature ensures you won't have to repeat the customization process.
I'll gladly assist you further in generating reports and managing invoices in QuickBooks Desktop. Feel free to click the Reply button below to share your questions with us.
I tried but didnt work
In our invoices , Product serial numbers are listed below the line item, I need a report exported to excel, to include alll the lines in the invoice description area.
Please see below.
Is there a way to include the invoice number in this download?
Hello there, ActiveSol and AGPS.
I'm here to assist you in running the report you're searching for.
In QuickBooks Desktop (QBDT), there's a report called Sales by Customer Detail that provides a comprehensive overview of your sales, with individual transactions sorted and subtotaled by customer, including invoice numbers and line items on each invoice.
To run and download the report, follow these steps:
That's all there is to it, ActiveSol and AGPS! If you have any other questions about getting the details of your invoices, feel free to let me know by adding a comment below. I'm always here to help.
Do you need to export data like this one?
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 | 15/09/2020 | 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 | 15/09/2020 | 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 | 15/09/2020 | 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 |
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here