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

Oracle Subledger Accounting (SLA) Tables, Views

Oracle Subledger Accounting (SLA) Tables, Views Oracle Subledger Accounting Tables: TABLE NAME DESCRIPTION XLA_AAD_GROUPS The XLA_AAD_GROUPS table stores the merge dependencies analyzed during the merge analysis.  All application accounting definitions with the same GROUP_NUM must be merged together. XLA_AAD_HDR_ACCT_ATTRS The XLA_AAD_HDR_ACCT_ATTRS stores standard, system and custom sources assigned to an accounting attribute at the AAD level. XLA_AAD_HEADER_AC_ASSGNS Store the analytical criteria for the application accounting definitions. XLA_AAD_LINE_DEFN_ASSGNS This table stores the journal lines definitions for the application accounting definitions. XLA_AAD_LOADER_DEFNS_T The XLA_AAD_LOADER_DEFNS_T table is the interface table that facilitates the data transfer from data files and the database. XLA_AAD_LOADER_LOGS The XLA_AAD_LOADER_LOGS table stores the errors and logs generated by the application accounting definitions loader. XLA_AAD_SOURCES XLA_AAD_SOURCES table stores a...

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...

Unbilled Receivables and Unearned Revenue Accounting in Oracle Projects

Unbilled Receivables and Unearned Revenue Accounting in Oracle Projects Introduction When it comes to contractual billing, invoice and revenue generation are two separate processes, which during the lifespan of a project may or may not always coincide with each other and so do the balances in revenue and receivables accounts.  This interim difference between revenue and invoice account balances is bridged using Unbilled Receivables (UBR) and Unearned Revenue (UER) Accounts. Unearned Revenue (UER) Unearned Revenue (also termed as deferred revenue or UER) signifies money received for the goods or services, which are yet to be delivered.  As per the principles of Revenue Recognition, UER is recorded as on the balance sheet unless it is converted to Revenue upon delivery of goods or services For Example XYZ Consulting Ltd. receives an annual maintenance contract of $ 12,000 on Dec 31, 2014 for the period of Jan 01, 2015 to Dec 31, 2015. At the start of the contract as of Dec 31, 2...