Skip to Content
avatar image
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 comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • 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 comment
    10|10000 characters needed characters exceeded

  • 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 comment
    10|10000 characters needed characters exceeded

  • 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 comment
    10|10000 characters needed characters exceeded