Banner Finance Fixed Assets Training Workbook

May 2005 Release 7.1

HIGHER EDUCATION

What can we help you achieve?

Confidential Business Information

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------This documentation is proprietary information of SunGard Higher Education and is not to be copied, reproduced, lent or disposed of, nor used for any purpose other than that for which it is specifically provided without the written permission of SunGard Higher Education. Prepared By:

SunGard Higher Education 4 Country View Road Malvern, Pennsylvania 19355 United States of America

© 2006 SunGard. All rights reserved. The unauthorized possession, use, reproduction, distribution, display or disclosure of this material or the information contained herein is prohibited. In preparing and providing this publication, SunGard Higher Education is not rendering legal, accounting, or other similar professional services. SunGard Higher Education makes no claims that an institution's use of this publication or the software for which it is provided will insure compliance with applicable federal or state laws, rules, or regulations. Each organization should seek legal, accounting and other similar professional services from competent providers of the organization’s own choosing. Without limitation, SunGard, the SunGard logo, Banner, Campus Pipeline, Luminis, PowerCAMPUS, Matrix, and Plus are trademarks or registered trademarks of SunGard Data Systems Inc. or its subsidiaries in the U.S. and other countries. Third-party names and marks referenced herein are trademarks or registered trademarks of their respective owners.

Table of Contents

Section A: Introduction ..............................................................................................................1 Overview ..................................................................................................................................1 Process Introduction .................................................................................................................2 Terminology .............................................................................................................................3 Section B: Set Up.........................................................................................................................4 Overview ..................................................................................................................................4 Creating Depreciation Codes....................................................................................................6 Creating Asset Type Codes ......................................................................................................8 Creating Acquisition Codes......................................................................................................9 Creating Asset Condition Codes ............................................................................................10 Creating Asset Title To Codes ...............................................................................................11 Creating Disposal Method Codes...........................................................................................12 Creating User-Defined Codes for Fixed Assets .....................................................................13 Using Commodity Codes to Flag Fixed Assets......................................................................14 Creating Account Codes.........................................................................................................16 Creating Account Codes for Accumulated Depreciation and Depreciation Expense ............17 Creating the Asset Account Codes for Fixed Assets..............................................................20 Creating Capital Expense Account Codes for Fixed Assets ..................................................21 Creating Capital Equity and Gain/Loss Account Codes ........................................................23 Creating a Capitalization (or Plant) Fund Code .....................................................................25 Setting System-Wide Fixed Asset Defaults ...........................................................................28 Overriding System Controls by Fund Type ...........................................................................30 Overriding System Controls by Fund.....................................................................................32 Determining the Minimum Value for Fixed Assets ...............................................................35 Self Check ..............................................................................................................................38 Answer Key for Self Check....................................................................................................39

Table of Contents

Section C: Day-to-Day Operations ..........................................................................................41 Overview ................................................................................................................................41 Creating Invoices....................................................................................................................43 Viewing the Invoice’s Posting Detail.....................................................................................49 Creating Fixed Asset Origination Tags ..................................................................................51 Query Fixed Asset Origination Tags......................................................................................53 Converting Origination Tags to Permanent Tags...................................................................54 Assigning Depreciation Information to a Tag........................................................................55 Creating Primary Tags............................................................................................................58 Deleting Non-capitalized Fixed Assets without Dtags...........................................................62 Removing Erroneous Origination Tags..................................................................................64 Displaying Tags......................................................................................................................67 Creating a Fixed Asset Received as a Gift .............................................................................68 Capitalizing a Gift ..................................................................................................................72 Creating an Asset That Was Expensed to the Wrong Account ..............................................74 Running the Depreciation Process .........................................................................................77 Displaying the Depreciation Posting History.........................................................................79 Disposing or Selling an Inventory Asset (Non-Capitalized Fixed Asset)..............................81 Adjusting Fixed Assets...........................................................................................................83 Handling Write-Offs...............................................................................................................87 Adjusting the Value of Fixed Assets......................................................................................89 Adjusting Accumulated Depreciation ....................................................................................91 Updating Past Depreciation for an Asset Master Record.......................................................93 Reclassifying Asset Account Values......................................................................................95 Transferring Fixed Assets ......................................................................................................97 Assigning a New Permanent Tag to a Fixed Asset ................................................................99 Fixed Assets Reports and Queries........................................................................................101 Summary ..............................................................................................................................102 Self Check ............................................................................................................................103 Answer Key for Self Check..................................................................................................105 Section D: Reference...............................................................................................................108 Overview ..............................................................................................................................108 Setup Forms and Where Used ..............................................................................................109 Day-to-Day Forms and Setup Needed..................................................................................110 Forms Job Aid ......................................................................................................................111

Section A: Introduction Lesson:

Overview

Workbook goal The goal of this workbook is to provide you with the knowledge and practice to maintain Fixed Assets data at your institution. The workbook is divided into four sections: • • • •

Introduction Set-up Day-to-day operations Reference

Intended audience Fixed Assets staff. Section contents Overview ..................................................................................................................................1 Process Introduction .................................................................................................................2 Terminology .............................................................................................................................3

_____________________________________________________________________________________________ ©SunGard 2004-2005 Fixed Assets Page 1

Section A: Introduction Lesson:

Process Introduction

Introduction The Banner Fixed Assets module is designed to allow the tracking and depreciation of Universities’ fixed or movable assets. Through the completion of an invoice, the system will temporarily tag the asset and automatically capitalize the tagged item when it has reached or exceeded the minimum capitalization amount. Personnel can then record the asset with a permanent tag; locate it, and process depreciation against it. Flow diagram This diagram highlights the processes used to manage fixed assets.

What happens The stages of the process are described in this table. Stage Description Inventory Clerk

1 2 3 4

Receives new asset records Updates new asset records Updates assets that are transferred, sold, lost, or disposed Performs inventory and reports assets list to Finance for audit purposes

_____________________________________________________________________________________________ ©SunGard 2004-2005 Fixed Assets Page 2

Section A: Introduction Lesson:

Terminology

Attachment An origination tag record can be designated as an attachment to indicate an integral relationship between the parent and subordinate asset. Component Associate one Permanent tag record to another by appointing the subordinate record as a Component of the primary record. Extract A process that moves temporary fixed asset tags from the Otag table (FFBOTAG) into the asset table (FFBMAST). Otag This is the temporary tag or origination tag that Banner will assign to an item when an invoice is paid to a fixed asset expense account. Ptag This is the permanent tag that asset management personnel will assign to a temporary tag. Dtag This is a document tag that can be created when journal entries, stores issues, or a cash receipt are entered against the fixed asset or capital expense accounts. Dtags are converted into Otags.

_____________________________________________________________________________________________ ©SunGard 2004-2005 Fixed Assets Page 3

Section B: Set Up Lesson:

Overview

Introduction This section provides the knowledge and practice to set up various special-purpose account and fund codes and designations for the processing of your fixed asset automatic capitalization. The steps include creating • • • • • • •

Accumulated depreciation account Depreciation expense account Fixed assets account Capital expenses account Capital equity account Gain/loss account Capitalization fund.

Intended audience Fixed Assets Staff Objectives At the end of this section, you will be able to • • • • • • •

Set up depreciation methods Set up validation forms about information on fixed assets Set up commodity codes flagged as fixed asset items Set up account codes for fixed assets Set up fixed asset fund codes Set up system-wide fixed asset defaults Determine the minimum value for fixed assets.

Prerequisites To complete this workbook, you should have • •

Completed the Education Practices computer-based training (CBT) tutorial “Banner 7 Fundamentals,” or have equivalent experience navigating in the Banner system Completed the Chart of Accounts, and Accounts Payable training workbooks.

©SunGard 2004-2005

Fixed Assets

4

Section B: Set Up Lesson:

Overview (Continued)

Section contents Overview ..................................................................................................................................4 Creating Depreciation Codes....................................................................................................6 Creating Asset Type Codes ......................................................................................................8 Creating Acquisition Codes......................................................................................................9 Creating Asset Condition Codes ............................................................................................10 Creating Asset Title To Codes ...............................................................................................11 Creating Disposal Method Codes...........................................................................................12 Creating User-Defined Codes for Fixed Assets .....................................................................13 Using Commodity Codes to Flag Fixed Assets......................................................................14 Creating Account Codes.........................................................................................................16 Creating Account Codes for Accumulated Depreciation and Depreciation Expense ............17 Creating the Asset Account Codes for Fixed Assets..............................................................20 Creating Capital Expense Account Codes for Fixed Assets ..................................................21 Creating Capital Equity and Gain/Loss Account Codes ........................................................23 Creating a Capitalization (or Plant) Fund Code .....................................................................25 Setting System-Wide Fixed Asset Defaults ...........................................................................28 Overriding System Controls by Fund Type ...........................................................................30 Overriding System Controls by Fund.....................................................................................32 Determining the Minimum Value for Fixed Assets ...............................................................35 Self Check ..............................................................................................................................38 Answer Key for Self Check....................................................................................................39

©SunGard 2004-2005

Fixed Assets

5

Section B: Set Up Lesson:

Creating Depreciation Codes

Depreciation methods Before you begin depreciating commodities, you need to determine various “useful life” depreciation methods; that is, depreciation methods that you will use over the “useful life” of the item. In Banner, combine a yearly depreciation method (e.g., Straight Line) with a first year option (e.g., Proportional) to create a “useful life” depreciation method. In Banner, there are 15 valid combinations. Banner form Use the Fixed Asset Depreciation Code Maintenance Form (FTMDEPR) to define these values. Note: The instructor should assign the combinations to the learners to ensure duplicates are not created. Remember, you cannot combine Sum of the Years Digits (Internal Depreciation Code) with Proportional (First Year Option).

©SunGard 2004-2005

Fixed Assets

6

Section B: Set Up Lesson:

Creating Depreciation Codes (Continued)

Procedure Follow these steps to complete the process. Step Action 1 Access the Fixed Asset Depreciation Code Maintenance Form (FTMDEPR). 2 Enter a depreciation method code in the Depreciation Method Code field. 3 Assign a name to the depreciation method in the Title field. SunGard Higher Education suggests that the title should combine the name of the internal depreciation code and first year option.

4 5 6 7 8

Note: Banner combines the values you select in the Internal Depreciation Code and First Year Option fields to create a “useful life” depreciation method. Enter an effective date in the Effective Date field. Select a yearly method of depreciating an item in the Internal Depreciation Code field. Select a value in the First Year Option field to specify how Banner should depreciate the item during its first fiscal year. Click the Save icon. Click the Exit icon.

©SunGard 2004-2005

Fixed Assets

7

Section B: Set Up Lesson:

Creating Asset Type Codes

Fixed asset type codes A fixed asset type code is required on all permanent tags for depreciation processing. Examples of some asset types might be: Computer Equipment, Art and Collectables, Vehicles, and Software. Banner form Asset type codes are created on the Fixed Asset Type Code Maintenance Form (FTMASTY).

Procedure Follow the process below to create Asset Type codes. Step Action 1 Access the Fixed Asset Type Code Maintenance Form (FTMASTY). 2 Perform a Record Insert Function. 3 Perform a Record Duplicate Function. 4 Enter a two-character code for the asset type in the Code field. 5 Tab to the Description field and type the description of the code. 6 Enter an effective date in the Effective Date field (it should be a previous date). 7 Tab to the Depreciation Method Code field and key in the method you just created or double click in the field and pick from the Depreciation Code list on FTVDEPR. 8 Enter a number in the Useful Life field. 9 Click the Save icon. 10 Click the Exit icon. ©SunGard 2004-2005

Fixed Assets

8

Section B: Set Up Lesson:

Creating Acquisition Codes

Fixed Asset Acquisition codes A fixed asset acquisition code is an optional code used on the permanent tag to state how an organization obtained the asset. Examples would be purchased, gift, constructed, and donated. Banner form These codes can be created on the Fixed Asset Acquisition Code Maintenance Form (FFVACQM).

Procedure Follow the process below to create Acquisition codes. Step Action 1 Access the Fixed Asset Acquisition Code Maintenance Form (FFVACQM). 2 Enter a two-character code for the acquisition code in the Code field. 3 Tab to the Description field and type the description of the code. 4 Click the Save icon.

5

Note: The Activity Date will display the date this code was created. Click the Exit icon.

©SunGard 2004-2005

Fixed Assets

9

Section B: Set Up Lesson:

Creating Asset Condition Codes

Fixed Asset Condition codes A fixed asset condition code is used as an option code for stating the condition of the item when an organization obtains it. Examples of condition codes are New, Used, Slightly damaged, and in need of repair. Banner form The condition codes are created on the Fixed Asset Condition Code Maintenance Form (FFVACON).

Procedure Follow the process below to create condition codes. Step Action 1 Access the Fixed Asset Condition Code Maintenance Form (FFVACON). 2 Enter a two-character code for the condition code in the Code field. 3 Tab to the Description field and type the description of the code. 4 Click the Save icon.

5

Note: The Activity Date will display the date this code was created. Click the Exit icon.

©SunGard 2004-2005

Fixed Assets

10

Section B: Set Up Lesson:

Creating Asset Title To Codes

Fixed asset type codes A fixed asset title to code is an optional code that states whom has title to an item when an organization obtains it. Examples are Institution, Bank, and State Government. Banner form The title to codes can be created on the Fixed Asset Title To Code Maintenance Form (FFVTTST).

Procedure Follow the process below to create Title To codes. Step Action 1 Access the Fixed Asset Title To Code Maintenance Form (FFVTTST). 2 Enter a two-character code in the Title-to Code field. 3 Tab to the Description field and type the description of the code. 4 Click the Save icon.

5

Note: The Activity Date will display the date this code was created. Click the Exit icon.

©SunGard 2004-2005

