Print Trial Balance Tab

This section includes the fields and descriptions for the Print Trial Balance tab.

Selection Criteria Island

Field Description
Company No. Here you enter a range of company numbers. The trial balance will only include entries to companies within this range. If you leave the fields blank, company numbers have no influence on the selection criteria.
Account No. Here you enter a range of account numbers. The trial balance will only include accounts with an account number within this range. If you leave the fields blank, they have no influence on the selection criteria.
Statistics 1-4 Here you enter up to four statistics code ranges. The printout will only include accounts with statistics codes within this range. If you leave the codes blank, the statistics fields have no influence on the selection criteria.
Sum Level Here you can enter a range of sum levels. The printout will only include accounts marked “Balance Sheet” in the Account Structure workspace on a sum level within the given range. If you leave the fields blank, they have no influence on the selection criteria.
Line No. In these fields, you can specify a range of line numbers from the account structure. The balance will only include lines in the Account Structure workspace and appearing on an account structure line within the specified range.
Department Here you can select a department. The printout will only include accounts assigned to this department. If you leave the field blank, it has no influence on the selection criteria.

Selection Criteria, Dimensions Island

Field Description
Location Here you enter a range of locations. The trial balance will only include entries to locations within this range. If you leave the fields blank, they have no influence on the selection criteria.
Entity The functionality of this field is similar to the functionality of the field “Location” above.
Project The functionality of this field is similar to the functionality of the field “Location” above.
Purpose The functionality of this field is similar to the functionality of the field “Location” above.
Spec. 1-3 The functionality of these fields is similar to the functionality of the field “Location” above.

Period Island

Field Description
Month/Yr. Here you enter the starting month/year and ending month/year of the period for which the balance is to be printed. You can also enter a different period range for each report line definition in the table. Enter the period as a number, for example, “1” for January, “2” for February, and so on.

If your company uses flexible periods that do not follow the calendar year, the month and year that you enter here refer to the period defined in the window Fiscal Year.

Print Control Island

Field Description
Layout Here you select whether to print an opening balance or a balance showing monthly movements. You select either “Opening” or “Movement.”

You can also sort the movement balance, first by options from one of the dimensions, then by account number. To do this, select the option concerning the desired dimension, for example, “Location Account,” “Entity Account,” or “Project Account” in this field. However, if you do so, you cannot select a dimension in the field “Allocate to Dimension.”

Allocate to Dimension Here you can select whether to split up individual account balances by dimension values. If you leave this field blank, the printout will show a total for every balance. If you select a dimension, the printout will show one line per dimension value, and a balance for every account in the balance sheet.

You can only select a dimension in this field if you select “Opening” or “Movement” in the “Layout” field.

Include Zero Balances from Level Here you specify whether to include zero-balance accounts for a given level. If you enter “1,” for example, the printout will only include zero-balance sum accounts, and will not include any zero-balance posting accounts.
Include Zero Balance Dimensions Here you can specify whether to include a dimension option, also when the balance for an option in an account is zero. The option is included regardless of its balance, if this field is marked. If it is not marked, the option is only included if the account has a balance that is different from zero for this option. The field only applies if the “Allocate to Dimension” field is marked.
Tax Code If you mark this field, the balance sheet will show the tax codes for every account.

If multiple tax codes are enabled, this field will be replaced by the field “Show Tax Codes.” To enable multiple tax codes, the system parameters “Show Three Tax Levels” and/or “Show Two Tax Levels” must be marked in the System Parameters workspace. For further information on multiple tax codes, please see the description in “Tax Codes.”

Include Page Break Here you can specify whether to include page breaks, where this is specified by page break accounts in the Account Structure workspace. If the field is marked, the printout includes page breaks. Page breaks only occur in page break accounts found on a line in the account structure that lies within the range specified in the field “Line No.”
Include Headings If you mark this field, the printout will include heading accounts in the Account Structure workspace. The printout will only include heading accounts found on a line in the account structure that lies within the range specified in the field “Line No.”
Include Underlinings If you mark this field, the printout will include underlining accounts—single underlining as well as doublein the Account Structure workspace. The printout will only include underlining accounts found on a line in the account structure that lies within the range specified in the field “Line No.”

Only Include Accts with Dimension Alloc. Here, you specify whether to include accounts assigned to a dimension. “Manual,” “Control,” “Heading,” and “Page Break” accounts can be assigned to either the “Company,” “Location,” “Entity,” or “Project” dimension in their account information cards. If you mark this field, you must select “Company Account,” “Location Account,” “Entity Account,” or “Project Account” in the “Layout” field in this window. If you do not mark this field, the balance will include all accounts.

Currency Island

Field Description
Reporting Currency In this field, you can specify the currency in which figures on the printout should be displayed. All total figures will be converted into and displayed in this currency. If the current user has been assigned to a company in the Users workspace, Maconomy suggests the company base currency of the company in question.

When converting amounts into the selected currency, Maconomy uses the exchange rates that are valid on the date entered in the field “Exchange Rate Date” below, and the exchange rate table used is the exchange rate table selected in the field “Exchange Rate Table” below. Please note that Maconomy performs currency conversion even though the original amount has been registered in the same currency as the one specified in this field, which may cause discrepancies between the registered amounts and the amounts shown in this window.

Exchange Rate Date In this field, you can specify an exchange rate date. When converting amounts into the reporting currency, Maconomy uses the exchange rates valid on this date according to the exchange rate table selected in the field “Exchange Rate Table” below.
Exchange Rate Table In this field, you can specify the exchange rate table to use when converting between currencies in the printout.
Basis In this field, you can specify which amounts on each G/L entry should form the basis of the printed figures. Each G/L entry stores the amount in enterprise currency, the base currency of the company in question, and the currency of the account on which the entry is recorded. The printout will for every G/L entry convert the amount in the in the currency of the basis selected into the reporting currency, using the selected exchange rate date and table.