> For the complete documentation index, see [llms.txt](https://www.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://www.bluegamma.io/documentation/pricers/calculating-a-swap-rate/reports.md).

# Reports

Download month-end clean and dirty MtM statements, accrued interest schedules and payment reports for your swap portfolio, with the methodology printed on the sheet.

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.

On the **Swap Pricer** page, open the **⋯** menu in the top right and click **Reports**.

<figure><img src="https://3184259219-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmmQPefoflG1RwUnUKKBR%2Fuploads%2Fgit-blob-673782d3301fdb73a6f3e51241ce56e2ab684e90%2Fimage.png?alt=media" 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, with a **Status** of Confirmed or Projected |

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

Reports show the book as it stood on the closing date. A swap traded after the closing date is left out, so an August pack pulled in October does not pick up September's trades. A swap traded on the closing date is included. When the period ends in the future, the book is taken as of today.

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%2Fgit-blob-b37610407ac23da0d7eaecd6354b23fe72e0360d%2Fimage.png?alt=media" 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, including each swap's PV01 at the closing date. It is the same figure, with the same sign, as the PV01 on the Swap Pricer page's **Traded** card.

Start, end, trade and payment dates are real Excel dates, so you can filter the workbook by year and month.

<figure><img src="https://3184259219-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmmQPefoflG1RwUnUKKBR%2Fuploads%2Fgit-blob-7ecc73657b24fb2614f391fee1a8dabd60e9b3ef%2Fseptember-2026-month-end-pack.png?alt=media" alt="The Detail sheet of the month-end pack with the PV01 column"><figcaption></figcaption></figure>

<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>

#### Portfolio Valuation

The **Download** button on the Swap Pricer page's **Traded** card exports a **Swap Portfolio Valuation** workbook of the book at the valuation time on screen:

* **Portfolio by Entity**: notional, weighted average fixed rate, final maturity, clean MtM, accrued interest, MtM and net PV01 per entity and currency.
* **Portfolio by Swap**: one row per swap, with its PV01.

Swaps traded after the valuation date are left out, and dates are real Excel dates, as in the month-end pack. To value the book at a month end, set the valuation time first: click the **Live** pill and pick **End of month**.

#### How Accrued Interest Is Calculated

The accrual conventions, sign, valuation timing and the identities every row satisfies are set out in [Swap Mark-to-Market & Accrued Interest](https://www.bluegamma.io/documentation/methodology/swap-mark-to-market.md).

#### Related

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

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

{% content-ref url="/pages/yAEYZXVZ9Xmoyxuce8uC" %}
[Swap Pricer](https://www.bluegamma.io/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 by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

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

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.
