Assets Acquired and Disposed Report

Overview

The Assets Acquired Report is helpful for budgeting purposes. Use this to keep track of how much you spend on Fixed Assets in a given period (monthly or quarterly,) and compare this to the amount you have budgeted. Use the Assets Acquired and Disposed report to print the acquired and disposed fixed assets for a specified date range. You can include either depreciable or non-depreciable assets in the report. You may elect to print a summary or detail report, and select from various report criteria options.

You can include either depreciable or non-depreciable assets by selecting the appropriate check box in the upper-right area of the report setup window. However, you cannot include both depreciable and non-depreciable assets in a single report.

When you run the report for depreciable assets, the Tier Parameter is determined by the Primary Depreciation Job.

When you run the report for non-depreciable assets, the Tier Parameter is determined by the Job to which the asset is currently assigned.

The Assets Acquired Report is helpful for General Ledger Account reconciliation purposes. For a selected date range, Group By Category the Fixed Assets you want to include. This report then enables you to tie out acquired Fixed Assets to the appropriate Fixed Asset account (Balance Sheet – Asset account) in the General Ledger.

The Assets Disposed Report is helpful for General Ledger Account reconciliation purposes. If you run this report by selecting Group By Category, this report enables you to tie out the appropriate Fixed Assets accounts (Balance Sheet – Asset accounts) and Accumulated Depreciation accounts (Balance Sheet – Asset accounts) in the General Ledger. You may also tie out any gains/losses on the Fixed Assets disposed to the Gain/Loss Disposal of Fixed Assets account (Income Statement – Expense account) in the General Ledger.

The Assets Acquired and Assets Disposed Reports may be helpful reports for your tax accountant to use on a quarterly or year-end basis. You may sort the report by Asset ID # or Description. You may filter the report by assets acquired or disposed, depreciable or non-depreciable, asset ID #'s, Job numbers, or dates.

The Summary report contains the Asset ID #, Description, Type, Serial Number, Cost of the Asset.

The Detail Report contains all items in the summary report plus the Method, Primary Job #, any Job allocation distribution (with percentage), Parent Asset ID (if applicable), date acquired, date effective and expected life. The report also includes the Current Job the Asset is assigned to.

You can filter, group, and print by Tiers, allowing for total customization of the report. To make filtering easier, for any Tier, you can include All, Pick/Create or Exclude parameters. Using Tier Templates to set up and save report templates makes it easy to generate a specific report each time you need it, without having to recreate the criteria. See Using Tier Templates for more information.

Key Functionality

Type a description to name the report. This description prints above the Report Title.

The Default Company Name for Report is populated from the Company Setup screen. The list contains all companies for which you have security permissions to view. If you have permission for only one company, that will be the only one displayed in the list. If you have permissions to multiple companies, the list will display those companies PLUS the default reporting company.

When discernible, WinTeam will print the appropriate company name and logo on each page; otherwise the Default Company Name will print. That is, if a Company level is included in the tiered section and is displayed in the tiered information at the bottom of the page, then that company's Report Name and Logo (if selected) prints on that page.

If there is not a Company identified in the tier area of the page, then the Default Company Name for Reports is used. The default Company Name and Logo is also used for the Total Enterprise report. For more information see Learning about WinTeam Reports.

Use the Report Format option to choose the level of detail for the report.

The Summary report contains the Asset ID #, Description, Type, Serial Number, Cost of the Asset, and the Current Job the asset is assigned to.

The Detail Report contains all items in the summary report plus the Method, Primary Job #, any job allocation distribution (with percentage), Parent Asset ID (if applicable), date acquired, date effective and expected life. This is the default option.

Use the Type of Report option to select the type of report.

Click Acquired to include acquired assets on the report.

Click Disposed to include disposed assets on the report.

Select to include either Depreciable or Non-Depreciable assets in the report.

Depreciable is selected by default.

Use the Sort By option to sort the report data by asset ID or asset description.

Click Number to sort report data by Asset ID. This is the default option.

Click Name to sort report data by Asset Description.

Asset Types

Use the Asset Types category to select the Asset Types to include on the report.

Select All to include all Asset Types.

Select Pick to define specific Asset Types for the report. When you select Pick, the Asset Types list displays. Select the check box next to each Asset Type to include on the report.

Assets

