Skip to main content

Accounting entries for the Asset Life Cycle


Accounting entries for the Asset Life Cycle


Finally am able to put the detailed accounting entries for the Asset Cycle. As highlighted in one of the post Oracle Assets creates journal entries for the following general ledger accounts:
  1. Asset Cost
  2. Asset Clearing
  3. Depreciation Expense
  4. Accumulated Depreciation
  5. Revaluation Reserve
  6. Revaluation Amortization
  7. CIP Cost
  8. CIP Clearing
  9. Proceeds of Sale Gain, Loss, and Clearing
  10. Cost of Removal Gain, Loss, and Clearing
  11. Net Book Value Retired Gain and Loss
  12. Intercompany Payables
  13. Intercompany Receivables
  14. Deferred Accumulated Depreciation
  15. Deferred Depreciation Expense
  16. Depreciation Adjustment
The setup of these accounts is done while you defining the asset books as per below. The number for above accounts can usually map it with Oracle seeded screen of setup;.
FA ACCOUNTS
Fig 1: Accounts and accounting in Fixed Assets
FA ACCOUNTS1
Fig 2: Accounts and accounting in Fixed Assets
Next we will see the different accounting at various transactional events.
dgreybarrow Depreciation Accounting
Whenever you run depreciation, Oracle Assets creates accounting entry with your accumulated depreciation accounts and your depreciation expense accounts. Oracle Assets creates separate journal entries for current period depreciation expense and for adjustments to depreciation expense for prior period transactions and changes to financial information.
Oracle Assets creates the following journal entries for a current period depreciation charge of AU$ 200:
FA accounts 1
dgreybarrow Current and Prior Period Addition
Read this previous post on mass addition:
The recoverable cost is AU$ 4,000 and the method is straight-line 4 years. You purchase and place the asset into service in Year 1, Quarter 1.
FA accounts 2
FA accounts 3
You place an asset in service in Year 1, Quarter 1, but you do not enter it into Oracle Assets until Year 2, Quarter 2. Your payables system creates the same journal entries to asset clearing and accounts payable liability as for a current period addition.
FA accounts 4
dgreybarrow Merge Mass Additions
When you merge two mass additions, Oracle Assets adds the asset cost of the mass addition that you are merging to the asset account of the mass addition you are merging into. Oracle Assets records the merge when you perform the transaction. Oracle Assets does not change the asset clearing account journal entries it creates for each line, so each of the appropriate clearing accounts clears separately.
FA accounts 5
dgreybarrow Construction-In-Process (CIP) Addition
You add a CIP asset. (CIP assets do not depreciate )
FA accounts 6
dgreybarrow Capitalization
Once you decide that a CIP asset is completed you can capitalize it very easily.
Navigation: Assets > Capitalize CIP Assets
A capitalization transaction is similar to an addition transaction: you place the asset in service so you can begin depreciating it. When you capitalize an asset in the period you added it, Oracle Assets creates the following journal entries:
FA accounts 7
FA accounts 8
When you capitalize an asset in a period after the period you added it, Oracle Assets creates journal entries that transfer the cost from the CIP cost account to the asset cost account. The clearing account has already been cleared.
FA accounts 9
dgreybarrow Deleted Mass Additions
Oracle Assets creates no journal entries for deleted mass additions and does not clear the asset clearing accounts credited by accounts payable. You clear the accounts by either reversing the invoice in your payables system, or creating manual journal entries in your general ledger.
dgreybarrowAsset Type Adjustments
If you change the asset type from capitalized to CIP, Oracle Assets creates journal entries to debit the CIP cost account and credit the asset clearing account. Oracle Assets does not create capitalization or reverse capitalization journal entries for CIP reverse transactions.
FA accounts 10
dgreybarrowCost Adjustments to Assets
Understand this way, you placed an asset in service in Year 1, Quarter 1. The recoverable cost is AU$4,000. The life of your asset is 4 years, and you are using straight-line depreciation. In Year 1, Quarter 4, you receive an additional invoice for the asset and change the recoverable cost to AU$4,800.
FA accounts 11
Expense will go at it:
FA accounts 13
Amortized
FA accounts 14

