Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowIs there a way to add the Bill To Name, Bill To City, Bill To State and Bill To Zip to the "Sales by Customer Detail" report?
When I go to Customize report, there is no option for any Bill To fields to be added to the report.
Are there any reports in QB that link Sales Items and Customers with Bill To information?
Solved! Go to Solution.
Thank you for posting here in the Community, @KAY15.
In customizing your sales by customer report, you can add the name of the city, state, and zip.
Here’s how.
You may also create specific custom reports in QuickBooks Desktop to focus on the information that matters most to your business. Please check out this link. Customize reports.
Feel free to fill me in if you have any other questions. Have a nice day!
Thank you for posting here in the Community, @KAY15.
In customizing your sales by customer report, you can add the name of the city, state, and zip.
Here’s how.
You may also create specific custom reports in QuickBooks Desktop to focus on the information that matters most to your business. Please check out this link. Customize reports.
Feel free to fill me in if you have any other questions. Have a nice day!
Hi @Pabz_L ,
I tried to do that but all I got was the prefilled address for that customer item on our customer center.
What we have is we have a lot of new customers who we usually file under the customer name, NEW, and these usually only just purchase once or twice from us so we don't want to have to make a new customer file for every new customer as we get a lot of them.
We use the BILL TO field on the top right of the create invoice module to indicate who they will be billed to. I see that the custom reports have a Ship To field which can be exported, but I don't see anything about a Bill To. Does this mean it's not possible to export this?
We also need to export the customer message on the lower left part of Quickbooks so if you know anything about that, help would also be greatly appreciated. Many thanks for reading this!
Hello there, vinseyjulip.
We're unable to add the Bill To Name, Bill To City, Bill To State, Bill To Zip columns on a report and then export it. We'll have to open each transaction and look into the billing address. I'll surely take this feedback to add these option on a detailed report.
On the other hand, if the Bill To information is the customer's default address, you can export a Customer Contact List and add the Bill To information. Here's how:
You can always post your questions here if you need more help. You take care always and have a great day!
Utilize one of these 3rd party tools to export the Sales Receipt data
https:// transactionpro.grsm.io/qbd
https:// partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2
The standard output should be like this. You may set filters to export certain data fields.
Customer | Transaction Date | RefNumber | Payment Method | Check Number | 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 | Shipping | Handling | Discount | SalesTax | Deposit To | Is Pending | Item Line Class | Service Date | FOB | Customer Acct No | Sales Tax Item | To Be E-Mailed | Other | Other1 | Other2 | Unit of Measure | Currency | Exchange Rate | Sales Tax Code | |
Anne's Bakery | 01/09/2020 | 100 | Check | 123 | 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 | 3 | 2 | 1 | Checking | Non | ||||||||||||||||||||||||||||||
Anne's Bakery | 01/09/2020 | 100 | Check | 123 | 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 | 3 | 2 | 1 | Checking | Non | ||||||||||||||||||||||||||||||
John's Barber Shope | 02/09/2020 | 101 | Check | 89 | 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 | 3 | 2 | 1 | Checking | 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.