DoorLoop

DoorLoop Reports API

The Reports API from DoorLoop — 4 operation(s) for reports.

Documentation GitHub OpenAPI

Operations 4

GET /reports/balance-sheet-summary Balance Sheet #

GET /reports/cash-flow-statement Cash Flow Statement #

GET /reports/profit-and-loss-summary Profit & Loss #

GET /reports/rent-roll Rent Roll #

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this

find_apisBrowse and filter every API in the catalog.
get_api_artifactsOne API's artifacts, grouped by type.
get_openapiThe primary OpenAPI for this API.
find_similar_apisAPIs that look like this one.
apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
resolveTurn a domain, URL or GitHub org into the provider it belongs to.
find_cohortsEvery scored population of providers in the catalog.

All 92 tools →

Call it yourself

curl for this page

This API

curl "https://apis.io/api/v1/apis/doorloop:doorloop-reports-api"

All apis

curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

openapi: 3.2.0
info:
  title: DoorLoop API Reference Reports API
  version: '1.0'
  summary: This is the DoorLoop API
  description: It does some pretty cool stuff and gives you complete access to DoorLoop's data
  license:
    name: Terms and Conditions
    url: https://www.doorloop.com/legal/terms
  contact:
    name: DoorLoop Inc.
    url: www.doorloop.com
    email: support@doorloop.com
  termsOfService: https://www.doorloop.com/legal/terms
servers:
- url: https://app.doorloop.com/api
  description: Production
