Export purchase orders to CSV
Overview
Export purchase orders or PO line items from Ramp as CSV files, or download PO PDFs as a zip file.
Note: Procurement requires the Procurement add-on; if your business is eligible, you may be able to start a 60-day free trial.
For general information about managing POs, see Purchase orders in Ramp.
Export purchase orders, line items, or PDFs
Open Manage spend > Purchase orders, then open the download menu in the table toolbar and choose the file you need:
- Export purchase orders as .csv, including intake form responses downloads purchase order data and intake form responses
- Export line items as .csv downloads purchase order line-item data
- Download the PO PDFs as a zip file
What the purchase order CSV includes
The purchase order CSV includes these fixed columns in order:
| Order | Columns |
|---|---|
| 1–10 | PO Number; Display Name; Vendor Name; Status; Receiving Status; Total PO Amount; Currency; Total PO Amount (USD); Frequency; PO Start Date |
| 11–20 | PO End Date; Paid By Bill Amount; Pending Bill Amount; Paid By Card Amount; Last Invoiced Date; Last Invoice Number; Owner Name; Owner Email; Owner Department; Owner Location |
| 21–30 | Approvers; Coordinator Name; Coordinator Email; Spend Program Name; Requested Date; Issued Date; Next Payment Date; Net Payment Terms; Vendor Contact Name; Vendor Contact Phone |
| 31–40 | Vendor Contact Email; Vendor Address; Billing Contact Name; Billing Contact Phone; Billing Contact Email; Bill To Address; Shipping Contact Name; Shipping Contact Phone; Shipping Contact Email; Ship To Address |
| 41–49 | PO Memo; Promise Date; Vendor Owner Name; Vendor Owner Email; Requester Name; Requester Email; Revision Number; Last Emailed to Vendor At; Latest Version Emailed to Vendor |
The export also includes dynamic columns for your intake form questions, enabled tracking categories, and PO custom fields. It includes Accounting Entity when an accounting provider is connected.
Purchase order exports and Export settings
Purchase orders are not part of the generic Export settings surface. Export POs from Manage spend > Purchase orders instead.
The generic Export settings surface covers transactions, reimbursements, bills, and vendor payments. See Export your data to CSV for information about exports for those data types.