An Image/Link below is provided (as is) to download presentationDownload Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.Content is provided to you AS IS for your information and personal use only. Download presentation by click this link.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.During download, if you can't get a presentation, the file might be deleted by the publisher.
E N D
Presentation Transcript
MINISTRY OF FINANCE IFMIS RE-ENGINEERING FIXED ASSETS process
Table ofContents 1.0 IFMIS Financial Management Operating Model 1.1 Overview Of Oracle Assets. 16 1.2 E-Business Suit Integration. 17 1.3 Oracle Assets Key Flexifields. 18 1.4 Asset Books Positioning. 19 1.5 Asset Life Cycle. 20 1.6 Adding Assets Manually. 21 1.7 Mass asset additions Process. 22 1.8 Acquire and Build CIP Assets. 23 1.9 Assets Adjustment Overview. 24 1.10 Elements Of Depreciation. 25 1.11 Tracking asset Retirements. 26 1.12 Assets Journal Entries Flow. 27 1.13 Reconciling Data In Oracle assets. 28 1.14 Viewing asset Information Online. 29 1.15 Oracle assets Reporting. 30 1.16 Assets Reports Groupings. 31 1.17 Asset Business Event Triggers. 32
Table ofContents 3.0 Mass Asset Additions 3.1 Mass Asset Additions Process. 67 3.2 Using the Mass Additions Interface Table. 68 3.3 Adding Assets from Invoice Distribution Lines. 69 3.4 The Mass Additions Process. 70 3.5 Requirements to Create Mass Addition Lines. 71 3.6 Required Fields and Mass Additions. 72 3.7 Automatic Preparation of Mass Additions Process. 73 3.8 Adding a Mass Addition Line to an Existing Asset. 74 3.9 Accounting for Cost Adjustments Example. 75
Table ofContents 4.0 Asset Retirements 4.1 Tracking Asset Retirements. 99 4.2 Overview of Retiring an Asset. 100 4.3 Reinstating Retired Assets. 101 4.4 Calculate Gains and Losses Program. 109 4.5 Processing a Pending Retirement and Reinstatement. 118 4.6 Calculating Depreciation for the Period Retired. 119 4.7 Recording Retirements and Reinstatements. 120 4.8 Recording Retirements. 121 4.9 Retirement Reports. 122 4.10 Retirement Reports. 123 4.11 Retirement Reports. 124
Table of Figures Figure I Asset Workbench Navigation. 37 Figure II Asset Workbench 38 Figure III Asset Workbech 39 Figure IV Asset Workbench 40 Figure V Asset Worbench 41 Figure VI Asset Workbench 42 Figure VII Asset Workbench 43 Figure VIII Asset Workbench 44 Figure IX Asset workbench 45 Figure X Asset Workbench 46 Figure XI Asset Workbench 47 Figure XIIAsset Workbench 54 Figure XIII Asset Workbench Quick Additions 55 Figure XIV Asset Workbench Quick Additions 56 Figure XV Asset Workbench Quick Additions 57 Figure XVI Asset Workbench Quick Additions 58 Figure XVII Asset Workbench Quick Additions 59
Table of Figures Figure XVIII Asset Workbench Quick Additions60 Figure XIX Asset Workbench Quick Additions 61 Figure XX Mass Additions Create Program 78 Figure XXI Prepare Mass Additions 79 Figure XXII Prepare Mass Additions 80 Figure XXIII Prepare Mass Additions 82 Figure XXIV Prepare Mass Additions 83 Figure XXV Prepare Mass Additions 84 Figure XXVI Prepare Mass Additions 85 Figure XXVII Prepare Mass Additions 86 Figure XXVIII Prepare Mass Additions 87 Figure XXIXPrepare Mass Additions 88 Figure XXX Prepare Mass Additions 89 Figure XXXI Prepare Mass Additions 90 Figure XXXII Prepare Mass Additions 91 Figure XXXIIIPrepare Mass Additions 92 Figure XXXIV Prepare Mass Additions 93
Table of Figures Figure XXXV Prepare Mass Additions 94 Figure XXXVI Prepare Mass Additions 95 Figure XXXVII Prepare Mass Additions 96 Figure XXXVIII Prepare Mass Additions 102 Figure XXXIX Prepare Mass Additions 103 Figure XL Reinstating Retired Assets 104 Figure XLI Reinstating Retired Assets 105 Figure XLII Reinstating Retired Assets 106 Figure XLIII Reinstating Retired Assets 107 Figure XLIV Reinstating Retired Assets 108 Figure XLV Reinstating Retired Assets 110 Figure XLVIReinstating Retired assets 111 Figure XLVII Calculate Gains and Losses Program 112 Figure XLVIII Calculate Gains and Losses Program 113 Figure XLIX Calculate Gains and Losses Program 114 Figure L Calculate Gains and Losses Program 115 Figure LI Calculate Gains and Losses Program 116
1.0 IFMIS Financial Management Operating Model Customers Ministries * Local Authorities * Parastatals/Quasi - Govt’s * Citizens Channels Telephone * Mail * Email * Fax * In - Person * Web * Contact Centre IFMIS Department Cash Financial Management Systems, Security & Application Support IFMIS Academy Compliance, Control & Query Management Fixed Assets Procure to pay Revenue to Cash Plan to Budget Record to Report
Overview of Oracle Asset Management
Objectives After completing this module, you should be able to do the following: Describe the overall Oracle Asset Management process from Setup through asset data flow to the General Ledger Identify the key functional areas that are part of Oracle Asset Management
Agenda Asset Management Process Overview Key Areas within Asset Management
1.2 E-Business Suite Integration Oracle Projects Invoice Lines Suppliers CIP assets Oracle Payables Oracle Purchasing Physical Inventory Asset Additions Budget Information Web ADI Oracle Assets/iAssets Spreadsheet Journal Entries Units of Measure Item Information Employees Oracle Inventory Oracle Human Resources Oracle General Ledger
1.3 Oracle Assets Key Flexfields To run the application, these key flexfields must be set up: Asset Category Key Flexfield Asset Location Key Flexfield Asset Key Key Flexfield
1.4 Asset Books Positioning New assets are assigned to a Category and to a Book Corporate Tax Budget Asset Books Assets Assigned to Asset Categories Asset Calendars Assigned to Depreciation Methods
1.5 Asset Life Cycle Manual Additions Quick Additions Detail Additions Oracle Payables Oracle Projects Other/ Legacy Systems WebADI Birth of an Asset FA_MASS_ADDITIONS AssetBooks Asset Retired Asset Depreciates
1.6 Adding Assets Manually Quick Additions Detail Additions Assets that require more information Assets added applying default rules Oracle Assets
1.7 Mass Asset Additions Process Oracle Projects Oracle Payables Other Systems FA_MASS_ADDITIONS Legacy System Web ADI Asset Books
1.8 Acquire and Build CIP Assets Asset Lines Oracle Projects Manual Additions FA_MASS_ADDITIONS Mass Additions Oracle Payables CIP ASSET
1.9 Asset Adjustment Overview
1.10 Elements of Depreciation Prorate Convention Asset Books Prorate Calendar Depreciation Method Depreciation Calendar Depreciation Units of Measure Depreciation Ceilings Investment Tax Credits Price Indexes Optional Elements
1.11 Tracking Asset Retirements Asset Life Automated addition Manual addition Invoice Transfer Adjustment Depreciation Createjournal entries
1.12 Assets Journal Entries Flow Run Create Accounting Run Depreciation to Generate Accounts Set up SLA Send entries to General Ledger No In Asset Books: -Allow GL Posting Yes -GL Ledger Name Post entries Run Transfer Journal Entries to GL
1.13 Reconciling Data in Oracle Assets Oracle General Ledger Oracle Assets Oracle Payables Oracle Projects
1.14 Viewing Asset Information Online Inquiry Depreciation Book Financial Information Employee Purchasing Information Location Invoice Supplier
1.15 Oracle Assets Reporting Oracle Assets Reports XML Publisher Reports Standard Reports Variable Format Reports (RXi) Report Manager Standard & Variable Format Reports
1.17 Asset Business Event Triggers Asset Addition Asset Transfer Asset Retirement
Manual Asset Additions
Objectives After completing this module, you should be able to do the following: * Discuss how manual asset additions fits into the Oracle Assets process * Discuss the two options for adding assets manually – Quick Additions and Detail Additions * List the required fields to add an asset * Discuss the difference between a Quick Addition and a Detail Addition * Explain the requirements to complete an asset Quick Addition (accept defaults)
Agenda Asset Life Cycle Asset Additions Required Data Quick Additions Detail Additions Manual Asset Additions Journal Entries Group Depreciation Energy Assets
2.1 Asset Additions Required Data To add an asset, the following fields require data: Asset Number Description Category Asset Type Units Book Cost Date Placed in Service Depreciation Expense Account Location
Asset Workbench Navigation Figure I Asset Workbench Navigation
Asset Workbench Figure II Asset Workbench
Asset Workbench Figure III Asset Workbech
Asset Workbench Figure IV Asset Workbench
Asset Workbench Figure V Asset Worbench
Asset Workbench Figure VI Asset Workbench
Asset Workbench Figure VII Asset Workbench
Asset Workbench Figure VIII Asset Workbench
Asset Workbench Figure IX Asset workbench
Asset Workbench Figure X Asset Wrkbench
Asset Workbench Figure XI Asset Workbench
2.2 Quick Additions Required Fields Optional Fields Asset Number Description Category Asset Type Units Book Cost Date Placed in Service Depr Expense Account Location Tag Number Category Descriptive Flexfield Serial Number Asset Key Supplier/PO Info Employee Info
2.3 Asset Cost Terminology Current Cost Original added cost +/- any cost adjustments Original Cost Original added cost - not updated after first period Recoverable Cost Current cost - salvage value - ITC basis reduction Net Book Value Current cost - accumulated depreciation
2.4 Accumulated Depreciation Considerations If you enter: The Oracle Assets System: Zero A/D Catches up all prior depreciation in the current period Too little A/D Books depreciation shortage in last period of asset's life Too much A/D Asset becomes fully reserved before the end of its life Just right A/D No depreciation adjustment required Entering Amounts in the Accumulated Depreciation (A/D) Field
2.5 Depreciate Checkbox Actions Depreciate Checkbox Asset depreciates as long as the checkbox is selected Depreciation from Date Placed in Service to date checked is charged in current period Check Later Start Depreciation for unchecked period(s) is taken in last period of asset's life Start Uncheck Recheck Later
2.6 Detail Additions - Assignments Window Fields in Detail Additions not previously discussed: Distribution Set Units to Assign
2.7 Detail Additions - Source Lines Window Supplier Invoice Number Line Description Name Number PO Number 12345 1 Laptop ABC Corp 7896 456963 Optionally enter the following information when adding an asset:
Asset Workbench Figure XII Asset Workbench
Asset Workbench Quick Additions Figure XIII Asset Workbench Quick Additions
Asset Workbench Quick Additions Figure XIV Asset Workbench Quick Additions
Asset Workbench Quick Additions Figure XV Asset Workbench Quick Additions
Asset Workbench Quick Additions Figure XVI Asset Workbench Quick Additions
Asset Workbench Quick Additions Figure XVII Asset Workbench Quick Additions
Asset Workbench Quick Additions Figure XVIII Asset Workbench Quick Additions
Asset Workbench Quick Additions Figure XIX Asset Workbench Quick Additions
2.8 Manual Asset Additions Journal Entries Asset Clearing Asset Clearing The journal entry created when manually adding an asset. Asset Cost 50,000 50,000 You must create a manual journal entry in General Ledger to clear the Asset Clearing Account. Appropriate Acct 50,000 50,000
Mass Asset Additions
Objectives After completing this module, you should be able to do the following: * Discuss how mass asset additions fits into the Oracle Assets process * Explain the 4 steps of the mass additions process * Explain how mass additions are utilized when converting to Oracle Assets * Explain which fields of the FA_MASS_ADDITION table are populated automatically and which fields must be manually added
* Discuss the preparation process that must be completed before mass addition lines can be added to Oracle Assets * Explain how posting mass addition lines adds assets to Oracle Assets * Discuss the mass additions delete and purge process used to clean up the FA_MASS_ADDITIONS table * Discuss the features of the Applications Desktop Integrator used to add assets Objectives
Agenda Mass Asset Additions Process * Create Mass Additions * Prepare Mass Additions * Post Mass Additions * Delete Mass Additions * Enter Future Transactions * Create Assets Using Web ADI
3.1 Mass Asset Additions Process Oracle Projects Oracle Payables Other Systems FA_MASS_ADDITIONS Legacy System Web ADI Asset Books
3.2 Using the Mass Additions Interface Table Create Mass Additions Process Invoice Lines Sent Oracle Payables Web ADI Upload to Interface Spreadsheet Rows FA_MASS_ADDITIONS Table Interface Assets Process Asset Lines Sent Oracle Projects
3.3 Adding Assets from Invoice Distribution Lines Add invoice lines Mass Additions process OraclePurchasing Oracle Payables (or other system) Oracle Assets Add CIP asset lines Oracle Projects Create journal entries Run depreciation Depreciation journal
3.4 The Mass Additions Process Create Mass Additions 1 Prepare Mass Additions 2 Oracle Payables FA_MASS_ADDITIONS 3 Add Cost adjustment Merge Split Post Mass Additions Delete Mass Additions 3 4 Delete Purge
3.5 Requirements to CreateMass Addition Lines Invoice line must be charged to an asset account The asset account charged must be set up as a clearing account in any Asset category Select the Track as Asset check box The AP invoice must be validated and accounted In Oracle Payables The AP invoice is transferred to the General Ledger
3.6 Required Fields and Mass Additions
3.7 Automatic Preparation of Mass Additions Process Lines FA_MASS_ADDITIONS Lines Lines Oracle Payables (or other system) Set up rules Run the Prepare Mass Additions program Post Mass Additions Verify data
3.8 Adding a Mass Addition Line to an Existing Asset Mass Addition line for peripherals Existing asset #82586 1,000 5,000 Existing asset #82586 Now 6,000 Amortize Adjustment Post Mass Additions
3.9 Accounting for Cost Adjustments Example The Scenario: Original Cost = $120,000 Life: 60 months Straight-line depreciation method … In month 31 Additional Cost of $6,000
Summary In this module, you should have learned how to: * Discuss how mass asset additions fits into the Oracle Assets process * Explain the 4 steps of the mass additions process * Explain how mass additions are utilized when converting to Oracle Assets * Explain which fields of the FA_MASS_ADDITION table are populated automatically and which fields must be manually added
* Discuss the preparation process that must be completed before mass addition lines can be added to Oracle Assets * Explain how posting mass addition lines adds assets to Oracle Assets * Discuss the mass additions delete and purge process used to clean up the FA_MASS_ADDITIONS table * Discuss the features of the Applications Desktop Integrator used to add assets Summary
Mass Additions Create Program Figure XX Mass Additions Create Program
Prepare Mass Additions Figure XXI Prepare Mass Additions
Prepare Mass Additions Figure XXII Prepare Mass Additions
Asset Retirements
Prepare Mass Additions Figure XXIII Prepare Mass Additions
Prepare Mass Additions Figure XXIV Prepare Mass Additions
Prepare Mass Additions Figure XXV Prepare Mass Additions
Prepare Mass Additions Figure XXVI Prepare Mass Additions
Prepare Mass Additions Figure XXVII Prepare Mass Additions
Prepare Mass Additions Figure XXVIII Prepare Mass Additions
Prepare Mass Additions Figure XXIX Prepare Mass Additions
Prepare Mass Additions Figure XXX Prepare Mass Additions
Prepare Mass Additions Figure XXXI Prepare Mass Additions
Prepare Mass Additions Figure XXXII Prepare Mass Additions
Prepare Mass Additions Figure XXXIII Prepare Mass Additions
Prepare Mass Additions Figure XXXIV Prepare Mass Additions
Prepare Mass Additions Figure XXXV Prepare Mass Additions
Prepare Mass Additions Figure XXXVI Prepare Mass Additions
Prepare Mass Additions Figure XXXVII Prepare Mass Additions
Objectives After completing this module, you should be able to do the following: * Discuss how asset retirements fits within the Oracle Assets process * Explain the necessity of tracking asset retirements and proper recording of accounting transactions * Discuss the Calculate Gains and Losses program and its role in asset retirements * Discuss the ability to reinstate asset retirements
Agenda * Tracking Asset Retirements * Full and Partial Asset Retirements * Mass Asset Retirements * External Retirements * Reinstating Retirements * Accounting for Retirements * Retirement Reports
4.1 Tracking Asset Retirements Asset Life Automated addition Manual addition Invoice Transfer Adjustment Depreciation Createjournal entries
4.2 Overview of Retiring an Asset Asset to retire Full retirement Partial retirement Entire units and entire cost Partial unit Partial cost Retired asset
4.3 Reinstating Retired Assets Oracle Assets makes it easy to reinstate formerly retired assets.
4.4 Calculate Gains and Losses Program Run the calculate gains and losses program to: • Calculate gains and losses resulting from retirements • Correct the accumulated depreciation for reinstated assets • Calculate Investment Tax credit recapture for retired assets in a tax book, if necessary
Calculate Gains and Losses Program Figure XLV Calculate Gains and Losses Program
Calculate Gains and Losses Program Figure XLVI Calculate Gains and Losses Program
Calculate Gains and Losses Program Figure XLVII Calculate Gains and Losses Program
Calculate Gains and Losses Program Figure XLVIII Calculate Gains and Losses Program
Calculate Gains and Losses Program Figure XLIX Calculate Gains and Losses Program
Calculate Gains and Losses Program Figure L Calculate Gains and Losses Program
Calculate Gains and Losses Program Figure LI Calculate Gains and Losses Program
Calculate Gains and Losses Program Figure LII Calculate Gains and Losses
4.5 Processing a Pending Retirementand Reinstatement
4.6 Calculating Depreciation for the Period Retired Factors that affect the period depreciation of an asset retired: Effective date of the retirement Depreciate-in-Year-Retired flag Retirement convention Depreciate if Retired in First Year flag in the Book Controls window
4.7 Recording Retirements and Reinstatements Asset Type Action CapitalizedCIP* Expensed 1. Charges or reverses depreciation for theyear retired 2. Removes the asset cost and accumulated depreciation from the corresponding accounts Clears the proceeds of sale and the cost of removal Recognizes gain or loss from the retirement 5. Creates no journal entries * Construction-in-Process
4.8 Recording Retirements Calculating the Gain or Loss from an Asset Sale - - Sale proceeds Removal cost Retired net book value Retired revaluation reserve + = Gain/Loss
4.9 Retirement Reports Report Name Description Form 4684: Casualties Shows the asset retirements with and Thefts Report the retirement type that you request Retired Assets Without Shows the retired assets without Property Class Report a 1245 or 1250 property class Retired Assets Without Shows retired assets without Retirement Types assigned types Report Asset Retirements by Shows the asset retirements for Cost Center each cost center for the book and period that you select with an asterisk (*) next to reinstated assets
4.10 Retirement Reports Report Name Description Asset Retirements Shows the assets that you retired Report for the Book and accounting period range that you select Asset Disposals Shows the assets that you removed Responsibility Report from the cost centers through retirements and transfers, and the location of each unit Reinstated Assets Shows reinstatement for the Book Report and From/To period range Tax Retirement Report Shows gain or loss and any ITC recapture for asset retirements
4.11 Retirement Reports Report Name Description Mass Retirements Reviews the mass retirement effect before you process it Mass Retirements Identifies exception assets not Exception Report retired as part of the mass retirement program Retirements Report Reviews the assets retired for the book and accounting period range selected
Summary After completing this module, you should now be able to: Discuss how asset retirements fits within the Oracle Assets process Explain the necessity of tracking asset retirements and proper recording of accounting transactions Discuss the Calculate Gains and Losses program and its role in asset retirements Discuss the ability to reinstate asset retirements
Objectives After completing this module, you should be able to do the following: * Perform the asset Financial Information and Transaction History inquiries * Discuss the key Asset Management reports that are utilized by an implementer to assist in the implementation of Asset Management * Explain the use of Variable Format Reports in Asset Management
5.1 Viewing Asset Information Online Inquiry Financial Information Depreciation Book Employee Purchasing Information Location Invoice Supplier
5.2 Types of Asset Inquiries You can view and query assets online in Oracle Assets without having to remember asset numbers. To find asset by Detail Assignment Source Line Lease Search Criteria Asset Number, Description, Category Employee, Expense Acct, Location Supplier, Invoice, Project, Task Lessor, Lease Number or Description
5.3 Viewing Financial Information Financial Information Books Window Assignments Source Lines Transaction History Depreciation History Cost History Transaction Detail
5.4 Viewing Transaction History Transaction History Find Transactions Transaction History Details
5.5 Viewing Transaction Accounting Financial Information Transaction History window Books window Transaction Accounting Account Dr Cr Asset Cost 900 Asset Clearing 900
Financial Information Figure LXXIII Financial Information
Financial Information Figure LXXIV Financial Information
Financial Information Figure LXXV Financial information
Financial Information Figure LXXVI Financial Information
Financial Information Figure LXXVII Financial Information