1. Accounting
  2. Banking
  3. Financial Institution Records
  4. Format Profile Creation
  5. Creating Format Profiles for Bank Reconciliation
  6. Setting Up a Bank Import Schedule

Setting Up a Bank Import Schedule

You can set up an automated bank transaction import schedule for profile types set to Bank Reconciliation. An automated import schedule ensures timely bank data updates and supports more efficient reconciliation processes. Choose the unit of time, frequency, import date, import time, and preferred time zone for automated imports. You can set up an import schedule from a format profile of a financial institution record, on the Import Schedules subtab.

Note:

You can also access a format profile to manage an import schedule from the Match Bank Data page by clicking Manage Import Schedules.

To set an import schedule:

  1. Go to Setup > Accounting > Financial Institution > List (Administrator). Select an existing financial institution or create one if required. See Creating Financial Institution Records.

  2. Select a format profile or to create one, click Add under the Format Profile: Configuration subtab. For more information, see Creating Format Profiles for Bank Reconciliation.

  3. Set the Profile Type to Bank Reconciliation and the Connectivity Method field to a connectivity plug-in.

  4. Open the Account Linking subtab to link a GL account. Select the account or accounts to link from the dropdown and click Save. At least one account linking is required to activate scheduling options of the Import Schedule feature.

  5. Click on the Import Schedule subtab. The scheduling fields are automatically populated with default values:

    • The unit of time as Day,

    • The frequency as 1 day,

    • A scheduled import date,

    • A randomized import time between 4:00 and 7:00 AM Pacific Time.

    Important:

    Transactions won't be imported until the date specified in the Earliest Transaction Date for Import field, located under the Account Linking subtab.

    Note:

    The import time in the imported data is based on the chosen time zone set during the schedule, regardless of the system's time zone. Only the last successful import time displayed on Format Profile and Match Bank Data pages is according to your respective time zone.

    You can edit the schedule in both new and existing format profiles. The units of time available are hour and day.

    All fields under the Import Schedule subtab must be filled or left blank. Partial entries are not allowed. Ensure to meet one of the following criteria:

    • All fields are filled, using either the default values or your preferred values.

    • All fields are left blank. The system uses the default values.

  6. Click Save.

For troubleshooting import schedule issues, Troubleshooting Bank Import Schedule Issues.

Related topics

General Notices