PANTHEON™ Help

 Toc
 PANTHEON Hilfe - Willkommen
[Reduzieren]PANTHEON
 [Reduzieren]Leitfäden für PANTHEON
  [Vergrößern]Leitfaden für PANTHEON
  [Vergrößern]Leitfaden für PANTHEON Einzelhandel
  [Vergrößern]Leitfaden für PANTHEON Vet
  [Vergrößern]Leitfaden für PANTHEON Farming
 [Reduzieren]Benutzerhandbücher für PANTHEON
  [Vergrößern]Benutzerhandbuch für PANTHEON
  [Vergrößern]Benutzerhandbuch für PANTHEON Einzelhandel
  [Vergrößern]Benutzerhandbuch für PANTHEON Vet
  [Vergrößern]Benutzerhandbuch für PANTHEON Farming
[Reduzieren]PANTHEON Web
 [Reduzieren]Leitfäden für PANTHEON Web
  [Vergrößern]Leitfaden für PANTHEON Web Light
  [Vergrößern]Leitfaden für das PANTHEON Web-Terminal
  [Vergrößern]Leitfaden für PANTHEON Web Rechtliches
  [Vergrößern]Alte Produkte Archiv
 [Reduzieren]Benutzerhandbücher für PANTHEON Web
  [Vergrößern]Erste Schritte PANTHEON Web
  [Vergrößern]Benutzerhandbuch für PANTHEON Web Light
  [Vergrößern]Benutzerhandbuch für das PANTHEON Web-Terminal
  [Vergrößern]Benutzerhandbuch für PANTHEON Web Legal
  [Vergrößern]Alte Produkte Archiv
[Reduzieren]PANTHEON Granulate
 [Reduzieren]Leitfäden für PANTHEON Granulate
  [Vergrößern]Personalgranulat
  [Vergrößern]Reiseaufträge Granulat
  [Vergrößern]Dokumente und Aufgaben Granule
  [Vergrößern]Dashboard Granule
  [Vergrößern]B2B-Bestellungen Granulat
  [Vergrößern]Feldservice-Granulat
  [Vergrößern]Bestandsgranule für Anlagevermögen
  [Vergrößern]Warenlager Inventar Granulat
 [Reduzieren]Benutzerhandbücher für PANTHEON Granulate
  [Vergrößern]Erste Schritte
  [Vergrößern]Personalgranulat
  [Vergrößern]Reiseaufträge Granulat
  [Vergrößern]Dokumente und Aufgaben Granule
  [Vergrößern]B2B-Bestellungen Granulat
  [Vergrößern]Dashboard Granule
  [Vergrößern]Feldservice-Granulat
  [Vergrößern]Bestandsgranulat für Anlagevermögen
  [Vergrößern]Lagereinlagerung Granulat
  [Vergrößern]Archiv
[Vergrößern]Benutzerseite

Load Time: 343,7557 ms
"
  1001235 | 211401 | |
Label


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.
Line Displays 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).
Subject Displays 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.

Debit Displays the amount of debit posts.
Credit Displays the amount of credit posts.
Document The 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.
   

Also other columns can be visible. We can call them with right mouse click (Select columns) or use function Show all Data in Posting Tab also on right mouse click.

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!