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:

|