I need a report in QB Enterprise that shows inventory received but not yet billed

I've got your back, @kimbre623.

I can help you find the report you need in QuickBooks Desktop.

To see your received items that were not billed, you can pull up the Purchases by Item Detail report. Then, you can utilize the Customize filter to see the Unbilled items. I'll guide you on how:

1. Go to the Reports menu, then select Reports Center.
2. From there, go to Purchases.
3. On the Purchases by item section, double-click the Purchases by Item Detail report to open it.
4. From the report window, click Customize Report in the upper-left corner.
5. Go to the Filters section and type in Billing Status in the search box.
6. Then, tick the Unbilled and select OK.
   
   

On top of that, I've added these resources to learn how to draw information clearly and save the same report settings for future use:

• Customize reports in QuickBooks Desktop
• Create, access, and modify memorized reports

Please don't hesitate to click the reply button if you require any additional concerns about pulling up reports in QBDT. You can always add them to your response and I'll get back here as soon as I can. Take care always.

HI- still looking for a report that shows me parts received but not attached to a vendor bill/credit card charge. The answer provided is not what I was asking.

Hi there, @kimbre623. Let me add some additional step on my colleague's answer.

We can pull up the Purchases by Item Detail report and customize it correctly so your desired report will show. I can walk you through the steps on how to do it.

1. Go to Reports, then Reports Center.
2. Select Purchases, and choose Purchases by item section. 
3. Open the Purchases by Item Detail report.
4. On the report window, click Customize Report. 
5. Go to the Filters section and search for Billing Status in the field provided.
6. Tick the Unbilled and select OK.
7. After that, search for the Transaction type.
8. Select the Item receipt in the Transaction type dropdown.
9. Hit OK.

From there on you can see all the items that are received but aren't attached to any bills or credit card charges. 

Additionally, you can visit this article for more information about personalizing your reports in QuickBooks Desktop (QBDT): Customize reports in QuickBooks Desktop.

Feel free to hit the reply button if you have further concerns about the report in QBDT. I'm all ears if you have one. 

Sorry but no, this is not the correct report. This report is still only showing received items that were not invoiced to customers. I need a report that shows received inventory that my predecessors did not attach to vendor bills/credit card receipts. see attached showing one of the transactions that show up on this report. In the attachment you can see I am trying to enter a bill for vendor DS Brown and there are 2 items that were received in 2020 that are still available to attach to the vendor bill. Those were actually paid by credit card receipts but were not attached to those transactions properly. I know how to fix them but I want a report that will show me all inventory received but never attached to vendor bill/credit card charges so I can fix them all without having to enter every single vendor name into the bill drop down to see if there is anything old still handing out.

The CPA told me to just ignore it but it drives me nuts and I want to correct them!

I understand you need to find a report that shows inventory received but not yet billed, kimbre623. Let me provide with alternative ways to show this data in your reports.

You can run the Open Purchase Order report to view purchase orders that aren't converted to a bill. Here's how:

1. Go to the Reports menu and select Purchases.
2. Click on Open Purchases Order.
3. In the report window, click Customize Report in the upper-left corner.
4. Go to the Filters section and type Name in the search box.
5. Look for the vendor and click OK.

Also, you can view item receipts that aren't turned into a bill by running the Transaction List by Vendor report. You can follow these steps to open the report:

1. In the Reports menu, select Vendors & Payables.
2. From there, go to Transaction List by Customer.
3. In the report window, click Customize Report in the upper-left corner.
4. Go to the Filters section and type Transaction Type in the search box.
5. Look for Item Receipt in the dropdown, then click OK.

Additionally, you can check this article for more information about personalizing your reports: Customize reports in QuickBooks Desktop.

To enter the appropriate bill against the inventory, utilize this resource: Enter bills against inventory.

If you have other concerns about reports or anything with QuickBooks Desktop, please don't hesitate to go back to this thread. I'm always here to help.

