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. |