cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Is there any report showing the list of bills with the payment status of corresponding customer invoices

I'm entering a bill assigning it to a certain customer job number. Then I raise a customer job number by selecting this bill. I want a report showing the list of such bills with the payment status of respective customer invoices.

Solved
Best answer 12-10-2018

Accepted Solutions
Established Community Backer ***

"I want to be able to track every single reimbursable bil...

"I want to be able to track every single reimbursable bill to its respective invoice line."

I fully understand the Request.

You can run reports to see if what you Incurred for that customer has been charged back to them, or still is unbilled, or got marked Not Billable, in error.

There also is the ability to review by Item, when you incurred it and when you charged it out.

As I stated, there is No Function in the program, after the fact, that shows the details of a bill and which invoice it got put on; or, the details of an invoice, and which bill it Came From.

For instance, I invoice you for something I incurred, and as long as I use the Serviced Date, that would be on a Bill or Check or Payment for that date, but nothing here in the Invoice or a Sales Report tells me the Supplier. So, I run a report such as Job Costs Detail by Vendor for that Job, or By Job and Vendor, which allows me to see all of the activity and find what you are asking for. Or, I run Item Profitability for that Job, or Job Profitability Detail for that Job, and here I see that Item, as something I incurred and charged back.

The vendor purchase details will show the job and the Billed status.

There is nothing seen here that tells you which Invoice it is on.

I totally understand what you are asking. I have been using QB since 1997.

View solution in original post

9 Comments
Established Community Backer ***

"I want to be able to track every single reimbursable bil...

"I want to be able to track every single reimbursable bill to its respective invoice line."

I fully understand the Request.

You can run reports to see if what you Incurred for that customer has been charged back to them, or still is unbilled, or got marked Not Billable, in error.

There also is the ability to review by Item, when you incurred it and when you charged it out.

As I stated, there is No Function in the program, after the fact, that shows the details of a bill and which invoice it got put on; or, the details of an invoice, and which bill it Came From.

For instance, I invoice you for something I incurred, and as long as I use the Serviced Date, that would be on a Bill or Check or Payment for that date, but nothing here in the Invoice or a Sales Report tells me the Supplier. So, I run a report such as Job Costs Detail by Vendor for that Job, or By Job and Vendor, which allows me to see all of the activity and find what you are asking for. Or, I run Item Profitability for that Job, or Job Profitability Detail for that Job, and here I see that Item, as something I incurred and charged back.

The vendor purchase details will show the job and the Billed status.

There is nothing seen here that tells you which Invoice it is on.

I totally understand what you are asking. I have been using QB since 1997.

View solution in original post

Not applicable

I see. Thank you for your broad explaination.

I see. Thank you for your broad explaination.
Established Community Backer ***

"What about the invoice number that this bill relates to?...

"What about the invoice number that this bill relates to? Is it visible in any report?"

What ties these together is the Customer Name for what you entered as Direct and tracked to that name; and, if you marked it Billable and invoiced it or selected it for the sales receipt, then that Item is what you have in common.

I will attach some screenshots.


Not applicable

I see what you mean. However what I'm looking for is a bi...

I see what you mean. However what I'm looking for is a bit more detailed linkage. I want to be able to track every single reimbursable bill to its respective invoice line. The reason for it is I want to make sure that I have received the funds from my cus
Established Community Backer ***

"I want a report showing the list of such bills with the...

"I want a report showing the list of such bills with the payment status of respective customer invoices."

Nothing shows "paid when paid" reporting. You can confirm Unbilled entries (costs incurred and marked as billable to a Customer) are Invoiced or on a sales receipt, and not overlooked.

Nothing relates the Customer's paid status to your Supplier's bill paid status.


Not applicable

Thanks for the answer. What about the invoice number that...

Thanks for the answer. What about the invoice number that this bill relates to? Is it visible in any report?
Not applicable

Re: Thanks for the answer. What about the invoice number that...

I've also had trouble connecting billed costs to customer invoices. Why doesn't QB have a "Billed Costs by Job" report. Am I missing something?

QuickBooks Team

Re: Is there any report showing the list of bills with the payment status of corresponding custom...

Hi jsultanov, 

 

I'm glad to see you again in the Community. Allow me to add up some details to the information given by @qbteachmt

 

QuickBooks Desktop provides a wide array of reports for the transactions created in the program. Though you can make customers billable to your vendors, the invoices and bills are linked to different types of reports.  

 

As what @qbteachmt mentioned above, the customer's paid status doesn't directly relate to your supplier's bill paid status. Therefore, there isn't a report that'll directly show the invoices that are linked to the bills. 

 

You'll want to run the Custom Transaction Detail report. This can give you a list of all invoices and bills created specifically to your customer or vendor. 

 

Here's how:

  1. Go to Reports at the top menu bar, select Custom Reports, then Transaction Detail
  2. In the Modify Report screen, put a check mark in the Billing Status item.
  3. Select the Filters tab.
  4. In the Search Filters field, enter Transaction Type
  5. Pick Multiple Transaction Types, then choose Invoice and Bill in the Transaction Type drop-down.
  6. Go back to the Search Filters field, enter Name.
  7. Select the customer's name you want to see. 
  8. Click Ok

Once done, manually look for the invoice associated to the bill so you can see its number. 

 

We are working on big improvements that will be helpful to the majority of our customers. If you have a minute, I encourage you to send a message to our product engineers requesting more customization options to the reports. 

 

To do so, go to Help at the top menu bar, then select Send Feedback Online. I'll do the same thing from my side, so we are hitting them through both employee and customer channels.

 

That information should help answer your question.

 

If you have other concerns while working in QuickBooks, please let me know. I'd gladly help. Have a great day! 

QuickBooks Team

Re: Is there any report showing the list of bills with the payment status of corresponding custom...

Hi there, The Reckoner. 

 

Thanks for joining us here in the Community! I'm here to address your concern about the report you need in QuickBooks Desktop. 

 

You're not missing anything. The program doesn't have a built-in report named Billed Costs by Job. 

 

The available reports for Job costing are Job Profitability Summary and Detail, Job Estimates vs Actuals Summary and Detail, Job Progress Invoices vs Estimates, Job WIP Summary, Item Profitability and the list goes on. The first answer provided by @qbteachmt above contains a great explanation about when to use these reports. 

 

However, none of these reports will directly show the invoices that are linked to the bills. You need to click each item so you'll be routed to the invoice details. 

 

Here's how:

  1. Go to Reports at the top menu bar, then Jobs, Times, & Mileages
  2. Open the Job Profitability Details Report
  3. In the Filter Report by Job, select the customer you need, and OK.
  4. Double-click the amount of the item you've billed to your customer. 
  5. The Item Actual Cost Detail page will show with the invoice details.

This may not be what you expected to do, but this can also give some of the necessary details you need. 

 

If you wish to see this type of report in the future, feel free to let our product engineers know. To do so by clicking Help at the top menu bar, then selecting Send Feedback Online and Product Suggestions. I'll also send the same suggestion for this, so we are hitting them through both employee and customer channels.


Don't hesitate to let me know on how things go. I can always get back here and help you out.

Need to get in touch?

Contact us