Unbilled Costs by Job Report not showing returned materials

Thanks for sharing this with us, ebo8302.

Let's sort this out and investigate why your returned materials worth $200 didn't show on the Unbilled Cost by Job report.

When making a return, ensure that the transaction created for the refund ​​​​uses the correct name of the Customer: Job. This is one of the factors why it's not showing in the report.

To review this, find the transaction using Audit Trail and follow the instruction below:

1. Go to Reports.
2. Under Accountant & Taxes, choose Audit Trail.
3. Find the transaction made for return and click to open.
4. Make sure it's the correct Customer:Job. Review other information.
5. Click Save & Close.

Should you need more information about managing refunds, check out this article: Give your customer a credit or refund in QuickBooks Desktop for Windows.

Also, to help me better isolate this issue, I'd like to know how you record the return or refund in QuickBooks Desktop. This can also be the reason why the $200 return is not showing in the report.

If you need tips and related articles in your future tasks, visit our QuickBooks Community help website for reference: QBDT Self-help. 

I'd appreciate any additional details that you can provide and I'll take it from there. Let me know if you have other questions. I'm here to help.

When I enter in the transaction, I'm going under the "splits" screen, checking the "billable" box, and entering in the customer's name.

Not sure what else I would need to do.

Hello there, @ebo8302.

You're on the right track when making the returned materials billable. However, it will not show in the Unbilled Costs by Jobs Report.

Though, we can run the Job Profitability Detail report for that specific Customer:Job to see the initial charge and return.

Here's how:

1. Go to the Reports menu.
2. Hover over Jobs, Time & Mileage.
3. Choose the Job Profitability Detail.
4. From the Filter Report by Job window, choose your Customer:Job.
5. Click OK.

You can also check this article about understanding reports in QuickBooks Desktop (QBDT).

Fill me in if you have other questions. I'm always here to help. Take care!

I am having the same difficulty with credits not appearing in "Unbilled Cost by Jobs" reports.  The odd thing is the credit does not appear on the "Unbilled Cost by Jobs” if it’s on the checking account (credit to checking).  However, if the credit is made on our Amex that credit appears in “the Unbilled Cost by Jobs”. I feel this inconsistency should be investigated. I am crediting the correct customer. We are a very small business and tracking is not that difficult. 

I have noticed this for years actually and just got curious and investigated today. I have to manually remember to write it into our report.  I want to keep track of the part of the job that is unbilled. We are not interested in the profit and therefore the other reports are not as suitable for our goals. I’d greatly appreciate it if you could investigate a way around this discrepancy since it works for Amex but not for the BOA checkbook.

I am using the 2019 Desk top version of quickbooks

Hello there, mmagui1.

First, may I know what type of transaction you entered? Is it an expense or bill? This will help me better isolate your concern about the missing credit from your checking account in the Ubilled Cost by Jobs report.

Let's fix this by deleting then recreating the transaction to toggle it. Before doing so, make sure to secure a copy of the transaction's information.

Locate the transaction using the Audit Trail. I'll show you how to do it:

1. Go to Reports.
2. Under Accountant & Taxes, choose Audit Trail.
3. Find the transaction made for return and click to open.
4. Click Delete.

Then, you can recreate the transaction and go back to the Unbilled Cost by Jobs to see how it works. If not, we can try some basic troubleshooting using the Verify and Rebuild Utility Tool. This helps trace common data damage within your company file. 

Below are the steps on how to do this:

1. From the File menu.
2. Click on Utilities.
3. Select Rebuild Data/ Verify Data.
   

The Community is always open if you have other questions. I'll be around to help. Wishing you a great day ahead!