Depreciation calc query for RB method DPIS in past
Hi,
Please could someone assist in the below query:
I don't agree with Oracle's depreciation calculation on an asset I have copied to the Tax Book from a Statutory book. Below are the asset details and the output of the depreciation report. We are using a Reduced Balance method of 25% of NBV. A pro-rate convention of mid-month is in use which means the depr start date of the asset should be 01JUL13. The current period is Feb16. Fiscal year is Jan to Dec. Please also see the excel document attached to view my formulas to do the recalculation.
Further to this, when I query this asset and change the DPIS date to 29JUN13 which still results in a depreciation start date of 01JUL13 and save and query the asset again, the Accumulated Depreciation is then calculated correctly (see screenshot below and bare in mind that this calculation will be to end of Jan16 and not Feb16. Also see the 2nd line on the calculation above which is until Jan16 and agrees to calculation below). (This calculation stays the same as below when the DPIS is changed back to 30JUN13)