NetSuite Purchase Orders and Vendor Bills from Excel
Create and edit NetSuite purchase orders, vendor bills, vendor credits and requisitions from Excel, lines included.
Screen recording in Excel with on-screen callouts. On the Finsyte ribbon, Record Edit opens a menu with Budget, Journal Entry, Intercompany Journal Entry and Bulk Records, and the Bulk Records submenu lists the saved templates by record type. Callout: Record Edit › Bulk Records › Opportunities. Opportunities is clicked. Callout: A Bulk Records sheet for Opportunities. An Opportunities sheet is inserted, with body field columns (Date Created, Opportunity #, Company, status, Probability), item line columns (Line ID, Item, Quantity, Rate, Price Level) and a Status column. Start is set to 6/1/2026. Callout: Set the date range to download. End is set to 7/31/2026, filtering on Date Created. Download Opportunities is pointed at. Callout: Download pulls the records in. The banner reads Download in progress, then Download complete, 7 records. Callout: Every matching record, ready to edit. The sheet holds 7 opportunities, OPP68 to OPP74, with their 10 item lines. The quantity of Welding Regulator Gauge on OPP70 changes from 5 to 3. Callout: Edit them like any Excel data. The quantity of 25 HP Rotary Vacuum Pump on OPP73 changes from 2 to 1, and SAF200 on OPP68 from 20 to 15. Add/Edit Opportunities is pointed at. Callout: Add/Edit uploads the changes. The banner counts processing 0 of 3 to 3 of 3, then reads Upload complete, 3 updated. Callout: Each row reports what happened. The Status column reads Updated Opportunity OPP70 on both of its lines, Updated Opportunity OPP73 and Updated Opportunity OPP68, where NetSuite set the SAF200 rate to 460; the other rows read Skipped (no changes). Pointing at Updated Opportunity OPP68 shows its link to the record in NetSuite. Callout: Each row links to its record.
Purchasing in bulk, from Excel
Purchasing and payables run on lists: bills to enter, orders from a planning sheet, credits from a vendor statement. Bulk Records puts each transaction and its lines in an Excel sheet, so a stack of documents becomes a batch you can check and upload at once. Formulas can code lines to accounts, departments and classes from a mapping table, and anything NetSuite rejects is noted on the cell that caused it.
Enter vendor bills with their lines
Add each bill and its lines from your worksheet, with formulas for coding and allocations, and upload the batch together.
Bill from purchase orders
Name the purchase order in Created From and the vendor bill is created from it the way NetSuite does, with each row matched to an order line.
Raise purchase orders from a plan
Turn a purchasing plan into purchase orders, requisitions or blanket purchase orders, one transaction per vendor with a line per item.
Record credits and returns
Create vendor credits and vendor return authorizations from a vendor statement or a returns list, lines included.
Purchasing: every supported record type
8 record types that Bulk Records supports. Records with a line sublist are tagged with it.
Transactions: Purchasing
- Blanket Purchase OrderLines: Items
- CheckLines: Items
- Purchase ContractLines: Items
- Purchase OrderLines: Items
- Purchase RequisitionLines: Items
- Vendor BillLines: Items
- Vendor CreditLines: Items
- Vendor Return AuthorizationLines: Items
Instead of a CSV import
Enter purchase orders and vendor bills with their lines without exporting, editing and re-importing a CSV. Once a record is uploaded, its row links straight to that record in NetSuite, so checking it takes one click.
Bulk Records: a simpler alternative to CSV importsPurchasing in Bulk Records: FAQ
- QCan I import vendor bills into NetSuite from Excel?
- Yes. Add each bill and its lines as new rows and upload. Bulk Records creates the bills in NetSuite and flags any value NetSuite rejects on its cell.
- QCan I create a vendor bill from a purchase order?
- Yes. Name the purchase order in Created From on a new bill row, and the bill is created from the order with its lines matched to the order’s lines.
- QCan I change purchase orders that already exist?
- Yes. Download them, edit header fields or lines, and upload. Each line keeps its Line ID, so changes land on the right line.
- QCan I receive a purchase order from Excel?
- Yes. Item receipts are created from purchase orders the same way, with each row matched to an order line. They are listed with the inventory and manufacturing record types.
- QAre custom fields and segments included?
- Yes. Templates can include custom fields and segments as columns, on the header or on the lines, so they download and upload with the rest of the transaction.
- QWhich purchasing records are supported?
- Purchase orders, vendor bills, vendor credits, vendor return authorizations, checks, purchase requisitions, blanket purchase orders and purchase contracts.
Try Bulk Records with your own NetSuite data
30-day free trial with every Finsyte feature included. No credit card required.
More Bulk Records
- Customers, vendors and CRM
- Items and merchandising
- Sales and billing
- Financial transactions
- Inventory and manufacturing
- Lists and setup
- Bulk Records overview
- How to bulk export NetSuite records to Excel
- Bulk Records use cases, step by step
- Bulk Record Templates in the docs
- Create Records From Another Transaction in the docs