Table of Contents

Fixed Asset Turnover Sheet

This report shows information about the movement and balances of Fixed Assets. It contains values at the beginning and end of the period, as well as debit and credit turnovers for each Fixed Asset during the period.

To run the report, select the Search icon, enter FA Turnover Sheet, follow the link.

On the Options tab, select filters based on the parameters needed to display information on the movement of Fixed Assets.

Field Description
View By Specifies by which period amounts are displayed.
Date Filter Specifies the dates that will be used to filter the amounts in the window.
G/L Account Filter Specifies the G/L account that will be used to filter the amounts in the window.
Fixed Asset Filter Specifies the Fixed Asset that will be used to filter the amounts in the window.
FA Location Specifies the FA location that will be used to filter the amounts in the window.
Responsible Employee Specifies whether the Responsible Employee detail level will be displayed.
Global Dimension 1 Filter Specifies the Global Dimension 1 value that will be used to filter the amounts in the window.
Global Dimension 2 Filter Specifies the Global Dimension 2 value that will be used to filter the amounts in the window.
Sort Type Specifies the parameters and levels for grouping and displaying data in the report.
Show Location Specifies whether the Location detail level will be displayed.
Show Responsible Employee Specifies whether the Responsible Employee detail level will be displayed.
Show SubClass Specifies whether the SubClass detail level will be displayed.
Show G/L Account Specifies whether the G/L Account detail level will be displayed.
Show amounts in ACY Specifies whether ACY of the G/L account will be displayed on the page.
Expand Account Specifies whether the expanded ledger account balance will be displayed on the page.

Click the Update Values button. The following information will be displayed in the rows of the FA Turnover Sheet:

Field Description
Name Specifies the name of the relevant parameter according to the level of detail in the report.
Starting Balance Specifies the balance at the beginning of the period.
Starting Balance Debit Specifies the general ledger account debit balance associated with the source at the beginning of the period.
Starting Balance Credit Specifies the general ledger account credit balance associated with the source at the beginning of the period.
Debit Amount Specifies the total of the ledger entries that represent debits.
Credit Amount Specifies the total of the ledger entries that represent credits.
Ending Balance Specifies the balance at the end of the period.
Ending Balance Debit Specifies general ledger debit balance associated with the entry at the end of the period.
Ending Balance Credit Specifies general ledger credit balance associated with the entry at the end of the period.

The Totals tab displays the summary values for the generated statement and contains the following information:

  • Starting Balance Total
  • Starting Balance Debit Total
  • Starting Balance Credit Total
  • Debit Total
  • Credit Total
  • Ending Balance Debit Total
  • Ending Balance Credit Total
  • Ending Balance Total

The report data can be exported to Excel by clicking the Search button in the FA Turnover Sheet rows.

See Also

Fixed Asset Card
Creating depreciation templates
Fixed Asset depreciation