tags:
- name: Reports
paths:
  /reports/balance-sheet-summary:
    parameters: []
    get:
      summary: Balance Sheet
      tags:
      - Reports
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/profitAndLossReportItem'
              examples: {}
      operationId: get-reports-balance-sheet
      security:
      - Key: []
      parameters:
      - schema:
          type: string
        in: query
        name: filter_group
        description: Filter by Portfolio Id
      - schema:
          type: string
        in: query
        name: filter_property
        description: Filter by Property Id
      - schema:
          type: string
        in: query
        name: filter_propertyOwner
        description: Filter by Owner Id
      - schema:
          type: string
          enum:
          - CASH
          - ACCRUAL
        in: query
        name: filter_accountingMethod
        required: true
        description: Cash / Accrual
      - schema:
          type: string
        in: query
        name: filter_date_from
        description: 'Format: YYYY-MM-DD'
      - schema:
          type: string
        in: query
        name: filter_date_to
        description: 'Format: YYYY-MM-DD'
      description: ''
  /reports/cash-flow-statement:
    parameters: []
    get:
      summary: Cash Flow Statement
      tags:
      - Reports
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/profitAndLossReportItem'
              examples: {}
      operationId: get-reports-cash-flow-statement
      security:
      - Key: []
      parameters:
      - schema:
          type: string
        in: query
        name: filter_group
        description: Filter by Portfolio Id
      - schema:
          type: string
        in: query
        name: filter_property
        description: Filter by Property Id
      - schema:
          type: string
        in: query
        name: filter_propertyOwner
        description: Filter by Owner Id
      - schema:
          type: string
          enum:
          - CASH
          - ACCRUAL
        in: query
        name: filter_accountingMethod
        required: true
        description: Cash / Accrual
      - schema:
          type: string
        in: query
        name: filter_date_from
        description: 'Format: YYYY-MM-DD'
      - schema:
          type: string
        in: query
        name: filter_date_to
        description: 'Format: YYYY-MM-DD'
      description: ''
  /reports/profit-and-loss-summary:
    parameters: []
    get:
      summary: Profit & Loss
      tags:
      - Reports
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/profitAndLossReportItem'
              examples:
                example-1:
                  value:
                    columns:
                    - title: string
                      field: string
                    data:
                    - accountType: string
                      accountName: string
                      accountId: string
                      rootAccount: true
                      parentAccountId: null
                      total: 0
                      totalWithSubAccounts: 0
                      groupBy:
                        ? ''
                        : string
      operationId: get-reports-profit-and-loss
      security:
      - Key: []
      parameters:
      - schema:
          type: string
        in: query
        name: filter_group
        description: Filter by Portfolio Id
      - schema:
          type: string
        in: query
        name: filter_property
        description: Filter by Property Id
      - schema:
          type: string
        in: query
        name: filter_propertyOwner
        description: Filter by Owner Id
      - schema:
          type: string
          enum:
          - CASH
          - ACCRUAL
        in: query
        name: filter_accountingMethod
        required: true
        description: Cash / Accrual
      - schema:
          type: string
        in: query
        name: filter_date_from
        description: 'Format: YYYY-MM-DD'
      - schema:
          type: string
        in: query
        name: filter_date_to
        description: 'Format: YYYY-MM-DD'
      description: ''
  /reports/rent-roll:
    get:
      summary: Rent Roll
      tags:
      - Reports
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                type: object
                x-examples:
                  example-1:
                    active: true
                    unitId: 601aad8e4fdad2298bb88162
                    unitName: '12'
                    unitAmenities: []
                    beds: 1
                    baths: 2
                    size: 1111
                    bedsAndBaths: 1/2
                    marketRent: 1000
                    property: 601aad884fdad2298bb88158
                    pictures: []
                    occupied: true
                    leaseId: 601aada84fdad2298bb881a8
                    leaseName: Tenant Portal7 & Tenant Portal8
                    start: '2021-02-03'
                    end: '2023-01-07'
                    term: Fixed
                    totalRecurringRent: 1000
                    rentPerSize: 0.9000900090009001
                    totalBalanceDue: 2000
                    leaseStatus: PAST_DUE
                    totalDepositsHeld: 0
                    renewalStage: NOT_STARTED
                    totalRecurringCharges: 0
                    totalRecurringCredits: 0
                    totalRecurringPayments: 0
                    lastPaymentDate: '2021-02-23'
                    lastPaymentAmount: 1000
                    lastReturnedPaymentDate: '2021-05-01'
                    lastReturnedPaymentAmount: -1000
                properties:
                  active:
                    type: boolean
                  unitId:
                    type: string
                  unitName:
                    type: string
                  unitAmenities:
                    type: array
                    items:
                      type: string
                  beds:
                    type: integer
                  baths:
                    type: integer
                  size:
                    type: number
                  bedsAndBaths:
                    type: string
                  marketRent:
                    type: number
                  property:
                    $ref: '#/components/schemas/mongoId'
                  pictures:
                    type: array
                    items:
                      type: object
                      properties:
                        rank:
                          type: integer
                        url:
                          type: string
                  occupied:
                    type: boolean
                  leaseId:
                    $ref: '#/components/schemas/mongoId'
                  leaseName:
                    type: string
                  start:
                    type: string
                  end:
                    type: string
                  term:
                    type: string
                    enum:
                    - FIXED
                    - AT_WILL
                  totalRecurringRent:
                    type: number
                  rentPerSize:
                    type: number
                  totalBalanceDue:
                    type: number
                  leaseStatus:
                    type: string
                    enum:
                    - ACTIVE
                    - INACTIVE
                  totalDepositsHeld:
                    type: number
                  renewalStage:
                    type: string
                    enum:
                    - NOT_STARTED
                    - RENEWAL_DRAFT
                    - RENEWAL_OFFER
                    - NOT_RENEWING
                  totalRecurringCharges:
                    type: number
                  totalRecurringCredits:
                    type: number
                  totalRecurringPayments:
                    type: number
                  lastPaymentDate:
                    type: string
                    description: 'Format: YYYY-MM-DD'
                  lastPaymentAmount:
                    type: number
                  lastReturnedPaymentDate:
                    type: string
                    description: 'Format: YYYY-MM-DD'
                  lastReturnedPaymentAmount:
                    type: number
                  nextLeaseId:
                    $ref: '#/components/schemas/mongoId'
                  nextLeaseName:
                    type: string
                  nextLeaseStart:
                    type: string
                    description: 'Format: YYYY-MM-DD'
                  rolloverToAtWill:
                    type: boolean
      operationId: get-reports-rent-roll
      security:
      - Key: []
      parameters:
      - schema:
          type: string
        in: query
        name: filter_group
        description: Filter by Portfolio Id
      - schema:
          type: string
        in: query
        name: filter_property
        description: Filter by Property Id
      - schema:
          type: string
        in: query
        name: filter_owner
        description: Filter by Owner Id
      - schema:
          type: string
        in: query
        name: filter_asOfDate
        description: 'Format: YYYY-MM-DD'
      description: ''
