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 | General marked 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.
It is also possible to review more than one account at time by using 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 tw o accounts
|
Account |
account 2: second 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.
|
 |
the selected format of the report is displayed or we select it from the list. Right mouse click opens Ad-Hoc analyises. |
Report in user's language |
If translations of chart of account exist for certain language in program, this translations can be used in the printout of trial balance. |