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

Can I create batch purchase orders using the batch transactions function or through Excel sync feature in QBO Advanced?

We use workflow approvals in QBO Advanced. Currently, I have a massive amount of POs in Excel that need to be entered into QBO. I am looking if there is a way I can do this with copy paste from Excel or by using the Excel sync feature. Thank you!
2 REPLIES 2
JanbonN
QuickBooks Team

Can I create batch purchase orders using the batch transactions function or through Excel sync feature in QBO Advanced?

While it's not possible to create batch purchase orders in QuickBooks Online Advance (QBOA), Rah. I'm here to help you submit a feature request.

 

We recognize how essential this functionality is for your business. Therefore, I suggest sending feedback to our dedicated product engineering team. They're responsible for thoroughly analyzing and determining which features will be included in the upcoming updates for the program.

 

To send your request:

 

  1. Go to the Gear icon.
  2. Select Feedback.
  3. Enter your comments or product suggestions.
  4. Tap Next to submit.

 

As a workaround, you can explore third-party applications that offer to enter batch purchase orders to QBO.

 

Additionally, you can run a report to get an overview of your business finances.

 

Let us know if you have other concerns with your batch transactions. We'll be here to help you in any way we can.

4Gal
Level 11

Can I create batch purchase orders using the batch transactions function or through Excel sync feature in QBO Advanced?

@rahmatullah-inar 

Prepare your PO 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           
201 Federal Express ######### Net 30Open  PO Box 1800   DallasTX23456    Delivery Chargestracking number 1235885.3           
201 Federal Express ######### Net 30Open  PO Box 1800   DallasTX23456    Delivery Chargestracking number 1238765.12           
201 Federal Express ######### Net 30Open  PO Box 1800   DallasTX23456    Delivery Chargestracking number 1239188.5           

 

then use an importer tool to proceed.

https://get.transactionpro.com/qbo

 

Need to get in touch?

Contact us