Resource: NetSuite Transaction Reclassifier
This article covers the NetSuite Transaction Reclassifier Resource in detail. If you haven’t yet learned about Resources in general and how to get the most out of them, we suggest you check out our Resources support article first.
What Is the Transaction Reclassifier?
Section titled “What Is the Transaction Reclassifier?”The Transaction Reclassifier lets you bulk edit transactions that are already in NetSuite. Download a set of transactions to your worksheet, change the account, entity, amount, memo, Department, Class or Location on as many lines as you need, then upload the changes in one step instead of opening each transaction in NetSuite.
It works across seven transaction types:
- Journal Entry
- Invoice
- Vendor Bill
- Expense Report
- Purchase Order
- Credit Card Charge
- Deposit
The Transaction Reclassifier is in beta.
What You Can Do
Section titled “What You Can Do”- Download and edit any of the seven types.
- Create new transactions for Journal Entries, Invoices and Deposits only. Creating Vendor Bills, Expense Reports, Purchase Orders and Credit Card Charges is not supported, and the upload will tell you so.
- Delete is not available. Delete transactions in NetSuite itself.
Filters for Downloading Transactions
Section titled “Filters for Downloading Transactions”Use the filters section on the left side of the Resource template to download only the transactions you want. The filters are cumulative, so you get results that match all of them.
- Start Date: transactions dated on or after this date
- End Date: transactions dated on or before this date
- Transaction Type: one of the seven types above. Leave it blank to download all of them.
Transaction Data Structure
Section titled “Transaction Data Structure”Each row is one transaction line. The first row of a transaction also holds the fields that apply to the whole transaction: Date, Subsidiary, Currency, Number and the description line. When you upload, a row with a Date starts a new transaction, and the rows below it without a Date are its lines.
Some columns are hidden, indicated by a ”+” button at the top of the sheet. They hold NetSuite IDs and the values NetSuite requires behind the scenes. We caution against changing these unless you know what you’re doing.
Checks Before Upload
Section titled “Checks Before Upload”Amalgam checks your changes before sending them to NetSuite, so a mistake is caught in the sheet rather than half-saved:
- Journal Entries must balance: total debits equal total credits.
- On Purchase Order and Credit Card Charge item lines, and on new Invoice lines, quantity times rate must equal the amount.
- Invoice rates must match the price NetSuite has for the item.
Reference Fields
Section titled “Reference Fields”Subsidiary, Currency, Account, Item or Service, Entity, Department, Class and Location all refer to data that already exists in NetSuite. Amalgam gives you a dropdown list for each, so you pick a valid value instead of typing it. Department, Class and Location can be set on each line, and there are also header columns for them that apply to the whole transaction.
If you add something in NetSuite while working, use the refresh button in the sidebar to update the dropdown lists.