Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I inherited a QB file that has a ton of items received but never attached to the bill. goes back years and I would like to clean it up. I can't find a report for received items not 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:
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:
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.
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:
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:
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.
"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:
If you still have questions, I'll be here to assist you. Have a lovely day and take care.
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.
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