Trial Balance
The Trial Balance is a form of combined
Balance Sheet and
Profit & Loss report, showing balances for each Account but not debit and credit subtotals. You may export the Trial Balance for the whole year or for an arbitrary part of the year as a tab-separated text file, and it can then be imported for further processing for example by an Annual Report generating program.
Double-click 'Trial Balance' in the 'Export' 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.
- Object
- Paste Special
Object register, Nominal Ledger/System module
- Enter a value in this field if you want to the export to contain Account balances for a certain Object. If the field is empty, the total balances of all Accounts, irrespective of Object, are exported. If you need to export balances for all Accounts, broken down by Object, use the 'Object Balances' export.
- Including Simulations
- Check the box if you want the export to include simulated transactions. Simulation rows of "Invalid" and "Transferred" Status will not be included.
- 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 use your home Currency.
Confirm with [Run] (or cancel using 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 informs you about the progress of the export process. You can interrupt the process at any time by pressing Esc (Windows) or ⌘-Full Stop (Macintosh).
Close the 'Exports' list window using the close box when the export has finished.
