Sunday, November 9, 2014

Oracle Fixed Assets Accounting Entries

In the Assets module, following are some of the accounts we setup. Some accounts (like Clearing) are used by other modules as well.
Note: All of these accounts are natural accounts, and are created as flexfield values for the natural account (GL account) segment.


 
Account
Segment Qualifier
1Asset CostAsset Account
2Asset ClearingAsset Account
3Depreciation ExpenseExpense Account
4Accumulated DepreciationContra-Asset Account
5Deferred Depreciation ReserveLiability Account
6Deferred Depreciation ExpenseExpense Account
7Depreciation AdjustmentExpense Account
8Proceeds of Sale ClearingAsset Account
9Cost of removal ClearingLiability Account
10Gain & LossRevenue Account
   

Here are the entries made by FA.
Transaction
Natural Account
Debit
Credit
Asset is addedAsset Cost$100

Asset Clearing
$100
Asset DepreciationDepreciation Expense$100

Accumulated Depreciation
$100
Asset Retirement –
W/o proceeds and W/o removal cost
Accumulated Depreciation$60

Gain/Loss$40

Asset Cost
$100
Asset Retirement –
With Proceeds, W/o Cost of removal
Accumulated Depreciation$60

Gain/Loss$40

Gain/Loss
$10

Proceeds from Sale$10

Asset Cost
$100
Asset Retirement - 
With Cost of removal
Accumulated Depreciation$60

Gain/Loss$40

Gain/Loss$5

Cost of removal Clearing
$5

Asset Cost
$100


4 comments:

  1. Dr. Aloke Ghosh told me about this blog for tracking all the changes. I really wanted to know more about GL account. Thank you so much for this informative post!

    ReplyDelete
    Replies
    1. Thanks Derryn for your encouragement
      if you can queries, reach me @ nani.krishna@gmail.com

      Delete
  2. Thanks Derryn for your encouragement
    if you can queries, reach me @ nani.krishna@gmail.com

    ReplyDelete
  3. Hello,

    I have one query.. We have sold the asset and in the book control we have setup Proceed to Sale clearing account and Account generator.

    Now, while selling the asset in R12 for local account instead of considering Proceed to Sales clearing account it has considered Account generator account.

    Can you please let me know what can be the reason?

    thanks,

    Darshan

    ReplyDelete