Import Purchase Orders
into Xero from
Excel, CSV or PDF
Xero cannot import purchase orders from a file, so someone retypes them. Email your PO export or spreadsheet to EntryRocket instead and the purchase orders appear in Xero automatically: every line item, every supplier, every time.
Used by businesses across the UK, Australia, New Zealand, and the US. Xero App Partner.
How it works
Email your purchase orders
CSV, Excel, PDF - send as-is to <unique>@files.entryrocket.com
โ
Your custom reader processes it
Maps every field (contact, date, delivery date, reference, line item details) exactly how Xero needs it
โ
Purchase orders appear in Xero
Every field correctly mapped as it should be
โ
You get a confirmation email
What was imported, what Xero returned, anything to review
Your procurement system and Xero shouldn't require a person in between
You raise a purchase order in your procurement system, then someone manually re-enters it into Xero. Or you export a file and spend time reformatting it to match Xero's template. Either way, the same data is being touched twice, and every touch is a chance for an error.
EntryRocket eliminates the manual step. Export your POs from your procurement system, email the file, and they appear in Xero exactly as they should.
Common scenarios for importing purchase orders into Xero
If your procurement workflow starts outside Xero, these are the situations where EntryRocket saves the most time.
Procurement teams using a separate purchasing system
Your team raises POs in a dedicated procurement tool or ERP module, but needs them reflected in Xero for budget tracking and bill matching. EntryRocket imports POs from your procurement system export so Xero always has the full picture, without double entry.
Retailers placing regular stock orders with suppliers
A retail business placing weekly replenishment orders across multiple product lines. Rather than recreating each order in Xero, email the order file and EntryRocket creates the purchase orders automatically: quantities, unit prices, and supplier details all mapped correctly.
Businesses matching POs to incoming bills
When supplier bills arrive, your team needs to match them against existing POs in Xero. That only works if the POs are in Xero in the first place. EntryRocket makes sure they are, automatically, from whatever system generated them.
What your purchase order spreadsheet needs
Xero imports invoices, bills and contacts from CSV, but not purchase orders. The request has been on Xero's product ideas forum since 2013; Xero's community manager closed it in May 2022 with "we do not have a direct plan to build export and import functionality in Purchase Order any time soon", and the newer request for an Excel import has sat at Submitted since 2023. So there is no Xero template to fill in. EntryRocket reads the file you already have, in whatever columns it has, and creates the purchase orders through the Xero API.
Column names and order do not matter, because the reader is built for your layout. What matters is that the file carries the data Xero needs for each purchase order. One row per line item, with the PO number repeated on every row, is the most common shape; one row per purchase order with the lines in a second sheet works too.
| In your file | Where it lands in Xero | Needed? |
|---|---|---|
| Supplier name | Contact, matched to an existing supplier in Xero or created | Required |
| PO number | Purchase order number (or Xero can assign the next one) | Required to skip duplicates |
| Order date | Date | Required |
| Line description, quantity, unit price | One line item each | Required |
| Account code or a rule to derive it | Account on each line | Required, can be fixed per reader |
| Tax code, or tax inclusive/exclusive flag | Tax rate on each line | Optional, defaults per reader |
| Item or product code | Product from products and services, with its purchase account and price | Optional |
| Delivery date, delivery address, attention to, telephone | Delivery details on the purchase order | Optional |
| Reference, job or cost centre | Reference field, or a tracking category on each line | Optional |
| Currency | Currency on the purchase order | Optional, base currency by default |
A sample row and what it becomes
Take a builder's ordering spreadsheet with one row per line: PO-10452, Northside Timber Supplies, 03/08/2026, 10/08/2026, TMB-9045, 90x45 MGP10 treated pine 4.8m, 120, 14.20, Lot 12 Rivergum Dr. The reader turns every row with PO-10452 into one purchase order in Xero for Northside Timber Supplies, dated 3 August with delivery on 10 August, a line of 120 x $14.20 coded to the materials account with GST on Expenses, and "Lot 12 Rivergum Dr" as the job tracking category. It is created as a draft or an approved purchase order, whichever you choose, and is ready to convert to a bill when the supplier invoice arrives.
Systems that export every open purchase order each time, rather than only the new ones, are handled too: a reader can check the purchase order numbers already in your Xero organisation before creating anything, so re-sending the full export never creates a duplicate.
Import purchase orders into Xero in four steps
The whole process takes less than a minute. You don't need to log into anything.
Email your purchase orders
Send to your dedicated @entryrocket.com address. CSV, Excel, PDF - send them as-is. No reformatting required.
Your custom reader picks it up
Maps every field (contact, date, delivery date, reference, line item details) exactly how Xero needs it.
Your purchase orders appear in Xero automatically
Supplier contact, line items, quantities, and amounts all correctly mapped.
You get a confirmation
An email showing what was imported, what Xero returned, and anything that needs a second look.
Import purchase orders into Xero from any file format
EntryRocket works with every format your accounting software, supplier, or ERP system can produce:
- CSV and TSV files
- Excel spreadsheets (.xlsx, .xls)
- PDF purchase orders
- XML and JSON exports
- IIF, TXT, and YAML files
Not sure if your format is supported? Send us a sample file and we'll tell you straight away.
Files received today
Xero document types
Every Xero document type, covered
Importing purchase orders is just the start. EntryRocket can create any document type in Xero.
Each reader is built around your exact file format and your Xero setup, not a generic template.
Why businesses choose EntryRocket for Xero purchase order imports
100% accuracy
No typos, no transposed numbers. Your data goes straight from the file into Xero exactly as it should. Our accuracy rate is 100%.
Under a minute per import
Most imports complete in under a minute. We process over 3,000 files per hour.
No login required
Just email your files. You don't need to log into anything or change your workflow.
Xero-certified
EntryRocket is an official Xero App Partner. Our integration has been reviewed and approved by Xero's team.
Always on
Send files whenever it suits you: weekends, late night, whenever. EntryRocket picks them up immediately.
Real support
Got a question? You'll hear back from the engineers who build EntryRocket, not a chatbot, not a ticket queue.
Loved by businesses worldwide
"What used to take 10-12 working hours every week now takes just seconds. EntryRocket has transformed our bookkeeping workflow completely."
Irma Bantjes
CFO, Stratus Financial Group ยท Sydney, Australia
"Our process went from 10-12 working hours to less than 10 minutes. The time savings alone make this an incredible investment for any business."
Peter Samuel
Forward Trucking Services ยท UK
Frequently asked questions
About importing purchase orders into Xero with EntryRocket.
View all FAQs โHow do I import purchase orders into Xero?
Email your PO file to your dedicated @entryrocket.com address. EntryRocket maps every field (PO number, supplier, line items, quantities, amounts) and creates the purchase orders in Xero automatically.
Can I import purchase orders from any procurement system into Xero?
Yes. EntryRocket builds a custom reader around your procurement system's export format. Whatever file your system produces (CSV, Excel, XML, JSON) we work with it as-is. You don't change your system or your process.
Can EntryRocket import purchase orders with multiple line items?
Yes. Multi-line POs are fully supported. Each line item is mapped to Xero with its own account code, quantity, unit price, and description.
What file formats work for importing purchase orders into Xero?
CSV, Excel, PDF, XML, JSON, IIF, TXT, and YAML. If your procurement system can export it, EntryRocket can almost certainly work with it.
How long does setup take for purchase order imports?
Most readers are ready within 2-3 business days. Complexity depends on your file format and any business rules you need applied: multi-currency, project codes, approvals routing, etc.
Also import into Xero
EntryRocket handles every Xero document type, not just purchase orders.
Import invoices
Sales invoices from any file format. CRM exports, e-commerce platforms, or supplier spreadsheets, straight into Xero.
โImport bills
Supplier bills from procurement systems, logistics platforms, or any file your suppliers send you.
โImport quotes
Sales quotes and estimates directly into Xero.
โImport credit notes
Credit notes and refunds into Xero automatically.
โImport journals
Journal entries in your Xero automatically.
โImport bank statements
Convert bank statements from any format to OFX for Xero reconciliation. Especially useful when your bank doesn't support direct feeds.
โImport bank transactions
Spend and receive money transactions from business software into Xero automatically.
โImport payments
Payment allocations into Xero automatically.
โImport batch deposits
Remittance files matched to many invoices in Xero. Also handles AP batch payments.
โImport inventory items
Product and inventory data into Xero.
โImport contacts
Customer and supplier contacts into Xero.
โStart importing purchase orders into Xero automatically
If you're spending even 15 minutes a week on manual Xero data entry, EntryRocket can give that time back. Most readers are ready within 2-3 business days.