Thank you for visiting the Community today, ax_wes1.
Let me help and guide you in the right direction on how to import your data (spreadsheet) into the desktop program.
In addition to @Fiat Lux - ASIA answer, QuickBooks Desktop (QBDT) allows you to import your customers, vendors, items, and chart of accounts from an Excel spreadsheet. The option to copy and paste data from the spreadsheet into the purchase order, on the other hand, is currently unavailable. I can see the benefits of incorporating this functionality into the desktop program. Users will save time because they will no longer have to manually enter the data.
I suggest submitting feedback about this feature so our engineers can consider adding it in future updates. Here's how:
- In your company file, head to the Help menu at the top bar to choose Send Feedback Online and Product Suggestions.
- This action will open the QuickBooks Feedback window.
- From there, click the Type of Feedback drop-down to select Product Suggestion.
- Press the Product Area drop-down and choose which area in QuickBooks needs improvement.
- Then enter your product suggestions in the Here is my suggestion box.
- Fill in the remaining fields.
- Click Send Feedback.
Alternatively, you can use a third-party program to copy and paste the information from your spreadsheet into the QBDT purchase order. To find one, go to the QuickBooks Apps Center. From there, enter a keyword in the search bar to expedite the process. Then, review the customers' reviews for a better comparison.
You can find more information about the various lists and transaction types you can import or export with Excel files by clicking on this link. The expenses and vendors guide also covers managing money out payments, handling vendor credits, making purchase orders, and inventory tracking.
Reach out to me again if you have any further questions about importing data into the program or other QuickBooks issues. Please know that I am always available to help. Have a wonderful day.
