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

sales per customer with addresses

I need a report that shows the customer's name, billing address, billing city, billing state, billing zip code and total sales for a specific period.  It would be nice if the customization in the Sales summary by customer would let you add the billing information.  That would make the report ideal.

 

I've seen some dialogue go back and forth in this area, but I have not seen a resolution to my satisfaction.  The last posting, if I remember correctly, was dated September of 2020.  Has QBO made any strides in this area?

 

Please advise.  Thank you.

Camate60

10 Comments 10
MaryLurleenM
Moderator

sales per customer with addresses

You can combine two reports for this, Camate60.

 

To achieve your goal, you can run Customer Contact List, and Sales by Customer Summary Report. Then, combine the two manually in Excel.

 

You can customize the Customer Contact List with the columns of customer's name, billing address, billing city, billing state, billing zip code. Then, run the Customer Summary Report for a specific period.

 

You'll want to export these reports to combine them in Excel manually.

 

Check out these articles for more reference:

Let me know if there's anything else I can help you with regards to report customization in QuickBooks Online. 

Camate60
Level 2

sales per customer with addresses

That's not helpful in that we have more customers have not made any purchases versus than those that have, for any given period.  It would be a tremendously laborious effort to do as you say.  What you have provided is a work-around, not a solution.

 

Is this something QBO is working on?  It seems that if the option to include the billing address details is available in another report modules of QBO, that it could be integrated in other components of the report sub menu.

 

Please advise.  Thank you.

JasroV
QuickBooks Team

sales per customer with addresses

I appreciate your prompt reply, @Camate60.

 

The option to customize the Sales by Customer Summary report to have the billing column isn’t available in QuickBooks Online (QBO). This report only shows the total sales of each customer in your account. 

 

As an alternative, you'll want to export the Customer Contact List report to Excel as suggested by my colleague MaryLurleenM above. Then, manually add a column for the total sales of a specific period from there.

 

To be guided in exporting reports in QBO, you can check out this article for your reference: Export your reports to Excel from QuickBooks Online.

 

If you wish to know about the latest news and updates about QuickBooks, you’re always welcome to visit our QuickBooks Blog page.

 

Additionally, to learn more about managing your reports in QBO, you can always utilize this link for your guidance: Run reports in QuickBooks Online.

 

Know that you’re always welcome to leave a reply if you have other queries running reports or managing your account. It’s always my pleasure to keep you on the right track. Keep safe and take care!

dancer1031
Level 1

sales per customer with addresses

Did you ever find a solution? I am in need of this exact report and it seems no one can offer a solution. 

 

ChristieAnn
QuickBooks Team

sales per customer with addresses

Hi there, dancer1031.

 

Thank you for visiting the QuickBooks Community. I recognize the importance of having the option to show the billing address, billing city, billing state, and billing zip code on the Sales by Customer Summary report. Thus, I'll ensure you can send feedback so your suggestion is forwarded to the Product Development Team.

 

There are dozens of reports in QuickBooks that give you a snapshot of your business and other important details. However, they have different functions that work differently. With this and as mentioned above, the said report will only tell you about the total sales for each customer as well as for each job. 

 

For now, I suggest going to the Gear icon in QuickBooks Online. From there, you're able to choose Feedback to submit a request about adding a column to see the customer's billing information. Any recommendations are sent to our engineer for consideration in future updates. 

 

Additionally, you can follow the details provided by my peer on how you can export the Customer Contact List to Excel or other reports. Then, manually customize the columns from there to add the information you want to view.

 

Lastly, you may click this article to see steps on how memorizing a report allows you to save it with its current customization settings: Memorize reports in QuickBooks Online.

 

I'm always here if you needed more help with your reports in QBO. Just let me know in the reply section below, dancer1031. Take care and have a great rest of the day!

imaknucklehead
Level 1

sales per customer with addresses

You have got to figure this one out.  I need the addresseses to be on the reports.  I don't have time to edit multiple excel files together.  Other accounting software allows for this - I guess they are just more advanced than quickbooks.

5247719970460144
Level 1

sales per customer with addresses

I found a report that works for me - Invoice List by Date. You can modify the dates on this report and customize the columns to show the addresses. 

megarooter
Level 2

sales per customer with addresses

thank you, that helps for open balance, but not if you need to know what service the customer had and you can't add that column to any report with addresses. it's ridiculous QBs!

megarooter
Level 2

sales per customer with addresses

agreed, why have a customize button if you're limited to what fields. for instance, the phone number field is offered, yet ALWAYS blank on my reports, because it pulls the "phone' field instead of 'mobile' phone field. In 2023 when everyone in the entire world uses a cell phone, and guess what? there is NO WAY to customize a report that shows the mobile phone number. grrrrr it's very frustrating - QB's can we please have a custom report that allows you to choose every field available? please? I don't have the time to combine 4 different reports manually. and please stop telling people to do that - we are asking for help and being dismissed.

Mich_S
QuickBooks Team

sales per customer with addresses

Hi there, mega. I recognize that it's crucial to have a feature in QuickBooks Online that allows you to input your customers' addresses and the type of service they require.

 

As my colleague mentioned, there are dozens of reports in QBO that give you a snapshot of your business and other important details. However, they have various functions that work differently. While your desired functionality is unavailable, I recommend sending us feedback to our product engineers.  Please know that your ideas and suggestions will help us determine what features our customers need the most. Here's how:

 

1. Log in to your QBO company.

2. Click the Gear icon.

3. Select Feedback.

 

4. Type in your product suggestions.

5. Once done, hit Next

 

You can also explore our QuickBooks Online Feature Requests webpage to keep track of any feature requests.

 

Alternatively, you can export your report to Excel and add your desired information from there. Check out the snapshot below for reference:

 

 

If you're good with this, feel free to explore these extra modules to send and manage your customers' bills:

 

 

Please post again if there is anything else I can do to assist you. I'll be right here to provide you with answers. Take the best care!

Need to get in touch?

Contact us