PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Collapse]Guide for PANTHEON
   [Expand]Settings
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]POS
   [Expand]Service
   [Collapse]Financials
    [Expand]Accounting Basics
    [Expand]Posting
    [Expand]Automatic Posting
    [Expand]Accounting Dashboard
    [Expand]Overview
    [Expand]Close
    [Expand]Accruals and Deferrals
    [Expand]Credits and Leases
    [Collapse]Reports
     [Expand]Annual Report for Slovene Authority
     [Expand]Mass Print Reports
     [Expand]General Journal
     [Expand]Account Card - old
     [Expand]Account Card
     [Expand]Outstanding Items
     [Expand]Outstanding Items - old
     [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]Četrtletno poročilo za AJPES
     [Expand]Summary Reports
     [Expand]Financial Analyses (ZEUS)
     [Expand]SFR - Statistika Finančnih Računov
     [Expand]Cross Reference
      Export General Ledger Data for Tax Purposes
     [Expand]Zavarovanje terjatev
    [Expand]Special Reports
     Consolidated Financials Statements
    [Expand]Fixed Assets
    [Expand]Transactions
    [Expand]Debt Collection
    [Expand]Reminders
    [Expand]Year-end
    [Expand]Interest
    [Expand]Cash
    [Expand]Archive
     ZEUS Planning
   [Expand]Personnel
   [Expand]Analytics
   [Expand]Desktop
   [Expand]Help
   [Expand]Messages and Warnings
   [Expand]Additional programs
   [Expand]Old products
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Expand]User Manual for PANTHEON
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 406.2586 ms
"
  1263 | 1614 | 336543 | Updated
Label

Trial Balance

010381.gif 010411.gif 010382.gif 010383.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.

The report can be accessed via the menu Financials | Reports | Trial Balance.

Table of contents

  1. Toolbar
  2. Tabs
  3. Criteria
  4. Document Types

 

  1. Toolbar: The toolbar is found on each PANTHEON form at the top of the program window. 
  2. Tabs:

2.1. Report:

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

 

2.2. Custom field – subjects

Which custom fields are displayed on this tab can be set in Settings | Program | Administration Panel in the panel Settings | Subjects | Custom fields.

2.3. Grid View

Trial Balance Report has also grid view. Grid view enables us detailed view every Trial balance report position and also grouping by any column from report i.e.:

Grid view can be also printed or exported to Excel. We use right mouse click and options for exporting or printing report:

3. Criteria:

WARNING

The report criteria have to be selected every time, but you may save them as a template.

 

Use date

In this section 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 - the document dates shall be considered in the trial balance (from journal entry item)
  • VAT Date

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 the documents of the same year.

Opening Balance

In this section select the opening balance, that is, in what way should the program use the data about the date of the initial status (Date FROM):

  • Transactions on ... – all the 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 the posts UP TO EXCLUDING the date of initial status are considered as the initial status. All the posts from and including the date of initial status forward are considered as transactions in the selected period.
  • Transactions up to including ... – all the posts UP TO INCLUDING the date of initial status are considered as the initial status. All the posts after this date are considered as transactions in the selected period.

See also examples.

Account

Account 1: the trial balance may be created for an individual account or for an individual account range (see descriptions of the next two fields). If the data is not entered here or in the next two fields, the trial balance for all posts in the selected period is created.

It is also possible to review more than one account at the same time by using the multi select key  .

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 two accounts.

Account

Account 2: second account by which the trial balance report is restricted. This data may represent the second account for a 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).

Digits

 

Group at

 

Subject

The report may be restricted by the individual subject.

Subject Type

The report may be restricted by the subject type.

Name 2

The report may be restricted by name 2 of the subject.

Department

The report may be restricted by the individual department from the journal entry item.

Cost Center

The report may be restricted by the individual cost center from the journal entry item. 

HINT

Using the function   opens Lookup table in which multiple options can be selected within a single field. In this case, different Cost Centers in relation to their Name, Group or Status

On lookup table you can see also non-active cost centers.

Document Report can be prepared for only one document. Note that you can prepare the report using the  wildcard characters!

Ext. Doc.

Select specific Foreign document for which you want to create a report.

Linked Doc.

Report can be prepared for the selected linked document.

Date from

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.

Primary Currency

Currency, in which we want to recalculate the trial balance. If the data is not entered, then the trial balance report shall be made in EUR or to be more exact in the default currency from the program parameters.

Convert to

If you want to convert data to different currency, in this field you can select it from the drop-down menu.

Journal Entry

Select specific journal entry for which you want to create a report.

Include Only Approved Journal Entries

If checked, the program will include in the report only the journal entries with the Approved status.

Clerk

From the drop-down menu select the clerk.

Acct. Type

From the drop-down menu select the account type you want to be captured in the report. By double-clicking on this field, the form Active types opens.

Report in Users Language

If the translations of the chart of the account exist for certain language in the program, these translations can be used in the printout of the trial balance.

Merge Accounts with Identical Name

If checked, the program will merge the accounts with identical name.

Use account 2 for reporting Select if you want to create report using account 2 from Chart of Accounts
Account 2 Select an account 2 from the drop-down menu. You can also choose more than one account by using the   multiselect button.
from - to Check this checkbox when filtering by a range of accounts.
Account 2 to Additional account 2. The account card can be prepared for: 
  • two accounts in one report. For example, for one subject, you can prepare a report for liabilities and for advanced payments to suppliers. In this case, do not check the from - to checkbox.
  • for a specific range of accounts. In this case, the from - to checkbox should be checked.

Also, option Use account 2 for reporting should be checked.

Report

By clicking on this button, a selected format of the report is displayed or we can select it from the list. Right mouse click opens the Ad-Hoc analysis:

 

4. Document Types: In this section there is a list of all the document types that you can capture into the trial balance report.

warning

The transactions from the records accounts are not taken into consideration here!

 

WARNING

To make the selection of the document types easier it is possible to use the shortcut from the right mouse button click menu (see General - Multiple selection list).

 

WARNING

Just like with filtering it is valid also for reports that a blank field means that all the 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!