LIMITED TIME 90% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
owayusaibe
Level 1

Can you create a purchase order by uploading a CSV file?

Would like to know if I can create a Purchase Order by uploading a CSV file versus entering each item manually.

2 Comments 2
Clark_B
QuickBooks Team

Can you create a purchase order by uploading a CSV file?

Hello there, @owayusaibe. I'd like to provide some insights on uploading purchase orders via CSV files in QuickBooks Online (QBO).
 
At the moment, the option to import purchase orders in QBO is unavailable. You can either add them manually or use a third-party app that integrates with QBO to bring in those POs.
 
To find a suitable app, go to the Apps menu within your company file. Here’s how:
 
  1. From the left menu, select Apps.
  2. Go to the Find apps tab.
  3. Enter the app name in the search bar or select the Browse category dropdown menu to check out different apps.

 

Additionally, you can visit this site to further search for a third-party app that allows CSV file importation of purchase orders: Third-party application.
 
For more information, check out this resource for FAQs about importing data to QBO: Common questions about importing data to QuickBooks Online.
 
Furthermore, I've included an article for viewing all your transactions in a specific report: Run reports in QuickBooks Online.
 
Please feel free to reach out for further assistance with data importation, @owayusaibe. We're here to help you.
Chrea
Level 8

Can you create a purchase order by uploading a CSV file?

@owayusaibe 

You can prepare your 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 you can use an importer tool to proceed.

https://get.transactionpro.com/qbo

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us