|
|
Posting - Import Bank Statements
Posting - Import Bank Statements
Posting - Import Bank
Statements
 |
Here you can group data to be directly transferred to a journal entry. That is
why you can manually change, modify, add and delete all the data which have been
automatically transferred from the
Bank Statement
panel, and which have parameters created in the document type of the
Financials module, added to them. |
When you click
Import data is entered in
the
Bank Statement panel. Data in the Posting
panel are incomplete at this point since posting accounts are missing and the
spaces representing them are thus colored red.
When you select the document type of the
Financials module, in which the imported bank
statement will be posted, you set parameters for selection of posting
account according to the selected criteria which have been entered in the
selected Document Types settings.
The criteria set determine to which account the transaction from the bank
statement is posted. That is why most of the posting data is
already prepared when you select the type of document from the Financials
module.
 |
Lines or rather the data in the lines, which still do not have the
corresponding criteria, are colored red. |
You can fill them by:
- additional settings in the Document Types of the
Financials module and by repeating the import
procedure
- adding data directly in this panel
Until all the data are entered you are unable post ot transfer them from bank
statement to the journal entry! If you attempt to post data, an error is returned (see
It is not possible to post!
Enter the missing data in the <Field> line, line: XX!).
 |
All mandatory checks are run when transferring data to the journal entry used in
reconciling bank statements. The former have been set when creating the Chart of
Accounts (see
Chart of Accounts), that is, both for manual and automatic
posting. Fields where mandatory data are missing is thus coloured red and the missing data causes the error specified
above. |
Supply the missing data in the
Posting panel.
After all the necessary data have been entered, select the
Post function from the Wizards
menu. With it you create a journal entry used in reconciling bank statement from the bank
account.
 |
To sum up
inflows (reconciling credit bank statements) and outflows (reconciling debit
bank statements)
separately the program automatically creates a contra-entry on the account
selected as the bank account for recording bank reconciliation. Such posts that enable you to
create a balanced journal entry, are colored blue. |

(data from the bank
statement)
|
There are data of a selected item from the bank statement in the header of
record.
These are therefore identical to the ones from the
Bank Statement panel. |
(balance data)
|
Debit and credit transactions of the bank statement and balance according to
the data from this panel are calculated promptly - by any possible changes
made. |
Line | Displays consecutive line number. |
Account |
Displays the account, to which the transaction will be posted. According to
the
account selected the checks from Chart of Accountsr (see
Chart of Accounts). |
Subject | Displays the subject, to which the
transaction is posted.
 |
The import procedure of bank statements validates bank accounts of payers and
recipients, according to the data entered in the Subjects register (see
LCY accounts).
If the subject name in the imported file is incomplete or irregular,
inflow or outflow is assigned to that ID (name) of the subject (it can be found
in the
Subjects register) in order to ensure correct closing.
That is why data about the subject in this panel and in the
Posting
panel may vary. |
Furthermore, with parameter settings in the document type
of the
Financials module you can determine that whole inflow or outflow
from the specified bank account is assigned to the subject entered there. |
Debit | Displays the amount of debit posts. |
Credit | Displays the
amount of credit posts. | Document | The data
appearing in this column
is copied from the next field (Link). |
Link |
Here is displayed the ID of the linked document as found in the bank statement
file.
 |
The import procedure of the bank statement DOES NOT VALIDATE THE OUTSTANDING
ITEMS OF THE SUBJECT. Data will be drawn from the imported
bank statement, notwithstanding if the linked document which the customer is
referencing with the payment exists or not. That is why it is recommended that
you promptly - by every import of bank statments - check the outstanding items
from the
Journal entry taskbar. If necessary close lines with an irregular or unmatching reference. |
| Note |
The data appearing in this column is copied from the imported bank statement. |
External Document |
The data appearing in this column is copied from the bank statement. |
Contra Account |
Displays the contra account which is always the one selected in the document type of the
Financials module, which has been selected as
journal entry in the
general information for importing. |
 |
Document and VAT date that can be observed in lines in bank statement are the
same as the transaction date from the header. Because transaction dates can vary,
the value date is filled-in with transaction date from lines in bank
statement! |
|
|
|