Import fixed asset with accumulated depreciation

(0) Share

Report

Posted on by Kumar_Sat

1,290

Hello,

I am seeking some help on importing fixed assets. I have a requirement of importing assets with accumulated depreciation (in FA sub ledger). What should be my approach? For an example, I am an asset A acquired on Jan 1, 2017 with a life of 3 years. The acquisition value was $3600. The net book value as of June 30 2019 is $600. I have an accumulated depreciation of $2,400. How should I bring $2,400 (as depreciation) and $600 (as net book) so that I can continue depreciating it at $100 per month from Jul 31 to Dec 31 2019.

Categories:

Financial Management

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Suggested answer

SouravDam 11,732 on at

Like (0)

Report
Copy link

Link copied!

Hi Kumar,

You have to create 2 separate fixed assets journal. One journal has to post with acquisition value and the other one has to post with accumulated depreciation value. Once both journals are posted; system will show you the net book value of that asset.

Else; if you have large number of fixed assets; you have to do the following.

--- First; generate the template from data management. You can use the fixed asset journal entity to export the template.

--- Upload the acquisition value of fixed assets by using this entity. Post the fixed asset acquisition journal.

--- Upload the accumulated depreciation value of fixed assets by using this entity. Post the fixed asset accumulated depreciation journal.

Once both journals are posted; system will show you the net book value of that asset.

Best regards,
Sourav Dam

Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.

Was this reply helpful? Yes No
Kumar_Sat 1,290 on at

Like (0)

Report
Copy link

Link copied!

I am sorry but this does not answer my question. The moot question is not the data import but how to make sure the remaining life will remain the same and the depreciation per month should remain constant during the remaining period.

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,732 on at

Like (0)

Report
Copy link

Link copied!

Hi Kumar,

Acquisition value as on Jan 1, 2017 is $3600. You have a net book value $600 as on June 30, 2019.

The Accumulated depreciation value you mentioned as $2400.

This accumulated depreciation of $2400 is the total depreciation value for last 2 years upto Dec 31, 2018 considering that every month it was depreciated for $100. Question is;

--- Are you considering this depreciation value also as on date June 30, 2019 or considering it upto Dec 31, 2018 as ideally it calculates ?

--- If you are considering this depreciation value as a balance as on June 30, 2019, then where the depreciation amount of $600 you have recorded starting from Jan 1 to June 30, 2019 which ultimately leaves a net book balance of $600 as on June 30, 2019 ?

Kindly help me to understand this to get a better clarity.

Best regards,
Sourav Dam

Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Kumar,

When you make your import / transfer postings then - depending on how you make them - the remaining deprecation period number that you can find in the fixed asset books might change. Before you start using D365FO 'live' you can open the fixed asset books entity - for example in Excel - and double check that the periods are still ok. If they are not, you can directly update them via the Excel addin.

Best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 306,446 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Kumar,

With the replies from Saurav and Ludwig, you should be able to complete your task. Usually, I did import the assets with the value models, then did the acquisition and depreciation journals as stated above. Using the Asset master data sheet, I did another import to update the correct values for the remaining depreciation periods, acquisition date and last depreciation date.

When all was imported, I did create an asset journal to check if a new depreciation run would give the correct values.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Andre

When you brought the acquisition date/placed in service date and remaining periods, did you do this after you had posted both the Acq and Depr journals?

Was this reply helpful? Yes No
Suggested answer

BillurSamdancioglu 21,343 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Yes, You can either do that way with to update asset book or there is a feature for assets. You may activate that functionality. And mark assets as imported assets.

Was this reply helpful? Yes No