Import Bank Statements

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.

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 selected 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 module and run import procedure once again,
• by completing data directly in the panel for posting in the Import Bank Statements window.

	Based on the found link document will Pantheon automatically enter subject to close outstanding items. Subject on bank statement lines will be same as the one on source linked document.
	Based on the found link document will Pantheon enter account to close outstanding items. Each source document has three postings. That is why the right choice is customer/supplier account between three of them. Subject account on bank statement lines will be same as the one on source linked document.
	At bank statement import will Pantheon based on found subject (found by subject code or by bank account of subject) enter account from subjects financial details (subjects register). The account number at bank statement import for payment transactions can also be set in Subject type (subject register).

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 entered 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 Subjects register (see LCY accounts). If the name of the subject from the imported file is incomplete or incorrect, the inflow or outflow is added to the same ID (name) of the subject as entered in the Subjects register in order to ensure correct closing. Because of this data on subject in the Bank Statements panel can differ from the ones in the Posting panel.

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

7. V panelu pregled polnenja podatkov program pri uvozu izpiskov poizkuša povezati podatke v datoteki s podatki v programu. V tabelo za logiranje se zapiše, če je našel podatek ali ga ni.

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 non corresponding reference whenever importing bank statements.

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

Uporaba uporabniških postopkov pri uvozu izpiskov

Pri uvozu izpiskov lahko izberemo uporabniški postopek, če v polju Struktura izbremo Uporabniški postopek. Pokaže se polje Št. postopka, v katerem lahko izberemo ARES postopek za uvoz podatkov. Uporabniški postopek lahko uporabimo za polnjenje podatkov na zavihku Bančni podatki.

Uporabniški postopek lahko uporabimo za uvoz podatkov, ki se prikažejo na zavihku Bančni podatki. Polnjenje podatkov na zavihku knjiženje se še vedno izvaja preko procedur v programu. Primer uporabe uporabniškega postopka je uporaba kopije ARES postopkov 100001T (uvoz ISO SEPA XML) ali 100001V (uvoz ZbsXML v2.2).

Polnjenje oddelkov in/ali stroškovnih nosilcev ob uvozu izpiskov

Pri uvozu izpiskov se privzeto oddelki in stroškovni nosilci polnijo le, če je vklopljeno zapiranje po oddelkih in stroškovnih nosilcih v administratorski konzoli. Polnjenje oddelkov in stroškovnih nosilcev ob uvozu izpiska, če nimamo vklopljenega zapiranja po oddelkih in stroškovnih nosilcih, lahko vklopimo tako, da na zavihku knjiženje kliknemo z desno miškino tipko in izberemo:

Program si bo nastavitev zapomnil (kljukica pred nastavitvijo) in bo ob naslednjem uvozu izpiskov polnil oddelke in/ali stroškovne nosilce. Nastavitev razveljavimo tako, da ponovno kliknemo izbiro (kljukica ni več prikazana).

Ali lahko uvozimo več izpiskov za določen dan?

Da. Program preveri, če poknjižen izpisek za določen dan že obstaja in če, se prikaže sporočilo, da obstaja in ob potrditvi lahko za isti dan uvozimo še en izpisek.

Če imate vedno en izpisek na dan, kliknite Ne, drugače boste poknjižili isti izpisek. Možnost je uporabna za tiste, ki od banke prejmete več izpiskov dnevno.

Označi zapise, če kriterijem ustreza več subjektov

Pri uvozu izpiskov lahko program naleti na več subjektov z enakimi podatki, npr enak TRR. Za dugače obarvan prikaz takih subjektov vklopimo opcijo "Označi zapise, če kriterijem ustreza več subjetkov".

Ob vklopljeni nastavitvi program obarva tovrstne knjižbe s pastelno barvo, kar pomeni, da lahko spremenimo subjekt na knjižbi z drugim. Z desnim klikom lahko pogledamo drugi subjekt in na knjižbe prestavimo drugi-pravilni subjekt.

Razdeli plačilo na podlagi združenega pl. naloga

V primeru, da smo za v likvidaturi kreirali in odposlali združeni plačilni nalog za več dokumentov, lahko pri uvozu izpiskov vklopimo opcijo za razdeljevanje plačlila na podlagi združenega naloga. Program bo preveril, če za določeno DANO plačilo obstaja več dokumentov. Pogoj za razdeljevanje je: enak subjekt, sklici (v dobro in breme), koda namena (včasih vrsta posla). Če pogoji ustrezajo bo program razdelil plačilo na več pozicij glede na posamične virmane.

V primeru na sliki je bilo v datoteki plačilo za oba računa v eni poziciji v znesku 2200 EUR. Program je na podlagi subjekta, enakega sklica in kode namena našel združen plačilni nalog, ki je bil ustvarjen iz računov 12-120-000005 in 12-120-000004 in zato plačilo v enem znesku razdelil na dva, glede na posamične virmane.

Prikaz vseh podatkov na zavihku knjiženje

Nastavitev se vklopi na zavihku Knjiženje z desno miškino tipko. Če je ta nastavitev vklopljena, se podatki iz začasne tabele bančnih podatkov vključijo v prikaz podatkov na zavihku Knjiženje.

Polni manjkajoče TRR ob knjiženju

Nastavitev se vklopi na zavihku Knjiženje z desno miškino tipko. Če je ta možnost vključena, program ob knjiženju izpiska doda TRR iz zavihka Bančni podatki subjektu, ki je izbran na zavihku Knjiženje, če ta TRR pri subjektu še ni vnešen.