By using this function you are able to import messages on crediting and
debiting bank account on a specific date. Export it as text file by using for
example ProKlik or any other means for electronically transferring funds.
How is the Procedure Preformed?
1. First export text file containing a statement following instructions for
electronic funds transfer.
(The function supports responding to all those EFT users using the same file
structure).
2. Set a file path and name of the file in the Financials | Transactions |
Import Bank Statements menu.
3. Click Import. Data are
entered in
Bank Statement panel.
If you have not selected the correct file to be imported, the following error is
returned (see
Error in file path for file structure of xx!).
4. The appropriate number of document type for reconciling bank statements is
found, as long as it was entered in the Import Bank Statements to Document Type
field in
transactions document type. It is filled with data
from line containing
general information. According to the number of
bank account from which data are imported, the default document type used for
reconciling bank statements is found.
The following can be found:
- the number of bank account for which you enter data (it is displayed in
statement and can be observed from the first field in
header)
- the number of the corresponding bank account is found among the default
values in document types used in transactions
- in this type of transactions document it finds the number of
document type for recondiling bank statements in
the Import Bank Statements to Document Type
field. By default it is filled when using the module for importing bank
statements.
The Posting panel displays incomplete data
which are in turn displayed in red color.
5. Select a document type from the
Financials module (that is, of it were not filled-in
automatically in the previous step), using which you can post the imported bank
statement.
Having selected the type of document for reconciling bank statements set the
parameters used in selecting account for posting, according to the seleced
criteria. You must have entered the criteria in the Document Type settings of
the Financials module.
Here you can find criteria using which it is set to which account will the
transactions from the statement be posted and under what conditions. Most of the
data required for posting are already preset when selecting a document from the
Financials module. Lines containing incomplete data are displayed in red. They
can be completed in the following way:
- by completing the Document Types settings of
Financials modue and run import procedure once
again
- by completing data directly in the panel for
posting in the Import Bank Statements
window
Until you complete all missing data in the statement you will not be able to
post it, that is, transfer it to a journal entry! Trying to post a bank
statement to journal entry returns the following error (see
Posting not possible!
Supply missing data in line: XX!).
All checks for basic entries, as set when creating chart of accounts (see
Chart of Accounts), are used in transferring data
to journal entry in order to reconcile bank statements, just like in posting
manually or automatically. The data which must be enterd due to settings of
Chart of Accounts is colored red. Any missing data cause the above-mentioned
error to occur.
 |
Bank accounts of payers and payment beneficiaries are checked in the import
procedure for bank statements, according to the data entered in the Subejcts
register (see
LCY accounts).
If the name of the subject from the imported file is incomplete or incorrect,
the infolw or outflow is added to the same ID (name) of the subject as entered
in the
Subejcts register in order to ensure correct closing.
Becasue of this data on subject in the Bank Statements
panel can differ from the ones in the
Posting
panel. |
5. Complete the data in the
Posting panel.
After all the required data have been entered, just select the function
Post from the wizards menu. This way a journal
entry for reconciling bank statement is created.
|
|
SUBJECT's OUTSTANDING ITEMS ARE NOT checked during import procedure for bank
statements. Data from imported statements will be imported regardless of whether
the linked document the customer referenced exists, or not. Because of this it
is wise that you promptly check in
journal entry taskbar all outstanding items, and
if necessary close lines containing an incorrect or uncorresponding reference
whenever importing bank statements. |
6. Should you decide to cancel the procedure before creating the journal entry,
data might get lost. You are warned about this with the following message:
Bank statement not posted! All entries will be
discarded! Close the window anyway?.