Fixed Assets

11

Section B: Set Up Lesson:

Creating Disposal Method Codes

Fixed asset type codes A disposal method code is required on all permanent tags when a tag is going to be sold, written off, or donated. Disposal method examples might be Lost, Donated, Discarded, Sold, and Destroyed. Banner form Disposal method codes are created on the Fixed Asset Disposal Method Code Maintenance Form (FFVDISP).

Procedure Follow the process below to create Disposal Method codes. Step Action 1 Access the Fixed Asset Disposal Method Code Maintenance Form (FFVDISP). 2 3 4

Enter a two-character code in the Disposal Code field. Tab to the Description field and type the description of the code. Click the Save icon.

5

Note: The Activity Date will display the date this code was created. Click the Exit icon.

©SunGard 2004-2005

Fixed Assets

12

Section B: Set Up Lesson:

Creating User-Defined Codes for Fixed Assets

Banner form The Fixed Asset User Defined System Codes Validation Form (FFVSDAT) enables you to create user-defined codes, assign values to them, and organize them into groups.

Banner form The process below demonstrates how to establish unique, user-defined codes within the Fixed Assets module. Step Action 1 Access the Fixed Asset User Defined System Codes Validation Form (FFVSDAT). 2 Enter CATEGORY in the Literal field. 3 Enter LG in the Value field. 4 Enter Legacy in the Title field. 5 Enter Legacy in the Short Title field. 6 Click the Save icon. 7 Click the Exit icon.

©SunGard 2004-2005

Fixed Assets

13

Section B: Set Up Lesson:

Using Commodity Codes to Flag Fixed Assets

Commodity maintenance It is possible to use Banner’s commodity codes to flag fixed asset purchases for tagging, rather than using capital expenditure account codes. The major difference in using commodity codes is that commodity codes never initiate the automatic capitalization process. So, commodity codes can be used in cases where the tagging of the asset is wanted, but where no capitalization entry is desired. Note: Using commodity codes for flagging fixed assets does not mean that you can no longer use capital expenditure accounts for this flagging as well. You can use commodity codes for some types of purchase and account codes for others. Banner form Commodity codes are created/updated in the Commodity Maintenance Form (FTMCOMM).

©SunGard 2004-2005

Fixed Assets

14

Section B: Set Up Lesson:

Using Commodity Codes to Flag Fixed Assets (Continued)

Procedure Follow these steps to complete the process. Step Action 1 Access the Commodity Maintenance Form (FTMCOMM). 2 Enter NEXT in the Commodity Code field. Banner will assign the next sequential number.

3 4 5 6 7 8 9 10 11 12 13 14

Note: Normally you would enter an existing commodity code, and then identify it as a fixed asset. Perform a Next Block function. Enter the description in the Commodity Description field. Select a code in the Unit of Measure Code field. Select a code in the Predecessor Commodity field. Select a code in the Tax Group field. Check the Fixed Asset check box to designate this commodity as a fixed asset. Enter the effective date for this commodity in the Start Date field. Enter 5 in the Useful Life field. The numbers placed in this field indicate the number of years. Perform a Next Block function to move to the Commodity Account area. Specify the chart and/or expense accounts for this commodity. Click the Save icon. Click the Exit icon.

©SunGard 2004-2005

Fixed Assets

15

Section B: Set Up Lesson:

Creating Account Codes

Categories of account codes The information that follows reviews the categories of account codes. Accumulated depreciation and depreciation expense Accumulated Depreciation (internal account type must be 10 asset and class F) and Depreciation Expense (internal account type can be either 40 fund balance, 60 labor, 70 expense, 90 fund addition, 95 fund deduction) are used on assets that are capitalized and are being depreciated. Fixed asset Fixed Asset (internal account type must be 10 asset and class F) accounts will be linked to your capital expense accounts, and will be used by the automatic capitalization process for the debit side of the entry. (The credit side will be capital equity). Capital expense Capital Expense (internal account type can be either 60 labor or 70 expense) refers to the expenditure account codes which, when used on an invoice or a journal voucher with D-tags turned on, will automatically initiate the tagging process and, where the minimum asset amount is met on an invoice, the capitalization process. Capital equity and Gain/Loss Account(s) The Capital Equity fund (internal account type can be either 40 fund balance, 90 fund addition or 95 fund deduction) is used on the credit side of the capitalization entries. The Gain/Loss account(s) (internal account type can be either 40 fund balance, 50 revenue, 60 labor, 70 expense, 90 fund addition, or 95 fund deduction) is used for the posting of revenue/expense associated with the disposal of assets.

©SunGard 2004-2005

Fixed Assets

16

Section B: Set Up Lesson:

Creating Account Codes for Accumulated Depreciation and Depreciation Expense

Overview This topic covers creating the account codes for Accumulated Depreciation (internal account type must be 10 asset and class F) and Depreciation Expense (internal account type can be either 40 fund balance, 60 labor, 70 expense, 90 fund addition, or 95 fund deduction). Banner form Creating the account codes is accomplished by using the Account Code Maintenance Form (FTMACCT).

©SunGard 2004-2005

Fixed Assets

17

Section B: Set Up Lesson:

Creating Account Codes for Accumulated Depreciation and Depreciation Expense (Continued)

Procedure 1 Follow the process below to use the Account Code Maintenance Form (FTMACCT) to create an accumulated depreciation account code. Note: You will be linking your accumulated depreciation account to your asset accounts after setting up your fixed asset account codes and creating the asset accounts. Consequently, you may have as many accumulated depreciation accounts as you have asset accounts, if you wish. Step Action 1 Access the Account Code Maintenance Form (FTMACCT). 2 Enter B (or the COA code for your institution) in the Chart of Accounts field. 3 Enter 1951 in the Account field (or create a unique account code). If creating your own, record your account code _______________. 4 Enter Accum Deprec-Capital Equipment in the Account Title field. 5 Enter an effective date in the Effective Date field (it should be a previous date). 6 Enter 17 (or the account type code that designates the fixed asset accounts in your chart) in the Account Type field. 7 Enter F in the Account Class field.

8 9 10

Note: The accumulated depreciation account codes must have an account class of F the account code for fixed assets. Enter C in the Normal Balance field to define this account with a credit balance. Click the Save icon. Click the Exit icon.

©SunGard 2004-2005

Fixed Assets

18

Section B: Set Up Lesson:

Creating Account Codes for Accumulated Depreciation and Depreciation Expense (Continued)

Procedure 2 Follow the process below to define the depreciation expense account code. Step Action 1 Access the Account Code Maintenance Form (FTMACCT). 2 Enter B (or the COA code for your institution) in the Chart of Accounts field. 3 Enter 7951 in the Account field (or create a unique account code). If creating your own, record your account code _______________. 4 Enter Deprec Exp-Capital Equipment in the Account Title field. 5 Enter an effective date in the Effective Date field (it should be a previous date). 6 Enter 71 (or the account type code that designates direct expense for your institution) in the Account Type field to define this as a depreciation expense account code. 7 Enter D in the Normal Balance field to define this account with a debit account. 8 Click the Save icon. 9 Click the Exit icon.

©SunGard 2004-2005

Fixed Assets

19

Section B: Set Up Lesson:

Creating the Asset Account Codes for Fixed Assets

Overview The asset accounts are those that will be used for automatic capitalization entries, for posting the (normal) debit side of the capital entry. Each asset account code must be linked to an accumulated depreciation account code and to a depreciation expense account code. The asset account codes, like any other account codes, are established in the Account Code Maintenance Form (FTMACCT). You can have as many asset account codes as you wish (for example, land, buildings, equipment, etc.). You will be creating capital expenditure account codes in a later exercise. For each of these capital expenditure codes, you will be designating which asset account you wish to have the system use for capitalization. Asset accounts must be linked to an internal account type of 10 for assets. The class field for asset accounts must be set to F. Procedure Follow these steps to complete the process. Step Action 1 Access the Account Code Maintenance Form (FTMACCT). 2 Enter B (or the COA code for your institution) in the Chart of Accounts field. 3 Enter 1950 in the Account field (or create a unique account code). If creating your own, record your account code: _______________. 4 Enter Fixed Asset-Capital Equipment in the Account Title field. 5 Enter an effective date in the Effective Date field (it should be a previous date). 6 Enter 17 (or the account type that designates fixed assets for your institution) in the Account Type field. 7 Enter F in the Account Class field.

8 9 10 11 12

Note: The asset account codes must have an account class of F. Enter 1951 (or the unique account code you created in the previous exercise) in the Accumulated Depreciation field. Enter 7951 (or the account code you created in the previous exercise) in the Depreciation Expense field. Enter D in the Normal Balance field to define this account with a debit account. Click the Save icon. Click the Exit icon.

©SunGard 2004-2005

Fixed Assets

20

Section B: Set Up Lesson:

Creating Capital Expense Account Codes for Fixed Assets

Overview The capital expenditure account codes are the “flags” for fixed assets. The use of one of these account codes on an invoice will automatically cause • •

The creation of an origination tag for each unit purchased by the invoice The posting of a capital entry if the item meets or exceeds the minimum capitalization amount in the System Control Maintenance Form (FOASYSC).

Capital expenditure account codes are identified as such by the entry of an asset account code in the Asset field of the Account Code Maintenance Form (FTMACCT) record. Capital expenditure accounts can have internal account types of 60 Labor or 70 Direct Expense. They will NOT have any Account Class designation. Note: The alternative to flagging your fixed assets using account codes is to use the commodity codes defined in the Commodity Maintenance Form (FTMCOMM). Assets that are flagged using commodity codes will not automatically capitalize; only capital expenditure account codes will initiate the automatic capitalization process.

©SunGard 2004-2005

Fixed Assets

21

Section B: Set Up Lesson:

Creating Capital Expense Account Codes for Fixed Assets (Continued)

Procedure Follow the procedure below to create capital expense account codes for your fixed assets. Step Action 1 Access the Account Code Maintenance Form (FTMACCT). 2 Enter B (or the COA code for your institution) in the Chart of Accounts field. 3 Enter 7952 in the Account field (or create a unique account code). If creating your own, record your account code _______________. 4 Enter Cap Expense-Capital Equipment in the Account Title field. 5 Enter an effective date in the Effective Date field (it should be a previous date). 6 Enter 71 in the Account Type field to define this as a capital expenditure account code. 7 Enter 1950 (or the unique fixed asset account code you just created) in the Asset Account field. 8 Enter D in the Normal Balance field to define this account with a debit account. 9 Click the Save icon. 10 Click the Exit icon.

©SunGard 2004-2005

Fixed Assets

22

Section B: Set Up Lesson:

Creating Capital Equity and Gain/Loss Account Codes

Categories of account codes There are two more categories of account codes you will need to create for fixed asset processing. These are: • •

A capital equity account used for the credit side of your automatic capitalization entries. The capital equity account can be an internal account type of 40 fund balance, 90 fund addition or 95 fund deduction. The gain/loss account(s), used for posting gains or losses incurred by the disposal of fixed assets. This account can be an internal account type of 40 fund balance, 50 revenue, 60 labor, 70 direct expense, 90 fund addition or 95 fund deduction.

Note: An institution can have the same gain and loss accounts. In this exercise, they are different for easier identification. Procedure 1 Follow the process below to create a capital equity account. Step Action 1 Access the Account Code Maintenance Form (FTMACCT). 2 Enter B (or the COA code for your institution) in the Chart of Accounts field. 3 Enter 4100 in the Account field (or create a unique account code). If creating your own, record your account code: _______________. 4 Enter Investment in Fixed Assets in the Account Title field. 5 Enter an effective date in the Effective Date field (it should be a previous date). 6 Enter 41 (or an account type code that will designate this as a fund balance account for your institution) in the Account Type field. 7 Enter C in the Normal Balance field to define this account with a credit balance. 8 Click the Save icon. 9 Click the Exit icon.

©SunGard 2004-2005

Fixed Assets

23

Section B: Set Up Lesson:

Creating Capital Equity and Gain/Loss Account Codes (Continued)

Procedure 2 Follow the process below to create a gain on a disposal/sale account. Step Action 1 Access the Account Code Maintenance Form (FTMACCT). 2 Enter B (or the COA code for your institution) in the Chart of Accounts field. 3 Enter 5888 in the Account field (or create a unique account code). If creating your own, record your account code: _______________. 4 Enter Gain on Sale of F/A in the Account Title field. 5 Enter an effective date in the Effective Date field (it should be a previous date). 6 Enter 59 in the Account Type field to define this as a gain on disposal/sale account code. 7 Enter C in the Normal Balance field to define this account with a credit balance. 8 Click the Save icon. 9 Click the Exit icon. Procedure 3 Follow the process below to create a loss on a disposal/sale account. Step Action 1 Access the Account Code Maintenance Form (FTMACCT). 2 Enter B (or the COA code for your institution) in the Chart of Accounts field. 3 Enter 7888 in the Account field (or create a unique account code). If creating your own, record your account code:_______________. 4 Enter Loss on Disp of F/A in the Account Title field. 5 Enter an effective date in the Effective Date field (it should be a previous date). 6 Enter 71 (or an account type code that designates direct expense for your institution) in the Account Type field. 7 Enter D in the Normal Balance field to define this account with a debit account. 8 Click the Save icon. 9 Click the Exit icon.

©SunGard 2004-2005

Fixed Assets

24

Section B: Set Up Lesson:

Creating a Capitalization (or Plant) Fund Code

Capitalization code The capitalization (or plant) fund code is the code Banner uses for posting automatic capitalization entries. The internal fund type for this fund must be 96 Investment in Plant. You may have several such capitalization funds if you choose. The system will determine which capitalization fund to use for a given purchase based on the criteria you set up for the fund that is expensed for that purchase. Banner form The fund code for Capitalization is created on the Fund Code Maintenance Form (FTMFUND).

