Language:


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:

Go back to: