ATTACHMENT G
2008 SAP Calendarised Asset Depreciation Budget Template Procedure
The SAP Calendarised Asset Depreciation Budget Template (located on the Finance Division Web Page) has been developed to assist in calculating the depreciation of an asset. The process is two fold:1) A SAP Depreciation Simulation report is run for all existing assets. The report provides the forecast for 2008 depreciation amounts for all existing assets. This information is entered into the spreadsheet “input from SAP” report. 2) Movements from the time the report was run to the end of the 2008 budget year is then recorded into the spreadsheet to determine the total depreciation for the 2008 Budget year. Calculation of depreciation for assets with a value greater than $5000: 1. Enter a description of each asset to be purchased in the column marked “DESCRIPTION”, above the appropriate category. 2. Enter the total purchase amount of the asset in the column marked “ASSET VALUE”. 3. Enter the expected month of purchase in the format JAN, FEB, MAR etc. 4. Note that asset purchases after the SAP Depreciation Simulation report is run, will not appear on the SAP report and will require separate entry on the template, with the month of Purchase for 2008 depreciation being “JAN”. Please highlight assets purchased in 2007. 5. For existing assets, enter in the row marked “Depreciation – 2007 Assets > $5,000” the total depreciation expense for the cost centre’s existing assets, this amount is found in the bottom line of the SAP report “Depreciation Simulation – 01 Book Deprc”. The remainders of the fields are self-calculating fields and show the depreciation on a monthly basis as well as the depreciation for the year in the column marked “TOTAL”. 6. Insert the total depreciation amount into the Budget template. Please input deprecation and amortization (506010 and 506020) amount in the Controlling Module of SAP. 7. Insert the total capital expenditure amount (150888) asset value for 2008 in the Finds Management Module of SAP.