Skip to main content
Bulk Records: Financial Transactions

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.

Start Free TrialWatch Demo
What Teams Do With It

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.

  • Import time

    Create time bills and timesheets from a time-tracking export, one row per entry.

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 imports
Questions?

Financial transactions in Bulk Records: FAQ

Q
Can 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.
Q
Can I import time entries?
Yes. Time bills and timesheets are supported record types, so time can be created from a sheet in bulk.
Q
Can 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.
Q
What 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.
Q
How 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.
Q
Do journal entries still need to balance?
Yes. Journal entries and intercompany journal entries must balance in Bulk Records as they do in NetSuite.

Try Bulk Records with your own NetSuite data

30-day free trial with every Finsyte feature included. No credit card required.

Start Free TrialWatch Demo

More Bulk Records