General - Import Bank Statements
General - Import Bank Statements
General - Import Bank Statements
| Exclue Temp. account |
This setting is used only with combination on setting on doc type for importing bank statements. Setting is Temporary account. Temporary account are accounts which contain data with non domestic currency. |
| Data File
|
By clicking  select a file path as well as the name of the file containing data about transactions on the bank account.
Of course, you can also enter data.
|
| Import |
By clicking this button you import data from the file. Data are entered in the Bank Statement panel. Data in the Posting panel are at this point incomplete since there is no posting accounts and the spaces, where the data to be posted is missing are marked with red.
If you have not selected a file to be imported, an error message appears (see Error in file path settings or in file structure xx!).
If you selected a wrong file (incorrect file format), the name and the path of the file in question are displayed as well.
|
| Bank Account |
The ID of your bank account.
If there existed transactions to multiple bank accounts on the same bank statement, then two kinds of records would have been formed, for each bank account separately (certain EFT systems may not support this).
|
| Name |
Displays the name of your company. |
| Transac. Date |
Displays the date on which the transaction was made (information from the statement).
 |
If there exists various different payment dates in the statement, the transaction date gets colored, and all corresponding dates from the statement are listed. The selected date is displayed in journal entry header as Journal Entry Period.
|
|
| Debit Balance |
Displays balance of the imported debit transactions (payments from the bank account). |
| Credit Balance |
Displays balance of the imported credit transactions (payments to the bank account). |
| Line Count |
Displays line umber in the bank statement (the sum of credit and debit lines) |
| Doc. Type |
Select a document type of the Financials module, in which the imported bank statements will be posted. The parameters used in the selection of the posting account are set according to the selected criteria that have been entered in the Document Types settings of the Financials module. This way most of the data is already prepared for posting if you select the document type of the Financials module. Lines which are still blank, having no corresponding criteria for posting, are marked red. Complete them by:
- additional settings in the Document Types of the Financials module (Open the register by double-clicking this field.) and repeat import procedure, or
- additional data entered directly in the Posting panel of the Import Bank Statements module
Enter the default document type used in reconciling bank statements to individual bank accounts in the appropriate document type, where you select a bank account number to which it will be posted.
|
| Journal Entry |
After having selected the Post function from the Wizards menu, a journal entry is created used in reconciling bank statements (if all the data in the Posting panel have been entered accordingly). Its ID appears in this field. |