> For the complete documentation index, see [llms.txt](https://bluegamma.io/documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://bluegamma.io/documentation/pricers/calculating-a-swap-rate/reports.md).

# Reports

Month end usually means rebuilding the same schedules in Excel. Reports produces them from your portfolio in one download, with the methodology printed on the sheet.

Open it from **My Swaps → Reports**.

<figure><img src="https://3184259219-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmmQPefoflG1RwUnUKKBR%2Fuploads%2FaVIfkzwfLPHTyL0vhUIE%2Fimage.png?alt=media&amp;token=0b12be6c-3872-4b6a-8306-43d992c222dc" alt=""><figcaption></figcaption></figure>

#### What Teams Use This For

**Hedge accounting.** Pay Fixed and Receive Fixed movement is totalled separately per currency before netting — the split a hedge accounting pack books from.

**Audit.** The accrued interest sheet gives the four balances auditors ask for: opening, coupons, interest accrued, closing. Every row reconciles and the methodology is on the sheet, so the file can go straight to your auditor.

**Month-end journals.** One workbook to forward to whoever posts them.

#### The Reports

| Report                      | What it shows                                                                                        |
| --------------------------- | ---------------------------------------------------------------------------------------------------- |
| **Clean / dirty statement** | Notional, clean MtM, accrued and dirty MtM at the closing date. Clean + accrued = dirty on every row |
| **Accrued interest**        | Opening accrued, interest accrued, coupons settled, closing accrued and the movement                 |
| **Payments**                | Every cashflow in the period, settled and upcoming, by leg and net                                   |

Set the period with the date fields or the **Last month**, **Last quarter** and **Last year** shortcuts. Both ends value at end of day on that date's closing market data. Filter to a single entity with **All entities**.

Figures are in each swap's own currency — there is no cross-currency conversion.

#### Month-end Pack

Bundles all three into one workbook, one sheet per report.

<figure><img src="https://3184259219-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmmQPefoflG1RwUnUKKBR%2Fuploads%2FnpB42mqANHuwrEmRqPuG%2Fimage.png?alt=media&amp;token=38bf7b5e-3fff-4ed1-8321-ba345acff3f3" alt=""><figcaption></figcaption></figure>

Tick what you want — each shows its row count first — and click **Download pack**.

Every sheet carries its period, valuation basis and preparation timestamp, so the file explains itself to whoever receives it. A **Detail** sheet holds the underlying per-swap data at full precision, keyed on swap ID for reconciliation.

<figure><img src="https://3184259219-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmmQPefoflG1RwUnUKKBR%2Fuploads%2Fu9wfD2aBWpBb6q8fHHFS%2Fimage.png?alt=media&amp;token=5fafc52a-5fa9-41e2-a04e-6d90dd10c075" alt=""><figcaption></figcaption></figure>

#### How Accrued Interest Is Calculated

* Fixed leg accrual net of floating leg accrual since the last payment date.
* Balances accrue through the end of the balance date inclusive.
* Every row satisfies opening + accrued − settled = closing.
* A coupon paying on the closing date belongs to that period; one paying on the opening date belongs to the prior period.
* Sign follows trade direction. A positive balance is interest accrued in your favour.

#### Related

{% content-ref url="/pages/S7o7TlnhdPBHwXuqZUZs" %}
[Swap Mark-to-Market](/documentation/pricers/calculating-the-mtm-of-a-swap.md)
{% endcontent-ref %}

{% content-ref url="/pages/kTzZuhkEeiEMJ4HttvOS" %}
[Swap Mark-to-Market & Accrued Interest](/documentation/methodology/swap-mark-to-market.md)
{% endcontent-ref %}

{% content-ref url="/pages/yAEYZXVZ9Xmoyxuce8uC" %}
[Swap Pricer](/documentation/pricers/calculating-a-swap-rate.md)
{% endcontent-ref %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://bluegamma.io/documentation/pricers/calculating-a-swap-rate/reports.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
