cancel
Showing results for 
Search instead for 
Did you mean: 
KAY15
Level 2

Sales by Item Report Including Bill To Name, Bill To City, Bill To State, Bill To Zip

Is 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
Best answer June 09, 2020

Best Answers
Pabz_L
QuickBooks Team

Sales by Item Report Including Bill To Name, Bill To City, Bill To State, Bill To Zip

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. 

 

  1. Go to the Reports tab.
  2. Select, Sales by Customer Detail.
  3. Click Customize Report.
  4. On the Display tab under columns, put a checkmark beside Name CityName State, and Name Zip.
  5. Then, click OK.

 

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!

View solution in original post

4 Comments 4
Pabz_L
QuickBooks Team

Sales by Item Report Including Bill To Name, Bill To City, Bill To State, Bill To Zip

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. 

 

  1. Go to the Reports tab.
  2. Select, Sales by Customer Detail.
  3. Click Customize Report.
  4. On the Display tab under columns, put a checkmark beside Name CityName State, and Name Zip.
  5. Then, click OK.

 

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!

vinseyjulip
Level 1

Sales by Item Report Including Bill To Name, Bill To City, Bill To State, Bill To Zip

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!

Catherine_B
QuickBooks Team

Sales by Item Report Including Bill To Name, Bill To City, Bill To State, Bill To Zip

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: 

  1. Go to the Reports menu.
  2. Choose Customers & Receivables
  3. Select Customer Contact List
  4. The Bill to information is displayed by default. To export it, just click Excel from the menu. 

You can always post your questions here if you need more help. You take care always and have a great day!

Fiat Lux - ASIA
Level 15

Sales by Item Report Including Bill To Name, Bill To City, Bill To State, Bill To Zip

@KAY15 @vinseyjulip 

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.

CustomerTransaction DateRefNumberPayment MethodCheck NumberClassTemplate 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 CodeItemQuantityDescriptionPriceShippingHandlingDiscountSalesTaxDeposit ToIs PendingItem Line ClassService DateFOBCustomer Acct NoSales Tax ItemTo Be E-MailedOtherOther1Other2Unit of MeasureCurrencyExchange RateSales Tax Code
Anne's Bakery01/09/2020100Check123  Y15/09/2020Anne's BakeryOne Harbor StreetAnytownNY12345USAAnne's BakeryOne Harbor Street AnytownNY12345USA(123) 456-7890        NonCabinets10Cabinets1000321 Checking             Non
Anne's Bakery01/09/2020100Check123  Y15/09/2020Anne's BakeryOne Harbor StreetAnytownNY12345USAAnne's BakeryOne Harbor Street AnytownNY12345USA(123) 456-7890        NonHardware10Hardware50321 Checking             Non
John's Barber Shope02/09/2020101Check89  Y15/09/2020John's Barber Shope1 Main Street AnytownNY12345USAJohn's Barber Shope1 Main Street AnytownNY12345USA(999) 888-8888        NonBlueprints1Blueprints500321 Checking             Non

Need to get in touch?

Contact us