Menu Path: None
To use Bank Statement Import, click the Import button in the ribbon in Bank Statement Management.
Import a bank statement from an external file.
Use Bank Statement Import to import bank statements into the system instead of manually entering information for a bank statement.
NOTE You can only import a bank statement for cash accounts that are associated with a bank code for which a bank statement import program is set up in Bank Code Maintenance.
You can import bank statements in the following formats:
MT940
OFX
To import a bank statement:
Enter or select a cash account for which to import a bank statement.
Select the format of the bank statement file.
Enter or select the bank statement file.
Click the Print Options tab, and select output options for the import report.
Click the Import button in the ribbon to start the import process. The Importing dialog box appears. When a bank statement is successfully imported, the system assigns a bank statement code to the bank statement. The code includes an MT or OFX prefix, and a nine-digit sequential number. After the import process is completed, the import report is output based on the options selected in step 4.
NOTE If the import file format is not correct, the import is not completed.
Button |
Description |
Exit |
Click this button to close the Bank Statement Import window. |
Import |
Click this button to start the import process. |
Field or Button |
Description |
Enter a cash account for which to import a bank statement, or click the Lookup button to select a cash account. |
|
Enter a cash account description for which to import a bank statement, or click the Lookup button to select a cash account description. |
|
Select whether the bank statement file is an OFX or MT940 file. |
|
Enter the path and file name containing the data to be imported, or click the Lookup button to navigate to and select the file. |
Field or Button |
Description |
Select one of the following output options:
|
|
Output File Type |
|
Specify File Name |
|
Output Directory |
Enter the location for the output report, or click the Lookup button to navigate to and select a location. This field is only available if the Specify File Name check box is cleared. |
Output File Name |
|
Excel Format Name |
|
Format Maintenance |
Click this button to display Excel Format Maintenance, which allows you to set up Excel formats. This button is only available if you select the Excel radio button. |
Save As Type |
|
Include header |
|
Delimiter |
|
Enclosing Character |
|
Printer |
|
These radio buttons are disabled in this window. |
|
These radio buttons are disabled in this window. |
|
These fields and radio buttons are disabled in this window. |
|
This field is disabled in this window. |
|
This field is disabled in this window. |
|
This field is disabled in this window. |
|
This check box is disabled in this window. |
|
This check box is disabled in this window. |
|
This check box is disabled in this window. |