Format Profile Creation

After you save a financial institution record, you can add one or more format profiles to it.

Format profiles enable you to configure settings necessary for manual or automatic import of financial institution data. There are two format profile types, and they each have different workflows:

• Bank Reconciliation – Configure a format profile to import bank and credit card data for reconciliation. Link your financial institution accounts to corresponding accounts in NetSuite, and map custom bank codes to bank data types. Bank Reconciliation is the default format profile type. For more information, see Creating Format Profiles for Bank Reconciliation.

  Note:

  As of NetSuite 2021.2, you can automatically generate customer payments from your imported data and apply them to invoices. These payments are automatically matched and cleared in the system. See Automated Cash Application.

• Corporate Card Expenses – Configure a format profile to import credit card charges for expense reporting. Link credit card charges to employee accounts and map expense codes to user-defined expense categories. For more information, see Creating Format Profiles for Expense Reporting.

You can only associate a format profile with one financial institution record. If you delete a financial institution record, NetSuite deletes the associated format profile as well. You cannot delete a format profile that has associated imports.

This section contains the follow topics:

• Creating Format Profiles for Bank Reconciliation

• Creating Format Profiles for Expense Reporting

General Notices