Movement Report

This report is essentially the same as the GL Trial Balance, but presented in a format to meet United States requirements.

Although the report will typically be run for a single financial year (either MTD for a single month, or YTD) you can enter a period range that spans across years. In this situation, because P&L account balances returns to zero at the end of each financial year, the closing balance of an account will not in fact equal the opening balance plus movement.

The movement columns for the Income and Expense accounts will be suppressed in this case, and this disclaimer printed: This report spans multiple financial years so net movement in non balance form accounts are not displayed. Any totals or subtotals that would normally include these suppressed values will also be suppressed

Header Details

Custom heading
Report process date and time
Page number
Period range, as specified in the parameters
Transaction Analysis details if applicable
The currency indicator, as specified in the parameters

Line Details

These details display for each General Ledger account, using the parameters selected and the period end date specified:

General Ledger Account number
General Ledger Account description
Currency (if printing in the Account currency)
Opening Balance
Debits (for the selected range)
Credits (for the selected range)
Movements (for the selected range)
Closing Balance

Information

If printing the report for a range that spans multiple financial years, the Debits, Credits, and Movement columns will be suppressed for non balance form accounts, and a message to this effect displays at the end of the report.

Totals:

If you output this report based on tree the report will group and sub-total by tree branch.
If you output this report in account currency the report will provide totals for each currency represented, and its ledger equivalent.
A grand total displays in ledger currency for all accounts included in the report.

Parameters

These parameters are available when you run the report:

Company

The default value is the company you are logged into, but you can change it to view the report for a different company.

View Mode

This is applicable if you are using Advanced Security and enables you to restrict the output based on team security.

Sequence

You can select the account sequence on which to base the output. These are defined in GL Module Sequences.

Tree

You can filter the output of this report by Tree. If you select a tree, you can specify which branches to include. If you do not want to filter the output by tree, select the option None in the Tree field.

Account Order

You can select to output order to be based on General Ledger account number or account description.

Exclude Zero Balance

Select this option to exclude accounts with zero balances and zero movements from the report.

Ledger Currency

You can select to output the report in ledger or account currency. If printing in the account currency, an additional Currency column displays on the report, and totals will be provided for each currency that is represented on the report.

Information If printing by Tree or Transaction Analysis, the report can only be printed in the general ledger's currency.

Print based on transaction analysis

This option is enabled if you are using the GL Transaction Analysis module. The Transaction analysis options button displays when you select the option, enabling you to select tree/branch combinations to include in the report.

You can select one of the MDA combinations set up for General Ledger analysis within the transaction analysis module. For each tree you can select one, all, or a combination of branches to output to the report.

Period Range

Enter the start and end dates of the range you want to print. These must be period start and end dates respectively. If the start and end dates are not in the same financial year, the debit, credit and movement columns will be suppressed for non-balance form accounts.

Account Range

Enter the first and last accounts of the range that you want to include in the report. You can use wildcards in this field.

Currency Range

Enter a start and end currency to limit the report to just accounts of a currency or range of currency.

Custom Heading

Enter text in this field that will print directly under the report header.