Skip to Content
author's profile photo Former Member
Former Member

Automating Specific Depreciation amounts

A client has an Excel spreadsheet where they have manually calculated an amount per year per asset for depreciation. There is not a consistent formula to apply and the amount is different for each asset each year. Is there a way to automate this? They will not be adding any new assets to this spreadsheet. These assets are tax only assets so it does not impact any of the financial ledgers.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Jan 25, 2018 at 05:31 PM


    If I undestood well, you want to upload the spreadsheet to the system with the irregular asset depreciation records. In this case you have the option to upload manual depreciation (ABMA) on those Assets Records. Thus you can vary the year amount.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 25, 2018 at 05:54 PM

    All I can say is that SAP supports tax calculations so if they want the data in SAP, it should be easy to load in the records with the amounts you have. If the client didn't consistently apply 200% DDB (example), then SAP may attempt to recalculate to compensate for any over/under depreciation. This would be a good thing in my opinion.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 25, 2018 at 11:28 PM

    Hi Rachel,

    You have not given out information such as

    1. if it is a cutover/opening upload (new implementation) or it is to be done in the running system with running data. Now Cutover and opening balance upload case still be possible in running system if you have new acquisition (new legal entity in the existing system) or merger (addition of data in the existing legal entity). What is your scenario?

    2. How many Depreciation area you have in the system along with Book depreciation area (generally 01)?

    3. Whether your assets in the excel belongs to current Fiscal year or from many fiscal years?

    I have two suggestion without much information about the your case:

    1. Upload the assets (custom program) and assign 'Manual Depreciation Key" (may be to only tax depreciation or to all depreciation area, you need to see your scenario) to all the assets in the excel. With this system might not apply its own mind to calculate depreciation and you might get success.

    2. Upload your assets with normal depreciation key and rate. System anyway does not pay attention to closed period depreciations, it will apply its own calculation for current fiscal year, and let that happen and later the do the manual adjustment with manual depreciation postings.

    We may provide you more suggestion if you layout all the details.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.