dgreybarrowReinstatement
Current Period Reinstatement
FA accounts 15
dgreybarrow Reclassification
Read these post for greatest
When you reclassify an asset from office equipment to computers in Year 1, Quarter 3. The asset cost is AU$4,000, the life is 4 years, and you are using straight-line depreciation
FA accounts 16

FA accounts 17
dgreybarrow Transfer Asset
Read this earlier post on asset transfer .
In Year 2, Quarter 2, you transfer the asset from cost center 100 to cost center 200 in the current period
FA accounts 18
In Year 3, Quarter 4, you transfer the asset from the ABC Manufacturing Company to the XYZ Distribution Company.
FA accounts 19
you place the same AU$4,000 asset in service with two units assigned to cost center 100. In Year 2, Quarter 3, you realize the asset actually has four units, two of which belong to cost center 200. If all units remain in the original cost center, Oracle Assets does not create any journal entries.
FA accounts 20
Take a note, majority of case the accounting entry happen when you run Create Journal or create accounting .Hope this helps.:)

Comments

  1. Oracle Apps R12 and Fusion Cloud Self Paced Training Videos by Industry Experts. Please Check https://www.oracleappstechnical.com

    ReplyDelete

Post a Comment

Popular posts from this blog

Create Accounting for a Payment generates errors 95333 and 95359

Create Accounting for a Payment generates errors 95333 and 95359 Error: 95333: A conversion rate does not exist to convert USD to AUD for the conversion type Corporate and conversion date 20-MAR-09 for line -25. Please use the Daily Rates form in General Ledger to enter a conversion rate for these currencies, conversion date and conversion type. 95359: There is no accounted amount for the subledger journal entry line. Please inform your system administrator or support representative that: The source assigned to the accounting attribute Accounted Amount has no value for extract line number 88547. Please make sure the source assigned to the accounting attribute Accounted Amount has a valid value, or assign a different source to this accounting attribute. Solution: 1. Specify a conversion rate for the currencies and conversion date mentioned in the error message 95333 Navigation under the General Ledger responsibility: Setup > Currencies > Currency Rates Manager > Daily Rates ...

Public API’s for FA Transactions

Public API’s for FA Transactions So far Oracle FA is have all the good things except the lack on reporting.Oracle FA is now offer lot of public API's that can be used to interfacing with third party or Oracle application other modules. Here are some of transaction's API's:   Additions API if you have requirement to add assets directly via PL/SQL then use  FA_ADDITION_PUB.DO_ADDITION. If you have selected the Allow CIP Assets check box on the Book Controls window of a tax book when adding CIP assets using the Additions API, the this API automatically adds those CIP assets to that tax book at the same time that they are added to the corporate book. Adjustments API you can make cost adjustments to your assetsdirectly via PL/SQL using  FA_ADJUSTMENT_PUB.DO_ADJUSTMENT  for any  process adjustment. Detail can be found in appendix H) You can use this API if you have a custom interface that makes it difficult to use with the existing Oracle Assets interfaces for adjusti...

AP Table Relation Oracle Apps

AP Table Relation Oracle Apps ORACLE PAYABLE TABLE RELATION Source Table Dependent Table Condition AP_INVOICE_LINES_ALL AIL ZX_LINES_SUMMARY ZLS AIL.invoice_id = ZLS.trx_id and  ZLS.application_id  = 200 and  ZLS.entity_code  = 'AP_INVOICES' and  ZLS.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and  AIL.summary_tax_line_id = ZLS.summary_tax_line_id AP_INVOICE_LINES_ALL AIL ZX_LINES ZL AIL.invoice_id = ZL.trx_id and  ZL.application_id  = 200 and  ZL.entity_code  = 'AP_INVOICES' and  ZL.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and  AIL.line_number = ZL.trx_line_number AP_INVOICE_DISTRIBUTIONS_ALL AID ZX_REC_NREC_DIST ZD AID.invoice_id = ZD.trx_id and  ZD.application_id  = 200 and  ZD.entity_code  = 'AP_INVOICES' and  ZD.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and...