Bills by Customer Detail Report - A How-To Guide
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.