The report on GL balances and turnovers provides balances and turnovers for a predefined set of GL accounts over a certain period. You can generate one of the following reports:
A comprehensive report: this includes all accounts and transaction currencies for a specific period, such as the previous month.
A focused report: this includes accounts and transaction currencies of your interest within a custom date range.
To create a report on GL balances and turnovers:
Go to Finance > Reports > GL account balances.
Click on Selected GL accounts to open a complete list of accounts for account-level selection adjustments.
Click on the Export as CSV button to start report generation.
Wait a moment to allow Tuum to finish the report generation.
The created GL balances and turnovers report will be available for download in CSV format.
Go to Reports > My reports to find the report you have created.
Click on the report's name in the Files column to download the report into the downloads folder on your computer.
The GL balances and turnovers report contains GL account number, type and name followed by:
Currency: the currency of the balances and turnovers.
Opening balance: the balance of the GL account at the beginning of the reporting period.
Debit turnover: the total debit turnover of the GL account during the reporting period.
Credit turnover: the total credit turnover of the GL account during the reporting period.
End balance: the balance of the GL account at the end of the reporting period.
On the GL account balances report page, select the .
The table below shows GL balances and turnovers report parameters for requesting a report. The required (mandatory) parameters are marked with a red asterisk (*).
Entry date from *
Date
Select the start date of the period for which you want to include balances and turnovers in the report. Note: The earliest date can be 3 months from today.
Entry date to *
Date
Select the period's end date for the balances and turnovers you want to include in the report. Note: The selected date can be up to 31 days from the Entry date from.
Remove zero lines *
Yes/No
Select one of the following options:
Option Yes will include only active GL accounts in the report. Active GL accounts had non-zero balances before the reporting period or had turnover during the specified reporting period.
Option No will include all selected GL accounts in the report regardless of their balance or activity status.
Transaction currency *
List
Select currencies whose balances and turnovers you want to include in the report, or deselect the currencies whose balances and turnovers you do not wish to include.
GL account from
List
Select the first GL account, which starts the range of GL accounts whose balances and turnovers you want to include in the report.
GL account to
List
Select the last GL account, which ends the range of GL accounts whose balances and turnovers you want to include in the report.
Selected GL accounts
List
Select the GL accounts whose balances and turnovers you want to include in the report or deselect the GL accounts whose balances and turnovers you do not wish to include.
