cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
JB_amba_01
Level 1

Managing stock and goods-in process

Hi everyone,

I've just started using QuickBooks Advanced, and I've encountered a challenge with stock management. We need to accurately track our on-hand stock, but some of our suppliers require upfront payment before shipping. When an invoice is assigned to a purchase order, QuickBooks changes the status from 'on order' to 'on hand,' even though the stock hasn't arrived yet. Since our shipments are international, it can take days or weeks for the stock to actually be on hand. This makes it difficult to know what stock is truly available for us to send out.

 

I've spoken with the support helpdesk, but they couldn't offer a solution. I'm wondering if anyone else has faced a similar issue and found a way to resolve it? Would a stock inventory add-on help, or would it face the same issue since it pulls invoice details from QuickBooks?

 

Any advice or suggestions would be greatly appreciated. Thanks in advance!

3 REPLIES 3
John C
QuickBooks Team

Managing stock and goods-in process

Hi JB_amba_01 Thanks for reaching out to us here on the Community. You could create the purchase order as you normally would, you could then create a bill payment (enter billpayment after qbo.intuit.com/app/ in the url) or create an expense, to account for the payment to your supplier, and use the creditors/accounts payable in the category column, enter the amount paid. When your stock does arrive you can then copy the purchase order to the bill, select make payment and add/link the bill payment or the expense to the bill.

Please note that as we're not accountants we recommend that you contact an accountant to qualify the above or there maybe an accountant or experienced Community member that reads this post and they're able to verify the above or offer an alternative solution.

We have also submitted your feedback to our developers and hopefully in the future they maybe able to implement a more robust stock tracking system that would enable customers to have an option to not affect the quantity on hand when copying a purchase order to a bill. I would also recommend that you leave feedback from within your product by selecting the cog/gear icon > Feedback. 

Mark Armistead
Level 7

Managing stock and goods-in process

@JB_amba_01Unfortunately the stock handling in QBO is terrible and hasn't improved one jot since I moved over from the Desktop version three years ago.
For some reason Intuit seems to think that it's a low priority in company's workflows. About the only thing it can handle is split deliveries against a PO, but other than that you may have to create an external stock list in a spreadsheet I'm afraid.
I tried a suggestion on the ‘Ideas Exchange Forum’ (link below) to try and improve the stock handling. But, it was closed because Intuit are useless and implementing anything in the product and in these forums. Welcome to the club of either putting up with it and making it work, or finding another product I’m afraid.

Until they realise that stock handling is equally important and sales handling, then we are stuck with it.

 

 

https://quickbooks.intuit.com/learn-support/quickbooks-idea-exchange/new-section-for-purchasing-amp-...

 

 

On Beta
Level 2

Managing stock and goods-in process

@JB_amba_01 

Looking back at TradeGecko's fate after their acquisition, don't expect too much that they will improve their inventory management features. You should consider having a third party application to integrate with QBO.

Need to get in touch?

Contact us