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
  [Collapse]Reports
   [Expand]General Journal
   [Expand]Account Card
   [Expand]Outstanding Items
   [Expand]Debt Structure
    Balance Report of Customers and Suppliers
   [Expand]Invoice Payment List
   [Expand]Pregled zamude pri plačilih
   [Expand]Trial Balance
   [Expand]Financial Reports
   [Expand]Monthly SKV Report for the National Bank
   [Expand]Summary Reports
   [Expand]Financial Analyses (ZEUS)
   [Expand]SFR - Statistika Finančnih Računov
    Export General Ledger Data for Tax Purposes
   [Expand]Cross Reference
  [Expand]Fixed Assets
  [Expand]Transactions
  [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: 562.5388 ms
print   |
Label

Trial Balance

Trial Balance

Trial Balance

010381.gif010411.gif010382.gif010383.gif
The report may be created for the trial balance of any range of accounts and any period so that you enter the corresponding data::

47369.gif

Report type
The report for the trial balance may be created at any level of detail. By this you may use two sets of reports: in the first set the transactions are displayed in a summary way regardless of the subject on the other hand the trial balances are created in a summary way by individual subjects. The selected report type may be displayed by clicking the print icon or by double-clicking the report name.

1) Summary:

  • 052 - Trial balance – Sub 1 the financial statement report is made by individual accounts, which are used according to the chart of accounts. Summary balances of sub-accounts are also displayed.
  • 053 - Trial balance – Sub 2 the financial statement report is made by individual accounts, which are used according to the chart of accounts. Summary balances of classes are also displayed.
  • 054 - Trial balance – Parent the financial statement report is made by parent accounts. Summary balances of classes are also displayed.
  • 055 - Trial balance – Groups financial statement report is made by groups of accounts.
  • 056 - Trial balance – Classes financial statement report is made by classes.

2) By subjects:

  • 057 - Trial balance – Sub 1
  • 058 - Trial balance – Sub 2
  • 059 - Trial balance – Parent
  • 060 - Trial balance – Groups
  • 061 - Trial balance – Classes

3) By departments:

  • 05B - Trial balance – Sub 1
  • 05C - Trial balance – Sub 2
  • 05D - Trial balance – Parent
  • 05E - Trial balance – Groups
  • 05F - Trial balance – Classes

4) By cost drivers:

  • 05G - Trial balance – Sub 1
  • 05H - Trial balance – Sub 2
  • 05I - Trial balance – Parent
  • 05J - Trial balance – Groups
  • 05K - Trial balance – Classes
Document types
you select the document types IDs for those general journals or journal entries that you want to create a trial balance report. Records document types are not listed!
If you want to create a trial balance report for the already closed fiscal year, you do not include the journal entry for the closing fiscal year in the selected transactions. The program by default does not select the type of posting document which is in the Program parameters | Financials | Generalmarked as "Document type for G/L closure".
Account
account 1: the trial balance may be created for individual account or for individual account range (see descriptions of the next two fields). If the data is not entered in this or in the next two fields, the trial balance for all posts in the selected period is created.
Account range
  • if this field is selected, the trial balance for transactions on accounts  in the range between account 1 and account 2 is created. All the accounts which have a greater ID than the first account and smaller than the second account shall be included.
  • if the field is not selected and the data for account 1 and 2 were entered , then the trial balance shall be created ONLY for those tw o accounts
Account
account 2: seconf account by which the trial balance report is restricted. This data may represent the second account for trial balance report or it represents the margin of the account range, for which the trial balance is created (see the description of the previous field).
Subject
the report may be restricted by individual subject
Department
the report may be restricted by individual department from the journal entry item
Cost drv. the report may be restricted by individual cost driver from the journal entry item
From date
the start date of data, which shall be included in the trial balance report, are entered. The data is used in combination with the data on initial status type and date consideration.
Date to
the end date of data, which shall be included in the trial balance report, are entered. The data is used in combination with the data on date consideration.
Use date
it may be selected, for which data the date margins Date FROM and Date TO, are valid - THE PERIOD DATE IS THE RIGHT CHOICE:
  • From period - the period date shall be considered in the trial balance (from journal entry header)
  • From document - document dates shall be considered in the trial balance (from journal entry item)

If it is an annual trial balance the reports should be the same by using either of the criteria since in the journal entries of the current year belong only documents of the same year.

Report currency
Currency, in which we want to recalculate the trial balance. If the data is nt entered, then the trial balance report shall be made in EUR or to be more exact in the default currency from the program parameters.
Use exchange rate
If data was entered in the previous field (report currency), you have to select the method of searching od exchange rate used in recalculation to the selected currency:
  • As of posting date - journal entry items shall be recalculated according to the exchange rate list on the date of posting period from the journal entry header
  • As of document date - journal entry items shall be recalculated according to the exchange rate list on the document date from the journal entry item
  • As set in 'Date to' - all journal entry items shall be recalculated according to the exchange rate list on the date from the field Date TO

In any case the exchange rate list of the national bank's central rate as selected in the program parameters shall be used.

Initial balance
initial status type is elected, that is in what way should the program use the data about the date of the initial status (Date FROM):
  • Transactions on ... – all posts ON THE DAY of the initial status or date FROM are considered the initial status. All posts after this date are considered as transactions in the selected period. This is the most often used and most regular format of the report.
  • Transactions up to ... – all posts UP TO EXCLUDING the date of initial status are considered as the initial status. All posts from and including the date of initial status forward are considered as transactions in the selected period.
  • Transactions up to including ... – all posts UP TO INCLUDING the date of initial status are considered as the initial status. All posts after this date are considered as transactions in the selected period.

See also examples.

019229.jpg the selected format of the report is displayed or we select it from the list
000001.gif Transactions from records accounts are not taken into consideration here!
000001.gif To make the selection of document types easier it is possible to use the shortcut from the right mouse button click menu (see General - Multiple selection list).
000001.gif See Taskbar for a general description of its functions.

000001.gif The report criteria have to be selected every time, but you may save them as a template.
000001.gif Just like with filtering it is valid also for reports that a blank field means that all values shall be included in the report. And non-blank fields mean that only those documents and items matching the entered data shall be included in the report!
By using special characters the filter may be set a bit wider (see General - Wildcard characters).



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