{% extends "consol/base.html" %}{% load consol_tags %}
{% block title %}Worksheet{% endblock %}
{% block content %}
{% include "consol/_run_head.html" with tab="ws" %}
<section class="card">
  <div class="card-head"><h2>Consolidation worksheet</h2>
  <span class="exports">Export: <a href="{% url 'run_export' run.pk 'worksheet' 'xlsx' %}">XLSX</a> · <a href="{% url 'run_export' run.pk 'worksheet' 'csv' %}">CSV</a></span></div>
  <div class="checks">
    <span class="badge {% if r.checks.worksheet_balances == '0' %}ok{% else %}error{% endif %}">{% if r.checks.worksheet_balances == '0' %}✓ worksheet nets to zero{% else %}worksheet off by {{ r.checks.worksheet_balances|money }}{% endif %}</span>
    <span class="badge {% if r.checks.balance_sheet_difference == '0' %}ok{% else %}error{% endif %}">{% if r.checks.balance_sheet_difference == '0' %}✓ balance sheet balances{% else %}BS difference {{ r.checks.balance_sheet_difference|money }}{% endif %}</span>
    {% for code, d in r.checks.cta_checks.items %}<span class="badge {% if d == '0' %}ok{% else %}error{% endif %}">{% if d == '0' %}✓ {{ code }} CTA = analytic{% else %}{{ code }} CTA Δ {{ d|money }}{% endif %}</span>{% endfor %}
  </div>
  <div class="scroll">
  <table class="grid num worksheet">
    <thead><tr><th>Account</th>{% for c in r.columns %}<th class="r">{{ c }}<div class="small muted">{{ r.translations|get:c|get:"currency" }}→{{ r.presentation_currency }}</div></th>{% endfor %}
    <th class="r">Eliminations</th><th class="r">Adjustments</th><th class="r">Consolidated</th></tr></thead>
    <tbody>{% for row in r.rows %}{% with a=r.accounts|get:row.account %}
      <tr class="type-{{ a.type }}"><td><strong>{{ row.account }}</strong> {{ a.name }}</td>
      {% for c in r.columns %}<td class="r drill" data-acct="{{ row.account }}" data-col="{{ c }}">{{ row.entities|get:c|money }}</td>{% endfor %}
      <td class="r drill" data-acct="{{ row.account }}" data-col="eliminations">{{ row.eliminations|money }}</td>
      <td class="r drill" data-acct="{{ row.account }}" data-col="adjustments">{{ row.adjustments|money }}</td>
      <td class="r drill strong" data-acct="{{ row.account }}" data-col="consolidated">{{ row.consolidated|money }}</td></tr>
    {% endwith %}{% endfor %}</tbody>
  </table></div>
  <p class="small muted">Debit-positive; credits in parentheses. Entity columns are translated into {{ r.presentation_currency }} with the CTA balancing figure posted to 3200.</p>
</section>
<section class="card">
  <h2>Elimination &amp; NCI entries ({{ r.entries|length }})</h2>
  {% for e in r.entries %}
  <details id="{{ e.id }}"><summary><strong>{{ e.id }}</strong> <span class="badge">{{ e.kind }}</span> {{ e.description }}</summary>
  <table class="grid num small"><thead><tr><th>Account</th><th>Entity</th><th>Component</th><th class="r">Debit</th><th class="r">Credit</th></tr></thead><tbody>
  {% for l in e.lines %}<tr><td>{{ l.account }} {{ r.accounts|get:l.account|get:"name" }}</td><td>{{ l.entity }}</td><td>{{ l.component }}</td>
  <td class="r">{% if l.amount|slice:":1" != "-" %}{{ l.amount|money }}{% endif %}</td><td class="r">{% if l.amount|slice:":1" == "-" %}{{ l.amount|neg|money }}{% endif %}</td></tr>{% endfor %}
  </tbody></table></details>
  {% endfor %}
</section>
<div class="two-col">
<section class="card"><h2>Goodwill</h2>
<table class="grid num small"><thead><tr><th>Sub</th><th class="r">Consideration</th><th class="r">Net assets at acq.</th><th class="r">Holder eff.</th><th class="r">Group eff.</th><th class="r">Goodwill (hist.)</th><th class="r">At closing</th></tr></thead><tbody>
{% for g in r.goodwill %}<tr><td>{{ g.entity }}</td><td class="r">{{ g.consideration|money:0 }}</td><td class="r">{{ g.net_assets|money:0 }}</td><td class="r">{{ g.holder_effective|pct }}</td><td class="r">{{ g.effective|pct }}</td><td class="r">{{ g.goodwill_hist|money:0 }}</td><td class="r">{{ g.goodwill_closing|money:0 }}</td></tr>{% endfor %}
</tbody></table>
<p class="small muted">Goodwill = holder's effective % × consideration − group effective % × net assets at acquisition (proportionate NCI), retranslated at closing rate.</p></section>
<section class="card"><h2>Associates (equity method)</h2>
<table class="grid num small"><thead><tr><th>Associate</th><th>Holder</th><th class="r">%</th><th class="r">Profit</th><th class="r">Share of profit</th><th class="r">Carrying adj.</th></tr></thead><tbody>
{% for a in r.associates %}<tr><td>{{ a.entity }}</td><td>{{ a.holder }}</td><td class="r">{{ a.percent|pct }}</td><td class="r">{{ a.profit|money:0 }}</td><td class="r">{{ a.share_of_profit|money:0 }}</td><td class="r">{{ a.carrying_adjustment|money:0 }}</td></tr>{% empty %}<tr><td class="muted" colspan="6">None</td></tr>{% endfor %}
</tbody></table></section>
</div>
{% endblock %}