Language:


HansaManuals Home   >> Standard ERP   >> Nominal Ledger   >> Exports  

Previous   Next               Entire Chapter in Printable Form               Search  

This text refers to program version 8.5  

Trial Balance

This page describes the 'Trial Balance' Export function in the Nominal Ledger module.

---

The 'Trial Balance' Export function in the Nominal Ledger exports closing balances for the specified period for each Account but not debit and credit subtotals. You can export the Trial Balance for the whole year or for an arbitrary part of the year to a tab-separated text file, and you can then import this information for example to an Annual Report generating program for further processing.

You can specify whether figures in the Trial Balance will be positive or negative depending on Account Type. To do this, use the check boxes in column 2 in the Presentation of Balances setting. For example, exported figures for Asset Accounts will obey the Assets check box in column 2 in the Presentation of Balances setting. It is recommended that the check boxes in column 2 in this setting should all be ticked or not ticked. If only some of the check boxes in column 2 are ticked, the Trial Balance report will not balance.

To export the Trial Balance, ensure you are in the Nominal Ledger, then open the 'Exports' list by clicking the [Routines] button in the Navigation Centre and the [Exports] button in the subsequent 'Routines' window. Then double-click 'Trial Balance' in the 'Exports' list to open the 'Specify Trial Balance Export' window.

Period
Paste Special    Reporting Periods setting, System module
Enter the start and end dates for the period to be covered by the export, separated by a colon. The export file will contain the balances on each Account for the end of the period specified here.

Tag/Object
Paste Special    Tag/Object register, Nominal Ledger/System module
Enter a Tag/Object Code here if you need the Account balances in the export file to be calculated from postings with a particular Tag/Object. You can also enter a number of Tags/Objects separated by commas, in which case Account balances will be calculated from postings with all the Tags/Objects listed. If you leave this field empty, Account balances will be calculated from all postings, with and without Tags/Objects.

Including Simulations
Use this option if you want the export to include simulated transactions from the Simulations register. Simulation rows in which the Status is "Invalid" and "Transferred" will not be included.

Values in
If you are using the Dual-Base system, use these options to specify whether the values in the export file are to be shown in Base Currency 1 or 2.

If you are not using the Dual-Base system, use the Base Currency 1 option to use your home Currency.
Confirm by clicking the [Run] button (or cancel by clicking the close box). A dialogue box will open, where you can name the export file and specify where it is to be saved. Enter a name for the file. Click [Save] or press the Enter key. A message window will inform you about the progress of the export process. When the export has finished, close the 'Exports' list window using the close box.

---

Export functions in the Nominal Ledger and Integration modules:

Go back to:

Previous   Next   Top            Entire Chapter in Printable Form