Use this screen to print comparisons and variances by Acct/Org between data in Costpoint Fixed Assets and the General Ledger at any point in time (current or historical). Costpoint Fixed Assets acts as a subsidiary ledger to the General Ledger. The individual balances for cost and accumulated depreciation values for each Asset Master record are stored in Costpoint Fixed Assets, but the totals of the detail records should reconcile to the summary balances in the General Ledger.
Because it is considered a responsible accounting practice to reconcile Costpoint Fixed Assets to the General Ledger on a monthly basis, you can use this report to automatically collect the necessary data and to identify discrepancies. In order to encourage this task on a routine basis, this report provides a starting point for the reconciliation task.
You can print data for the Fixed Assets Cost accounts and/or the Fixed Assets Accumulated Depreciation accounts.
The Fixed Assets Cost account is the account assigned in Costpoint Fixed Assets as the Asset account to denote "ownership."
The Fixed Assets Accumulated Depreciation account is the account assigned in Costpoint Fixed Assets by means of an Accum Depr Account Code to point to the GL account to which accumulated depreciation should be posted.
You will normally find this report most useful when performing the reconciliation for company-owned assets for which balances reside in balance sheet accounts in the General Ledger.
Although the G/L balances for assets assigned to project ownership accounts are normally non-depreciable and do not normally reside in balance sheet accounts, you can make selections for this report that include non-depreciable assets and/or one project, a range of projects, or all projects. For projects and/or non-depreciable assets, you may find that only a portion of this report is applicable.
You can print the reconciliation for asset accounts/orgs/projects, accumulated depreciation accounts/orgs/projects (by accumulated depreciation account code or by account), or both.
You can select any one "point-in-time" for which the data will be collected and printed by selecting the fiscal year, period, and subperiod. The selected point in time can be current or historical.
If you print the reconciliation for the accumulated depreciation accounts and have also selected the Accum Depr Acct/Org/Proj radio button in the Select A/D Accts By group box, you can print the Accum Depr Acct Codes on the report.
Because you may already have computed depreciation at the time you print this report, you can include or exclude the Current Period Depreciation values in the FA totals for Accum Depreciation. (Current period depreciation values are always added by the system and reflected in the accumulated depreciation values.)
You can also include active records, inactive records, and/or disposals within your other selection criteria for the reconciliation report.
Print this report for any point in time, current or historical.
Use the options in this group box to print data for the Fixed Assets cost accounts and/or the Fixed Assets accumulated depreciation accounts. You must select at least one checkbox.
The Fixed Assets Cost account is the account assigned to the Asset Master record in Costpoint Fixed Assets as the asset account to denote "ownership."
The Fixed Assets Accumulated Depreciation account is the account assigned to the Asset Master record in Costpoint Fixed Assets by means of an Accum Depr Account Code to point to the GL account to which accumulated depreciation should be posted.
This checkbox is selected by default.
Select this checkbox to print data for the Fixed Assets Cost accounts.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the FA Cost (Asset Accts) column in the Query table.
This checkbox is unchecked by default.
Select this checkbox to print data for Fixed Assets Accumulated Depreciation accounts.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the FA Accum Depr (A/D Accts) column in the Query table.
The radio buttons in this group box are available only if you have selected the FA Accum Depr (A/D Accts) checkbox in the Print Reconciliation For group box.
Use this group box to select accumulated depreciation options either by accumulated depreciation account code or directly by accumulated depreciation account/organization/project.
The radio button is available only if you have selected the FA Accum Depr (A/D Accts) checkbox in the Print Reconciliation For group box. In this circumstance, this radio button is selected by default.
Select this radio button to choose records for the accumulated depreciation part of the reconciliation report by accumulated depreciation account code. The actual account/ organization/project data that is associated with the code(s) will also print on the report.
You can also print the code(s) on the report by selecting the Accum Depreciation Account Codes checkbox in the Show group box.
If you select this radio button and save the print parameters for this report, "C" will be inserted into the Select A/D Accts By column in the Query table.
The radio button is available only if you have selected the FA Accum Depr (A/D Accts) checkbox in the Print Reconciliation For group box. In this circumstance, this radio button is unselected by default.
Select this radio button to choose records for the accumulated depreciation part of the reconciliation report by accumulated depreciation account/organization/project.
You can also print the associated accumulated depreciation account code(s) on the report by selecting the Accum Depreciation Account Codes checkbox in the Show group box.
If you select this radio button and save the print parameters for this report, "A" will be inserted into the Select A/D Accts By column in the Query table.
This checkbox is available for use only if you have selected the FA Accum Depr (A/D Accts) checkbox in the Print Reconciliation For group box AND you have selected the Accum Depr Acct/Org/Proj radio button in the Select A/D Accts By group box. In this circumstance, this checkbox is checked by default.
Select this checkbox to print accumulated depreciation account code(s) data associated with the accumulated depreciation acct/org/proj on the report. You can select this option regardless of whether you have chosen to select the accumulated depreciation parameters by accumulated depreciation code or accumulated depreciation account/organization/project.
If you select this checkbox and save the print parameters for this report, "Y" will be inserted into the Show Accum Depr Acct Codes column in the Query table.
The fields in this group box are available only if you have selected the FA Cost (Asset Accts) checkbox in the Print Reconciliation For group box.
Use this group box to select records for the report from one asset ("ownership") account, a range of asset ("ownership") accounts, or all asset ("ownership") accounts. (Account and organization asset "ownership" data is required in each Asset Master record; project "ownership" data is optional.)
The default option for this field is "All." You can accept the displayed default range option, enter a different valid range option, or select one from the drop-down box. Range options are "All, "One," "Range," "From Beginning," and "To End."
If you save the print parameters for this report, the selected range option, as applicable, will be identified in the Query table in the Asset Account Range Option column.
Enter the beginning asset ("ownership") account number in this field or use Lookup to select an account number from the G/L Account table. Because this is a standard Lookup to the ACCT table, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All" or "From Beginning" in the Range field, this field will be inactive.
If you save the print parameters for this report, the selected From value, as applicable, will be identified in the Query table in the From Asset Account column.
Enter the ending asset ("ownership") account number or use Lookup to select an account number from the G/L Account table. Because this is a standard Lookup to the ACCT table, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All," "One," or "To End" in the Range field, this field will be inactive.
If you save the print parameters for this report, the selected To value, as applicable, will be identified in the Query table in the To Asset Account column.
The fields in this group box are available only if you have selected the FA Cost (Asset Accts) checkbox in the Print Reconciliation For group box.
Use the fields in this group box to select records for the report from one asset ("ownership") organization, a range of asset ("ownership") organizations, or all asset ("ownership") organizations. (Account and organization asset "ownership" data is required in each Asset Master record; project "ownership" data is optional.)
The default option for this field is "All." You can accept the displayed default range option, enter a different valid range option, or select one from the drop-down box. Range options are "All, "One, "Range," "From Beginning," and "To End."
If you save the print parameters for this report, the selected range option, as applicable, will be identified in the Query table in the Asset Organization Range Option column.
Enter the beginning ("ownership") organization in this field or use Lookup to select an organization from those displayed. Because this is a standard Lookup to the ORG_ACCT table, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All" or "From Beginning" in the Range field, this field will be inactive.
If you save the print parameters for this report, the selected From value, as applicable, will be identified in the Query table in the From Asset Organization column.
Enter the ending ("ownership") organization in this field or use Lookup to select an organization from those displayed. Because this is a standard Lookup to the ORG_ACCT table, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All," "One," or "To End" in the Range field, this field will be inactive.
If you save the print parameters for this report, the selected To value, as applicable, will be identified in the Query table in the To Asset Organization column.
The fields in this group box are available only if you have selected the FA Cost (Asset Accts) checkbox in the Print Reconciliation For group box.
Use this group box to select records for the report from one asset ("ownership") project, a range of asset ("ownership") projects, or all asset ("ownership") projects, as applicable. (Account and organization asset "ownership" data is required in each Asset Master record; project "ownership" data is optional.)
The default option for this field is "All." You can accept the displayed default range option, enter a different valid range option, or select one from the drop-down box. Range options are "All, "One, "Range," "From Beginning," and "To End."
If you save the print parameters for this report, the selected range option, as applicable, will be identified in the Query table in the Asset Proj Range Option column.
Enter the beginning ("ownership") project in this field, as applicable, or use Lookup to select a project from those displayed. Because this is a standard Lookup to the PROJ table, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All" or "From Beginning" in the Range field, this field will be inactive.
If you save the print parameters for this report, the selected From value, as applicable, will be identified in the Query table in the From Asset Project column.
Enter the ending ("ownership") project in this field, as applicable, or use Lookup to select a project from those displayed. Because this is a standard Lookup to the PROJ table, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All," "One," or "To End" in the Range field, this field will be inactive.
If you save the print parameters for this report, the selected To value, as applicable, will be identified in the Query table in the To Asset Project column.
The fields in this group box are available only if you have selected the FA Accum Depr (A/D Accts) checkbox in the Print Reconciliation For group box.
If you have selected the Accum Depr Acct Code radio button in the Select A/D Accts By group box, select records for the report from one accumulated depreciation account code, a range of accumulated depreciation account codes, or all accumulated depreciation account codes. In this circumstance, the Select Accum Depr Organizations and Select Accum Depr Projects group boxes will not be available.
If you have selected the Accum Depr Acct/Org/Proj radio button in the Select A/D Accts By group box, select records for the report from a range of (including one), or all, accumulated depreciation account accounts, organizations, and/or projects.
The default option for this field is "All." You can accept the displayed default range option, enter a different valid range option, or select one from the drop-down box. Range options are "All, "One," "Range," "From Beginning," and "To End."
If you have selected the Accum Depr Acct Code radio button in the Select A/D Accts By group box and if you save the print parameters for this report, the selected range option, as applicable, will be identified in the Query table in the Accum Depr Acct Code Range Option column.
If you have selected the Accum Depr Acct/Org/Proj radio button in the Select A/D Accts By group box and if you save the print parameters for this report, the selected range option, as applicable, will be identified in the Query table in the AD Account Range Option column.
Enter the beginning accumulated depreciation code or account in this field, as applicable, or use Lookup to select one.
If you selected the Accum Depr Acct Code radio button in the Select A/D Accts By group box, Lookup will access a code from the Accum Depr Acct Codes table. If you selected the Accum Depr Acct/Org/Proj radio button in the Select A/D Accts By group box, Lookup accesses an account number from the G/L Account table.
Because this is a standard Lookup to the ACCT table or to the ACCUM_DEPR_ACCT table, as applicable, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All" or "From Beginning" in the Range field, this field will be inactive.
If you select the Accum Depr Acct Code radio button in the Select A/D Accts By group box and you save the print parameters for this report, the selected From value, as applicable, will be identified in the Query table in the From Accum Depr Acct Code column.
If you select the Accum Depr Acct/Org/Proj radio button in the Select A/D Accts By group box and you save the print parameters for this report, the selected From value, as applicable, will be identified in the Query table in the From AD Account column.
Enter the ending accumulated depreciation code or account in this field, as applicable, or use Lookup to select one.
If you selected the Accum Depr Acct Code radio button in the Select A/D Accts By group box, Lookup accesses a code from the Accum Depr Acct Codes table. If you selected the Accum Depr Acct/Org/Proj radio button in the Select A/D Accts By group box, Lookup accesses an account number from the G/L Account table.
Because this is a standard Lookup to the ACCT table or to the ACCUM_DEPR_ACCT table, as applicable, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.
If you select "All," "One," or "To End" in the Range field, this field will be inactive.
If you select the Accum Depr Acct Code radio button in the Select A/D Accts By group box and you save the print parameters for this report, the selected To value, as applicable, will be identified in the Query table in the To Accum Depr Acct Code column.
If you select the Accum Depr Acct/Org/Proj radio button in the Select A/D Accts By group box and you save the print parameters for this report, the selected To value, as applicable, will be identified in the Query table in the To AD Account column.
The fields in this group box are available for use only if you have selected the FA Accum Depr (A/D Accts) checkbox in the Print Reconciliation For group box AND you have selected the Accum Depr Acct/Org/Proj radio button in the Select A/D Accts By group box. If you have selected the Accum Depr Acct Code radio button in the Select A/D Accts By group box, the fields in this group box are not available for use.
The default option for this field is "All." You can accept the displayed default range option, enter a different valid range option, or select one from the drop-down box. Range options are "All, "One, "Range," "From Beginning," and "To End."
If you select the Accum Depr Acct/Org/Proj radio button in the Select A/D Accts By group box and you save the print parameters for this report, the selected range option, as applicable, will be identified in the Query table in the Accum Depr Org Range Option column.
Enter the beginning accumulated depreciation organization in this field or use Lookup to select one. Because this is a standard Lookup to the ORG_ACCT table, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.
If you selected the Accum Depr Acct/Org/Proj radio button in the Select A/D Accts By group box, Lookup accesses an organization from the G/L Organization table. If you selected the Accum Depr Acct Code radio button in the Select A/D Accts By group box, this field is not available for use.
If you select "All" or "From Beginning" in the Range field, this field will be inactive.
If you select the Accum Depr Acct/Org/Proj radio button in the Select A/D Accts By group box and you save the print parameters for this report, the selected From value, as applicable, will be identified in the Query table in the From Accum Depr Organization column.
Enter the ending accumulated depreciation organization in this field or use Lookup to select one. Because this is a standard Lookup to the ORG_ACCT table, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.
If you selected the Accum Depr Acct/Org/Proj radio button in the Select A/D Accts By group box, Lookup accesses an organization from the G/L Organization table. If you selected the Accum Depr Acct Code radio button in the Select A/D Accts By group box, this field is not available for use.
If you select "All," "One," or "To End" in the Range field, this field will be inactive.
If you select the Accum Depr Acct/Org/Proj radio button in the Select A/D Accts By group box and you save the print parameters for this report, the selected To value, as applicable, will be identified in the Query table in the To Accum Depr Organization column.
The fields in this group box are available for use only if you have selected the FA Accum Depr (A/D Accts) checkbox in the Print Reconciliation For group box AND you have selected the Accum Depr Acct/Org/Proj radio button in the Select A/D Accts By group box. If you have selected the Accum Depr Acct Code radio button in the Select A/D Accts By group box, the fields in this group box are not available for use.
The default option for this field is "All." You can accept the displayed default range option, enter a different valid range option, or select one from the drop-down box. Range options are "All, "One, "Range," "From Beginning," and "To End."
If you select the Accum Depr Acct/Org/Proj radio button in the Select A/D Accts By group box and you save the print parameters for this report, the selected range option, as applicable, will be identified in the Query table in the Accum Depr Project Range Option column.
Enter the beginning accumulated depreciation project in this field, if applicable, or use Lookup to select one. Because this is a standard Lookup to the PROJ table, you may find that you have selected data for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.
If you selected the Accum Depr Acct/Org/Proj radio button in the Select A/D Accts By group box, Lookup accesses a project from the G/L Project table. If you selected the Accum Depr Acct Code radio button in the Select A/D Accts By group box, this field is not available for use.
If you select "All" or "From Beginning" in the Range field, this field will be inactive.
If you select the Accum Depr Acct/Org/Proj radio button in the Select A/D Accts By group box and you save the print parameters for this report, the selected From value, as applicable, will be identified in the Query table in the From Accum Depr Project column.
Enter the ending accumulated depreciation project in this field or use Lookup to select one. Because this is a standard Lookup to the PROJ table, you may find that you have selected data from the Lookup for which asset records do not exist or do not meet your other selection criteria. In this event, the data you expect to retrieve may not be selected.
If you selected the Accum Depr Acct/Org/Proj radio button in the Select A/D Accts By group box, Lookup accesses a project from the G/L Project table. If you selected the Accum Depr Acct Code radio button in the Select A/D Accts By group box, this field is not available for use.
If you select "All," "One," or "To End" in the Range field, this field will be inactive.
If you select the Accum Depr Acct/Org/Proj radio button in the Select A/D Accts By group box and you save the print parameters for this report, the selected To value, as applicable, will be identified in the Query table in the To Accum Depr Project column.
Select this pushbutton to display additional selection parameters for this report.