Table of Contents

Importing Bank Statements

Important

In order to upload the bank statement file correctly, you must define a link between the user's company account ID and the bank account card in the system. For more information, see ID-to-Account Mapping.

Importing Bank Statements

To import a bank statement file:

  1. Choose the Tell me what you want to do, icon, and enter Bank Statement List.
  2. Choose the Create from Template action on the ribbon.
  3. In the list, select the template that will be used for the imported file.
  4. If the interface uses a file, you will be asked to upload a bank statement file.
  5. After the import process is complete, the app will return the number of correctly imported bank statements. If any bank statement contains data for multiple bank accounts, a new separate bank statement is created for each bank statement.
Important

For the bank statement import to be successful, the imported files must contain the statement for a period of one day.

Tip

You can start the import of a bank statement using the New Bank Statement action in the Role Center.

History of Imported Bank Statements

To see the history of imported bank statements:

  1. Choose the Tell me what you want to do, icon, and enter Bank Statement Files.

Each entry on the Bank Statement Files page contains the following fields:

  • Entry No.
  • Bank Statement Template Code - Specifies the code of a bank statement template used when importing a bank statement.
  • File Name - Specifies the name of the source file.
  • Creation Date
  • Created by User ID
  • Status - The filed can have the following values:
    • New - Specifies that the bank statement has not been imported into the system.
    • Processed - Specifies that the file has been created on a basis of the bank statement.
    • Cancelled - Specifies that the bank statement document has been deleted.
Note

If any errors occur in the import process, they are displayed in the Import Errors FactBox.

See Also

A Sample Bank Statement File