components:
  schemas:
    mongoId:
      type: string
      title: mongoId
      x-stoplight:
        id: 40j7qlmpihfdj
      pattern: /^[a-f\d]{24}$/i
      examples:
      - 507f191e810c19729de860ea
      example: 00000020f51bb4362eee2a4d
    profitAndLossReportItem:
      type: object
      properties:
        columns:
          type: array
          items:
            type: object
            properties:
              title:
                type: string
              field:
                type: string
        data:
          type: array
          items:
            type: object
            properties:
              accountType:
                type: string
              accountName:
                type: string
              accountId:
                type: string
              rootAccount:
                type: boolean
              parentAccountId:
                type: 'null'
              total:
                type: integer
              totalWithSubAccounts:
                type: integer
              groupBy:
                type: object
                properties:
                  ? ''
                  : type: string
      x-examples:
        example-1:
          columns:
          - title: string
            field: string
          data:
          - accountType: string
            accountName: string
            accountId: string
            rootAccount: true
            parentAccountId: null
            total: 0
            totalWithSubAccounts: 0
            groupBy:
              ? ''
              : string
  securitySchemes:
    Key:
      type: apiKey
      in: header
      name: Authorization
      description: 'Bearer token. Create a key under Settings -> API access; it is a JWT. Example: `Authorization: Bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.<payload>.<signature>`'
x-stoplight:
  id: cz75kvx8cjg25