OK I get it. QuickBooks does not have the ability to do what I need. Every report suggested does not give me what I am asking for. Thanks for trying but you all are way off base. each report gives me part of the info but no report gives me a list of items received that were never attached to a vendor bill/credit card payment.

1. In the Reports menu, select Vendors & Payables.
2. Select Transaction List by Vendor.
3. In the report window, click Customize Report in the upper-left corner.
4. Go to the Filters section, then type Transaction Type in the Search filter box.
5. Select Item Receipt in the Transaction Type dropdown.
6. Once done, click OK.

@kimbre623 

"each report gives me part of the info but no report gives me a list of items received that were never attached to a vendor bill/credit card payment."

QBD creates Item Receipts when items are received but no vendor bill is attached.  You need to run a Transaction List by Vendor, click Customize Report, click on the Filters tab, select Transaction Type under 'Filter' and select 'Item Receipt' under 'Transaction Type'.  That shows you all items received into inventory (with or without a PO) with no vendor bill attached.  You mentioned a "bill/credit card payment".  A cc payment requires either a bill or a cc charge and subsequent payment- both of which indicate you received a bill (otherwise what would you have paid for?) and, therefore, would not be part of the report you're looking for.     

How does this report help me? It shows a list of item receipts but it does not show which ones are attached to a bill/credit card payment.

I ran this report and all it does is provide a list of item receipts. It does not indicate whether they are connected to anything or not.

The Transaction List by Vendor will only show the item receipt, @kimbre623. As Rainflurry mentioned, it will not show with or without a PO attached to the bill. If a PO is linked to a bill, it won't appear in that report.

I suggest checking each item's receipt for connected bills or credit card payments. You can double-click the item for you to open. 

I've attached some articles that can help you run reports: 

• Customize reports in QuickBooks Desktop
• Create, access, and modify memorized reports
• Set report preferences

If you still have questions, I'll be here to assist you. Have a lovely day and take care. 

@kimbre623 

If you see an item receipt on the report, that means there is no bill associated with it.  So, all item receipts have no bill attached.  As soon as a bill is associated with an item receipt, the item receipt no longer shows on the report.  

Well then there is clearly a bug in my QB Desktop Enterprise because I am staring at the report you told me to run and it shows items received that are connected to bills. tons of them since I do things correctly. I need to clean up old old errors and do not know how.

I have the report pulled up. My question is I have a lot of Item Receipts that are old and not linked to a bill. 

We receive customer-supplied products at zero value and never receive bills for them. 

1. how should they be received so we don't have all of these item receipts still out there going forward

2. how can I clear up all the old ones? There are hundreds of them. 

Hello! Dog-dog.

Thanks for reaching out to the community. It's great that you've pulled up the report and identified the issue with item receipts that are not linked to a bill. Let's work through a solution for managing new entries and clearing up those existing ones.

When an item receipt appears on the report, it indicates that no bill is linked to it. All item receipts listed are without bills attached. Once a bill is linked to an item receipt, that receipt will no longer appear in the report, so the only way to close an item receipt is to create a bill. Since the amount is zero, it will automatically set the status in the bill as paid. But it won't affect the balances since the value is zero.

To enter a bill for an item receipt, here's how:

1. At the Home page, select Enter Bills against Inventory.
2. On the "Select Item Receipt" window, go to the Vendor dropdown and choose the correct vendor's name.
3. Then, select OK.

To keep the original inventory availability date, tick the box for the option "Use item receipt date for the bill date" and select the item receipt corresponding to your bill.

To track Accounts Payable in QuickBooks, you enter the bill before paying the vendor. By doing so, you always know how much you owe from your vendors/suppliers, and you can ensure that expenses are recorded in the correct accounting period. Many smaller businesses don't bother with tracking Accounts Payable.

You also have the option to receive inventory, either with or without a bill, once you've recorded a purchase order. To learn more about how to receive inventory, check this one out:

Feel free to reach out if you need further assistance. We're here to help you ensure smooth and accurate inventory and billing management. Keep up the great work! Best regards.