Print Balance Overview Tab

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

Selection Criteria Island

Field Description
Company No. In these fields you enter a range of companies. If you enter a range, the report will only include information pertaining to companies within the specified range. If you leave these fields blank, they will not affect the report.
Account No. Here you enter a range of account numbers. The printout will only include accounts with an account number within this range. If you leave these fields blank, they will not affect the report.
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 these codes blank, the statistics fields have no influence on the printout.
Sum Level Here you can enter a range of sum levels. The printout will only include accounts with a sum level within the given range. If you leave these fields blank, they have no influence on the printout.
Line No. In these fields, you can specify a range of line numbers from the account structure. The printout will only include accounts with an account structure line number within the specified range, and marked “Balance Sheet” in the Account Structure workspace.
Department Here you can select a department. The printout will only include accounts assigned to this department in the Account Information Card workspace. If you leave these field blank, it has no influence on the printout.

Selection Criteria, Dimensions Island

Field Description
Location Here you enter a range of locations. The printout will only include entries to locations within this range. If you leave these fields blank, they will not affect the report.
Entity The functionality of this field is similar to that of the field “Location” above.
Project The functionality of this field is similar to that of the field “Location” above.
Purpose The functionality of this field is similar to that of the field “Location” above.
Spec. 1-3 The functionality of these fields is similar to that of the field “Location” above.
Local Spec. 1-3 The functionality of these fields is similar to that of the field “Location” above.

Period Island

Field Description
Month/Yr. Here you enter the starting month and year and the closing month and year of the period for the printout. Enter the month as a number, for example, “1” for January, “2” for February, and so on.

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

Budget Island

Field Description
Budget Model If you have selected “Result” in the field “Layout,” you must enter the budget model with which you want to compare the actual figures in this field. The printout will then show both the budgeted and the actual figures based on the budget and G/L entries within the selection criteria. If the layout “Result” has not been selected, the field has no effect.
Version In this field, you can enter the version of the budget model selected in the field “Budget Model” above with which you want to compare the actual figures. If the layout “Result” has not been selected, the field has no effect.
Budget Type In this field, you can select the budget type with which to compare the actual period figures, if you have checked the box “Compare with Budget” in the Print Control island. Instead of selecting a budget model in the field “Budget Model” above, you can select a budget type to make Maconomy select the budget model of the specified type for the fiscal year indicated in the field “Month/Yr.” Budget types are created in the pop-up field “Budget Type” in the Popup Fields workspace in the Set-Up module.
Version Type In this field, you can select the budget version type to use when comparing budget figures with actual figures, if you have checked the box “Compare with Budget” in the Print Control island. Instead of selecting a version number in the field “Version” above, you can select a budget version type to make Maconomy select the budget model of the specified version type for the fiscal year indicated in the field “Month/Yr.” Budget types are created in the pop-up field “Budget Version Type” in the Popup Fields workspace in the Set-Up module.

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 give rise to 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 that are 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.

Print Control Island

Field Description
Layout In this field you choose the layout of the printout. The layout “Balance Sheet” shows opening and closing balances and the total movements within the period for each of the balance sheet accounts identified by the selection criteria. The layout “Trial Balance” shows debited and credited amounts and total movements within the period for each of the P&L and balance sheet accounts comprised by the selection criteria. The layout “Result” compares actual amounts with the budget figures for the individual accounts. For all the layouts, only the entries identified by the selection criteria are included in the printout.
Include Zero Balances from Level Here you specify whether to include accounts with zero balances in the printout for a given level. If, for example, you enter “1,” the printout will only show sum accounts with a balance of zero, whereas no posting accounts with a balance of zero will be shown.
Settings Here you specify additional settings:
  • Include Page Break— Here you can specify whether to include page breaks in the printout, where this is specified by page break accounts in the Account Structure workspace. If the box is checked, the printout includes page breaks. Page breaks only occur where the page break accounts in the account structure are included in the range specified in the field “Line No.”
  • Include Headings— Here you can specify whether to include headings in the printout, where this is specified by heading accounts in the Account Structure workspace. If the box is checked, the printout includes headings. Headings only occur where the heading accounts in the account structure are included in the range specified in the field “Line No.”
  • Compare with Budget — You can mark this field if you wish to compare the period figures with a budget. If you mark the field, the period movements will be compared with the budget selected in the field “Budget Type.” If this field is not marked, the period movements are compared with the movements in the corresponding fiscal period in the previous year.