NetSuite Payments, Deposits and Journals from Excel
Create and edit NetSuite payments, deposits, expense reports, credit card charges, journal entries and time from Excel, 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.
Financial transactions in bulk, from Excel
Cash application, deposits, card charges and expense reports pile up at month end, and most of them already live in a spreadsheet or a bank export. Bulk Records lets you prepare them in Excel and upload them to NetSuite as one batch. Formulas can match receipts to open invoices or code card charges before anything posts, and only the records you changed are sent.
Apply customer and vendor payments
Customer payments, vendor payments and their applications carry apply lines, so a payment and the documents it settles go up together.
Record deposits, refunds and prepayments
Enter deposits, customer deposits, customer refunds and vendor prepayments from your bank or remittance data, with formulas doing the matching.
Load expense reports and card charges
Upload expense reports with their expense lines, and credit card charges and refunds with their item lines, straight from the statement export.
Load project time
Professional services teams can upload their hours as time entries, one row per entry, logged against the customer or project.
Financial transactions: every supported record type
20 record types that Bulk Records supports. Records with a line sublist are tagged with it.
Transactions: Financial
- Adv. Intercompany Journal EntryLines: Lines
- Budget Import
- Charge
- Credit Card ChargeLines: Items
- Credit Card RefundLines: Items
- Customer Deposit
- Customer PaymentLines: Apply
- Customer Refund
- Deposit
- Deposit ApplicationLines: Apply
- Expense ReportLines: Expenses
- Intercompany Journal EntryLines: Lines
- Journal EntryLines: Lines
- Paycheck
- Statistical Journal EntryLines: Lines
- Vendor PaymentLines: Apply
- Vendor Prepayment
- Vendor Prepayment ApplicationLines: Apply
Time & Payroll
- Time Bill
- Time Sheet
Instead of a CSV import
Record payments, deposits and other financial transactions 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 importsFinancial transactions in Bulk Records: FAQ
- QCan I import customer payments into NetSuite from Excel?
- Yes. Add each payment with the invoices it applies to and upload. Bulk Records creates the payments in NetSuite and flags any value NetSuite rejects on its cell.
- QCan I import time entries?
- Yes. Time entries (NetSuite's Time Bill record) are supported, one row per entry, so a team can upload its hours by customer or project from a sheet.
- QCan I import credit card charges from a statement?
- Yes. Paste the statement export into a Credit Card Charge sheet, code each charge with formulas or a mapping table, and upload. Each charge carries its item lines.
- QWhat happens when NetSuite rejects a payment or deposit?
- The error is placed on the row and cell that caused it, with the message as a cell note. Fix the value and upload again.
- QHow is this different from the Journal Entry template?
- The Journal Entry template is built for preparing and posting individual entries, with an Out of Balance check and a Review link. Bulk Records handles many records at once, with a sheet for each record type, journal entries included.
- QDo journal entries still need to balance?
- Yes. Balance journal entries and intercompany journal entries in Bulk Records the same way you do in NetSuite.
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
- Purchasing
- 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
- Journal Entry Template in the docs