Generate the vendor list with spending summary
- Log in to NetSuite using your company’s login.
-
Go to Reports > Purchases > Purchase by Vendor > Customize Summary, then modify the Report Builder data:
- Enter a name in the Name field.
- Select the fields the report will include. Click the + sign to expand the fields under the Vendor field:
- Vendor includes the Alt. Phone field.
- Address Book (under the last Vendor field) includes the address fields you’ll likely need: Address 1, Address 2, City, State, and Zip.
-
Click Save to display the report. Adjust the date range, then export:
- Enter the date range and click Refresh.
- Click the Excel icon to export the file.
- Open the Excel file, widen the columns so all text is readable, and save the file to your desktop.
Bring these vendors into Dash.fi
You have two in-app options:- Sync automatically. Dash.fi integrates with NetSuite — connecting the integration syncs your vendors with no manual export needed. See Connect NetSuite.
- Bulk import your export. Upload the file you exported on the Vendors tab and map its columns to Dash.fi’s vendor fields. See Import your vendor list.