Report the depreciation calculation in an Excel format. This expedites the JV process and reporting in the CAFR.
The depreciation report provides detail of each asset. This report should be available in Excel, then sorted by asset for the jv entry to post in the general ledger. Also the Excel format provides the depreciation by function required in the CAFR.
We plan to make changes to Fixed Asset reporting this year. The depreciation report itself may not go to excel, but we are reviewing including the Accum and Current Depreciation on the Fixed Asset Listing.