©SunGard 2004-2005

Fixed Assets

25

Section B: Set Up Lesson:

Creating a Capitalization (or Plant) Fund Code (Continued)

Procedure Follow the process below to create a capitalization fund code. Step 1 2 3 4 5 6 7

Action Access the Fund Code Maintenance Form (FTMFUND). Enter B (or the COA code for your institution) in the Chart of Accounts field. Enter 9601 in the Fund field (or create a unique account code). If creating your own, record your account code: _______________. Enter Investment in Plant Fund in the Title field. Enter an effective date in the Effective Date field (it should be a previous date). Enter 96 (or a fund type code that designates investment in plant for your institution) in the Fund Type field. Select Cap Different or No Cap from the drop-down list in the Capitalization Fund Indicator field.

©SunGard 2004-2005

Fixed Assets

26

Section B: Set Up Lesson:

Creating a Capitalization (or Plant) Fund Code (Continued)

Procedure, continued Step 8

9 10 11 12

Action Enter 11005 (or a valid organization code for your institution) in the Organization field. Note: The Organization field identifies the codes that Banner will use for making depreciation, gain, or loss postings. Enter 10 (or a valid Program code for your institution) in the Program field. Click the Save icon. Repeat steps 2-10 and create capitalization fund 9602. Click the Exit icon.

©SunGard 2004-2005

Fixed Assets

27

Section B: Set Up Lesson:

Setting System-Wide Fixed Asset Defaults

Fixed assets system control form You can set up system-wide defaults for the system to use. This is accomplished in the Fixed Assets System Control Form (FFASYSC). These settings will be applied in any case where a capital expenditure is made from a fund that does not have fixed asset overrides established, in Fund Type Maintenance (FTMFTYP) or in the Fund Code Maintenance Form (FTMFUND).

©SunGard 2004-2005

Fixed Assets

28

Section B: Set Up Lesson:

Setting System-Wide Fixed Asset Defaults (Continued)

Procedure Follow these steps to complete the process. Warning: Only one participant may update this form. Step Action 1 Access the Fixed Asset System Control Maintenance Form (FFASYSC). 2 Enter B (or the COA code for your institution) in the Chart of Accounts field. 3 Enter an effective date in the Effective Date field (it should be a previous date). 4 Enter 9601 or (your unique capitalization or plant fund code) in the Capitalization Fund field. 5 Enter 4100 (or your unique equity account code) in the Capitalization Equity Account field. 6 Enter 5888 (or the unique gain account code you created in an earlier exercise) in the Gain Account field. 7 Enter 7888 (or the unique loss account code you created in an earlier exercise) in the Loss Account field. 8 Select Depreciation & Post from the drop-down list in the Depreciation/Posting Indicator field. 9 Select Depreciation Expense Account from the Expense/Equity Account Default Indicator field. 10 Enter 11005 in the Organization field.

11 12 13

Note: If your depreciation expense, gain and loss accounts were created to be fund additions and fund deductions, then you will still need to complete the defaults for the organization and program. Several adjustment entries in fixed asset require the codes to be filled in. Enter 10 in the Program field. Click the Save icon. Click the Exit icon.

©SunGard 2004-2005

Fixed Assets

29

Section B: Set Up Lesson:

Overriding System Controls by Fund Type

Fund Type Maintenance You can override the set up on the Fixed Assets System Control Form (FFASYSC), through the Fund Type Maintenance (FTMFTYP). The override allows for different capital funds, equity, gain and loss accounts and turn off posting of depreciation by fund type, if necessary. Note: If you do not set up these specifications at the fund type level, the system will use the defaults you set up in your Fixed Assets System Control Form (FFASYSC). Most universities do not need to override FFASYSC.

©SunGard 2004-2005

Fixed Assets

30

Section B: Set Up Lesson:

Overriding System Controls by Fund Type (Continued)

Procedure Follow these steps to complete the process. Warning: Only one participant may update this form. Step Action 1 Access Fund Type Maintenance (FTMFTYP).

2 3 4 5 6 7 8 9 10 11 12

13 14 15 16 17 18 19

Note: The FTMFTYP form is a maintenance form. In this exercise, you will retrieve an existing record rather than create a new one. Perform a query. Enter B (or the COA code for your institution) in the Chart of Accounts field. Enter 21 in the Fund Type field. Execute your query. Perform a Record Insert function. Perform a Duplicate Record function. Enter the current date in the Effective Date field. Enter 9602 (or the unique fund code you created in a previous lesson) in the Capitalization Fund field. Enter 4100 (or the unique equity account code you created in a previous lesson) in the Capitalization Equity Account field. Select Fixed Asset Information from the Options menu. Select No Depreciation from the drop-down list in the Depreciation/Posting Indicator field. Note: We are saying any fund in fund type 21 does not depreciate. Select None from the Expense/Equity Account Default Indicator field. Enter 5888 (or the unique gain account code you created in an earlier exercise) in the Gain Account field. Enter 7888 (or the unique loss account code you created in an earlier exercise) in the Loss Account field. Enter 11005 in the Organization field. Enter 10 in the Program field. Click the Save icon. Click the Exit icon.

©SunGard 2004-2005

Fixed Assets

31

Section B: Set Up Lesson:

Overriding System Controls by Fund

Fund codes for capital expenditures In this lesson we will set up a fund code to specify a different capitalization fund to be used for capital expenditures. This specification is made using the Fund Code Maintenance Form (FTMFUND). The source fund code is used on the invoices. These are the funds where the capital expense will be recorded, and will include your unrestricted fund(s) and any other funds from which capital expenditures may be made. Note: If you do not set up these specifications at the fund level, the system will use the defaults you set up in your Fixed Assets System Control Form (FFASYSC). Most universities do not need to override FFASYSC.

©SunGard 2004-2005

Fixed Assets

32

Section B: Set Up Lesson:

Overriding System Controls by Fund (Continued)

Procedure 1 Follow the process below to create a source fund code when the capitalization fund codes are different from FFASYSC. Step Action 1 Access the Fund Code Maintenance Form (FTMFUND).

2 3 4

5

6 7 8 9 10 11 12 13

Note: The FTMFUND form is a maintenance form. In this exercise, you will retrieve an existing record rather than create a new one. Perform a query. Enter B (or the COA code for your institution) in the Chart of Accounts field. Enter 1120 (or the fund code that designates the unrestricted fund for your institution) in the Fund field. Warning: Only one participant will be able to make changes to this record. Other participants can choose other existing fund numbers. Execute your query. Note: The system displays the title and additional information for your selected fund. Perform a Record Insert function. Perform a Duplicate Record function. Enter the current date in the Effective Date field. Select Cap Different or No Cap from the drop-down list in the Capitalization Fund Indicator field. Enter 4100 (or the unique equity account code you created in a previous lesson) in the Capitalization Equity Account field. Enter 9602 (or the unique fund code you created in a previous lesson) in the Capitalization Fund field. Click the Save icon. Click the Exit icon.

©SunGard 2004-2005

Fixed Assets

33

Section B: Set Up Lesson:

Overriding System Controls by Fund (Continued)

Procedure 2 Follow the process below to create a source fund code where the source fund and capitalization code are the same. Step Action 1 Access the Fund Code Maintenance Form (FTMFUND). 2 Enter B (or the COA code for your institution) in the Chart of Accounts field. 3 Enter 1115 in the Fund field. 4 Enter Current Unrestricted Fund in the Title field. 5 Enter an effective date in the Effective Date field (it should be a previous date). 6 Enter 11 in the Fund Type field. 7 Enter AL in the Bank field. 8 Select Cap Fund same as Source fund in the Capitalization Fund Indicator field.

9 10 11 12 13

14 15 16 17 18 19 20

Note: By doing this, Fund 1115 is now its own capitalization fund. You may do this to override what the capitalization fund is on FFASYSC. Select None in the Multiple Fund Balance Indicator field. Enter 4100 or your unique equity account code you created in an earlier exercise in the Capitalization Equity Account field. The system automatically enters the capitalization (or plant) fund code in the Capitalization Fund field. Select Fixed Asset Information from the Options menu. Select No Depreciation from the drop-down list in the Depreciation/Posting Indicator field. Note: Fund 1115 and your fund code is a “source” or “input” fund, which does not have a fixed asset associated with it, so there is no depreciation. Select None from the Expense/Equity Account Default Indicator field. Enter 5888 (or the unique gain account code you created in an earlier exercise) in the Gain Account field. Enter 7888 (or the unique loss account code you created in an earlier exercise) in the Loss Account field. Enter 11005 in the Organization field. Enter 10 in the Program field. Click the Save icon. Click the Exit icon.

©SunGard 2004-2005

Fixed Assets

34

Section B: Set Up Lesson:

Determining the Minimum Value for Fixed Assets

Implementing the fixed assets module The Finance System Control Maintenance Form (FOASYSC) determines the minimum value for automatic capitalization of a fixed asset and when Banner should create an origination tag, or a document tag. The fields that govern the system-wide operation of the Fixed Assets module are the Min Asset Cap Amount, Fixed Asset Feed Code, and DTAG Feed From fields. The Min Asset Cap Amount is the minimum monetary value for which Banner will automatically create capitalization entries for items purchased using a fixed asset account code. The Fixed Asset Feed Code is used to indicate when you want Banner to assign an origination tag. The choices from the pull-down list are: Invoice – Banner creates an origination tag when it posts invoiced documents. Receiving & Invoice – Banner creates an origination tag when a fixed asset item is received (though it will still not be possible to permanently tag the item until it is invoiced, as well). The DTAG Feed From is used to indicate is document tag will be issued when a journal voucher, stores issue or direct cash receipt are recorded against a capital expense account. Note: The fixed asset tagging and the automatic capitalization are two separate processes. Every item purchased using a fixed asset account code will tag. Only items exceeding your Min Asset Cap Amount will be automatically capitalized.

©SunGard 2004-2005

Fixed Assets

35

Section B: Set Up Lesson:

Determining the Minimum Value for Fixed Assets (Continued)

Banner form Finance System Control Maintenance Form (FOASYSC)

Procedure Follow the process below to set up where a document tag is created and determine the minimum value for fixed assets. Note: For this exercise, the instructor will update this form. Step Action 1 Access the System Control Maintenance Form (FOASYSC).

2 3 4 5 6 7 8

Note: The FOASYSC form is a maintenance form, and you are only permitted to change this record as of the current date. Perform an Insert Record function. Perform a Duplicate Record function. Enter the current date in the Effective field. Select Fixed Asset Information from the Option menu. Enter 1000 in the Minimum Asset Capitalization Amount field. Select Invoice from the drop-down list in the Fixed Asset Feed Code field. Check the Journal Voucher check box in the DTAG FEED from section.

©SunGard 2004-2005

Fixed Assets

36

Section C: Day-to-Day Operations Lesson:

Determining the Minimum Value for Fixed Assets (Continued)

Procedure, continued Step 9 10

Action Click the Save icon. Click the Exit icon. Note: Changes to FOASYSC will not take effect until you have logged off Banner and logged back in again.

©SunGard 2004-2005

Fixed Assets

37

Section B: Set Up Lesson:

Self Check

Directions Use the information you have learned in this workbook to complete this self check activity. Question 1 What form enables you to create user-defined codes, assign values to them, and organize them into groups? Question 2 When setting up accumulated depreciation account codes, what account class should they be? Question 3 What Banner form do you use to link account codes to a single asset account? Question 4 What form do you use to create a capital expenditure account? Question 5 Is it necessary to have different Gain and Loss Accounts? Question 6 What Banner form is used to create a source fund code? Question 7 Automatic capitalization postings are only generated when you use capital expenditure account codes. True or False Question 8 What form is used to define depreciation codes?

©SunGard 2004-2005

Fixed Assets

38

Section B: Set Up Lesson:

Answer Key for Self Check

Question 1 What form enables you to create user-defined codes, assign values to them, and organize them into groups? The Fixed Asset User Defined System Codes Validation Form (FFVSDAT) Question 2 When setting up accumulated depreciation account codes, what account class should they be? The account class must be an F for the accumulated depreciation. Question 3 What Banner form do you use to link account codes to a single asset account? Account Code Maintenance Form (FTMACCT) Question 4 What form do you use to create a capital expenditure account? The Account Code Maintenance Form (FTMACCT) Question 5 Is it necessary to have different Gain and Loss Accounts? No. An organization may have the same account for Gain and Losses. Question 6 What Banner form is used to create a source fund code? The Fund Code Maintenance Form (FTMFUND) Question 7 Automatic capitalization postings are only generated when you use capital expenditure account codes. True. A commodity code can flag a fixed asset, but no capitalization posting will occur unless a capital expenditure account code is also used. ©SunGard 2004-2005

Fixed Assets

39

Section B: Set Up Lesson:

Answer Key for Self Check (Continued)

Question 8 What form is used to define depreciation codes? The Fixed Asset Depreciation Code Maintenance Form (FTMDEPR)

©SunGard 2004-2005

Fixed Assets

40

Section C: Day-to-Day Operations Lesson:

Overview

Introduction The purpose of this section is to explain the day-to-day or operational procedures to create and maintain fixed assets in the Fixed Asset Module. Intended audience Fixed Assets Staff Objectives At the end of this section, you will be able to • • • • • • • •

Create invoices for fixed assets Extract origination tags and document tags from the temporary table Create and update a master record for a fixed asset Create document tags Setup and depreciate an asset Perform adjustments on an asset Transfer records Query and report on records.

Prerequisites To complete this section, you should have completed the Education Practices computer-based training (CBT) tutorial “Banner 7 Fundamentals,” or have equivalent experience navigating in the Banner system. You will also need to ensure that you have a working knowledge of asset management and the accounting structure.

© SunGard 2004-2005

