Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I'm trying to find/write a report that will show me the customer invoice # associated with a Rebillable Charge. I can't quite get there
I tried running a Transaction List by Vendor, filtering the Split Acct = COGS Rebillable (where we code the original expense/bill), and adding the "Client" field to the report. It seems like that should work, but the Client field shows as null, even though there are clients assigned to each of these rebillable items. See screen shot as an example.
I also tried running a Sales By Client Detail, which is great except it doesn't allow me to add the underlying Bill/Exp reference # - I only get the memo/description, $, and then a line item that specifies the associated Markup.
We have hundreds of rebillable expenses each month, and we want to pay our vendors once the client pays us for the rebillable expense. I have a clunky process, and looking for ideas since I haven't been able to solve this report configuration on my own. With this info (noted above) I could run two separate reports, and do some vlookups in excel to identify which bills are eligible for payment,.
Thx in advance for any ideas!
We're using the Advanced subscription, if that matters...
I appreciate the effort you've put in, @leeseinmt. I can provide an alternative report that shows customer invoices associated with rebillable charges in QuickBooks Online (QBO).
You can pull up the Transaction List with Splits report to show both the invoices associated with the billable expense charge. Then, Customize it to show the specific details of your transactions. Follow the steps to proceed:
Additionally, please refer to this article to learn more about personalizing reports in QuickBooks: Customize reports in QuickBooks Online.
Furthermore, you can memorize the report to save its current customization settings and easily access it in the future.
Feel free to send a reply on the Community page if you have other questions about managing your reports or other QuickBooks-related concerns. The team will be here to help you in any way possible.
Thx for the idea, but I already know from this report the inv# and Client. Adding Client again via customization doesn't give me any new info. I need to know the BILL# associated with each of the rebillable items.
When I customize to add Vendor, they all come up blank, and I don't see a way to add the underlying Bill or Expense reference # associated with the rebillable charge
Any ideas are appreciated! I've created a bunch of diff reports and using vlookups I can eventually get to the data I want, but was hoping to simply create a report in QBO.
I appreciate you following the suggested report above and looking for another report for the customer invoice associated with billable charges, Leeseinmt. I'll help you submit your feedback to our developers in QuickBooks Online.
I can see the convenience of pulling up bills or expenses and the billable charges in one report. However, this report is unavailable in QuickBooks Online.
What we can do is pull up the Transaction List by Customer and click each transaction to narrow down the details of each item. Although it's time-consuming, it still provides the details you're looking for.
In the meantime, we can share some feedback about this option. This way, they can learn more about the features that business owners need.
Follow the steps below:
Furthermore, our product developers will receive your comments through our QuickBooks Online Feature Requests website.
I've included this article to help you save your current customized reports: Memorize reports in QuickBooks Online.
Leave your response below about billable items in QuickBooks Online. I'm looking forward to providing more updates on this topic.
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