Manage Fixed Assets and Depreciation

This skill is expert in fixed asset tracking systems, specializing in asset lifecycle management, depreciation calculations, compliance requirements, and financial reporting, with knowledge of GAAP, IFRS, and tax regulations. Its data model covers asset categories (Land, Buildings, Equipment, Vehicles, IT Assets, Furniture & Fixtures), critical fields (Asset ID, Description, Category, Location, Cost Basis, Acquisition Date, Useful Life, Salvage Value), status tracking (Active, Disposed, Retired, Under Construction, Fully Depreciated), and ownership types (Owned, Leased, Financed, Under Construction). It implements four depreciation methods - straight-line, double-declining balance (accelerated), units of production (usage-based), and MACRS (Modified Accelerated Cost Recovery System for tax purposes, with year-by-year rate tables for 3, 5, and 7-year asset classes). It covers database schema design (a fixed_assets master table, a depreciation_schedules table tracking beginning/ending book value per fiscal period, and an asset_movements table for transfers/disposals/impairments with gain/loss), barcode/RFID tagging with Code 128 generation and audit-scan lookup, compliance reporting (an annual depreciation report joining assets to schedules, and capitalization-threshold checks by category), automated monthly depreciation processing that skips fully depreciated assets, physical inventory reconciliation identifying missing and unexpected assets, and ERP integration that posts depreciation entries as balanced debit/credit general ledger entries.

Use this skill when building or auditing a fixed asset system that needs real depreciation calculation, compliance reporting, and GL integration - not a simple equipment inventory list. It names concrete capitalization thresholds by category (IT equipment $1,000, furniture $2,500, vehicles $5,000, buildings $10,000, land improvements $5,000) and supports both book and tax depreciation methods side by side, since GAAP and tax reporting often diverge. Its security and audit guidance calls for role-based access with segregation of duties, detailed audit trails, approval workflows for disposals above threshold, and annual physical inventory reconciliation - this is built for regulated financial reporting, not informal asset lists. It is not meant for simple non-financial equipment tracking that doesn't need depreciation, GL posting, or audit-trail compliance.

class DepreciationCalculator:
    def straight_line(self, cost_basis, salvage_value, useful_life_years):
        """Standard straight-line depreciation"""
        return (cost_basis - salvage_value) / useful_life_years
    
    def double_declining_balance(self, book_value, useful_life_years, year):
        """Accelerated depreciation method"""
        rate = 2 / useful_life_years
        return book_value * rate
    
    def units_of_production(self, cost_basis, salvage_value, total_units, units_used):
        """Usage-based depreciation for equipment"""
        per_unit_rate = (cost_basis - salvage_value) / total_units
        return per_unit_rate * units_used

Given asset acquisition data, the skill produces depreciation calculations across four methods like the ones above, a relational schema (fixed_assets, depreciation_schedules, asset_movements tables), barcode generation and audit-scan matching, an annual depreciation report for auditors, capitalization-threshold validation, a monthly automated depreciation run updating book values, physical inventory reconciliation flagging missing/unexpected assets, and balanced GL journal entries (debit depreciation expense, credit accumulated depreciation) for ERP posting.

Accounting, finance, and ERP integration teams building or maintaining fixed asset systems who need real GAAP/IFRS-compliant depreciation methods, audit-ready reporting, and general ledger integration rather than a simple asset spreadsheet. It suits organizations that need both book and tax depreciation tracked separately, standard compliance reports like Form 4562, and performance patterns (indexed lookup fields, fiscal-year table partitioning, cached depreciation calculations, batch monthly runs) sized for large asset registers.