Is it possible to import a purchase Order from Excel or a CSV file into QBO?
I have large Purchase Orders of approx 80 - 100 lines at a time and would like to be able to pull this data into QBO instead of manually typing the Stock codes and then the Quantities.
Thank you for taking the time to reach out to us here on the Community page, @graham-hogg.
We're able to import bank transactions to QuickBooks Online (QBO) by preparing an Excel CSV file. However, importing purchase order to QBO isn't available as of the moment. To bring the details to QuickBooks, you have to input the transactions manually.
To create a purchase in QBO:
I understand the importance of being able to import purchase orders to QBO, @graham-hogg. I'll take note of this and ensure to send feedback to our product developers. This way, they'll be able to know and might consider the feature in the coming updates.
For additional reference about importing bank transactions using Excel CSV files, read these articles:
Post again if you have any other questions. I'm a post away to help. Have a good day!
Utilize the 3rd party tool to import PO data in bulk
The template should be like this
|101||Staples||15/05/2020||15/05/2020||Open||UPS||100 Houston Street||Suite 2000||San Diego||CA||12345||Internal Use||Office Supplies||For Anne||25.1|
|101||Staples||15/05/2020||15/05/2020||Open||UPS||100 Houston Street||Suite 2000||San Diego||CA||12345||Internal Use||Telephone||Phone Cards||50.25|
|101||Staples||15/05/2020||15/05/2020||Open||UPS||100 Houston Street||Suite 2000||San Diego||CA||12345||Internal Use||Office Furnitue||New Chairs||300.18|
Hope it helps.
Thanks for joining this thread, Serge01.
For now, the ability to import Purchase Orders into QuickBooks Online is still unavailable. We're unable to provide you a specific time frame as to when this feature be added in QuickBooks. You'll want to consider looking for a third party application that can integrate with QBO. That way, you'll be able to import purchase orders. You can visit this link: QuickBooks App Center
I would also recommend visiting our QuickBooks Blog. From there, you'll be updated with the features and enhancements that our developers are currently working on.
Please let me know if you any other QuickBooks concerns. I'll be around to help you out.