Finance Fixed Assets Page 41

Section C: Day-to-Day Operations Lesson:

Overview (Continued)

Section contents Overview ................................................................................................................................41 Creating Invoices....................................................................................................................43 Viewing the Invoice’s Posting Detail.....................................................................................49 Creating Fixed Asset Origination Tags ..................................................................................51 Query Fixed Asset Origination Tags......................................................................................53 Converting Origination Tags to Permanent Tags...................................................................54 Assigning Depreciation Information to a Tag........................................................................55 Creating Primary Tags............................................................................................................58 Deleting Non-capitalized Fixed Assets without Dtags...........................................................62 Removing Erroneous Origination Tags..................................................................................64 Displaying Tags......................................................................................................................67 Creating a Fixed Asset Received as a Gift .............................................................................68 Capitalizing a Gift ..................................................................................................................72 Creating an Asset That Was Expensed to the Wrong Account ..............................................74 Running the Depreciation Process .........................................................................................77 Displaying the Depreciation Posting History.........................................................................79 Disposing or Selling an Inventory Asset (Non-Capitalized Fixed Asset)..............................81 Adjusting Fixed Assets...........................................................................................................83 Handling Write-Offs...............................................................................................................87 Adjusting the Value of Fixed Assets......................................................................................89 Adjusting Accumulated Depreciation ....................................................................................91 Updating Past Depreciation for an Asset Master Record.......................................................93 Reclassifying Asset Account Values......................................................................................95 Transferring Fixed Assets ......................................................................................................97 Assigning a New Permanent Tag to a Fixed Asset ................................................................99 Fixed Assets Reports and Queries........................................................................................101 Summary ..............................................................................................................................102 Self Check ............................................................................................................................103 Answer Key for Self Check..................................................................................................105

© SunGard 2004-2005

Finance Fixed Assets Page 42

Section C: Day-to-Day Operations Lesson:

Creating Invoices

Overview There are two types of invoices: Regular and Direct Pay. Regular invoices are those that are related to a purchase order; direct pay type invoices are those that are unrelated to any purchase order. Either type of invoice will initiate fixed asset tags and the automatic capitalization process if the amount is over the minimum capitalization amount on FOASYSC. Note: You must invoice an item before Banner can create the origination tag. Banner form Invoice/Credit Memo Form (FAAINVE)

Procedure 1 Follow the process below to create a direct pay invoice that will buy a boiler for $10,000. Step Action 1 Access the Invoice/Credit Memo Form (FAAINVE). 2 Enter NEXT in the Document field. Banner will assign the next sequential number. 3 Select Direct Pay in the field to the right of the Multiple checkbox. 4 Enter a vendor in the Vendor field. 5 Perform a Next Block function. 6 Enter the invoice date in the Invoice Date field. 7 Enter the transaction date in the Transaction Date field. 8 Enter the date you want payment made in the Payment Date field. 9 Enter A1 in the Bank field. 10 Perform a Next Block function. 11 Enter Boiler in the Commodity Description field. 12 Enter 10,000 in the Approved Amounts field. 13 Perform a Next Block function. 14 Enter 1110 in the Fund field. 15 Enter 11005 in the Organization field. 16 Enter 7952 in the Account field. 17 Enter 10 in the Program field. 18 Tab all the way through the rest of the form.

© SunGard 2004-2005

Finance Fixed Assets Page 43

Section C: Day-to-Day Operations Lesson:

Creating Invoices (Continued)

Procedure, continued Step 19 20 21 22

Action Perform a Next Block function. Click on the Complete button to complete the invoice. Record the Invoice #:_______________. Click the Exit icon. Note: The instructor will run posting (FGRACTG).

© SunGard 2004-2005

Finance Fixed Assets Page 44

Section C: Day-to-Day Operations Lesson:

Creating Invoices (Continued)

Procedure 2 Follow the process below to create a direct pay invoice that will buy a valve for $600. Step Action 1 Access the Invoice/Credit Memo Form (FAAINVE). 2 Enter NEXT in the Document field. Banner will assign the next sequential number. 3 Select Direct Pay in the field to the right of the Multiple checkbox. 4 Enter a vendor in the Vendor field. 5 Perform a Next Block function. 6 Enter the invoice date in the Invoice Date field. 7 Enter the transaction date in the Transaction Date field. 8 Enter the date you want payment made in the Payment Date field. 9 Enter A1 in the Bank field. 10 Perform a Next Block function. 11 Enter Valve in the Commodity Description field. 12 Enter 600 in the Approved Amounts field. 13 Perform a Next Block function. 14 Enter 1110 in the Fund field. 15 Enter 11005 in the Organization field. 16 Enter 7952 in the Account field. 17 Enter 10 in the Program field. 18 Tab all the way through the rest of the form. 19 Perform a Next Block function. 20 Click on the Complete button to complete the invoice. 21 Record the Invoice #:_______________. 22 Click the Exit icon. Note: The instructor will run posting (FGRACTG).

© SunGard 2004-2005

Finance Fixed Assets Page 45

Section C: Day-to-Day Operations Lesson:

Creating Invoices (Continued)

Procedure 3 Follow the process below to create a direct pay invoice that will buy a heating component for $2,500. Step Action 1 Access the Invoice/Credit Memo Form (FAAINVE). 2 Enter NEXT in the Document field. Banner will assign the next sequential number. 3 Select Direct Pay in the field to the right of the Multiple checkbox. 4 Enter a vendor in the Vendor field. 5 Perform a Next Block function. 6 Enter the invoice date in the Invoice Date field. 7 Enter the transaction date in the Transaction Date field. 8 Enter the date you want payment made in the Payment Date field. 9 Enter A1 in the Bank field. 10 Perform a Next Block function. 11 Enter Heating Component in the Commodity Description field. 12 Enter 2,500 in the Approved Amounts field. 13 Perform a Next Block function. 14 Enter 1110 in the Fund field. 15 Enter 11005 in the Organization field. 16 Enter 7952 in the Account field. 17 Enter 10 in the Program field. 18 Tab all the way through the rest of the form. 19 Perform a Next Block function. 20 Click on the Complete button to complete the invoice. 21 Record the Invoice #:_______________. 22 Click the Exit icon. Note: The instructor will run posting (FGRACTG).

© SunGard 2004-2005

Finance Fixed Assets Page 46

Section C: Day-to-Day Operations Lesson:

Creating Invoices (Continued)

Procedure 4 Follow the process below to create a direct pay invoice that will buy paper for $1,500. Step Action 1 Access the Invoice/Credit Memo Form (FAAINVE). 2 Enter NEXT in the Document field. Banner will assign the next sequential number. 3 Select Direct Pay in the field to the right of the Multiple checkbox. 4 Enter a vendor in the Vendor field. 5 Perform a Next Block function. 6 Enter the invoice date in the Invoice Date field. 7 Enter the transaction date in the Transaction Date field. 8 Enter the date you want payment made in the Payment Date field. 9 Enter A1 in the Bank field. 10 Perform a Next Block function. 11 Enter Paper in the Commodity Description field. 12 Enter 1,500 in the Approved Amounts field. 13 Perform a Next Block function. 14 Enter 2110 in the Fund field. 15 Enter 11005 in the Organization field. 16 Enter 7952 in the Account field. 17 Enter 10 in the Program field. 18 Tab all the way through the rest of the form. 19 Perform a Next Block function. 20 Click on the Complete button to complete the invoice. 21 Record the Invoice #:_______________. 22 Click the Exit icon. Note: The instructor will run posting (FGRACTG).

© SunGard 2004-2005

Finance Fixed Assets Page 47

Section C: Day-to-Day Operations Lesson:

Creating Invoices (Continued)

Procedure 5 Follow the process below to create a direct pay invoice that will buy pencils for $100. Step Action 1 Access the Invoice/Credit Memo Form (FAAINVE). 2 Enter NEXT in the Document field. Banner will assign the next sequential number. 3 Select Direct Pay in the field to the right of the Multiple checkbox. 4 Enter a vendor in the Vendor field. 5 Perform a Next Block function. 6 Enter the invoice date in the Invoice Date field. 7 Enter the transaction date in the Transaction Date field. 8 Enter the date you want payment made in the Payment Date field. 9 Enter A1 in the Bank field. 10 Perform a Next Block function. 11 Enter Pencils in the Commodity Description field. 12 Enter 100 in the Approved Amounts field. 13 Perform a Next Block function. 14 Enter 2110 in the Fund field. 15 Enter 11005 in the Organization field. 16 Enter 7952 in the Account field. 17 Enter 10 in the Program field. 18 Tab all the way through the rest of the form. 19 Perform a Next Block function. 20 Click on the Complete button to complete the invoice. 21 Record the Invoice #:_______________. 22 Click the Exit icon. Note: The instructor will run posting (FGRACTG).

© SunGard 2004-2005

Finance Fixed Assets Page 48

Section C: Day-to-Day Operations Lesson:

Viewing the Invoice’s Posting Detail

The posting process The Posting Process (FGRACTG) posts invoices (and all other postable documents in Banner). Document Retrieval Inquiry Form Once the Posting Process is complete, purchase orders and invoices can be viewed in detail through the Document Retrieval Inquiry Form (FGIDOCR).

Viewing the posted invoices The Document Postings Form (FGQDOCP) allows you to view the posted invoices. The Header Information displays a limited summary of the invoice. The Detail Information displays the accounting distribution for the invoice. When you access FGQDOCP, you should see the following: • • • •

Accounts payable transaction Automatic capitalization entry Expenditure Control entry to match with the Accounts Payable and YTD expense entries YTD Capital expense, which pairs with Accounts Payable and the Expenditure Control entries.

© SunGard 2004-2005

Finance Fixed Assets Page 49

Section C: Day-to-Day Operations Lesson:

Viewing the Invoice’s Posting Detail (Continued)

Procedure Follow the process below to view posted invoices. Step Action 1 Access the Document Retrieval Inquiry Form (FGIDOCR). 2 Enter the invoice number in the Document field. 3 Perform a Next Block Function. 4 Select Access Document Postings from the Options menu to go to the Document Postings Form (FGQDOCP), which displays all the transactions posted to a fund and organization. 5 Move the vertical scroll bar to display the transactions. 6 Click the Exit icon to close FGQDOCP and return to the FGIDOCR form. 7 Click the Exit icon.

© SunGard 2004-2005

Finance Fixed Assets Page 50

Section C: Day-to-Day Operations Lesson:

Creating Fixed Asset Origination Tags

Origination tag extraction process Generating origination tags for each invoiced item will require you to run the Fixed Asset Origination Tag Extraction (FFPOEXT). This process will take all of the tags that have been updated to the FFBOTAG table and create master fixed asset records for these in the FFBMAST table (your fixed asset master file). The Fixed Asset Origination Tag Extraction then clears these records from the FFBOTAG table. The FFPOEXT process produces a report that should be reviewed carefully. This will list all of the tags, which have been or will be created by this process, and indicate whether or not the tagged asset was also capitalized. This report should be used to ensure that tags are being created appropriately, and to correct errors resulting from incorrectly coded invoices. There are five basic things that can occur to the origination tags after they are extracted: 1. An origination tag on the extract that is capitalized will be converted to a permanent tag. 2. An origination tag on the extract will be attached to another capitalized permanent tag. 3. An origination tag that is capitalized will be converted to a permanent tag and then made a component of another capitalized permanent tag. 4. An origination tag that is capitalized needs to be document tagged out because the item is not a fixed asset item. 5. An origination tag that is not capitalized needs to be document tagged out because the item is not a fixed asset item. Following the previous exercises your extract should include the following: • Boiler for $10,000 that was capitalized • Valve for $600 that was not capitalized • Heating Component for $2,500 that was capitalized • Paper for $1,500 that was capitalized • Pencils for $100 that were not capitalized. Note: It is extremely important that the FFPOEXT process be run frequently and regularly. The FFBOTAG table will start accumulating tags as soon as you have turned fixed assets “on” in the System Control Maintenance Form (FOASYSC).

© SunGard 2004-2005

Finance Fixed Assets Page 51

Section C: Day-to-Day Operations Lesson:

Creating Fixed Asset Origination Tags (Continued)

Banner form Fixed Asset Origination Tag Extraction (FFPOEXT)

Procedure Note: The instructor will run the FFPOEXT process. Step Action 1 Access the Fixed Asset Origination Tag Extraction Process (FFPOEXT). 2 Perform a Next Block function 3 Enter DATABASE or a printer name in the Printer field. 4 Perform a Next Block function 5 Enter A in Parameter 01: Audit or Update Mode Values field. 6 Perform a Next Block function 7 Click the Save icon. 8 Review the output. 9 Rerun the job in Update mode be repeating steps 2-8 but change the parameter from A to U. 10 After the report is reviewed, click the Exit icon.

© SunGard 2004-2005

Finance Fixed Assets Page 52

Section C: Day-to-Day Operations Lesson:

Query Fixed Asset Origination Tags

Banner form Fixed Asset Procurement Query Form (FFIPROC)

Procedure Follow the process below to view origination tags by accessing the Fixed Asset Procurement Query Form (FFIPROC). Step Action 1 Access the Fixed Asset Procurement Query Form (FFIPROC). 2 Execute a Query. 3 Use the vertical scroll bar to scroll through the list of origination tags. 4 Locate your five invoices. 5 Record the origination tag numbers. There is an origination tag for each item. Origination Tag #: ___________________________________ Origination Tag #: ___________________________________ Origination Tag #: ___________________________________ Origination Tag #: ___________________________________ Origination Tag #: ___________________________________

© SunGard 2004-2005

Finance Fixed Assets Page 53

Section C: Day-to-Day Operations Lesson:

Converting Origination Tags to Permanent Tags

