Purchase order to sales order automation in QuickBooks Desktop

Why do customer POs get keyed wrong?

Customers use their own part numbers, so someone has to know their “BRK-12” is your item 4410.
Prices disagree, because QuickBooks fills in the price from your item.
Ship-to addresses change per order, and the PO’s address gets missed.

How do you turn a PO email into a sales order by hand?

1. Send every PO to one folder.

New Outlook: right-click a PO email, hover over Rules, select Create rule, choose the folder and select OK. For more conditions, select More options, Add a condition, Add an action, then Save.
Gmail: in the search box, click Show search options, enter the criteria, click Create filter, choose to apply a label, and click Create filter again. A search such as has:attachment {from:buyer@example.com from:purchasing@example.com} catches attached POs from one customer’s buyers.
Add a second rule on the customer’s addresses alone for POs typed into the email body.

2. Turn on sales orders. Go to Edit > Preferences, select Sales & Customers, open Company Preferences, check Enable Sales Order and select OK.

3. Create the sales order. Go to Customers > Create Sales Orders and pick the customer from Customer: Job. Enter the order details from the PO, including the customer’s PO number, then add each line under Item.

4. Check every line against the PO. The description and amount fill in from your item setup and can be changed on the sales order. Compare quantity, unit and price line by line, then select Save & Close.

5. Order what you don’t stock. In Enterprise 24.0 R9 and later, go to Edit > Preferences > Items & Inventory > Company Preferences and check Link and track sales order line items with purchase orders. Then select Create Purchase Order on the sales order.

6. Close the email. Move it to an “Entered” folder or label.

What does each PO format need?

Format	What goes wrong	Check before you save
PDF from the customer’s system	Their part numbers, multi-page line lists	Line count and PO total match the sales order
Excel file	Extra columns, hidden rows, units in a separate column	Units of measure and every row copied
Typed in the email body	Missing PO number or ship-to, “same as last time”	Ask for the missing detail before entering
Revised or resent PO	A second sales order for the same order	Search the PO number before creating a new one

How do you check it worked?

Count. POs received today should equal sales orders entered today.
Run the open orders report. Go to Reports > Sales > Open Sales Orders by Customer and look for duplicates.
Spot-check prices on three orders a day.
Watch fulfillment. In Enterprise, turn on the worksheet at Edit > Preferences > Items & Inventory > Company Preferences > Advanced Inventory Settings, under Site Operations. Open it from Customers > Sales Order Fulfillment Worksheet; its Dashboard shows orders as Open, Picked, Packed and Shipped.
Invoice from the order. On the sales order, select Create Invoice, then Create invoice for all of the sales order(s) or Create invoice for selected items.

What are your options?

Option	Good for	Watch for
Do it yourself with inbox rules and the checks above	A few dozen POs a week from a handful of customers	Keying time, and one person who knows every customer’s part numbers
Buy an order-entry app that connects to QuickBooks Desktop	Steady volume in consistent formats	What it does with a PO it can’t read, and whether it supports your Desktop version
Ask customers to order through EDI or a portal	Large customers who already send EDI	Smaller customers keep emailing
Bring in an outside team (AI workers)	Mixed formats, many customers, revisions	Who approves orders before they reach the warehouse

What can an AI worker do, and what stays with your team?

An AI worker can do	Keep with your team
Read PDF, Excel and email-body POs from the shared folder	Accepting a price that differs from your price list
Match the customer’s part numbers to your items	Adding new items or new customers
Check for an existing sales order with the same PO number	Changing a confirmed ship date
Create the sales order	Credit holds and terms
Send you a daily list of entered, flagged and skipped POs	Anything the PO and your records disagree on

Check every order it creates for the first weeks, then widen what it enters alone.

Apps reach a Desktop company file only with your permission, set under Edit > Preferences > Integrated Applications > Company Preferences. Choose “Yes, whenever my QuickBooks company file is open” and leave the personal data checkbox (Social Security numbers and similar) off.

Before handing anything off, map how a PO moves today, step by step. For the status questions in the same inbox, see answering dealer order status emails. For read-only questions about your numbers, see what the Claude connector can do with QuickBooks Desktop.

FAQ

Can QuickBooks Desktop import sales orders from a CSV file? No. Intuit’s CSV import covers lists such as customers, vendors and items, so sales orders come in by hand or through a connected app.

Which QuickBooks Desktop editions have sales orders? Intuit says sales orders are only available in Premier and Enterprise. The Sales Order Fulfillment Worksheet is an Enterprise feature.

Should the customer’s PO number go on the sales order? Yes. It is how you find duplicates, answer the customer’s questions and match their payment later.