Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
How do I receive inventory/create a bill for my purchase order when I get the inventory delivered?
Solved! Go to Solution.
Hello reggiesroast,
Thanks for posting!
I'd be pleased to help. Here's how to create a bill for your purchase order:
Hello reggiesroast,
Thanks for posting!
I'd be pleased to help. Here's how to create a bill for your purchase order:
Agreed, QB Online stinks and is difficult to navigate, especially the Reports, compared to the Desktop version. It is not user friendly and the naming of reports was changed (which makes it more difficult). I'm not sure what the benefit is on QB Online v Desktop is but I much prefer the Desktop version.
I am still unclear about when the inventory is updated and how we ensure that inventory corrections are made.
I understand that process as follows - please correct anything I have got wrong:
(Note that I have not included a reference to the situation where a packing slip is incorrect as obviously we talk to the vendor and sort out how to resolve it.)
Once we know that the vendor has finished issuing invoices against a PO and all invoices are paid, QBO still shows an outstanding amount due on each Bill. Presumably there is also a discrepancy between the inventory added in accordance with the Bill and the actual shipments received (on packing slips). How do we ensure in QBO that the inventory adjustment, the PO, the Bill and the goods received all match at the end?
Thanks in advance for any explanation and advice. This is causing a lot of stress because it is over 6 months since taking over the accounting for this and Bills are not being cleared and Inventory is going out of whack!
Hi @briton,
Allow me to clear things up for you and share how this process works.
Your inventory gets updated right after you mark a bill with the inventory items as paid. To ensure that its correctly updated, I suggest making changes to the bill you've created from the initial PO. Base your changes from the invoice your vendor sent you, including shipping costs.
With this, you won't have any issues with your inventory since the update will depend on the actual items you've received from your vendor. The bill will also close without any discrepancies since the total amount you paid for matches with the invoice you received.
Further details on inventory management by buying and selling products is in this article: Buying and selling inventory.
I'll be here to provide further assistance. Should you require it, drop me a comment below and I'll get back to you.
Thanks Ryan.
So if I understand you correctly:
So unless we get a perfectly matched PO against deliveries and invoice, what you are saying is that we need to enter each item/quantity on an invoice in a newly created bill and merely annotate which PO it is a partial fulfillment of.
Did I understand your answer?
Thanks for getting back to us, @briton.
You can create a bill from the PO each time you receive a shipment according to inventory received. Used the Copy to Bill from the PO and reduce the QTY of items if you received partially delivered items, this way it will update the PO's open items.
Also, you can still use the feature as the PO in QuickBooks Online (QBO) will update each time you do a Copy to Bill and let you track how many inventories remained undelivered.
Once you received the invoice from the vendor, you can run the Purchase by Vendor Detail report to match the items that were billed and what was invoiced.
Here's how to run the report:
Also, just in case you want to adjust your inventory, please refer to this article for the detailed steps: How to Edit an Inventory Quantity Adjustment.
Let me know if you have other questions. I'm always here to help. Have a good day!
So, when you receive a PO and create a bill, the inventory is not added to the register until its paid?
Thanks for joining this conversation, DKolb.
To answer your question, when creating a bill from a purchase order (PO), the quantity of the item in that transaction will be added in the inventory (Products and Services) list automatically. It will also be posted in the expense and accounts payable account (AP). Once the bill is paid, that the time it will be posted in the bank's register.
For additional resources, consider checking out these articles:
Please reach out to me in the comment section below if you have any other issues or concerns. I'm always here to help. Have a great week!
Thanks for the response! I am trying to figure out how to automatically add inventory received from a purchase order. Does QBO do that?
Good day, @davidkolb.
As of the moment, your inventory items from a purchase order won't automatically be added to your item's quantity on hand. This is because your purchase order is a non-posting transaction. Thus, it doesn't affect the quantity of your items and in any of your accounts.
With that being said, you can consider copying your inventory items from a purchase order to a vendor transaction once you received them. This way, QuickBooks will automatically add the quantity of your inventory items to your current inventory count. To do so:
Additionally, here's an article you can read to learn more about how you can add your purchase order to a vendor transaction: Apply a Purchase Order to a Vendor Transaction.
Lastly, I've also added this helpful article that'll guide you in identifying and finding your purchase order transaction: How to Run Purchase Order Reports?
If there's anything else that I can help you with, please let me know ion the comment section down below. I'll be always around ready to help.
Mine is not so simple. I want to receive inventory from a purchase order I created. When I follow your instructions (Action, Copy to bill, Save). I cannot input the quantity I am receiving. Doesn't allow me to do so. Also, I need to add tariff and inbound freight to get my true cost. Do I have to add this percentage to each item manually? Would that show on the bill? Will these additional costs show on my vendor bill when I make payment? I hope my question make sense.
Of course, your question makes sense, Tom. Let's review the details you need to change and add to your bill.
There's no restriction in editing the item quantities. When you copy the purchase order to a bill, it will take you to the Bill page where you can change their quantities. Is there an error when you try this step?
As for the tariff and freight, you can create items for each and assign their corresponding expense accounts. Then, add them, like how they are shown on the actual transaction. If their amounts are in the percentage formats, just get the converted values and them to your bill. And yes, they will be included in your bill payments.
Let me know if you still need help with your inventories.
I am using Desktop PRO 2018, 2019 & 2020.
I do not see the "ACTION" pull down menu. Where is it located
Hello there, @LCecchini. I'm here to ensure you're able to receive inventory from your purchase order in QuickBooks Desktop (QBDT). This way, you can keep track of your inventory and record them accordingly.
The steps provided above are for the online version of QuickBooks. That's why you're unable to locate the Action pull-down menu. With QBDT, you can receive inventory with or without a bill after you record a purchase order. This way, your quantity on hand for each item and the payable to the vendor will be updated. Let me guide you how.
I've attached a screenshot below that shows the third and fourth steps.
You can also refer to this article for the detailed steps: Receive inventory.
Receiving inventory is part of your usual A/P workflow in QBDT. To see the complete list of workflows and other vendor-related transactions, refer to this article: Accounts Payable workflows in QuickBooks Desktop.
Let me know how it goes in the comments below. If you have other concerns about receiving inventory items, purchase orders, and vendor-related transactions, I'm just around to help. Take care always.
I noticed you said the inventory gets updated once the bill is paid. How does that work with charge accounts? We typically have 30 to 60-day terms with our vendors, but would like to have the inventory updated when we receive the items, rather than when paying the bill.
I'm here to share some insights about this, PrestigeLock.
In QuickBooks Online, the item will be added automatically to the Products and Services list after creating a bill from a purchase order.
For QuickBooks Desktop, you can receive inventory without a bill after you record a purchase order.
Here's how:
For further guidance with the process, please see this article: Receive Inventory.
Once you record what you owe to your vendors in QuickBooks Desktop, you can now pay your bills to settle your payables. Please see this article for QuickBooks Online.
Please do let us know if you need further assistance in managing your vendor transactions and inventory. I'm here to help you out.
While Charlene's solution is nice, it misses an important point. If you manually enter inventory receipt, you are missing a useful feature of Quickbooks. Anyway here's how we do it - you might want to try it:
This fully uses the automation feature of Quickbooks for inventory control. It's simple and does not require any manual corrections or entries for almost all of our inventory receipts.
I am using QB Online.
Is there a definitive How To Video, recommendations for a third party product, that better assist this process of Receiving Inventory for a business where we receive back orders, constantly? I've read multiple threads and jeez... really? One 'How To' template that nails it should be created. QBO is very limited. Small business owners don't have time for adjusting inventory reports, etc. I've used Enterprise and thought QBO was a less expensive and had the requisite suite of features to run your business--- At this point I am looking at Zoho. Also, Intuit, (I am in the South Bay) -- are you driving a business model that requires third party applications because while QBO accessibility is great for remote teams, you need to crank up the usability studies and listen to folks a bit more. (I've been trying to get the Sales Order feature for over 3 years.)
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