Use the Assets category to select the assets to include on the report.

Select All to include all asset IDs.

Select Range to define a range of asset IDs for the report. When you select Range, the range fields display. Type the beginning asset ID in the From field and the ending asset ID in the To field, or use the Lookup feature to locate the record.

Select Pick to define specific Assets for the report. When you select Pick, the Assets list displays. Select the check box next to each Asset to include on the report.

Select Create to define your own list of Assets. When you select Create, a small grid displays to the right. Enter the Asset ID Numbers you want to include in the list, or use the Lookup to locate the Asset ID Numbers.

Select Exclude to identify records that should not be included. When you select Exclude, a small grid displays to the right. Enter the Asset ID Numbers you want to exclude in the list, or use the Lookup to locate the Asset ID Numbers.

Categories

Use the Categories category to select the Asset Categories to include on the report.

Select All to include all Hours Categories.

Select Pick to define specific Asset Categories for the report. When you select Pick, the Asset Categories list displays. Select the check box next to each Asset Category to include on the report.

Date Acquired

This category is available if the selected Type of Report is Acquired.

Use the Date Acquired category to filter the report criteria by Asset Acquired Dates.

Select All to include all assets regardless of the Asset Acquired Date.

Select Date Range to define a range of Asset Acquired Dates for the report. When you select Date Range, the date range fields display. Type the beginning date in the From field and the ending date in the To field.

Date Disposed

This category is available if the selected Type of Report is Disposed.

Use the Date Disposed category to filter the report criteria by Asset Disposed Dates.

Select All to include all assets regardless of the Asset Disposed Date.

Select Date Range to define a range of Asset Disposed Dates for the report. When you select Date Range, the date range fields display. Type the beginning date in the From field and the ending date in the To field.

Methods

Use the Methods category to select Assets based on Depreciation Methods.

Select All to include all Assets, regardless of the Depreciation Method.

Select Pick to define specific Assets based on Depreciation Methods for the report. when you select Pick, the Depreciation Methods list displays. Select the check box next to each asset Type to include on the report.

Group By

This report can be grouped by Asset ID, Asset Type, Category, Date Acquired, or Method.

The default Group By is Asset ID.

If the Group by Parent ID check box is selected AND the Group By selection is Asset ID, the report will group by Parent ID first, and then group by Asset ID.

Use the Tier Template to define and save customized settings for a report. To use an existing template, select the template from the list and click Load.

To create a new template, you can load an existing template, make the necessary modifications, click Save, and define a new template name in the Save As dialog box. Alternatively, you can start with a blank template by clicking the Clear button.

To modify an existing template, load the template, make the necessary modifications, and then click Save. The name of the existing template display in the Save As dialog box. Click OK.

For more information see Using Tier Templates and Using Tier Parameters.

Select the Group By Parent ID check box to group the selected Fixed Assets by Parent ID on the report.

This check box is NOT selected by default.

If the Group by Parent ID check box is selected AND the Group By selection is Asset ID, the report will group by Parent ID first, and then group by Asset ID.

The Print Company Totals check box is available to users who have only one company, and may be selected to print company totals on the report.

The Print Enterprise Totals check box is available to users who have more than one company, and may be selected to print enterprise totals on the report. This check box is selected by default.

If this is not selected, the report prints only the tiered reports that are marked for printing.

Select the Include Custom Fields check box to include the Custom Fields on the report. Only the Custom Fields that are used will display on the report. You could print all 26 Custom Fields, if used.

This check box is not selected by default.

Select the Include Notes check box to include Notes (from the FA: Master File) in the report.

This check box is NOT selected by default.

Notes do not include the assignment history or repair history notes.

Select this check box to print the company logo on the report. It is selected or cleared by default based on the option selected in SYS:Defaults. However, you can modify the setting on each report.

Select this check box to include a list of the report options selected for the report. The Report Criteria page includes any ranges specified and each Category/Record selection made for the report. This check box is cleared selected by default.

Preview

Click the Preview button (or use the shortcut key, ALT + V) to view the report before printing.

Print

Click the Print button (or press ALT + P) to send the report to your default printer.

Export

Click the Export button (or press ALT + X) to export the report to a specified format. Reports may be exported to Adobe Acrobat (PDF), Excel, Comma-Separated Values (CSV), Grid View and E-mail (available for premise-based clients only).