Bank Reconciliation
410 - Bank Reconciliation
It is the only predefined document type used in reconciling bank statements (the Bank Reconciliation checkbox needs to be checked).
After entering account code, subject ID and linked document ID the outstanding items balance as well as other data on linked document are displayed in line of the journal entry.
Settings Panel:
|
Set criteria and search order
|
For finding the subject we can define sequence of searching data. We set that with moving options from window Do not use to empty one on left hand side of the window.
The entity subject can be searched by using the following criteria:
- Name (search subject in subject register by using name of subject)
- Bank Account (search subject in subject register by bank account that subject has entered under bank accounts)
- Linked Document (search subject in subject register by entered link documents on entries)
- Bank Account and Reference (currently not in use)
- Sales Order (search subject in subject register by using order number of customer)
|
| Received payments are Grouped for Accounts |
We can enter multiple accounts, which are separated by a semicolon. When we have accounts in the field, program will check if total amount of payment correspond to the sum of amount on this accounts for the customer and link document (department and cost center if turned on in settings). Paid amount will be spread among amount that accounts.
|
| Structure for Payment Order Import |
Choose data structure for import data. |
| Currency |
The selected currency will be taken into account when the import bank statements from the file. For manual entry this currency will be default currency in the journal. Account need to has set that it is allowed posting in foreign currency or any.
|
| Fill Data from Reference for Customer Payments |
We can choose from drop down menu default values for Document, Linked Document and External document at bank statement import. Recommended values are: Document: D - Credit; Linked Document: D- Credit; External Document: B - Debit.
|
| Fill In Data from Reference for Supplier Payments |
We can choose from drop down menu default values for Document, Linked Document and External document at bank statement import. Recommended values are: Document: B - Debit; Linked Document: D- Credit; External Document: D - Credit.
|
| Save Data |
Marked option will save data from imported bank account (content of the file) even we will not posted them and close tab. |
| When Filling In Account and Subject |
Look Only in Active Subjects - program pri iskanju subjektov ne bo iskal tistih, ki nimajo statusa aktivno.
Find Account based on Post in Subsidiary Account - glede na sklic bo program poiskal knjižbe s takšnim veznim dokumentom in med temi knjižbami konto, ki je v šifrantu kontnega plana označen kot K - Kupec oz. D - Dobavitelj.
Fill In Receivables / Payables Account from Subjects - v primeru, da v prejšnjih korakih ni bil najden konto, bo program vnesel konto (če je naveden) v finančnih podatkih subjekta (kupca oz. dobavitelja).
Fill In Account from Subject Types - v primeru, da v prejšnjih korakih ni bil najden konto, bo program vnesel konto (če je naveden) v šifrantu tipov subjektov za tip, ki je naveden kot primarni tip na subjektu.
Find Subjects in Posts from Opening Onwards - The program will seek subjects only from the entries from the date of opening onwards.
|
| Doc. Type from Importing |
Set (choose from drop down menu) document type we need for posting of bank statement. We open Document Types for Bank Statement Import register with double click in the field. |
| Do Not Save Data from Bank Statement File |
|
Zavihek Polnjenje konta in subjekta glede na šifre na virmanu, TR: Podrobna pojasnila najdemo tudi na povezavi Denar.
For example of use see Journal Entry Lines - Bank Reconciliation and Financials.
Under the Fill Account and Subject According to Payment Order Code and Bank Account tab set the method used.
V zavihku Ponjenje konta in subjekta glede na šifre na virmanu, TR določimo način polnjeja kontov in subjektov glede na šifre na virmanu in glede na transakcijski račun.
V kolikor hočemo imeti več dokumentov za knjiženje bančnih izpiskov in imajo ti dokumenti enake podatke kot obstoječi potem to lahko storimo z klikom na gumb 
.
Poglejmo kako poteka postopek:
Open new document type:
Kliknemo na 
in se nam odpre okno
Vnesemo vrsto dokumenta iz katerega bomo kopirali podatke in kliknemo gumb 
.
Vsi podatki, ki so bili v vrsti dokumenta 410 pod zavihkom Polnjenje konta in subjekta glede na šifre na virmanu, TR se prenesejo na novo vrsto dokumenta.
Za lažje oblikovanje nastavitev glej tudi opis čarovnika za kopiranje transakcijskih računov dobaviteljev v nastavitve za uvoz bančnih izpiskov.