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

Previous   Next               Entire Chapter in Printable Form               Search  

This text refers to program version 8.5  

Monthly Balances

This page describes the 'Monthly Balances' Export function in the Nominal Ledger.

---

The 'Monthly Balances' Export function in the Nominal Ledger will export monthly Account balances for each Account or for selected Accounts. The resulting export file will contain separate columns for each month in the report period and can be read directly by most word processors or spreadsheet programs, for further processing. You can restrict the export to a certain time period, certain Accounts and a Tag/Object.

You can specify whether the figures in the Monthly Balances export will be positive or negative depending on Account Type. To do this, use the check boxes in column 3 in the Presentation of Balances setting. For example, exported figures for Asset Accounts will obey the Assets check box in column 3 in the Presentation of Balances setting.

To run this Export function, ensure you are in the Nominal Ledger and 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 'Monthly Balances' to open the 'Specify Monthly Balances Export' window.

Period

Paste Special    Reporting Periods setting, System module

Enter the period for the balances you wish to export. The export file will contain separate columns for each calendar month in the period.

Accounts

Paste Special    Account register, Nominal Ledger/System module

Range Reporting    Alpha

Fill out this field if you only want to export the balances for certain Accounts.

Tag/Object

Paste Special    Tag/Object register, Nominal Ledger/System module

Enter a Tag/Object here if you need the balances in the report to be calculated from postings with a particular Tag/Object only. Unlike most Nominal Ledger reports, you can only enter a single Tag/Object here: if you enter a number of Tags/Objects separated by commas, the report will be empty.

Including Simulations

Check this box if you want to include the balances from simulated transactions in the export file. 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 [Run]. 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, and click [Save] or press the Enter key. A message window will inform you about the progress of the export process..

---

Export functions in the Nominal Ledger and Integration modules:

• Introduction
  

• Accumulated Monthly P/L Report
  

• Consolidation
  

• Key Financial Ratios
  

• Monthly Balances
  

• SIE (Swedish Standard Import/Export)
  

• Tag/Object Balances
  

• Transactions
  

• Trial Balance
  

• XBRL Report

Go back to:

• Home page for Nominal Ledger manual
  

• Home page for Standard ERP manual

Previous   Next   Top            Entire Chapter in Printable Form