If you are using the Expense Reports feature, you can now create a format profile to configure manual imports of corporate card charges from any provider for expense reporting. Such format profiles use a custom transaction parser built using the Financial Institution Parser Plug-in interface to import transactions from a file you have downloaded from a financial institution.
Note
Format profiles that use custom connectivity and parser plug-ins for automatic retrieval are not yet supported. Therefore, the following procedure only covers manual import setup.
You can automate imports of corporate card charges from American Express by using the AMEX Corporate Card Integration SuiteApp. This SuiteApp automatically provisions a financial institution record and format profile to configure your import.
Format profiles configured for manual import enable you to do the following:
-
Link corporate credit card charges to corresponding employee records in NetSuite
-
Map expense codes to corresponding user-defined expense categories
-
Configure a parser plug-in, if parser configuration is supported
To do this procedure, you need the following:
-
Financial Institution Records permission.
-
Custom parser built with the Financial Institution Parser Plug-in interface.
Important
To avoid performance degradation, you should not configure a bank data import that exceeds 10,000 corporate card transactions.
To create a format profile for expense reporting:
-
Go toSetup > Accounting > Financial Institution > List.
NetSuite displays the Financial Institutions page.
-
Next to the financial institution record for which you want to add a format profile, click View.
NetSuite displays the Financial Institution page.
-
In the Format Profile: Configuration subtab, click Add.
-
In the Profile Name field, enter a name for your format profile. For example, Wells Fargo Charges.
-
In the Description field, enter a description to help you identify this format profile.
-
From the Profile Type field dropdown, select Corporate Card Expenses.
The profile type cannot be modified after you save.
-
From the Connectivity Method dropdown list, select Manual Import.
-
From the Transaction Parser list, select a custom parser built with the Financial Institution Parser Plug-in interface.
For a custom plug-in to be available, you must create and upload one to NetSuite.
- Link corporate credit card charges to corresponding employee records in NetSuite.
-
(Optional) Map custom expense codes to corresponding user-define expense categories.
- (Optional) If parser configuration is required, configure your transaction parser.If your parser plug-in supports parser configuration, the Parser Configuration subtab appears and is populated with configuration fields.
-
Click Save.
-
Repeat these steps for each format profile that you want to create for expense reporting.
After import configuration is complete, you can manually import your data atTransactions > Bank > Banking Import History > Upload File.
To view imported charges, see the Imported Employee Expenses page (Transactions > Employees > Imported Employee Expenses).