Bank Reconciliation
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 - Pantheon will not search subjects with status different than Active.
Find Account based on Post in Subsidiary Account - Pantheon will search entries with link document and between them account, marked as Line K - Customer/Receivables or D - Supplier/Payables.
Fill In Receivables / Payables Account from Subjects - when the account is not found in prior steps, Pantheon will use an account from subject register / financial details, if exists (customer oz. supplier).
Fill In Account from Subject Types - when the account is not found in prior steps, Pantheon will use an account from Subject Type register (if exists). Subject type marked as Primary Type will be used.
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, or 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 |
Tick an option when we do not want to save data from Bank statement file. |
| Temporary accounts |
Somethimes bank statements file contains data for more than one currency, but user does not want to import and post that data. If checkbox is on for individual document type and Exclude Temp. account is also on on bank statements import, program will extract those data when importing file. Currency must also be set in this case. |
Panel fill In Account and Subject According to Payment Order Code and Bank Account: detailed information can be found on link Financials.
We determine the method of filling the accounts and subjects according to the reference on payment order and depending on the bank account.
| Copy settings for bank statements import from another document |
Copy settings from one document type to another |
| Import of bank statement setting from Microsoft Excel |
Import bank statement setting from excel for settings on tab: Fill in Account and subject according to Payment order code and bank Accounts |
Let us introduce the procedure:
1. Open new document type.
2. Use copy settings button 
and new window appears:
| Document Type |
Enter or choose from drop down menu document type that we want to copy. |
| From database |
Choose database from which we want to copy settings of panel Fill in Account and Subject according to Payment Order Code and Bank Account. |
| Mode |
We can choose between two modes:
- Adding - If Adding is chosen, only non-existing settings will be added.
- Overwrite - If overwrite is chosen, non-existing settings will be added and existing will be overwritten with new settings.
|
| Copy |
All settings will be copied by using Copy button  .
All data from the panel Fill in Account and Subject According to Payment Order Code and Bank Account will be entered to the new document type.
|