Movement Report

This report is the same as the GL Trial Balance, but presents information in a format that meets requirements in the United States.

Although the report is run for a single financial year (either MTD for a single month, or YTD), you can enter a period range that spans years. Because P&L account balances return to zero at the end of each financial year, the closing balance of an account will not equal the opening balance plus movement.

The movement columns for the income and expense accounts is suppressed, and this disclaimer is printed:

This report spans multiple financial years so net movement in non balance form accounts are not displayed.

Any totals or subtotals that include these suppressed values are also suppressed

Header Details

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

Line Details

This information displays 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

Note: If printing the report for a range that spans multiple financial years, the Debits, Credits, and Movement columns are 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.

Company

The default value is the company you are logged into. 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

Select the account sequence on which to base the output. These are defined on the GL Module Sequences form.

Tree

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

Account Order

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

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 is provided for each currency that is represented on the report.

Note: If you print by tree or transaction analysis, the report print 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 is enabled when you select the option. Click it to select tree and branch combinations to include in the report.

Select one of the MDA combinations set up for general ledger analysis in 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 to print. These must be period start and end dates. If the start and end dates are not in the same financial year, the debit, credit and movement columns are suppressed for non-balance form accounts.

Account Range

Enter the first and last accounts of the range 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.