Juni offers a ‘Match Bank Data’ CSV export for Netsuite to get all of your Juni transactions accounted for in Netsuite. For each transaction, the CSV export contains:
Date (MM/DD/YYYY) - Cannot be changed by user
Based on transaction settlement date
Payer/Payee Name - Cannot be changed by user
Transaction description
Transaction ID - Cannot be changed by user
Transaction Type - Cannot be changed by user
CREDIT for received money (positive amounts)
DEBIT for spent money (negative amounts)
Amount - Cannot be changed by user
Amount in card/Juni account currency
Memo - Can be changed by user, and is optional
In this column, you can either concatenate values from other columns or add a custom text input
Data points that can be concatenated:
Transaction date
Transaction date
Payer/Payee name
Transaction ID
Transaction type
Amount
Transaction URL - ‘Embed a direct link to the transaction and receipt details in Juni’
NS Internal Customer ID - Can be changed by user, and is optional
Example: CU000001
Any Customer ID that you add will be added to all rows in the exported CSV
NS Customer Name - Can be changed by user, and is optional
Example: Supplier A
Any Customer Name that you add will be added to all rows in the exported CSV
Invoice Number(s) - Can be changed by user, and is optional
Example: IN000001
Any Invoice Number that you add will be added to all rows in the exported CSV
Setup of the CSV export in Juni
Go to the "Transactions" page
Select the accounts and date range you wish to export by clicking “Add Filters”
Click on "Export" in the top left hand corner
Choose "Ready Templates"
Choose Netsuite
Configure your Netsuite custom format to match your Netsuite setup
Click "Export"
Uploading the CSV export in Netsuite
Go to the ‘Match Bank Data’ page within the Netsuite dashboard (via the search button or by going to Transactions > Bank > Match Bank Data)
Hover to the top right corner of the page where the three dots sign is (’…’) and click on ‘Upload File’
Under ‘Manual Import’, select the ‘Import with a default parser (CSV, OFX, QFX, BAI2, or CAMT.053)’ option
Click on ‘Choose a file’ and import the respective CSV file you downloaded from Juni
After uploading successfully, select the Account the upload is associated with from the drop down menu