Create and Edit NetSuite Records in Excel
Download, edit and upload 155+ NetSuite record types from Excel, including your custom records. Customers, items, sales orders, vendor bills and more, in bulk.
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.
- NetSuite record types, plus your custom records
- 155+
- to download, edit and upload
- 1 sheet
- are sent when you upload
- Changes only
- from any row to its record in NetSuite
- 1 click
Every supported NetSuite record type, editable in a spreadsheet
Bulk Records turns a NetSuite record type into an Excel sheet: one row per record, or per line for transactions, with a column for each field you chose. Download the records you need, change them with everything Excel offers, and upload. New rows become new records.
- 155+ record types, including your custom record types and custom fields
- Create and update on one sheet: the Internal ID column decides which
- Transaction lines with a Line ID per line, so edits land on the right line
- Only records that changed are sent when you upload
- NetSuite’s errors appear on the row and cell that caused them
- Each row links straight to its record in NetSuite, so checking an upload takes one click
- Templates you can share with your company and copy from sandbox to production
From NetSuite to Excel and back in four steps
Design the template
In the Template Portal, right in Excel, pick the record type and the body and line fields you want as columns.
Download records
In Excel, choose Record Edit › Bulk Records and your template, then download the records that match your filter. Learn how to download records.
Edit in Excel
Change values, fill down, paste from another sheet or calculate with formulas. Add rows for new records.
Upload
Upload sends the new and changed records to NetSuite. Anything NetSuite rejects is flagged on its cell.
Step-by-step guides to common bulk jobs
Each guide gives the template settings, the steps on the sheet and what to check before you upload.
Accounting and close
AP, AR and treasury
Sales, purchasing and operations
Inventory
Built for the way finance and operations teams change data
One sheet stays connected to NetSuite from download to upload, and shows you what happened to every record.
Create and update
One sheet creates and updates records
Download the records you want to change and add rows for new ones. A row with an Internal ID updates that record, and a row without one creates a new record. Excel formulas can clean up or transform data before it goes in.
Screen recording in Excel with on-screen callouts. A Customers sheet is set to download the customers created from 10/15/2026 to 10/16/2026, and Download Customers on the Finsyte ribbon is pointed at. Callout: Download the customers. The banner reads Download complete, 5 records. Callout: Every customer, ready to edit. Each row, Northwind Fabrication, Summit Ridge Tools, Cedar Valley Supply, Bluebird Machining and Ironwood Components, has its Internal ID. The phone number for Summit Ridge Tools changes from 303-555-0110 to 303-555-0188. Callout: Change a row that has an Internal ID. The fields of Ironwood Components are copied and pasted into a new row. Callout: Add a row without one. The new row is named Silver Creek Supply, with Customer ID CUST-1107 and no Internal ID. Callout: No Internal ID means a new customer. Add/Edit Customers is pointed at. Callout: Add/Edit uploads both. The banner counts processing 0 of 2 to 2 of 2, and the new row gets Internal ID 5048 and Customer ID 472 in place of CUST-1107. The banner reads Upload complete, 1 created, 1 updated. Callout: One updated, one created. Summit Ridge Tools reads Updated Customer 468, Silver Creek Supply reads Created Customer 472, and the other rows read Skipped (no changes).
Errors
NetSuite’s errors land on the cell that caused them
When NetSuite rejects a value, the error appears as a note on that cell. Each record succeeds or fails on its own, so one rejected record doesn’t stop the rest. Fix the marked cells and upload again: records that already went in aren’t duplicated.
Screen recording in Excel with on-screen callouts. Six customers are downloaded on a Customers sheet. The phone number for Cedar Valley Supply changes from 303-555-0144 to 303-555-0155. Callout: Change a phone number. The Category cell of Northwind Fabrication is right-clicked and Wholesale, which is not a NetSuite category, is pasted with Paste Options › Keep Text Only. Callout: Paste a category NetSuite will reject. Add/Edit Customers on the Finsyte ribbon is pointed at. Callout: Upload with Add/Edit. The banner counts processing 0 of 2 to 2 of 2, then reads Upload complete, 1 updated, 1 failed (4948): Category "Wholesale" is invalid. Callout: The good record still goes in. Cedar Valley Supply reads Updated Customer 469, while Northwind Fabrication reads Error: upload failed and its Category cell turns red. Hovering the red cell shows the note Invalid Category: "Wholesale", which explains that Wholesale wasn’t in the column’s dropdown list, so NetSuite didn’t accept it. Callout: The error sits on the cell that caused it. The cell’s dropdown list opens and Mechanical Supplies is pointed at. Callout: Pick a valid category from the dropdown. Mechanical Supplies is picked and Add/Edit Customers is pointed at again. Callout: Upload again. The banner counts processing 0 of 1 to 1 of 1, then reads Upload complete, 1 updated. Callout: Fixed, with nothing duplicated. Northwind Fabrication reads Updated Customer 467 and its Category cell is no longer red, and Cedar Valley Supply, already in, reads Skipped (no changes).
Results
Check every upload in one click
After an upload, each row’s Status shows the result and links straight to that record in NetSuite, including records the upload just created. Click the status to open the record and check it. Downloaded rows carry the same link, so the record behind any row is one click away.
Screen recording in Excel and NetSuite with on-screen callouts. Six customers are downloaded on a Customers sheet. The phone number for Bluebird Machining changes from 303-555-0123 to 303-555-0139. Callout: Change a record. The fields of Silver Creek Supply are copied to a new row, named Maple Ridge Tooling, with Customer ID CUST-1108 and no Internal ID. Callout: Add a new one. Add/Edit Customers on the Finsyte ribbon is pointed at. Callout: Upload new and changed records. The banner counts processing 0 of 2 to 2 of 2, the new row gets Internal ID 5148 and Customer ID 473, and the banner reads Upload complete, 1 created, 1 updated. Callout: Each row’s Status links to its record. Bluebird Machining reads Updated Customer 470, Maple Ridge Tooling reads Created Customer 473, and the other rows read Skipped (no changes). Pointing at Created Customer 473 shows the link to that customer’s record in NetSuite. Callout: One click opens it in NetSuite. The link is clicked and the record opens in NetSuite in Microsoft Edge: customer 473 Maple Ridge Tooling, status CUSTOMER-Closed Won, phone 303-555-0123, category Industrial, primary subsidiary United States. Callout: The new customer, in NetSuite.
Validation
Check the sheet before anything is sent
Validate Sheet reviews the whole sheet without sending anything to NetSuite: required fields, list values, dates, closed or locked posting periods, and journal entries that don’t balance. It also shows how many records the upload will create, update or leave unchanged.
Screen recording in Excel with on-screen callouts. Seven customers are downloaded on a Customers sheet. The Primary Subsidiary of Summit Ridge Tools, United States, is deleted. Callout: Clear a required field. The phone number for Cedar Valley Supply changes from 303-555-0155 to 303-555-0177. Callout: Change a phone number. The fields of Maple Ridge Tooling are copied to a new row, named Juniper Tooling, with Customer ID CUST-1106 and no Internal ID. Callout: Add a new customer. Validate Sheet on the Finsyte ribbon is pointed at. Callout: Validate Sheet checks everything first. Validate Sheet is clicked and nothing is sent to NetSuite. The rows to send are highlighted, and the banner reads Validation warning, 1 possible issue(s) across 1 record(s), hover highlighted cells for details. 1 to create, 2 to update, 5 unchanged. The Status column reads Will create on Juniper Tooling, Will update on Cedar Valley Supply and Will update, review warnings on Summit Ridge Tools, while the other rows keep their downloaded links. Callout: See what will be created or updated, before anything is sent. Hovering the highlighted empty Primary Subsidiary cell shows the note Primary Subsidiary is required. Callout: Problem cells are flagged. Hovering the Status cell of Summit Ridge Tools shows the same note. Callout: …with the reason in a note.
Everything a bulk update needs
Work the way you already work in Excel
Sort and filter to find the records to change, fill a new value down a column, look values up against a mapping table, or paste a block from another workbook. The sheet only reaches NetSuite when you choose to upload.
Templates your team can share
Build a template once in the Template Portal, right in Excel. Keep it personal or share it with everyone in your company, and export it to copy it between your sandbox and production accounts. A default filter limits every download to the records it’s meant for, such as invoices in US dollars.
Lines without the guesswork
Every line sublist gets a Line ID column. A row with a Line ID updates that line, a row without one adds a line, and a line whose ID is on no row is removed. Sublists your template has no columns for are never touched.
Lot numbers, serial numbers and statuses
Add the Inventory Assignment columns and enter lot numbers, serial numbers and inventory statuses directly, one row per assignment. Leave them off and NetSuite builds the default detail for you.
Create one transaction from another
Name a source transaction in Created From and Bulk Records creates the record from it the way NetSuite does: an invoice or item fulfillment from a sales order, an item receipt or vendor bill from a purchase order, a credit memo from a return authorization, and other supported pairs. A row that can’t be matched is held back with the reason on its cell.
Only what changed
Every downloaded record is stamped with a checksum, so an upload sends only the records you actually changed, and added, copied or deleted line rows count as changes. Dropdowns tied to the sheet fill list fields with valid values.
Custom records and custom fields
Custom record types and custom fields work the same way as standard ones, so the records your account has added to NetSuite are covered too.
Built on NetSuite’s REST API
Bulk Records works through NetSuite’s REST API with each user’s own NetSuite role and permissions. It needs the Finsyte SuiteApp deployed in your NetSuite account, which comes with Finsyte and deploys from Finsyte Preferences, and no extra NetSuite modules.
Built-in templates too
Record Edit also includes ready-made templates for budgets and for journal entries and intercompany journal entries.
155 record types, grouped by the work they support
Each page lists every record type it covers. Custom record types and custom fields work the same way.
- 22 record types
Customers, vendors and CRM
Customer, Vendor, Contact and more - 30 record types
Items and merchandising
Inventory Item, Non-Inventory Purchase Item, Non-Inventory Resale Item and more - 20 record types
Sales and billing
Invoice, Sales Order, Estimate and more - 8 record types
Purchasing
Vendor Bill, Purchase Order, Vendor Credit and more - 20 record types
Financial transactions
Budget Import, Journal Entry, Adv. Intercompany Journal Entry and more - 22 record types
Inventory and manufacturing
Inventory Adjustment, Inventory Transfer, Item Fulfillment and more - 33 record types
Lists and setup
Account, Classification, Department and more - Your own
Custom records
Custom record types and custom fields, downloaded and uploaded like standard ones
A simpler alternative to CSV imports
Updating NetSuite data in volume usually means a round trip: export, edit, map, import, then check what failed. Bulk Records keeps that whole cycle in one Excel sheet that stays connected to NetSuite.
For teams that work in Excel, Bulk Records is a simpler alternative to CSV imports. You set the template up once rather than mapping fields for every import, and the same sheet downloads, edits and uploads, so there is no file to export and reassemble.
Bulk Records: FAQ
- QCan I use Bulk Records instead of a CSV import?
- Yes. Bulk Records downloads, edits and uploads records from one Excel sheet, so you set a template up once instead of mapping fields for each import. It creates and updates records on the same sheet and shows any errors on the cells that caused them.
- QWhich NetSuite record types does it support?
- 155+: all 155 standard record types, from customers, vendors and items to sales orders, invoices, purchase orders, vendor bills, payments, inventory transactions and setup lists, plus your custom record types.
- QCan I update existing records as well as create new ones?
- Yes. Download the records you want to change, edit them and upload. A row with an Internal ID updates that record; a row without one creates a new record.
- QDoes it handle transaction lines?
- Yes. Each line has a Line ID, so an upload updates, adds or removes the right lines. Sublists the template has no columns for are left as they are.
- QHow do I check a record after I upload it?
- Click its Status cell. After an upload, each row’s status links straight to its record in NetSuite, including records the upload created, so you can open and check it without searching.
- QWill an upload change records I didn’t edit?
- No. Every downloaded record is stamped with a checksum, so an upload sends only the records you changed.
- QWhat happens if NetSuite rejects a record?
- Its error appears on the cell that caused it, and every other record still uploads. Fix the cell and upload again; records that already went in aren’t duplicated.
- QWhat do I need in NetSuite?
- The Finsyte SuiteApp, deployed in your NetSuite account. It comes with Finsyte and deploys from Finsyte Preferences. No extra NetSuite modules are needed.
- QCan my team share templates?
- Yes. A template can be personal or shared with everyone in your company, and only its owner can change it. Export a template to copy it between your sandbox and production accounts.
- QDoes it handle lot and serial numbers?
- Yes. Add the Inventory Assignment columns to a template to enter lot numbers, serial numbers and inventory statuses for each line. Without them, NetSuite builds the default inventory detail.
- QDoes it work with custom fields and custom records?
- Yes. Templates can include custom fields, and custom record types can be downloaded, edited and uploaded like standard ones.
Try it with your own NetSuite data
30-day free trial with every Finsyte feature included. No credit card required.