---
title: "Retrieves an excel workbook of a series of profit and loss reports"
method: GET
path: "/profit_and_loss_excel"
tags: ["ProfitAndLossExcel"]
---

# Retrieves an excel workbook of a series of profit and loss reports

`GET /profit_and_loss_excel`

## Request

- Base URL: `https://example.myintranetapps.com/api`
- URL: `https://example.myintranetapps.com/api/profit_and_loss_excel`
- Auth: HTTP basic
- TypeScript: <https://skmtc.dev/bossinsights/apis/boss-insights/docs/profit_and_loss_excel/get.ts> (a function with typed inputs; its response is checked against the schema)

Retrieves an excel workbook of a series of profit and loss reports

## Query parameters

- `start` string, date-time
- `end` string, date-time
- `refresh` string

## Response `200`

ProfitAndLossExcel resource

- ProfitAndLossExcel: provides an excel workbook of a series of mapped profit and loss reports
  - `file` string

## Other responses

- `404`: Resource not found

---

[API](https://skmtc.dev/bossinsights/apis/boss-insights.md) - [All operations](https://skmtc.dev/bossinsights/apis/boss-insights/llms.txt) - [OpenAPI document](https://skmtc.dev/bossinsights/apis/boss-insights/revisions/d08a107895ad?raw)