x-provenance:
  method: searched
  source: https://api.doorloop.com/reference
  harvested: '2026-10-14'
  tool: harvest-readme-openapi.py
  note: Assembled verbatim from the OpenAPI definition ReadMe embeds in each operation page of the provider's developer portal; paths and components merged by API title, nothing authored.
  assembled_from:
  - https://api.doorloop.com/reference/delete-account.md
  - https://api.doorloop.com/reference/delete-communication.md
  - https://api.doorloop.com/reference/delete-expense.md
  - https://api.doorloop.com/reference/delete-file.md
  - https://api.doorloop.com/reference/delete-lease-charge.md
  - https://api.doorloop.com/reference/delete-lease-credits-leasecreditid.md
  - https://api.doorloop.com/reference/delete-lease-payment.md
  - https://api.doorloop.com/reference/delete-lease-reversed-payment.md
  - https://api.doorloop.com/reference/delete-note.md
  - https://api.doorloop.com/reference/delete-owner.md
  - https://api.doorloop.com/reference/delete-task.md
  - https://api.doorloop.com/reference/delete-tenant.md
  - https://api.doorloop.com/reference/delete-vendor-bill.md
  - https://api.doorloop.com/reference/delete-vendor-credit.md
  - https://api.doorloop.com/reference/delete-vendor.md
  - https://api.doorloop.com/reference/download-file.md
  - https://api.doorloop.com/reference/get-account.md
  - https://api.doorloop.com/reference/get-accounts.md
  - https://api.doorloop.com/reference/get-communication.md
  - https://api.doorloop.com/reference/get-communications.md
  - https://api.doorloop.com/reference/get-current-user.md
  - https://api.doorloop.com/reference/get-expense.md
  - https://api.doorloop.com/reference/get-expenses.md
  - https://api.doorloop.com/reference/get-file.md
  - https://api.doorloop.com/reference/get-files.md
  - https://api.doorloop.com/reference/get-lease-charge.md
  - https://api.doorloop.com/reference/get-lease-charges.md
  - https://api.doorloop.com/reference/get-lease-credit.md
  - https://api.doorloop.com/reference/get-lease-credits.md
  - https://api.doorloop.com/reference/get-lease-payment.md
  - https://api.doorloop.com/reference/get-lease-payments.md
  - https://api.doorloop.com/reference/get-lease-reversed-payment.md
  - https://api.doorloop.com/reference/get-lease-reversed-payments.md
  - https://api.doorloop.com/reference/get-lease-tenants.md
  - https://api.doorloop.com/reference/get-lease.md
  - https://api.doorloop.com/reference/get-leases.md
  - https://api.doorloop.com/reference/get-note.md
  - https://api.doorloop.com/reference/get-notes.md
  - https://api.doorloop.com/reference/get-owner.md
  - https://api.doorloop.com/reference/get-owners.md
  - https://api.doorloop.com/reference/get-properties.md
  - https://api.doorloop.com/reference/get-property-group.md
  - https://api.doorloop.com/reference/get-property-groups.md
  - https://api.doorloop.com/reference/get-property.md
  - https://api.doorloop.com/reference/get-reports-balance-sheet.md
  - https://api.doorloop.com/reference/get-reports-cash-flow-statement.md
  - https://api.doorloop.com/reference/get-reports-profit-and-loss.md
  - https://api.doorloop.com/reference/get-reports-rent-roll.md
  - https://api.doorloop.com/reference/get-task.md
  - https://api.doorloop.com/reference/get-tasks.md
  - https://api.doorloop.com/reference/get-tenant.md
  - https://api.doorloop.com/reference/get-tenants.md
  - https://api.doorloop.com/reference/get-unit.md
  - https://api.doorloop.com/reference/get-units.md
  - https://api.doorloop.com/reference/get-user.md
  - https://api.doorloop.com/reference/get-users.md
  - https://api.doorloop.com/reference/get-vendor-bill.md
  - https://api.doorloop.com/reference/get-vendor-bills.md
  - https://api.doorloop.com/reference/get-vendor-credit.md
  - https://api.doorloop.com/reference/get-vendor-credits.md
  - https://api.doorloop.com/reference/get-vendor.md
  - https://api.doorloop.com/reference/get-vendors.md
  - https://api.doorloop.com/reference/post-account.md
  - https://api.doorloop.com/reference/post-communication.md
  - https://api.doorloop.com/reference/post-expense.md
  - https://api.doorloop.com/reference/post-files.md
  - https://api.doorloop.com/reference/post-lease-charge.md
  - https://api.doorloop.com/reference/post-lease-credit.md
  - https://api.doorloop.com/reference/post-lease-payment.md
  - https://api.doorloop.com/reference/post-lease-reversed-payments.md
  - https://api.doorloop.com/reference/post-leases-full.md
  - https://api.doorloop.com/reference/post-leases-move-in.md
  - https://api.doorloop.com/reference/post-leases-move-out.md
  - https://api.doorloop.com/reference/post-notes.md
  - https://api.doorloop.com/reference/post-owner.md
  - https://api.doorloop.com/reference/post-task-update.md
  - https://api.doorloop.com/reference/post-task.md
  - https://api.doorloop.com/reference/post-tenant.md
  - https://api.doorloop.com/reference/post-vendor-bill.md
  - https://api.doorloop.com/reference/post-vendor-credit.md
  - https://api.doorloop.com/reference/post-vendor.md
  - https://api.doorloop.com/reference/put-account.md
  - https://api.doorloop.com/reference/put-communication.md
  - https://api.doorloop.com/reference/put-expense.md
  - https://api.doorloop.com/reference/put-file.md
  - https://api.doorloop.com/reference/put-lease-charge.md
  - https://api.doorloop.com/reference/put-lease-credit.md
  - https://api.doorloop.com/reference/put-lease-payment.md
  - https://api.doorloop.com/reference/put-note.md
  - https://api.doorloop.com/reference/put-owner.md
  - https://api.doorloop.com/reference/put-task.md
  - https://api.doorloop.com/reference/put-tenant.md
  - https://api.doorloop.com/reference/put-unit.md
  - https://api.doorloop.com/reference/put-vendor-bill.md
  - https://api.doorloop.com/reference/put-vendor-credit.md
  - https://api.doorloop.com/reference/put-vendor.md
  merge:
    pages: 96
    deduped: 446
    conflicts_kept_first: 0