Posting - Import Bank Statements

Posting - Import Bank Statements

The Posting section of Import Bank Statements form allows you to 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. Here you can group data to be directly transferred to a journal entry.

The section can be accessed from Financials | Transactions | Import Bank Statements.

The section is divided into following parts.

1. Header

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.

In Header, you can find following data: 
 

Tr. Type	Type of transaction (inflows, outflows et.c.)
Account	Bank Account from Supplier ot Buyer. In this field, if Supplier or Buyer is missing in Code of Subjects you can add it from AJPES by clicking on button Search. Search is done by Transaction account from Bank statement,
Subject	Name of subject from the Bank Statement. By clicking on button  (Search) suppliers and buyers can be imported from AJPES (Slovenian Register of Subjects) directly to the Code of Subjects.
Description	Description of transaction
Trans.Date	Date of Transaction
Amount	Amount of Transaction
DR Reference	Debit reference
CR Reference	Credit reference
Link	Link
Outs. Items	By clicking on this button, you can open Outstanding items for specific subject.
Acc. Card	By clicking on this button, you can open Account Card Report  for specific subject.
Post	After all the necessary data have been entered, by clicking on this button you Post Bank statement. With it you create a journal entry used in reconciling bank statement from the bank account.

2. Lines

Warning 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!).

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

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.

In Lines, you can find following data:

(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. Warning 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. ​When posting lines that refers to bank account transactions (subject is bank), subject can also be automatically filled but only when field subject is marked as mandatory field on bank reconciliation account (settings made in chart of accounts).
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). Exception are lines that refers to bank account transactions (subject is bank). In this case Document can also be automatically filled but only when it is marked as a mandatory field on bank reconciliation account (settings made in chart of accounts). Document number consist of bank statement year and bank statement number.
Link	Here is displayed the ID of the linked document as found in the bank statement file. Exception are lines that refers to bank account transactions (subject is bank). In this case Link can also be automatically filled but only when it is marked as a mandatory field on bank reconciliation account (settings made in chart of accounts). Link number consist of bank statement year and bank statement number.  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.

Also other columns can be visible. We can call them with right mouse click (Select columns) or use function Show all Data in Posting Tab also on right mouse click.

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!

When posting bank statements program checks for all payments on statement if there exists payment oreders with  status "O - Sent". In case such payment orders exists IRIS appears and status of this payment orders can be automatically changed to  "R - Confirmed".