Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Recently migrated from Desktop to Online. I'm looking for a report, or filtering instructions, to generate a report of purchases by customer and/or by project, including purchases/expenses marked as unbillable.
You can run and customize the Sales by Customer Detail report, @greensman. I'm here to walk you through the process.
The Sales by Customer Detail report provides a comprehensive overview of the purchases made by each customer. To include the unbillable on the report, you can customize the report by following the steps below:
On the other hand, you can refer to this article with the guides on filtering your reports: Customize reports in QuickBooks Online using modern view.
Additionally, you can memorize your reports to save your current customizations.
Let us know if you have other concerns about reports in QuickBooks Online. We'll be here to help you in any way we can.
I am asking about purchases, not sales. So if I have purchased two dogwoods and marked them for a customer project as billable, and a yard of mulch with the same customer project selected but marked NON-billable, where can I find or how do I get to a report that shows me that for that customer I purchased dogwoods and mulch both?
I'll be happy to chime in and walk you through running a report to show the purchases linked to a customer, @greensman.
In QuickBooks Online (QBO), you can run the Purchases by Vendor Detail report and customize it to show the required information. While we're unable to group them by customers, we can add a column to display the list of transactions associated with a customer.
To do that:
Moreover, you can memorize a report and send it to your team members on a recurring schedule.
It's always our goal to address your concerns with reports. If you need further guidance, please feel free to reach out back to us. We'll be glad to offer additional assistance. Keep safe.
Thank you for your reply. I cannot mark this as a solution; your suggestion requires me to sift through all purchases to find the ones I need for the client/project I'm working on. That's not helpful for my work flow when I am wanting to quickly see what I purchased for one customer. I have been able to Group by None and sort by customer to get all my purchases lumped together for one customer in the list, but I still will have to export this file to excel to isolate purchases for only that customer or job.
It seems to me so straightforward and apparent that users would need to filter & report Quickbooks data by Customer/Project--I don't understand why this feature (and so many similarly useful but gone features) was available in Quickbooks Desktop but is not now that I have migrated to Quickbooks Online.
Thank you for your time.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here