PANTHEON™ 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: 390.6329 ms
print   |
Label

General - Import Bank Statements

General - Import Bank Statements

General - Import Bank Statements

010381.gif010382.gif010383.gif

50159.gif

Data File


50160.gif

By clicking 008957.gif select a file path as well as the name of the file containing data about transactions on the bank account.

Of course, you can also enter data.

Import
By clicking this button you import data from the file. Data are entered in the Bank Statement panel. Data in the Posting panel are at this point incomplete since there is no posting accounts and the spaces, where the data to be posted is missing are marked with red.

If you have not selected a file to be imported, an error message appears (see Error in file path settings or in file structure xx!).

If you selected a wrong file (incorrect file format), the name and the path of the file in question are displayed as well.

Bank AccountThe ID of your bank account.

If there existed transactions to multiple bank accounts on the  same bank statement, then two kinds of records  would have been formed, for each bank account separately (certain EFT systems may not support this).

Name Displays the name of your company.
Transac. DateDisplays the date on which the transaction was made (information from the statement).

 

000001.gif If there exists various different payment dates in the statement, the transaction date gets colored, and all corresponding dates from the statement are listed. The selected date is displayed in journal entry header as Journal Entry Period.

50266.gif

Debit Balance Displays balance of the imported debit transactions (payments from the bank account).
Credit Balance Displays balance of the imported credit transactions (payments to the bank account).
Line CountDisplays line umber in the bank statement (the sum of credit and debit lines)
Doc. Type

Select a document type of the Financials module, in which the imported bank statements will be posted. The parameters used in the selection of the posting account are set according to the selected criteria that have been entered in the Document Types settings of the Financials module. This way most of the data is already prepared for posting if you select the document type of the Financials module. Lines which are still blank, having no corresponding criteria for posting, are marked red. Complete them by:

  • additional settings in the Document Types of the Financials module (Open the register by double-clicking this field.) and repeat import procedure, or
  • additional data entered directly in the Posting panel of the Import Bank Statements module

Enter the default document type used in reconciling bank statements to individual bank accounts in the appropriate document type, where you select a bank account number to which it will be posted.

Journal Entry After having selected the Post function from the Wizards menu, a journal entry is created used in reconciling bank statements (if all the data in the Posting panel have been entered accordingly). Its ID appears in this field.



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