cancel
Showing results for 
Search instead for 
Did you mean: 
leeseinmt
Level 4

Report that shows the Customer Invoice associated with a Rebillable Charge

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...

3 Comments 3
GebelAlainaM
QuickBooks Team

Report that shows the Customer Invoice associated with a Rebillable Charge

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:

  1. Go to the Reports menu.
  2. Locate the Transaction List with Splits.
  3. Click Customize.
  4. Under the Rows/Columns, select Customer.
  5. In the Filter section, check Transaction Type and select Billable Expense Charge and Invoice.
  6. Filter out all the necessary details you need, then hit Run Report.

     image_720.png

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.

leeseinmt
Level 4

Report that shows the Customer Invoice associated with a Rebillable Charge

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.

ChristineJoieR
QuickBooks Team

Report that shows the Customer Invoice associated with a Rebillable Charge

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:

 

  1. Go to the Gear icon.
  2. Under the Profile column, press the Feedback button.
  3. Write your product suggestion, then click Next.

 

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.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us