Monthly Balances
Select this command if you want to export the monthly balances of the company - for all or a selection of Accounts. The resulting export file can be read directly by most word processors or spreadsheet programs, for further processing. You can limit the export to a certain time period, certain Accounts and an Object.
Double-click 'Monthly Balances' in the 'Export' list 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. For each month that is included in the period, a separate column will be created in the export file.
- 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.
- Object
- Paste Special
Object register, Nominal Ledger/System module
- Fill out this field to export monthly balances for a specific Object. If you leave the field empty, all balances for the period will be exported.
- Including Simulations
- Check this box if you want to include the balances from simulated transactions in the export file. Simulation rows of "Invalid" and "Transferred" Status will not be included.
- Values in
- If you are using the Dual-Base system, you can choose which Base Currency will be used in the export file. 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 use your home Currency.
Confirm by clicking [Run] (or cancel using the close box). Hansa will open a dialogue box 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 informs you about the progress of the export process. The process can be interrupted at any time by pressing Esc (Windows) or ⌘-Full Stop (Macintosh).
