Balance Sheet - Printing
Having entered a definition for the Balance Sheet as described here, you will be ready to print the report. After ensuring you are in the Nominal Ledger, click the [Reports] button in the Navigation Centre and then double-click 'Balance Sheet' in the 'Reports' list. The 'Specify Balance Sheet' window will be opened.
- Period
- Paste Special
Reporting Periods setting, System module
- Enter the period for the Balance Sheet you want to print. The Account balances in the report will be calculated from postings (i.e. from Transaction rows) recorded during the period specified here. The first period in the Reporting Periods setting will be offered as a default.
- Header
- Specify a title for the report here. This title will be printed in the report header, and will also appear in the title bar of the report window if you print the report to screen.
- Object
- Paste Special
Object register, Nominal Ledger/System module
- Enter an Object Code here if you need the Account balances in the report to be calculated from postings with a particular Object. You can also enter a number of Objects separated by commas, in which case Account balances will be calculated from postings with all the Objects listed. If you leave this field empty, the Account balances in the report will be calculated from all Transaction rows, with and without Objects.
- Object Type
- Paste Special
Object Types setting, Nominal Ledger
- Enter an Object Type Code in this field if you want the report to show Account balances calculated from postings with Objects belonging to a certain Object Type.
- Including Unspecified
- Check this box if, for each Account, you want to show a balance figure for Transaction rows for Objects belonging to the Object Type specified above and a second balance for all other Transaction rows.
- Currency
- Paste Special
Currency register, System module
- If you specify a Currency here, the Account balances in the report will be calculated only from those Transaction rows with the specified Currency shown on flip C. The balances will be calculated using the figures on flip C of those Transaction rows (i.e. they will be in the chosen Currency). If you leave this field blank, all Transaction rows will be included in the calculations. In this case the calculation will use the figures in the Base 1 or Base 2 Debit or Credit fields on flip A (choose which Base Currency is to be used using the Values In options described below).
- Language
- Paste Special
Languages setting, System module
- You can produce the Balance Sheet in different Languages: enter the required Language Code here. The appropriate translation for each Account Name will be taken from the 'Texts' card of the Account record and for each report heading and sub-heading from the report definition.
- If you do not enter a Language here, but you have entered a Language in the Company Info setting in the System module, the report will be produced in that Language if you are using the Account Description in Company Language option in the Transaction Settings setting in the Nominal Ledger.
- Accounts
- Use these options to choose how you want the Accounts to be printed in the report.
- All
- This option will list all the Accounts that have been included in the Balance Sheet definition.
- With Balance
- This option will only list Accounts that have an opening balance and/or a closing balance.
- An Account with no opening balance that has been used in the period in such a way that it also has no closing balance will not be shown in the report. If you want such an Account to be included in the report, use the Used Only option below.
- Groups only
- This option does not print balances for individual Accounts. Instead, it simply prints an overall balance for each line in the Balance Sheet definition.
- Used Groups only
- This option only prints balances for lines in the Balance Sheet definition that have been used.
- Used only
- This option will only list Accounts that have been used. This includes Accounts that have balances brought forward from a previous period that have not been used during the report period.
- This option is similar to With Balance above, with the exception that it also includes Accounts with no opening balances that have been used during the period in such a way that they also have no closing balances.
- Notation
- Select the printing format for the values in the Balance Sheet.
- Exact
- Shows the balances as stored in the Transactions.
- No Decimals
- Rounds the balances up or down to the nearest whole number.
- Thousands, Millions
- Divide the balances by 1,000 or 1,000,000.
- Comparison in %
- If you choose "Budget" or "Revised Budget" as the Comparison option (below), an extra column will be added to the report. If you do not select this Comparison in % option, this column will display the Budget or Revised Budget figures for each Account. If you do select this option, the column will display the difference between the Budget or Revised Budget and actual figures, expressed as a percentage.
- Comparison
- Choose to compare with Net Change, Budget, Revised Budget or the same period the previous year.
- If you are using the Budget or Revised Budget options, Budget or Revised Budget records will only be included in the report if they have at least one entry in the grid area of the screen complete with date. If you use Objects, you should create Budget (and, if you are using them, Revised Budget) records for each Account/Object combination and overall Budgets/Revised Budgets for each Account without Objects. This will allow you to use the Budget or Revised Budget options with a particular Object, and with no Object.
- If you are using the Budget or Revised Budget options, you can choose a Budget Class using 'Paste Special' from the Class field. The Budget or Revised Budget figures will be taken from the Budget or Revised Budget records with the specified Class. If you do not specify a Class, figures will be taken from the Budget or Revised Budget records in which the Class is blank.
- The No Comparison option will simply display balances brought forward and for the report period. It is appropriate for users in Russia where the Balance Sheet is printed using a standard report design including line numbers. You should define the line numbers using the Extra Code field in the Balance Sheet line definitions.
- Including Simulations
- Select this option if you need simulated transactions from the Simulation register to be included in the report. Simulation rows in which the Status is "Invalid" and "Transferred" will not be included.
- List Transaction Nos
- If you select this option, the Transaction Numbers of all Transactions that fall within the reporting period, together with debit and credit totals, will be listed at the end of the report.
- No Header
- Check this box if you want the report to be printed without a header.
- Show zeroes instead of blank strings
- If you choose All as the Accounts option, unused Accounts will be shown in the report with blank values. Similarly, blank values may be included in the report if you choose Budget or Revised Budget as the Comparison option, which will add an extra column to the report. Depending on the Comparison in % option, this column will display the Budget or Revised Budget figures for each Account or the difference between the Budget or Revised Budget and actual figures, expressed as a percentage. If there is no Budget or Revised Budget figure for a particular Account, nothing will be printed (i.e. the space will be blank).
- If you would prefer "0.00" to be printed instead of the blanks, select this Show zeroes instead of blank strings option.
- Values in
- If you are using the Dual-Base system, values in this report can be shown in either Base Currency. Use these options to choose which Currency is to be used on this occasion.
- If you are not using the Dual-Base system, use the Base Currency 1 option to produce a report in your home Currency.
- If you have entered a Currency in the Currency field above, the figures in the report will be in that Currency.
When you click [Run], the Balance Sheet will be printed as you have specified.
When printed to screen, the Balance Sheet has the Standard ERP Drill-down feature. Click on the Account Number of any Account in the report to open the Nominal Ledger Report for the same Account and period. From the Nominal Ledger report, you can click on any Transaction Number to open an individual Transaction record.
---
Please click for details about:
---
Reports in the Nominal Ledger:
---
Go back to:
|
Introduction to Reports in the Nominal Ledger
