How to build a fixed asset depreciation schedule in Excel

Fixed assets are one of those accounting areas that look fine until the audit or tax request shows up. A single balance in the GL is not enough. I learned that after chasing old equipment invoices across AP folders, credit card statements, and one manager's email because nobody could explain why depreciation changed from one month to the next. My Excel schedule starts with one row per asset, not …