Can Bill Street 1 and Bill Street 2 fields both appear as columns in a customer contact report?

Hi there, @avpny. Welcome to the Community! I'm happy to clarify how address details appear in your reports!

In QBO, if you add details into both the Bill Street 1 and Bill Street 2 fields for a customer, when you run Customer Contact List report, these two lines will not display as separate columns. 

Instead, the system design combines them into a single entry to minimize adding a new column and prevent reports from becoming too wide and cluttered, especially when you have many other columns of contact and sales data. The report focuses on providing a clear, full address at a glance.

If you have follow-up questions, please feel free to click the Reply button.

Hi, @avpny.

Just checking in to see if the solution we shared worked for you.

Did it fix the issue, or are you still having trouble?

Happy to help if you need any more assistance!

So that's not helpful when I need to create a mailing list and I need both columns listed separately.

So that's not helpful when I need to create a mailing list and I need both address columns listed separately.  Is there no way to get both of them in one customer list???  If not, why do they even exist as separate fields???

No, this solution is not a solution.

We understand how important it is for your workflow to have both billing street address fields appear as separate columns in your Customer Contact List report, avpny.

Currently, the option to display the billing street address fields (1 and 2) in separate columns within the report is unavailable. As a workaround, you can export your report to Excel to further customize it to meet your specific needs.

However, you can also share your feedback about the report directly with our product engineers in QuickBooks Online (QBO). Your suggestions are highly valued and help us understand the features that matter most to our users.

If you have additional questions, feel free to comment below.