Steps:
-
Download Chart of Account .csv from NetSuite by Navigating to Lists > Accounting > Accounts
-
Click the Export - CSV button (grey page icon near the top left)
-
Open the downloaded CSV in Excel
-
Delete first 5 rows before the Headers row
-
Remove any lines containing Accounts that you won’t want to sync to Procurify
-
Add a column called Sync To Procurify
-
Enter TRUE for all lines
-
Save the CSV file
-
In NetSuite, navigate to Setup > Import/Export > Import CSV Records
Import Type: Accounting
Record Type: Chart of Accounts
CSV File: Select One File to Upload -
Select the CSV file you just saved
-
Click Next > Update > Next
-
Double check the Field Mapping, NetSuite should have automatically matched the columns in the file
-
Click Next
-
Enter information to Import Map Name (suggested “Sync Accounts to Procurify”)
-
Click Save & Run
The accounts marked as TRUE under column Sync to Procurify via this method will sync via the next scheduled Account sync from our bundle configuration. The sync can also be manually executed from the bundle configuration.
Note: This does not take into consideration if the Account marked to Sync to Procurify is a sub account - ensure you also mark any applicable parent account to Sync to Procurify. Once synced, accounts also need to be assigned to Departments in your Procurify Chart of Accounts before they’re available for use.
Additional Information:
- N/A