cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
SergeiG
Level 2

Importing vendors invoices (goods) or purchase orders in QBO

Hello community,

 

I'm using QBO Plus with FIFO inventory tracking and I'm looking for a solution for the next scenario:

Each 2-3 months I need to enter to QBO a new vendor's invoice for 500-600 products (a half of existing products and another half is new products).

As I see, the typical solution by QBO is creating a purchase order (for inventory control) and vendor bill (for money tracking). Am I correct?

If I follow this solution, I can import a list of new products and create a purchase order manually. However, doing it manually I spent a lot of time and have a big chance for mistakes.

If I change number of products directly in stock manually, I loose opportunity to track inventory by FIFO and have a chance for mistakes again.

 

So, the question is:

Is there any way to import vendor's invoices (_not_ bills) OR purchase orders to QBO, as I can import initial inventory?

 

Thank you.

3 Comments 3
JamesM4
QuickBooks Team

Importing vendors invoices (goods) or purchase orders in QBO

Hello SergeiG,

 

Glad to have you message us here. QuickBooks is a versatile program that helps you streamline your accounting with ease. I'll be happy to steer you in the right direction so you can get back to doing what you love. 

 

The  function you've described above isn't available. I can see the benefit of having the importing options you've described and I encourage you to send feedback about this to our engineers. You can send feedback by clicking on the Gear icon and looking for Feedback. I recommend searching for a third-party data migration app that can offer more importing options on our app store www.apps.com.

 

Let me know if you have other questions by leaving a comment below. I'll be one message away.

Fiat Lux - ASIA
Level 15

Importing vendors invoices (goods) or purchase orders in QBO

@SergeiG 

You can prepare your Purchase Order data with the following template

RefNumberAPAccountVendorPrintOnCheckNameTxnDateDueDateSalesTermPOStatusShipMethodNameClassAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryPrivateNoteCurrencyExchangeRateExpenseAccountExpenseDescExpenseAmountExpenseBillableStatusExpenseBillableEntityExpenseClassLineItemLineDescLineQtyLineUnitPriceLineAmountLineBillableStatusLineBillableEntityLineClass
101 Staples ################## OpenUPS 100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  Office SuppliesFor Anne25.1           
101 Staples ################## OpenUPS 100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  TelephonePhone Cards50.25           
101 Staples ################## OpenUPS 100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  Office FurnitueNew Chairs300.18           
185 Green's Taxi Service ######### Net 30Closed  1 Main Street   San DiegoCA12345    Transportation 125.13           
201 Federal Express ######### Net 30Open  PO Box 1800   DallasTX23456    Delivery Chargestracking number PR7 1HX25.15           

 

then  use an importer tool to proceed

https://get.transactionpro.com/qbo

 

SergeiG
Level 2

Importing vendors invoices (goods) or purchase orders in QBO

Thank you for the answer.

I left a feedback and I hope that it wouldn't put at the bottom of a backlog.

As a new customer, I was surprised that this root and useful feature still not implemented in QBO.

Need to get in touch?

Contact us