VRPlatformVRPlatform
Statements

/statements/batch

Get Statements by period. Get Statements by ownership period, can be multiple if multiple currencies are found in a month

GET
/statements/batch
X-API-Key<token>

API key provided in dashboard

In: header

Query Parameters

viewAs?string
Default"manager"
Value in"owner" | "manager"
ownershipPeriodId*string
Match^([0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-8][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}|00000000-0000-0000-0000-000000000000|ffffffff-ffff-ffff-ffff-ffffffffffff)$
Formatuuid
month*string

Month string in format YYYY-MM.

Match^\d{4}-\d{2}$
Formatvrp-month
currency?string

Currency in ISO 4217 format, will be converted to lowercase

Response Body

application/json

application/json

application/json

application/json

application/json

application/json

curl -X GET "https://api.vrplatform.app/statements/batch?ownershipPeriodId=497f6eca-6276-4993-bfeb-53cbbbba6f08&month=2024-01"
{
  "data": [
    {
      "id": "string",
      "total": -9007199254740991,
      "financials": {
        "balanceStart": -9007199254740991,
        "netRevenue": -9007199254740991,
        "expenses": -9007199254740991,
        "reserve": -9007199254740991,
        "netIncome": -9007199254740991,
        "payouts": -9007199254740991,
        "balanceEnd": -9007199254740991
      },
      "summary": [
        {
          "name": "string",
          "text": "string",
          "value": 0,
          "separated": true
        }
      ],
      "payment": {
        "expected": -9007199254740991,
        "received": -9007199254740991,
        "status": "unpaid"
      },
      "uniqueRef": "string",
      "currency": "string",
      "startAt": "string",
      "endAt": "string",
      "issues": [
        {
          "code": "emptyJournalEntryAccountIds",
          "severity": "error",
          "context": {
            "affected": 0
          },
          "message": "string"
        }
      ],
      "drilldown": {
        "type": "journalEntryReport",
        "filter": {
          "ids": "string",
          "txnCode": "string",
          "published": true,
          "status": "active",
          "ledger": "historical",
          "startAt": "string",
          "endAt": "string",
          "search": "string",
          "date": "string",
          "amount": "string",
          "isDateRangeEndInclusive": true,
          "reservationIds": "string",
          "transactionIds": "string",
          "ownerStatementIds": "string",
          "currency": "string",
          "excludeApAppendix": true,
          "listingIds": "string",
          "listingOwnershipPeriodIds": "string",
          "accountIds": "string",
          "accountReservationLineTypeIds": "string",
          "categoryIds": "string",
          "excludeCategoryIds": "string",
          "contactIds": "string",
          "classifications": "string",
          "accountType": "ledger",
          "types": "string",
          "excludeTypes": "string",
          "entityTypes": "string",
          "bookingChannels": "string",
          "triggerTypes": "string",
          "excludeTriggerTypes": "string",
          "parties": "string",
          "party": "owners",
          "accountAssignmentTypes": "string",
          "managerStatementSectionIds": "string",
          "recurringFee": true,
          "openingBalanceType": "taxPayable"
        },
        "measure": "periodActivity",
        "label": "string"
      },
      "payouts": [
        {
          "id": "string",
          "lineId": "string",
          "description": "string",
          "descriptionLock": {
            "status": "locked",
            "booksClosed": {
              "date": "string"
            },
            "ownerStatement": {
              "ids": [
                "497f6eca-6276-4993-bfeb-53cbbbba6f08"
              ]
            },
            "reconciled": {
              "bankRecordIds": [
                "497f6eca-6276-4993-bfeb-53cbbbba6f08"
              ]
            },
            "statementPeriod": {
              "hits": [
                {
                  "listingId": "8c73d933-f7ed-437e-9da1-caac95adc1ae",
                  "txnAt": "string",
                  "openFrom": "string"
                }
              ]
            }
          },
          "date": "string",
          "total": 0,
          "totalFormatted": "string"
        }
      ],
      "source": {
        "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
        "type": "string",
        "status": "active",
        "appId": "string",
        "appIcon": "string"
      },
      "listing": {
        "id": "string",
        "name": "string",
        "uniqueRef": "string"
      },
      "status": "draft",
      "ownership": {
        "id": "string",
        "startAt": "string",
        "endAt": "string",
        "reserve": -9007199254740991,
        "members": [
          {
            "id": "string",
            "ownerId": "string",
            "contactId": "string",
            "split": 0
          }
        ]
      },
      "layout": {
        "name": "string",
        "summaryType": "default",
        "isDefault": true,
        "showTeamEmail": true,
        "netRevenueSections": [
          {
            "id": "string",
            "name": "string",
            "locked": true,
            "visible": "all",
            "aggregate": true,
            "columns": [
              {
                "id": "string",
                "name": "string",
                "locked": true,
                "visible": "all",
                "type": "field",
                "value": "string"
              }
            ]
          }
        ],
        "otherSections": [
          {
            "id": "string",
            "name": "string",
            "locked": true,
            "visible": "all",
            "columns": [
              {
                "id": "string",
                "name": "string",
                "locked": true,
                "visible": "all",
                "type": "field",
                "value": "string"
              }
            ]
          }
        ],
        "id": "string",
        "version": -9007199254740991,
        "activeListings": [
          {
            "id": "string",
            "name": "string"
          }
        ],
        "linkedAccounts": [
          {
            "id": "string",
            "name": "string",
            "uniqueRef": "string",
            "status": "active"
          }
        ],
        "createdAt": "2024-01-15T12:30:00.000+00:00",
        "systemSections": [
          {
            "id": "string",
            "name": "string",
            "locked": true,
            "visible": "all",
            "columns": [
              {
                "id": "string",
                "name": "string",
                "locked": true,
                "visible": "all",
                "type": "field",
                "value": "string"
              }
            ]
          }
        ]
      },
      "rows": [
        {
          "id": "string",
          "total": -9007199254740991,
          "section": "string",
          "sourceListing": {
            "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
            "name": "string",
            "uniqueRef": "string",
            "shortRef": "string"
          },
          "issues": [
            {
              "code": "previousPeriodJournalEntries",
              "severity": "warning",
              "context": {
                "affected": 0
              },
              "message": "string"
            }
          ],
          "columns": [
            {
              "name": "string",
              "text": "string",
              "type": "string",
              "value": 0,
              "accountIds": [
                "string"
              ],
              "drilldown": {
                "type": "journalEntryReport",
                "filter": {
                  "ids": "string",
                  "txnCode": "string",
                  "published": true,
                  "status": "active",
                  "ledger": "historical",
                  "startAt": "string",
                  "endAt": "string",
                  "search": "string",
                  "date": "string",
                  "amount": "string",
                  "isDateRangeEndInclusive": true,
                  "reservationIds": "string",
                  "transactionIds": "string",
                  "ownerStatementIds": "string",
                  "currency": "string",
                  "excludeApAppendix": true,
                  "listingIds": "string",
                  "listingOwnershipPeriodIds": "string",
                  "accountIds": "string",
                  "accountReservationLineTypeIds": "string",
                  "categoryIds": "string",
                  "excludeCategoryIds": "string",
                  "contactIds": "string",
                  "classifications": "string",
                  "accountType": "ledger",
                  "types": "string",
                  "excludeTypes": "string",
                  "entityTypes": "string",
                  "bookingChannels": "string",
                  "triggerTypes": "string",
                  "excludeTriggerTypes": "string",
                  "parties": "string",
                  "party": "owners",
                  "accountAssignmentTypes": "string",
                  "managerStatementSectionIds": "string",
                  "recurringFee": true,
                  "openingBalanceType": "taxPayable"
                },
                "measure": "periodActivity",
                "label": "string"
              },
              "props": {
                "property1": null,
                "property2": null
              }
            }
          ],
          "drilldown": {
            "type": "journalEntryReport",
            "filter": {
              "ids": "string",
              "txnCode": "string",
              "published": true,
              "status": "active",
              "ledger": "historical",
              "startAt": "string",
              "endAt": "string",
              "search": "string",
              "date": "string",
              "amount": "string",
              "isDateRangeEndInclusive": true,
              "reservationIds": "string",
              "transactionIds": "string",
              "ownerStatementIds": "string",
              "currency": "string",
              "excludeApAppendix": true,
              "listingIds": "string",
              "listingOwnershipPeriodIds": "string",
              "accountIds": "string",
              "accountReservationLineTypeIds": "string",
              "categoryIds": "string",
              "excludeCategoryIds": "string",
              "contactIds": "string",
              "classifications": "string",
              "accountType": "ledger",
              "types": "string",
              "excludeTypes": "string",
              "entityTypes": "string",
              "bookingChannels": "string",
              "triggerTypes": "string",
              "excludeTriggerTypes": "string",
              "parties": "string",
              "party": "owners",
              "accountAssignmentTypes": "string",
              "managerStatementSectionIds": "string",
              "recurringFee": true,
              "openingBalanceType": "taxPayable"
            },
            "measure": "periodActivity",
            "label": "string"
          },
          "type": "transaction",
          "source": {
            "id": "string",
            "type": "deposit",
            "description": "string",
            "lines": [
              {
                "id": "string",
                "description": "string",
                "descriptionLock": {
                  "status": "locked",
                  "booksClosed": {
                    "date": "string"
                  },
                  "ownerStatement": {
                    "ids": [
                      "497f6eca-6276-4993-bfeb-53cbbbba6f08"
                    ]
                  },
                  "reconciled": {
                    "bankRecordIds": [
                      "497f6eca-6276-4993-bfeb-53cbbbba6f08"
                    ]
                  },
                  "statementPeriod": {
                    "hits": [
                      {
                        "listingId": "8c73d933-f7ed-437e-9da1-caac95adc1ae",
                        "txnAt": "string",
                        "openFrom": "string"
                      }
                    ]
                  }
                }
              }
            ],
            "recurringFee": {
              "id": "string"
            }
          }
        }
      ],
      "attachments": [
        {
          "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",
          "transactionId": "75906707-8c31-479c-b354-aa805c4cefbc",
          "createdAt": "2024-01-15T12:30:00.000+00:00",
          "filename": "string",
          "extension": "string",
          "contentType": "string",
          "byteSize": -9007199254740991,
          "isOwnerAccessible": true
        }
      ]
    }
  ]
}
{
  "code": "string",
  "message": "string",
  "issues": [
    {
      "message": "string"
    }
  ],
  "context": null
}
{
  "code": "string",
  "message": "string",
  "issues": [
    {
      "message": "string"
    }
  ],
  "context": null
}
{
  "code": "string",
  "message": "string",
  "issues": [
    {
      "message": "string"
    }
  ],
  "context": null
}
{
  "code": "string",
  "message": "string",
  "issues": [
    {
      "message": "string"
    }
  ],
  "context": null
}
{
  "code": "string",
  "message": "string",
  "issues": [
    {
      "message": "string"
    }
  ],
  "context": null
}