Banner form Banner has assigned origination tags to the invoiced items. Now you must update the items and assign them to permanent tags using the Fixed Asset Master Maintenance Form (FFAMAST).

Procedure In this exercise, the Boiler that was invoiced and capitalized for $10,000 is now going to be converted to a Permanent Tag. Step Action 1 Access the Fixed Asset Master Maintenance Form (FFAMAST). 2 Enter an origination tag number in the Asset Tag field. 3 Select Convert to permanent tag in the Action field. 4 Perform a Next Block function. 5 Enter NEXT in the Permanent Tag # field or enter your own permanent tag number.

6 7 8

Note: Using next, Banner will assign the next sequential number for you. Go to the Asset Type field. Click Search to view a list of values. Highlight E4 and double-click it to select it.

9 10

Note: Permanent Tag # and Asset Type are the only two fields you must enter information to create a permanent tag. The remaining fields and windows allow you to enter information specific to the item. Select Acquisition Information from the Options menu. Enter a serial number for this asset in the Serial Number/VIN field.

11 12

Note: Please take time later to complete other pertinent information in the remaining fields in this window, and to navigate to the other windows. Click the Save icon. Click the Exit icon.

© SunGard 2004-2005

Finance Fixed Assets Page 54

Section C: Day-to-Day Operations Lesson:

Assigning Depreciation Information to a Tag

Assigning depreciation information After converting the asset to a permanent tag, you need assign the depreciation information to the tag. Banner form The Fixed Asset Depreciation Form (FFADEPR) is used to assign the depreciation information to a tag.

© SunGard 2004-2005

Finance Fixed Assets Page 55

Section C: Day-to-Day Operations Lesson:

Assigning Depreciation Information to a Tag (Continued)

Fields Use the information in the table to complete the procedure that follows. Field Remaining Periods Accumulated Depreciation Last Depreciation Date Total Net Book Value Last Activity Date Fund Organization

Account Program

Posting Code

Value The number has been reduced by the number of depreciated periods. The amount of depreciation taken to date. The last time this item was depreciated. The Accumulated Depreciation field value is subtracted from the Total Adjusted Cost field value. The last time this item was updated. This is the capitalization fund code, which is automatically populated from the source fund. It cannot be changed. The organization code assigned to the capitalization fund code automatically appears here. You can assign an organization code to the capitalization fund code on the Fund Code Maintenance Form (FTMFUND). The depreciation expense code created on the Account Code Maintenance Form (FTMACCT) is automatically displayed. Banner automatically populates the program code assigned to the capitalization fund code. You can assign a program code to the capitalization fund code on the Fund Code Maintenance Form (FTMFUND). Banner automatically populates the value you entered in the Depreciation/Post Indicator field that you assigned to the capitalization fund code. You assigned a postcode to the capitalization fund code on the Fund Code Maintenance Form (FTMFUND).

© SunGard 2004-2005

Finance Fixed Assets Page 56

Section C: Day-to-Day Operations Lesson:

Assigning Depreciation Information to a Tag (Continued)

