NetSuite Bulk Update Use Cases in Excel
Real jobs finance and operations teams do in NetSuite in bulk, each with the template settings to use, the steps on the sheet and what to check before you upload.
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.
Accounting and close
- Journal Entry
Upload Journal Entries to NetSuite from Excel
Copy last month’s accruals and allocations, change the amounts and upload them as new entries, each checked for balance first.
See the steps - Department, Classification, Location, Employee, Inventory Item, Purchase Order
Reclassify NetSuite Departments, Classes and Locations in Bulk
Create the new segment values, move open orders, employees and items onto them in one upload, and inactivate the old values when nothing points at them.
See the steps
AP, AR and treasury
- Company Bank Details, Bank Details
Switch EFT Templates on NetSuite Bank Accounts in Bulk
Download every company bank account to a sheet, pick the new EFT template on the accounts that move and upload them together. The same pattern updates vendor bank details.
See the steps - Customer, Vendor
Update NetSuite Customers and Vendors in Bulk from Excel
Download customers or vendors, change terms, credit limits and addresses with Excel’s own tools, inactivate the stale ones and upload only what changed.
See the steps
Sales, purchasing and operations
- Purchase Order
Change Line Fields on Many NetSuite Orders from Excel
Download open purchase orders with one row per line, change the department, class or rate on the lines that need it and upload. Other lines stay as they are.
See the steps - Purchase Order, Sales Order, Transfer Order
Bulk Close Old NetSuite Orders from Excel
Download open orders older than a cut-off date, mark the lines that will never be received or fulfilled as closed and upload them in one batch.
See the steps - Inventory Item, Service Sale Item
Update NetSuite Item Prices and Preferred Vendors from Excel
Download items with their price levels and vendors, work out the new prices in Excel and upload. Items you don’t change are skipped.
See the steps
Inventory
- Inventory Number
Update NetSuite Lot Numbers in Bulk
Download the lot number records for an item, correct expiration dates or fill in quality fields, and upload them together.
See the steps - Inventory Adjustment, Bin Transfer
Upload Inventory Adjustments and Bin Transfers to NetSuite
Add stock to NetSuite from a spreadsheet, with each new lot on its own row with its expiry and status, or move stock between bins in one upload.
See the steps - Item Receipt
Receive NetSuite Purchase Orders in Batches
Enter the order and quantities received on each row and upload. Each receipt is created from its purchase order and stays linked to it.
See the steps
Try Bulk Records with your own NetSuite data
30-day free trial with every Finsyte feature included. No credit card required.