Skip to content
SkillReady to runNewFinance

Multi-Entity Depreciation

Written in-house · editorially graded

Every SkillsBank offering is written in-house — never scraped or crowd-sourced — and graded against a fixed editorial rubric in a separate grading step.

Dry-run test passed · Aug 16, 2026

Trigger check passed

Editorially graded · Aug 16, 2026

Consolidates existing subsidiary fixed-asset registers or ERP depreciation exports (SAP/NetSuite/Oracle, ad hoc XLSX/CSV) from two or more entities in different currencies and/or fiscal calendars into a linked multi-entity XLSX workbook with per-entity local-currency rollforwards, a currency-translated Master Consolidated Schedule, an FX/assumptions audit trail, a Data Quality/Gaps sheet, and a one-page PDF executive summary with an editable DOCX source. It applies ASC 830 currency-translation and ASC 810 consolidation/fiscal-alignment rules, flagging data gaps, useful-life outliers, and intercompany transfers rather than silently resolving them. This is a multi-entity, multi-currency consolidation workflow, not a single-entity depreciation schedule — use when a corporate finance, controllership, or consolidation team needs to roll up two or more subsidiaries' fixed-asset/depreciation data into one GAAP-consistent consolidated schedule and management summary for close, audit, or board reporting.

What you get

An installable SKILL.md file for your AI assistant. Produces an Excel workbook (.xlsx), a PDF, and a Word document (.docx).

Works in
Claude Code · Cursor
Native — drops into .claude/skills/
Copilot · Codex · Gemini CLI
Native — reads .agents/skills/
claude.ai — web & desktop
Upload the .zip in Customize → Skills
ChatGPT
Via a Project — paste into its instructions

See it in action

A real input → output sample

Sample input
Helios Manufacturing Inc. needs a consolidated depreciation rollup for December 2024 close. The parent currency is USD, and the period-end is 12/31/2024. Two entity source files are provided: Entity_Germany_NetSuite_Export.csv (EUR) and Entity_Brazil_Manual.xlsx (BRL). EUR/USD rates are given as prior period-end spot 1.0750, current period-end spot 1.0850, and weighted-average 1.1020. The Japan subsidiary file is missing, and there was an intercompany equipment transfer from Germany to Brazil in October without transaction-level detail.
Sample output
Sample output produced by the Multi-Entity Depreciation skill
Produced by an AI assistant following this skill on the sample input above.
View the full output as text
Example Output
Deliverables include an XLSX workbook (Helios_Consolidated_Depreciation_Rollup_2024-12-31.xlsx) with 5 tabs: Entity_Germany, Entity_Brazil, Master Consolidated Schedule, FX Rates & Assumptions, and Data Quality / Gaps. A PDF Executive Summary (Helios_Depreciation_Executive_Summary_2024-12-31.pdf) provides consolidated totals, entity contribution, FX translation impact, and judgment calls flagged. The output highlights missing items, including BRL/USD FX rates, Japan entity file, depreciation method/convention for Brazil, useful life for 3 German assets, land/building split, and intercompany transfer detail.

Goes well with

Related