Bills by Customer Detail Report - A How-To Guide

Peter O · ‎May 25, 2024

Tl;dr Instructions below for creating a “Bill by Customer Detail” report.

Information current as of 05/25/2024, using QBO Advanced.

To my fellow QBO users: I understand your pain with QBO reports. I’ve been onboarding with QBO (Advanced) over the last multiple weeks. My experience has been horrible. After much beating of my head against the proverbial wall, many exclamations of frustration (to put it mildly), and an excruciating amount of exploration in QBO’s reporting menus, I have now discovered a means of generating a useable “Bills by Customer Detail” report.

I have posted the instructions below in hopes the information will be helpful.

From the Reports screen:

Create a New Report, using “Bills” as the report type
Add two columns:
- Columns > More Columns > Bills > Line Items > Customer > “Customer”
- Columns > More Columns > Bills > Line Items > Account > “Description"
Filter:
- By: Paid Status
- Options: Equals
- Value: Unpaid

Export to Excel:
- Delete the top rows
- Delete the bottom row
- Ctrl-Shift-L (toggles filters)
- Filter the Customer column by “--“ results
- Delete rows 2 through the last row with data
- Unfilter the Customer column

Now you have a list of the unpaid bills, including the Customer assigned against the bill, along with any notes you may have written in the “Description” field.

Additional notes:

I have no idea why the report duplicates every single bill. If someone else knows how to resolve this, please share.
I do not know why the report generates a date in a format that is not readable by Excel. To fix this easily: create a new column, format it for the date format you prefer, and use the DATEVALUE formula to convert all of the dates in the “Due Date” column to dates that Excel can pull into pivot tables. Note: someone else posted this solution elsewhere on the forums, I just can’t find that post again to give them due credit.

Peter O · ‎May 25, 2024

I really should have tested the report more thoroughly. Turns out "Vendor Credits" do not pull into the report. Also, if you divide your bills across multiple expense accounts (or even have the same expense account, but for a different description/class), the report also duplicates those lines. Some clean-up is necessary, even on this report. Ugh. I would have deleted my original post so I could post again some time later after further testing, but apparently I can't do that. More updates to come, I guess.

KayePe · ‎May 25, 2024

We would like to express our gratitude for sharing your valuable insights with us. I want to assure you that our dedicated team of product engineers is working tirelessly to provide an enhanced update for QuickBooks. Note that we hear your sentiments.

Regarding the issue of duplicate transactions appearing when adding a line item, this occurs because the system automatically adds column data for the line item, resulting in the display of duplicate information.

Furthermore, we greatly appreciate your input on running a Bill by Customer Detail report in QBO. Your insights are invaluable to us as we strive to enhance our platform. If you have any further concerns or feedback on this matter, please do not hesitate to share them with us. Take care.

JGENT · ‎May 29, 2024

I appreciate the input we still haven't gotten a good report for this yet unfortunately but if you figure anything further out keep me posted!

Robert NYC · ‎June 06, 2024

Thanks for posting this.

My problem is I can't find "create new report" anywhere in QBO.

Where is it?

thx

JGENT · ‎June 20, 2024

I can't find it either, I found these instructions online but when I go to reports there is nowhere that says +Create.

Go to Reports (Take me there) and select + Create new report.
Select the report type, then select Create. Note: Based on the experience you see, you might see the following two options instead. Select an appropriate one: ...
Select the pencil icon. , then enter/edit the name of your report.

RheaMaeH · ‎June 20, 2024

Thank you for bringing up this question about report creation in QuickBooks Online (QBO), JGENT. Let me clarify the available options based on subscription.

In QuickBooks Online Advanced, you can find the + Create new report option when generating a report. Here's how:

Login to your QuickBooks Online account.
Go to the Reports option.
In the report field, you can see the + Create new report.

On the other hand, QBO subscriptions like Simple Start, Essentials, and Plus, the + Create new report features aren't available. However, you can still run reports using the standard options. For more details, visit this article: Run reports in QuickBooks Online.

Furthermore, you can check this article on how to get the most out of your financial reports: Customize reports in QuickBooks Online.

Feel free to visit us if you have further questions about report options in QuickBooks Online. The QuickBooks Community is open 24/7 to help you out.

Topics

Training

Community

Resources

Bills by Customer Detail Report - A How-To Guide