Bank Reconciliation
In menu Settings | Program | Document Types | Finanials | Posting document types for postings can be found. Document type 4100 is the only predefined document type used in reconciling bank statements (the Bank Reconciliation checkbox needs to be checked).
In tab Financials basic settings for document type can be found.
| Bank Reconciliation |
Marked if selected document types is used for posting of bank statements. |
| Copy settings |
Enables copying of settings for bank statement import from one document type to other or from one database to other. |
| Account |
Select the transaction account number to which the statement is being posted for. |
| Account BA |
Select the account number from Chart of accounts to which the statement is being posted for. |
| Import strucuture |
Select the import structure which will be used for Bank statement import.
 |
Hint
In case the statement import structure is selected, entering a bank account in field account is mandatory.
|
|
| Check Journal Entry Balance |
Select which type of journal entry balance control option you want. when post the document type.
|
| The 'Close' button opens the form 'Close outstanding items by re-posting' |
Select if you want to open the form Close outstanding items by re-posting by clicking on button close. |
| Find Open Amount when Manually Entering Line |
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. |
| Posting of Costs |
|
1.1. Copy Settings
Below is described the Copy Settings button:
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.
|
| 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 (not in use). |
| 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. |
Detailed information can be found on link Financials. In this panel, we determine the method of filling the accounts and subjects according to the reference on payment order and depending on the bank account.
In Toolbar | Wizard some additiona options related to Bank statement import can be found:
| 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 |