Procedure Follow the process below to assign the depreciation information to a tag. Step Action 1 Access the Fixed Asset Depreciation Form (FFADEPR). 2 Enter the permanent tag number that you just created in the last exercise in the Permanent Tag field. 3 Perform a Next Block function. 4 Enter the “useful life” depreciation methodology, which you created on the Fixed Asset Depreciation Code Maintenance Form (FTMDEPR, in the Depreciation Method field. For this exercise, select SL (Straight Line). 5 Select the depreciation frequency in the Frequency field. Select Monthly for this exercise. 6 Indicate the salvage value in the Salvage Value field. For this exercise, enter 100. 7 Enter the date the depreciation can begin in the Start Date field. For this exercise, enter the first of this month. 8 Enter the life expectancy for this item in the Useful Life field. For this exercise, enter 5 if it did not pop in from the Depreciation Code. 9 Click the Save icon. 10 Click the Exit icon.

© SunGard 2004-2005

Finance Fixed Assets Page 57

Section C: Day-to-Day Operations Lesson:

Creating Primary Tags

Primary Tags In this lesson, you can practice creating primary tag numbers. A primary tag is used to associate a group of assets in one of the following ways. As a component of a primary tag, an asset is merely grouped with other items, but can be assigned its own permanent tag number, and can be adjusted and depreciated independently. As an attachment to a primary tag, an asset cannot be assigned a permanent tag number of its own (it will be referenced only using the origination tag number) and will be adjusted and depreciated as part of the primary tag. Banner form Fixed Asset Master Maintenance Form (FFAMAST)

© SunGard 2004-2005

Finance Fixed Assets Page 58

Section C: Day-to-Day Operations Lesson:

Creating Primary Tags (Continued)

Procedure 1 In this exercise the Heating Component for $2,500 is going to be made a component of the Boiler. Step Action 1 Access the Fixed Asset Master Maintenance Form (FFAMAST). 2 Enter in the heating component’s origination tag number in the Asset Tag field. 3 Select Convert to permanent tag in the Action field. 4 Perform a Next Block function. 5 Enter NEXT in the Permanent Tag field or enter your own permanent tag number.

6 7 8 9 10 11 12 13 14

15 16 17 18 19 20

Note: Using next, Banner will assign the next sequential number for you. Assign this asset to the Boiler permanent tag you just created in the Primary Tag field. Select Component of in the Subordinate Type field. Enter the item’s category in the Asset Type field. Click the Save icon, Click the Exit icon. Access the Fixed Asset Depreciation Form (FFADEPR). Enter the permanent tag number that you just created in the Permanent Tag field. Perform a Next Block function. Enter the “useful life” depreciation methodology, which you created on the Fixed Asset Depreciation Code Maintenance Form (FTMDEPR) in the Depreciation Method field. For this exercise, select SL (Straight Line). Select the depreciation frequency in the Frequency field. Select Monthly for this exercise. Indicate the salvage value in the Salvage Value field. For this exercise, enter 100. Enter the date the depreciation can begin in the Start Date field. For this exercise, enter the first of this month. Enter the life expectancy for this item in the Useful Life field. For this exercise, enter 5 if it did not pop in from the Depreciation Code. Click the Save icon. Click the Exit icon.

© SunGard 2004-2005

Finance Fixed Assets Page 59

Section C: Day-to-Day Operations Lesson:

Creating Primary Tags (Continued)

Procedure 2 In this exercise the valve for $600 is going to be made an attachment of the Boiler. Before this can be done the valve must be capitalized first. Non-capitalized items may not be attached to capitalized items. Step Action 1 Access the Fixed Asset Master Maintenance Form (FFAMAST). 2 Enter an origination tag number in the Asset Tag field. 3 Select Origination Tag-Update Asset from the drop-down list, in the Action field. 4 Perform a Next Block function. 5 Enter E4 the Asset Type field. 6 Perform a Next Block function. 7 Enter PU in the Acquisition Method field. 8 Enter 20 in the Condition Code field. 9 Enter IN in the Title To field. 10 Perform a Next Block function. 11 Enter the received date in the Received Date Field. 12 Enter B (or the COA code for your institution) in the COA field. 13 Enter 11005 in the Orgn field. 14 Enter the location code for the asset in the Locn field. 15 Perform a Next Block function.

16

Note: .The accounting information from the invoice is displayed. Perform a Next Block function:

17 18

Note: .The default capitalization information will appear from FFASYSC. Click the New Sequence icon. Enter 1950 in the Asset Account field.

19 20 21 22 23 24

Note: The accumulated depreciation account will default. Enter 600 in the Cost field. Click the Save icon. Click the Exit icon. Access the Fixed Asset Adjustment Form (FFAADJF). Enter Next in the Document Code field. Select Otag capitalization in the Function Code field.

© SunGard 2004-2005

Finance Fixed Assets Page 60

Section C: Day-to-Day Operations Lesson:

Creating Primary Tags (Continued)

Procedure 2, continued Step 25 26 27

28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46

Action Perform a Next Block function. Enter the reason or justification for updating the asset in the Description field. Enter the acquisition date for this item in the Trans Date field. Remember, adjustments cannot be dated prior to the capitalization date. Note: Any future adjustments cannot be dated prior to this capitalization date. Perform a Next Block function. Enter in the origination tag of the valve, in the Otag field. Perform a Next Block function. Make sure the Asset and Accounting numbers match. Click the Complete icon. Click the Exit icon. Run the Posting Process (FGRACTG). Access the Fixed Asset Master Maintenance Form (FFAMAST). Enter in the valve’s origination tag number in the Asset Tag field. Select Origination Tag - Update Asset in the Action field. Perform a Next Block function. Assign this asset to the boiler’s permanent tag in the Primary Tag field. Select Attached to in the Subordinate Type field. Click the Save icon. Click the Exit icon. Access the Fixed Asset Depreciation Form (FFADEPR). Enter the permanent tag number of the Boiler in the Permanent Tag field. Perform a Next Block function. Confirm the attachment’s asset depreciation expense distribution matches the boilers

© SunGard 2004-2005

Finance Fixed Assets Page 61

Section C: Day-to-Day Operations Lesson:

Deleting Non-capitalized Fixed Assets without Dtags

Banner form In some instances an incorrectly coded invoice can cause the generation of fixed asset tags that you do not want. So long as the assets in question have not also been capitalized, they can be simply deleted using the Fixed Asset Deletion Form (FFAFDEL). Note: If you delete the fixed asset using this method and Dtags are marked in FOASYSC, then do not make a journal entry to move the transaction out of the fixed asset expense line or a Dtag will be created.

© SunGard 2004-2005

Finance Fixed Assets Page 62

Section C: Day-to-Day Operations Lesson:

Deleting Non-capitalized Fixed Assets without Dtags (Continued)

Procedure Follow the process below to delete a fixed asset. Step Action 1 Access the Fixed Asset Deletion Form (FFAFDEL). 2 Perform an Execute Query function. Any eligible (non-capitalized) tags are displayed. 3 Click on one of the boxes on the right side of your screen in the Delete column.

5

Note: You might get an error or warning, for example, if the item you selected has adjustments or is tagged. Take note of any messages that are displayed in the Auto Hint line. Select Asset Master Information from the Options menu to query the fixed asset detail relating to your selected item. Select Delete All from the Options menu to delete all selected assets.

6

Note: you will be asked to select Delete All again Select Delete All again from the Options menu to delete all selected assets.

7

Note: A pop up box will appear indicating the record was deleted. Click the Exit icon.

4

© SunGard 2004-2005

Finance Fixed Assets Page 63

Section C: Day-to-Day Operations Lesson:

Removing Erroneous Origination Tags

Document Tag In FOASYSC, document tags were turned on for journal vouchers. In order for a document, tag to be created a journal voucher must be completed that either debits or credits the capital expense account. For this workbook, that is account 7952. After the journal voucher is created and posted, the FFPOEXT process is run to create the document tag. Document tags are resolved on the form Fixed Asset Dtag Processing (FFADTGP). Banner form Fixed Asset Dtag Processing (FFADTGP)

Procedure 1 In this exercise, the paper for $1,500 will be dtagged out of the capital expense account and the capitalization will be reversed. Step Action 1 Access the Journal Voucher Quick Form (FGAJVCQ).

© SunGard 2004-2005

Finance Fixed Assets Page 64

Section C: Day-to-Day Operations Lesson:

Removing Erroneous Origination Tags (Continued)

Procedure, continued Step 2

Action Using a JE15 rule code, complete this journal voucher: Debit - 2110-11005-7210-10 for $1,500 Credit – 2110-11005-7952-10 for $1,500

3 4

Note: Record your journal voucher number. Run the posting process – FGRACTG. Run the Fixed Asset Origination Tag extract – FFPOEXT.

5 6 7 8 9 10

Note: The capitalization process was reversed after the extract was run. Write down the Document Tag number attached to your journal voucher. Access the Fixed Asset Dtag Processing form (FFADTGP). Enter in your journal voucher number in the Document field. Verify Journal Entry is selected in the Type field. Verify Pending is selected in the DTag Pending field. Perform a Next Block function.

11 12 13 14

Note: The accounting information defaults in from the journal voucher. Leave it alone since it is correct that we are moving expenditures out of the capital expense account. Select Delete in the Action field. Enter in the paper’s Otag number in the Otag field. Select Perform Actions from the Options menu. Click OK in the pop up box indicting the sequences is in balance and to perform the update.

15 16 17

Note: You will be brought to the Fixed Asset Master Delete form (FFAFDEL). The paper’s Otag is marked for deletion. Select Delete All from the Options menu. Select Delete All from the Options menu, again.

18

Note: A pop up box will appear indicating the record was deleted. Click the Exit icon.

© SunGard 2004-2005

Finance Fixed Assets Page 65

Section C: Day-to-Day Operations Lesson:

Removing Erroneous Origination Tags (Continued)

Procedure 2 In this procedure, the pencils for $100 will be dtagged out of the capital expense account. Step Action 1 Access the Journal Voucher Quick Form (FGAJVCQ). 2 Using a JE15 rule code, complete this journal voucher: Debit - 2110-11005-7210-10 for $100 Credit – 2110-11005-7952-10 for $100

3 4 5 6 7 8 9 10

11 12 13 14

Note: Record your journal voucher number. Run the posting process – FGRACTG. Run the Fixed Asset Origination Tag extract – FFPOEXT. Write down the Document Tag number attached to your journal voucher. Access the Fixed Asset Dtag Processing form (FFADTGP). Enter your journal voucher number in the Document field. Verify Journal Entry is selected in the Type field. Verify Pending is selected in the DTag Pending field. Perform a Next Block function. Note: The accounting information defaults in from the journal voucher. Leave it alone since it is correct that we are moving expenditures out of the capital expense account. Select Delete in the Action field. Enter in the pencil’s Otag number in the Otag field. Select Perform Actions from the Options menu. Click OK in the pop up box indicting the sequences is in balance and to perform the update.

15 16 17

Note: You will be brought to the Fixed Asset Master Delete form (FFAFDEL). The pencil’s Otag is marked for deletion. Select Delete All from the Options menu. Select Delete All from the Options menu, again.

18

Note: A pop up box will appear indicating the record was deleted. Click the Exit icon.

© SunGard 2004-2005

Finance Fixed Assets Page 66

Section C: Day-to-Day Operations Lesson:

Displaying Tags

Banner form The Fixed Asset List Form (FFIFALV) lists the permanent tags, origination tags, and the primary tags.

Procedure Follow the process below to list the permanent, origination and primary tags. Step Action 1 Access the Fixed Asset List Form (FFIFALV). 2 Select the Permanent Tag radio button. 3 Perform a Next Block function. 4

Perform an Execute Query function.

5

Note: The permanent tags are displayed in descending order. Click the Exit icon.

© SunGard 2004-2005

Finance Fixed Assets Page 67

Section C: Day-to-Day Operations Lesson:

Creating a Fixed Asset Received as a Gift

Manually create a fixed asset Use the Fixed Asset Master Form (FFAMAST) form to create a fixed asset record manually. Use the Gifts/Donations option provided in the Action field of the FFAMAST form to manually create the tag. If the gift or donation needs to be capitalized, do this after the permanent tag is created. The Fixed Asset Adjustment form (FFAADJF) needs to be accessed to record the capitalization entry. The Fixed Asset Depreciation Form (FFADEPR) is used to set up the depreciation schedule. Banner form Fixed Asset Master Form (FFAMAST)

© SunGard 2004-2005

Finance Fixed Assets Page 68

Section C: Day-to-Day Operations Lesson:

Creating a Fixed Asset Received as a Gift (Continued)

Procedure 1 Follow the procedure below to manually create a fixed asset that was received as a gift but will not be capitalized. Step Action 1 Access the Fixed Asset Master Form (FFAMAST). 2 Enter NEXT in the Asset Tag field. 3 Select Gifts/Donations from the drop-down list the Action field. 4 Perform a Next Block function. 5 Enter NEXT in the Permanent Tag# field. 6 Enter a description of this acquisition (for example, Grandfather Clock) in the Asset Description field. 7 Enter EA in the U/M field. 8 Enter B2 in the Asset Type field. 9 Perform a Next Block function. 10 Enter DN in the Acquisition Method field. 11 Enter 20 in the Condition Code field. 12 Enter IN in the Title To field. 13 Perform a Next Block function. 14 Enter the received date in the Received Date field. 15 Enter B (or the COA code for your institution) in the COA field. 16 Enter 11005 (or a valid organization code for your institution) in the Organization field. 17 Enter the location code for the asset in the Location field. 18 Click the Save icon. 19 Click the Exit icon.

© SunGard 2004-2005

Finance Fixed Assets Page 69

Section C: Day-to-Day Operations Lesson:

Creating a Fixed Asset Received as a Gift (Continued)

Procedure 2 Follow the process below to manually create a fixed asset that was received as a gift that will be capitalized. Step Action 1 Access the Fixed Asset Master Form (FFAMAST). 2 Enter NEXT in the Asset Tag field. 3 Select Gifts/Donations from the drop-down list the Action field. 4 Perform a Next Block function. 5 Enter NEXT in the Permanent Tag field. 6 Enter a description of this acquisition (for example, Oil Painting of Campus signed by Author dated 1945) in the Asset Description field. 7 Enter EA in the U/M field. 8 Enter AC in the Asset Type field. 9 Perform a Next Block function. 10 Enter DN in the Acquisition Method field. 11 Enter 20 in the Condition Code field. 12 Enter IN in the Title To field. 13 Perform a Next Block function. 14 Enter the received date in the Received Date Field. 15 Enter B (or the COA code for your institution) in the COA field. 16 Enter 11005 (or a valid organization code for your institution) in the Organization field. 17 Enter the location code for the asset in the Location field. 18 Perform a Next Block function. 19

Enter 1110 (or a valid source fund code for your institution) in the Fund field.

20

Enter 11005 (or a valid organization code for your institution in the Organization field.

21

Enter 1950 (or a valid fixed asset account) in the Account field.

© SunGard 2004-2005

Finance Fixed Assets Page 70

Section D: Reference Lesson:

Creating a Fixed Asset Received as a Gift (Continued)

Procedure 2, continued Step 22 23 24

25 26

Action Enter 10 (or a valid program code for your institution) in the Program field. Enter the value of the gift in the Cost field. Perform a Next Block function: Note: The default capitalization information will appear from FFASYSC. You may change it by clicking the new sequence button on the button of the form and changing the funds and accounts. This will not be done in this exercise. Click the Save icon. Take note of the Origination Tag number and Permanent Tag number.

© SunGard 2004-2005

Finance Fixed Assets Page 71

Section C: Day-to-Day Operations Lesson:

Capitalizing a Gift

Permanent tag capitalization The Permanent Tag Capitalization function allows you to capitalize an asset that either came through the Procurement Process not capitalized or was entered as a gift/donation. Prior to using this function, you must complete the Capitalization window of the Fixed Asset Master Form (FFAMAST) for the permanent tag. In this exercise, you will be using the action called SCAP – PTAG Capitalization on the Fixed Asset Adjustment Form (FFAADJF). This option creates capitalization postings to your ledger. Note: Another option on this form, NCAP – No Posting to GL, can be used to flag the item as capitalized without creating ledger postings. This option might be used in the case of converted assets, where the capital entry already exists in the ledger. Banner form Fixed Asset Adjustment Form (FFAADFJ)

© SunGard 2004-2005

Finance Fixed Assets Page 72

Section C: Day-to-Day Operations Lesson:

Capitalizing a Gift (Continued)

Procedure In this procedure, you will create the capitalization entry action, which will post to the ledgers, using the Fixed Asset Adjustment Form (FFAADJF). Step Action 1 Access the Fixed Asset Adjustment Form (FFAADJF). 2 Enter Next in the Document Code field. 3 Select Ptag capitalization in the Function Code field. 4 Perform a Next Block function. 5 Enter the reason or justification for updating the asset in the Description field. 6 Enter the acquisition date for this item in the Trans Date field. Remember, adjustments cannot be dated prior to the capitalization date.

7 8 9 10 11 12 13 14 15 16 17

18 19 20 21 22 23

Note: Any future adjustments cannot be dated prior to this capitalization date. Perform a Next Block function. Enter in the permanent tag you just created in the last exercise, in the Ptag field. Perform a Next Block function. Make sure the Asset and Accounting numbers match. Click the Complete icon. Click the Exit icon. Run the Posting Process (FGRACTG). Access the Fixed Asset Depreciation Form (FFADEPR). Enter the permanent tag number that you just capitalized in the Permanent Tag field. Perform a Next Block function. Enter the “useful life” depreciation methodology, which you created on the Fixed Asset Depreciation Code Maintenance Form (FTMDEPR) in the Depreciation Method field. For this exercise, select SL (Straight Line). Select the depreciation frequency in the Frequency field. Select Monthly for this exercise. Indicate the salvage value in the Salvage Value field. For this exercise, enter 100. Enter the date the depreciation can begin in the Start Date field. Enter the life expectancy for this item in the Useful Life field. For this exercise, enter 20 if it did not pop in from the Depreciation Code. Click the Save icon. Click the Exit icon.

© SunGard 2004-2005

Finance Fixed Assets Page 73

Section C: Day-to-Day Operations Lesson:

Creating an Asset That Was Expensed to the Wrong Account

Document Tag There are times when an item is truly an asset but has not been charged to the capital expense account. Since, document tags are turned on in FOASYSC a journal voucher can be created that will debit the capital expense account and credit the operating account. When FFPOEXT is run, a document tag is created that can be turned into an origination tag on the Fixed Asset Dtag Processing form (FFADTGP). If the asset needs to be capitalized then an adjustment needs to be made on FFAADJF to adjust depreciation set up on FFADEPR. Banner form Fixed Asset Dtag Processing (FFADTGP)

Procedure In this procedure, a copier machine for $2.000 was charged to the supplies account and it needs to be moved to the capital expense account, capitalized and then depreciation set up. Step Action 1 Access the Journal Voucher Quick Form (FGAJVCQ).

© SunGard 2004-2005

Finance Fixed Assets Page 74

Section C: Day-to-Day Operations Lesson:

Creating an Asset That Was Expensed to the Wrong Account (Continued)

Procedure, continued Step 2

Action Using a JE15 rule code, complete this journal voucher: Debit - 1110-11005-7952-10 for $2,000 Credit – 1110-11005-7210-10 for $2,000

3 4 5 6 7 8 9 10

11 12 13 14 15

16 17 18 19 20 21

Note: Record your journal voucher number. Run the posting process – FGRACTG. Run the Fixed Asset Origination Tag extract – FFPOEXT. Write down the Document Tag number attached to your journal voucher. Access the Fixed Asset Dtag Processing form (FFADTGP). Enter your journal voucher number in the Document field. Verify Journal Entry is selected in the Type field. Verify Pending is selected in the DTag Pending field. Perform a Next Block function. Note: The accounting information defaults in from the journal voucher. Leave it alone since it is correct that we are moving expenditures into the capital expense account. Select Create in the Action field. Click the Save icon Write down the origination tag number that was assigned Select Perform Actions in the Options menu. Click OK in the pop up box indicting the sequences is in balance and to perform the update. Note: Once you click ok the Dtag has been completed and now is marked resolved. Click the Exit icon. Access the Fixed Asset Master Maintenance Form (FFAMAST). Enter an origination tag number in the Asset Tag field. Select Convert to permanent tag from the drop-down list, in the Action field. Perform a Next Block function. Enter NEXT in the Permanent Tag field or enter your own permanent tag number. Note: Using next, Banner will assign the next sequential number for you.

© SunGard 2004-2005

Finance Fixed Assets Page 75

Section C: Day-to-Day Operations Lesson:

Creating an Asset That Was Expensed to the Wrong Account (Continued)

Procedure, continued Step 22 23 24 25 26 27 28 29 30

31 32 33 34 35 36 37 38

39 40 41 42 43 44

Action Enter E1 in the Asset Type field. Perform a Next Block Function. Enter PU in the Acquisition Method field. Enter a date in the Acquisition Date field. Enter 20 in the Condition Code field. Enter IN in the Title To field. Perform a Next Block function. Enter the location code for the asset in the Location field. Perform a Next Block function. Note: The Capitalization numbers will appear from FFASYSC but the cost needs to be inserted. Click the New Sequence button. Enter 2,000 in the Cost field. Click the Save icon. Click the Exit icon. Access the Fixed Asset Depreciation Form (FFADEPR). Enter the permanent tag number that you just created in the last exercise in the Permanent Tag field. Perform a Next Block function. Enter the “useful life” depreciation methodology, which you created on the Fixed Asset Depreciation Code Maintenance Form (FTMDEPR) in the Depreciation Method field. For this exercise, select SL (Straight Line). Select the depreciation frequency in the Frequency field. Select Monthly for this exercise. Indicate the salvage value in the Salvage Value field. For this exercise, enter 100. Enter the date the depreciation can begin in the Start Date field. Enter the life expectancy for this item in the Useful Life field. For this exercise, enter 3 if it did not pop in from the Depreciation Code. Click the Save icon. Click the Exit icon.

© SunGard 2004-2005

Finance Fixed Assets Page 76

Section C: Day-to-Day Operations Lesson:

Running the Depreciation Process

Running Depreciation You have assigned the depreciation expense distribution to permanent tags on the Fixed Asset Depreciation Form (FFADEPR). It is now time to run the Depreciation Process (FFPDEPR) to depreciate the assets for one month. You returned to FFADEPR to view the results of running FFPDEPR. Banner form Depreciation Process (FFPDEPR)

© SunGard 2004-2005

Finance Fixed Assets Page 77

Section C: Day-to-Day Operations Lesson:

Running the Depreciation Process (Continued)

Procedure Note: The instructor will run the FFPDEPR process. Step Action 1 Access the Depreciation Process (FFPDEPR). 2 Perform a Next Block function 3 Enter the desired printer name in the Printer field.

4 5

6 7 8 9 10 11

Note: You can enter DATABASE to write the report to a table for on-line viewing and to enable the saving of the report to a shared folder on a designated network drive. Perform a Next Block function Enter these parameter values. Parameter Value Parameter 01: Asset Type Leave blank. Parameter 02: Depreciation method code Leave blank. Parameter 03: Depreciation frequency Enter M. Parameter 04: Chart of Accounts Enter B. Parameter 05: Depreciation month and Enter the month and year you are in. year Parameter 06: Posting Date (DD-MON- Leave alone. YYYY) Parameter 07: Execution Mode (A/U) Enter A. Parameter 08: Report Type (D/S) Enter D. Click the Save Parameter Set as checkbox. Click the Save icon Select Review Output on the Options menu to review the report. Rerun the job in Update mode by repeating steps 2-8 but change the parameter seven from A to U. Run the Posting Process (FGRACTG). Click the Exit icon.

© SunGard 2004-2005

Finance Fixed Assets Page 78

Section C: Day-to-Day Operations Lesson:

Displaying the Depreciation Posting History

Document retrieval inquiry Returned to FFADEPR to view the results of running FFPDEPR. Then view the Document Retrieval Inquiry Form (FGIDOCR) to view the accounting distribution for the depreciation. Banner form Document Retrieval Inquiry Form (FGIDOCR)

© SunGard 2004-2005

Finance Fixed Assets Page 79

Section C: Day-to-Day Operations Lesson:

Displaying the Depreciation Posting History (Continued)

Procedure Follow the process below to view the accounting distribution for the depreciation. Step 1 2 3 4 5 6 7 8

Action Return to the Fixed Asset Depreciation Form (FFADEPR) to view the updates made to the asset now that the Depreciation Process (FFPDEPR) has been run. Enter the boiler’s permanent tag number in the Permanent Tag field. Perform a Next Block function. View the updates in the accumulated depreciation field. Click the Exit icon. Access the Document Retrieval Inquiry Form (FGIDOCR). Enter the depreciation number created from running FFPDEPR in the Document field. Perform a Next Block function.

10 11

Result: A limited summary is displayed in the Header Information area. The debit side of the transaction is displayed in the Detail Information area. Select Access Document Postings from the Options menu to go to the Document Postings Form (FGQDOCP). Summary information is displayed at the top. Scroll down as necessary to view the transactions. You should see the following:

12 13

Credit to accumulated depreciation account Debit to the expenditure control An increase in the year to date amount of the depreciation expense. Click the Exit icon. Click the Exit icon, again

9

© SunGard 2004-2005

Finance Fixed Assets Page 80

Section C: Day-to-Day Operations Lesson:

Disposing or Selling an Inventory Asset (Non-Capitalized Fixed Asset)

Banner form The Fixed Asset Master Form (FFAMAST) can be used to remove an inventory asset. Using the FFAMAST form to dispose or sell an inventory asset will keep a history of when this item was removed from inventory. No entries are made when this process is used, so if the asset was sold the proceeds would be recorded through a receipt entry in Banner.

© SunGard 2004-2005

Finance Fixed Assets Page 81

Section C: Day-to-Day Operations Lesson:

Disposing or Selling an Inventory Asset (Non-Capitalized Fixed Asset) (Continued)

Procedure Follow the process below to dispose of or selling an inventory asset Step 1 2 3 4 5 6 7 8

Action Access the Fixed Asset Master Form (FFAMAST) Enter permanent tag number in the Asset Tag field. Select Disposal of Uncapitalized Tag in the Action field. Perform a Next Block function. Perform another Next Block function. Enter the disposal method in the Disposal Method field Click the Save icon Click the Exit icon.

© SunGard 2004-2005

Finance Fixed Assets Page 82

Section C: Day-to-Day Operations Lesson:

Adjusting Fixed Assets

Banner form The Fixed Asset Adjustment Form (FFAADJF) allows you to process many different kinds of accounting adjustments to your fixed assets. Note: The Fixed Asset Adjustment Form (FFAADJF) creates documents that require posting before their effects can be viewed in the ledger. The Posting Process (FGRACTG) must be run manually if it is not running in background.

Accounting adjustments Review the descriptions that follow for the types of adjustments you can make. Note: This and several of the subsequent lessons will explore some of these options. You are encouraged, however, to experiment with all of them and carefully examine the resulting postings. DISP – Sale of Asset Records the sale for an asset. When selling an asset even if it is less than the cost, the fixed asset module will record the entry as a credit to the gain account (unless the account is changed) and a debit to cash. In addition, there will be a credit to the asset account and a debit to the equity account.

© SunGard 2004-2005

Finance Fixed Assets Page 83

Section C: Day-to-Day Operations Lesson:

Adjusting Fixed Assets (Continued)

WOFF – Write-off Write offs are used only on capitalized assets and it will reverse capitalization entries for a fixed asset (credit to the asset account and a debit to the equity account). If depreciation had already occurred, then the accumulated depreciation would have been debited, the asset account credited and the difference recoded in the loss account. WRIT – Write Up/Down Permits adjustment of the capitalized value of a fixed asset. A write up of a capitalized fixed asset will debit the asset account and credit the equity account. If a write down were performed, then there would be no entry to the asset or equity account but a credit to the accumulated depreciation and debit to depreciation expense. SCAP – PTAG Capitalization Creates a capitalization entry for a fixed asset. SCAO – Otag Capitalization Creates a capitalization entry for a fixed asset that has not been assigned a permanent tag (for example, Attachments to primary tags). ADPR – Depreciation Adjustments Permits adjustment of the accumulated depreciation of a capitalized fixed asset that has already had depreciation started on it. DEPP – Record Past Depreciation Permits the updating of accumulated depreciation amounts within the Fixed Assets module (this option does not create ledger postings). GLAS – GL Change Asset Account Permits transfer of the asset from one asset account to another. GLEQ – GL Change Equity Account Permits transfer of the asset from one equity account to another. GLCF – GL Change Fund Code Permits transfer of the asset from one capitalization fund to another.

© SunGard 2004-2005

Finance Fixed Assets Page 84

Section C: Day-to-Day Operations Lesson:

Adjusting Fixed Assets (Continued)

GLFE – GL Change Fund and Equity Permits modification of both the capitalization fund and equity code. GLCE – GL Change Cap Amount/ Account Permits change of the asset amount and account. NCAP – No Posting to GL Permits you to record that assets are capitalized without creating ledger postings (for example, for converted assets). RCAP – Reverse Cap for PTAG Can be used to reverse capitalization entries for items that should not have been capitalized, but have been permanently tagged. RCAO – Reverse Cap for Otag Can be used to reverse capitalization entries for items that should not have been capitalized, and have not been permanently tagged.

© SunGard 2004-2005

Finance Fixed Assets Page 85

Section C: Day-to-Day Operations Lesson:

Adjusting Fixed Assets (Continued)

Procedure Follow the process below to utilize the Fixed Asset Adjustment Form (FFAADJF) to process a DISP – Sale of Asset transaction. Step Action 1 Access the Fixed Asset Adjustment Form (FFAADJF). 2 Enter NEXT in the Document Code field. 3 Select Sale of Asset in the Function Code field. 4 Perform a Next Block function. 5 Enter the reason for updating the asset In the Description field. 6 Enter today’s date in the Transaction Date field.

10 11 12 13

Note: Adjustments cannot be dated prior to the capitalization date. Select Document Text from the Options menu if you want to add text. Perform a Next Block function. Enter one of the permanent tag numbers you created in the Ptag field. The tag’s Description and Net Book Value are automatically displayed. Enter a disposal method in the Disposal field. Enter the selling price that is greater than the asset’s worth in the Amount field. Perform a Next Block function. Perform another Next Block function.

14 15 16 17 18 19 20 21

Note: The revenue distribution will default. Change the Fund from 9601 to 1110. Enter A1 in the Bank field. Enter 100 in the Amount Percent field. Tab to the Revenue field and the sale price will appear. Select Access completion from the Options menu. Click the Complete button. Click the Exit icon. Run the Posting Process (FGRACTG).

7 8 9

© SunGard 2004-2005

Finance Fixed Assets Page 86

Section C: Day-to-Day Operations Lesson:

Handling Write-Offs

Overview This function handles write-offs with or without accumulated depreciation. Write offs are used only on capitalized assets and it will reverses capitalization entries for a fixed asset (credit to the asset account and a debit to the equity account). If depreciation had already occurred the accumulated depreciation would have been debited, the asset account credited and the difference recoded in the loss account. Banner form Fixed Asset Adjustment Form (FFAADJF)

© SunGard 2004-2005

Finance Fixed Assets Page 87

Section C: Day-to-Day Operations Lesson:

Handling Write-Offs (Continued)

Procedure Follow these steps to complete the process. Step Action 1 Access the Fixed Asset Adjustment Form (FFAADJF). 2 Enter NEXT in the Document Code field. 3 Select Write Off in the Function Code field. 4 Perform a Next Block function. 5 Enter the reason for updating the asset in the Description field. 6 Enter today’s date in the Transaction Date field.

7 8 9

Note: Adjustments cannot be dated prior to the capitalization date. Select Document Text from the Options menu if you want to add text. Perform a Next Block function. Enter one of the permanent tag numbers that you created in the Ptag field.

10 11 12 13 14

Note: Don’t enter the permanent tag number that you recorded as a Sale of Asset value in a previous exercise, since you can’t write off an asset that is sold. Its description and net book value will be displayed. Enter a disposal code in the Disposal field. Perform a Next Block function. Click the Complete button. Click the Exit icon. Run the Posting Process (FGRACTG).

© SunGard 2004-2005

Finance Fixed Assets Page 88

Section C: Day-to-Day Operations Lesson:

Adjusting the Value of Fixed Assets

Overview This function allows you to adjust the value of an asset up or down, whether accumulated depreciation is involved or not. A write up of a capitalized fixed asset will debit the asset account and credit the equity account. If a write down were performed, then there would be no entry to the asset or equity account but a credit to the accumulated depreciation and debit to depreciation expense. Note: This function is available only for capitalized assets. Banner form The Fixed Asset Adjustment Form (FFAADJF) is used to adjust the value of fixed assets.

© SunGard 2004-2005

Finance Fixed Assets Page 89

Section C: Day-to-Day Operations Lesson:

Adjusting the Value of Fixed Assets (Continued)

Procedure Follow the process below to adjust the value of a fixed asset. Step Action 1 Access the Fixed Asset Adjustment Form (FFAADJF). 2 Enter NEXT in the Document Code field. 3 Select Write Up/down adjustments in the Function Code field. 4 Perform a Next Block function. 5 Enter the reason for updating the asset in the Description field. 6 Enter today’s date in the Transaction Date field.

7 8 9

10

11 12 13 14

Note: Adjustments cannot be dated prior to the capitalization date. Select Document Text from the Options menu if you want to add text. Perform a Next Block function. Enter one of the permanent tag numbers that you created in the Ptag field. Note: Don’t enter the permanent tag number that you recorded as a Sale of Asset value in a previous exercise, since you can’t write off an asset that is sold. Its description and net book value display. Enter the amount that you want to write up/down (the “delta” amount) in the Amount field. For a write-down, precede the amount with a - (minus) sign. For this exercise, enter 100. Perform a Next Block function. Click the Complete button. Click the Exit icon. Run the Posting Process (FGRACTG).

© SunGard 2004-2005

Finance Fixed Assets Page 90

Section C: Day-to-Day Operations Lesson:

Adjusting Accumulated Depreciation

Depreciation Adjustment function Permits adjustment of the accumulated depreciation of a capitalized fixed asset that has already had depreciation started on it. Banner form Fixed Asset Adjustment Form (FFAADJF)

© SunGard 2004-2005

Finance Fixed Assets Page 91

Section C: Day-to-Day Operations Lesson:

Adjusting Accumulated Depreciation (Continued)

Procedure Follow the process below to adjust accumulated depreciation. Step Action 1 Access the Fixed Asset Adjustment Form (FFAADJF). 2 Enter NEXT in the Document Code field. 3 Select Depreciation adjustment in the Function Code field. 4 Perform a Next Block function. 5 Enter the reason for updating the asset in the Description field. 6 Enter today’s date in the Transaction Date field.

7 8 9 10

11 12 13 14

Note: Adjustments cannot be dated prior to the capitalization date. Select Document Text from the Options menu if you want to add text. Perform a Next Block function. Enter one of the permanent tag numbers that you created in the Ptag field. Its description, net book value, salvage value, and net depreciable value are displayed. Enter the amount by which you want to depreciate the asset, that is, the net difference in the Amount field. For a write-down, precede the amount with a - (minus) sign. For this exercise, enter 100. Perform a Next Block function. Click Complete to complete the adjustment. Click the Exit icon. Run the Posting Process (FGRACTG).

© SunGard 2004-2005

Finance Fixed Assets Page 92

Section C: Day-to-Day Operations Lesson:

Updating Past Depreciation for an Asset Master Record

Record past depreciation function The Record Past Depreciation function allows you to update an asset’s master record (displayed on the Capitalization window of the Fixed Asset Master Form (FFAMAST) and depreciation maintenance record (displayed on the Fixed Asset Depreciation Form (FFADEPR) for past depreciation already recorded in the ledgers. This function is only available for capitalized assets that have not been previously depreciated or adjusted in the Fixed Assets module. It will not create postings to the ledgers. You may use the Depreciation Process (FFPDEPR) to post past depreciation to both the ledgers and the Fixed Assets module. Banner form Fixed Asset Adjustment Form (FFAADJF)

© SunGard 2004-2005

Finance Fixed Assets Page 93

Section C: Day-to-Day Operations Lesson:

Updating Past Depreciation for an Asset Master Record (Continued)

Procedure Follow the process below to update past depreciation for an asset master record. Step Action 1 Access the Fixed Asset Adjustment Form (FFAADJF). 2 Enter NEXT in the Document Code field. 3 Select Record Past Depreciation in the Function Code field. 4 Perform a Next Block function. 5 Enter the reason for updating the asset in the Description field. 6 Enter today’s date in the Transaction Date field.

7 8 9 10 11 12 13

Note: Adjustments cannot be dated prior to the capitalization date. Select Document Text from the Options menu if you want to add text. Perform a Next Block function. Enter one of the permanent tag numbers that you created in the Ptag field. Its description, net book value, salvage value, and net depreciable value are displayed. Enter the amount of prior depreciation in the Amount field. Perform a Next Block function. Click Complete to complete the adjustment. Click the Exit icon.

© SunGard 2004-2005

Finance Fixed Assets Page 94

Section C: Day-to-Day Operations Lesson:

Reclassifying Asset Account Values

Reclassification of capitalization values The GL Change – Asset Account function deals with reclassification of capitalization values for both the General Ledger and the Fixed Assets modules. This function reverses the asset balance in the original account and records the balance in the new asset account. Banner reclassifies any accumulated depreciation for the asset to the accumulated depreciation account associated with the new asset account. Prior to using this function, you must complete the Capitalization window of the Fixed Asset Master Form (FFAMAST) for the asset. You must enter the fund, asset account, equity account, and cost amount for each account distribution on the master record. Banner form Fixed Asset Adjustment Form (FFAADJF)

© SunGard 2004-2005

Finance Fixed Assets Page 95

Section C: Day-to-Day Operations Lesson:

Reclassifying Asset Account Values (Continued)

Procedure Follow the process below to reclassify asset account values. Step Action 1 Access the Fixed Asset Adjustment Form (FFAADJF). 2 Enter NEXT in the Document Code field. 3 Select GL Change- Asset Account in the Function Code field. 4 Perform a Next Block function. 5 Enter the reason for updating the asset in the Description field. 6 Enter today’s date in the Transaction Date field.

7 8 9 10 11 12 13 14

Note: Adjustments cannot be dated prior to the capitalization date. Select Document Text from the Options menu if you want to add text. Perform a Next Block function. Enter one of the permanent tag numbers that you created in the Ptag field. Its description, net book value, salvage value, and net depreciable value are displayed. Enter the new asset account code in the Account field. Perform a Next Block function. Click Complete to complete the adjustment. Click the Exit icon. Run the Posting Process (FGRACTG).

© SunGard 2004-2005

Finance Fixed Assets Page 96

Section C: Day-to-Day Operations Lesson:

Transferring Fixed Assets

Transferring Assets Use the Fixed Asset Transfer Form (FFATRAN) to record the new location/owner of a fixed asset. Through this form, you can track the movement of a fixed asset from one location to another. Banner form The Fixed Asset Transfer Form (FFATRAN)

© SunGard 2004-2005

Finance Fixed Assets Page 97

Section C: Day-to-Day Operations Lesson:

Transferring Fixed Assets (Continued)

Procedure Follow the process below to transfer a fixed asset to new location and/or owner. Step Action 1 Access the Fixed Asset Transfer Form (FFATRAN). 2 Enter a permanent tag number in the Permanent Tag# field. 3 Perform a Next Block function. The origination tag number and description are displayed.

4

Note: The system lists an asset’s transfer history in descending chronological order. The current location and accountability information for the asset are displayed in the To column. Select Transfer Information from the Options menu to transfer an asset.

5 6 7 8

Note: The system moves the current location and accountability information in the From column. Enter the new location in the To column to transfer the asset. Type the reason for the transfer in the Transfer Reason field. Click the Save icon. Click the Exit icon.

© SunGard 2004-2005

Finance Fixed Assets Page 98

Section C: Day-to-Day Operations Lesson:

Assigning a New Permanent Tag to a Fixed Asset

Overview There may be occasions when you need to reassign another permanent tag to an asset. If you know the original permanent tag, reassigning a new permanent tag is easy to do. Go to the Fixed Asset Transfer Form (FFATRAN) and display the old permanent tag number, and then reassign a new tag. It may be more difficult if you do not know the old permanent tag. To obtain the old tag number, you need to know something about the asset, such as the serial number. You can query on this information to obtain the permanent tag number in FFIPROC. Banner form Fixed Asset Transfer Form (FFATRAN)

© SunGard 2004-2005

Finance Fixed Assets Page 99

Section C: Day-to-Day Operations Lesson:

Assigning a New Permanent Tag to a Fixed Asset (Continued)

Procedure Follow the process below to assign a new permanent tag to a fixed asset. Step Action 1 Access the Fixed Asset Transfer Form (FFATRAN). 2 Enter in a permanent tag number in the Permanent Tag field. 3 Perform a Next Block function. 4 Select Transfer Information from the Options menu to automatically transfer the information in the To section into the From section. 5 Enter the new tag number in the Permanent Tag field.

6 7 8 9

Note: You cannot use the “next” feature here. You must enter an unused number. Enter in a location code in the Location field. Enter in the reason for the permanent tag change in the Transfer Reason field Click the Save icon. Click the Exit icon.

© SunGard 2004-2005

Finance Fixed Assets Page 100

Section C: Day-to-Day Operations Lesson:

Fixed Assets Reports and Queries

Available query forms and delivered reports These queries and reports are used frequently in the Fixed Assets Module. Form Description Fixed Assets Adjustment Query Fixed Assets Master Query Fixed Assets Procurement Query Fixed Assets Adjustment List Fixed Assets Adjustment History Fixed Assets Master Record Report Fixed Assets / Asset Group Report Fixed Asset Procurement Report Fixed Asset Property Report

Banner Name FFIADJF FFIMAST FFIPROC FFIADJL FFIADJH FFRMAST FFRAGRP FFRPROC FFRPROP

© SunGard 2004-2005

Finance Fixed Assets Page 101

Section C: Day-to-Day Operations Lesson:

Summary

Let’s review As a result of completing this workbook, you have • • • • • • • • • • • •

Set up account codes for fixed assets Set up fixed asset fund codes Set up system-wide fixed asset defaults Determined the minimum value for fixed assets Created invoices for fixed assets Extracted origination tags from the temporary table Created and updated a master record for a fixed asset Created document tags Setup and depreciated an asset Performed adjustments on an asset Transferred records Queried and reported on records.

Quick Reference Your instructor may refer to forms, processes, reports, and tables using a seven-character name, rather than the object’s proper name. This quick key is provided for your convenience. Proper Name of Form Invoice/Credit Memo Fixed Asset Adjustment Fixed Asset Depreciation Fixed Asset Master Maintenance Fixed Asset System Control Maintenance Fixed Asset Transfer Fixed Asset Dtag Processing Fixed Asset Procurement Query Fixed Asset User Defined System Codes Validation Document Retrieval Inquiry System Control Maintenance Account Code Maintenance Commodity Maintenance Fund Code Maintenance Fixed Asset Type Code Maintenance

Seven Characters FAAINVE FFAADJF FFADEPR FFAMAST FFASYSC FFATRAN FFADTGP FFIPROC FFVSDAT FGIDOCR FOASYSC FTMACCT FTMCOMM FTMFUND FTMASTY

© SunGard 2004-2005

Finance Fixed Assets Page 102

Section C: Day-to-Day Operations Lesson:

Self Check

Directions Use the information you have learned in this workbook to complete this self check activity. Question 1 Which Banner form is used to create an invoice? Question 2 All accounts payable transactions may be viewed on FGIDOCR. True or False Question 3 Tags can be capitalized or not be capitalized. True or False Question 4 Which Banner form do you use to create a permanent tag? Which two fields on this form are required to create a permanent tag? Question 5 Can manually created tags be deleted? Question 6 How is the accounting and depreciation for an attachment handled? How is accounting and depreciation for a component handled? Question 7 What form do you use to view updates to the asset after the Depreciation Process (FFPDEPR) has been executed?

© SunGard 2004-2005

Finance Fixed Assets Page 103

Section C: Day-to-Day Operations Lesson:

Self Check (Continued)

Question 8 The Header area on FGIDOCR displays limited summary information; however, the lower area displays debit information for the transaction. True or False Question 9 The Fixed Asset Adjustment Form (FFAADJF) allows you to dispose of assets that have not been capitalized. True or False Question 10 What form do you use to convert an asset that was entered as a gift or donation? Question 11 What Banner function is used to adjust accumulated depreciation up or down for depreciable assets? Question 12 After you update past depreciation, it will create a posting to the ledgers. True or False Question 13 The GL Change Asset Account Function does not capitalize values on the general ledger. True or False Question 14 You can use the Fixed Asset Transfer form (FFATRAN) to track the location/owner of a fixed asset, and to assign a permanent tag to an asset. True or False

© SunGard 2004-2005

Finance Fixed Assets Page 104

Section C: Day-to-Day Operations Lesson:

Answer Key for Self Check

Directions Use the information you have learned in this workbook to complete this self check activity. Question 1 Which Banner form is used to create an Invoice? The Invoice/Credit Memo Form (FAAINVE) Question 2 All accounts payable transactions may be viewed on FGIDOCR. True Question 3 Tags can be capitalized or not be capitalized. True. You can choose to tag certain items that may have a unit cost below your capitalization limit. Question 4 Which Banner form do you use to create a permanent tag? The Fixed Asset Master Maintenance Form (FFAMAST) Which two fields on this form are required to create a permanent tag? The Permanent Tag # and Asset Type are the only two fields you must enter information to create a permanent tag. Question 5 Can manually created tags be deleted? Yes, but only if they are not capitalized and have no “adjustment” transactions (e.g., depreciation). Otherwise, they must be written off and disposed.

© SunGard 2004-2005

Finance Fixed Assets Page 105

Section C: Day-to-Day Operations Lesson:

Answer Key for Self Check (Continued)

Question 6 How is the accounting and depreciation for an attachment handled? Accounting and depreciation are included in the primary tag. How is accounting and depreciation for a component handled? A component is accounted and depreciated separately. Question 7 What form do you use to view updates to the asset after the Depreciation Process (FFPDEPR) has been executed? The Fixed Asset Depreciation Form (FFADEPR) Question 8 The Header area on FGIDOCR displays limited summary information; however, the lower area displays debit information for the transaction. True Question 9 The Fixed Asset Adjustment Form (FFAADJF) allows you to dispose of assets that have not been capitalized. False. This option creates capitalization postings to your ledger. Question 10 What form do you use to convert an asset that was entered as a gift or donation? The Fixed Asset Master Maintenance Form (FFAMAST) Question 11 What Banner function is used to adjust accumulated depreciation up or down for depreciable assets? The Depreciation Adjustment function on form FFAADJF

© SunGard 2004-2005

Finance Fixed Assets Page 106

Section C: Day-to-Day Operations Lesson:

Answer Key for Self Check (Continued)

Question 12 After you update past depreciation, it will create a posting to the ledgers. False. You must use the Depreciation Process (FFPDEPR) to post past depreciations to both ledgers. Recording Past depreciation assumes that the posting has already occurred and only updated the Fixed Asset Modules. Question 13 The GL Change Asset Account Function does not capitalize values on the general ledger. False. The GL Change Asset Account function capitalizes values for both the General Ledger and the Fixed Assets module. Question 14 You can use the Fixed Asset Transfer form (FFATRAN) to track the location/owner of a fixed asset, and to assign a permanent tag to an asset. True

© SunGard 2004-2005

Finance Fixed Assets Page 107

Section D: Reference Lesson:

Overview

Introduction The purpose of this section is to provide reference materials related to the workbook. Section contents Overview ..............................................................................................................................108 Setup Forms and Where Used ..............................................................................................109 Day-to-Day Forms and Setup Needed..................................................................................110 Forms Job Aid ......................................................................................................................111

© SunGard 2004-2005

Finance Fixed Assets Page 108

Section D: Reference Lesson:

Setup Forms and Where Used

Guide Use this table as a guide to the setup forms and the day-to-day forms that use them. Setup Form Day-to-Day Form(s) Form Name Code Form Name Code Fixed Asset Depreciation Code FTMDEPR Maintenance Form Fixed Asset Type Code FTMASTY Maintenance Form Fixed Asset Acquisition Code FFVACQM Maintenance Form Fixed Asset Condition Code FFCACON Maintenance Form All these set up forms are needed for Fixed Asset Title To Code FFVTTST maintaining fixed assets and are fundamental Maintenance Form for all the day-to-day forms listed on the Fixed Asset Disposal Method FFVDISP following page. Code Maintenance Form Fixed Asset User Defined FFVSDAT System Codes Validation Form Commodity Maintenance Form FTMCOMM Account Code Maintenance FTMACCT Form Fund Code Maintenance Form FTMFUND Fixed Assets System Control FFASYSC Form Finance System Control FOASYSC Maintenance Form

© SunGard 2004-2005

Finance Fixed Assets Page 109

Section D: Reference Lesson:

Day-to-Day Forms and Setup Needed

Guide Use this table as a guide to the day-to-day forms and the setup forms needed for each. Day-to-Day Form Setup Forms Needed Invoice/Credit Memo Form (FAAINVE) • All of these day-to-day forms rely on the data in the underlying set up forms listed on the previous page. • Finance System Control Maintenance Form (FOASYSC) Document Retrieval Inquiry Form • Invoice/Credit Memo Form (FAAINVE) (FGIDOCR) Fixed Asset Origination Tag Extraction • Same as above (FFPOEXT) Fixed Asset Procurement Query Form • Same as above (FFIPROC) Fixed Asset Master Maintenance Form • Same as above (FFAMAST) Fixed Asset Depreciation Form (FFADEPR) • Same as above Fixed Asset Master Maintenance Form • Same as above (FFAMAST) Fixed Asset Dtag Processing (FFADTGP) • Same as above Fixed Asset List Form (FFIFALV) • Same as above Fixed Asset Adjustment Form (FFAADFJ) • Same as above Depreciation Process (FFPDEPR) • Same as above Document Retrieval Inquiry Form • Same as above (FGIDOCR) Fixed Asset Transfer Form (FFATRAN) • Same as above

© SunGard 2004-2005

Finance Fixed Assets Page 110

Section D: Reference Lesson:

Forms Job Aid

Guide Use this table as a guide to the forms used in this workbook. The Owner column may be used as a way to designate the individual(s) responsible for maintaining a form. Form Name FTMDEPR FTMASTY FFVACQM FFCACON FFVTTST FFVDISP FFVSDAT FTMCOMM FTMACCT FTMFTYP FTMFUND FFASYSC FOASYSC

Form Description Fixed Asset Depreciation Code Maintenance Form Fixed Asset Type Code Maintenance Form Fixed Asset Acquisition Code Maintenance Form Fixed Asset Condition Code Maintenance Form Fixed Asset Title To Code Maintenance Form Fixed Asset Disposal Method Code Maintenance Form Fixed Asset User Defined System Codes Validation Form Commodity Maintenance Form Account Code Maintenance Form Fund Type Maintenance Form Fund Code Maintenance Form Fixed Assets System Control Form Finance System Control Maintenance Form

© SunGard 2004-2005

Owner

Finance Fixed Assets Page 111

Release Date

This workbook was last updated on 2/17/2006.