Pantheon User Manual

 Categories
[Expand]User Manual for DataLab PANTHEON 5.5
 No formula defined!
[Collapse]Datalab PANTHEON 5.5 Guide
 [Expand]Orders
 [Expand]Settings
 [Expand]Manufacturing
 [Expand]Goods
 [Expand]Service
 [Collapse]Financials
  [Expand]Accounting Basics
  [Expand]Manual Posting and the Journal Entry
  [Expand]Accruals and Deferrals
  [Expand]Automatic Posting
   General Ledger Overview
   Subsidiary Accounts Overview
  [Expand]Browse Posts
  [Expand]Close
  [Expand]Reports
  [Expand]Fixed Assets
  [Collapse]Transactions
   [Expand]Create Payment Orders from Invoices
   [Expand]Payment Orders
   [Expand]Payment Transaction - Abroad
   [Collapse]Import Bank Statements
    [Expand]General - Import Bank Statements
     Bank Statement - Import Bank Statements
     Posting - Import Bank Statements
   [Expand]Direct Debit
    Settings of Electronic Funds Transfer
   [Expand]ODO Forms
  [Expand]Debt Collection
  [Expand]Interest
  [Expand]Cash Transactions
  [Expand]Year-end
  [Expand]Archive
   Planning
  [Expand]Reports
 [Expand]Personnel
 [Expand]ZEUS Business Intelligence System
 [Expand]Desktop
  Web Portals
  Extra
 [Expand]Datalab Software System Environment
 [Expand]Messages and Warnings
 [Expand]Additional Programs
 Opening or closing round bracket missing!
 Debugging Formulas
[Expand]Testing and Debugging Formulas
 Opening or closing square bracket missing!
 Conditional statement at position x not enclosed in square brackets!
 Syntax error in conditional statement. Correct syntax is [condition:value]
 Adjacent operators (xx)!
 Last character of the formula is an operator!
 Variable not enclosed in hashes (#)!
 Illegal characters: xyz
 Unknown error!
[Expand]User Manual for Datalab PANTHEON Farming
[Expand]User Site
 Adjacent hashes!
 The line number must be an integer (#xx#)!
 The first character of #xx# must be a transaction type or a column mark!
 The first character of #xx# must be an operation type (R, S, O or A)!
 The second character of #xx# must be a transaction type (D, K, S, P, or O)!
 Variable not defined
[Expand]Kralicek Quicktest Financial Ratios

Load Time: 406.4416 ms
print   |
Label

Posting - Import Bank Statements

Posting - Import Bank Statements

Posting - Import Bank Statements

010381.gif010382.gif010383.gif

000001.gif Here you can group data to be directly transferred to a journal entry. That is why you can 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.

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.

000001.gif 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!).

000001.gif 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.

Supply the missing data in the Posting panel. After all the necessary data have been entered, select the Post function from the Wizards menu. With it you create a journal entry used in reconciling bank statement from the bank account.

000001.gif 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.

50164.gif

(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.
LineDisplays 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).
SubjectDisplays the subject, to which the transaction is posted.
000001.gif 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.

DebitDisplays the amount of debit posts.
CreditDisplays the amount of credit posts.
DocumentThe data appearing in this column is copied from the next field (Link).
Link Here is displayed the ID of the linked document as found in the bank statement file.
000001.gif 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.
000001.gif 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!



Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!