Balance Sheet

BalanceSheet objects represent the individual line-items in a Balance Sheet report. Skywalk API allows you to obtain the following attributes from a Balance Sheet report:

The `BalanceSheet` Object#

Attributes

idstring

Ephemeral ID for the purpose of child/parent traversal.

Example:

"0"

titlestring

Name of record.

Example:

"ASSETS"

glAccountIdstring

Unique ID for this GL Account.

Example:

null

glAccountNamestring

Name of associated GL Account.

Example:

"ASSETS"

glAccountCodestring

Name of associated GL Account.

Example:

null

balancestring

Account balance.

Example:

"10,000.00"

parentIdstring

Maps to the ID of the parent record.

childIdsstring[]

Maps to the ID of the child records.

Example:

["1","6","7","8","12"]

The BalanceSheet Object

{
  "id": "0",
  "title": "ASSETS",
  "glAccountId": null,
  "glAccountName": "ASSETS",
  "glAccountCode": null,
  "balance": "10,000.00",
  "childIds": [
    "1",
    "6",
    "7",
    "8",
    "12"
  ]
}

Get Balance Sheet#

GET /v1/balance-sheet

Follows: Authentication • Caching • Polling • List Response Format • Scheduled Job

The balance sheet endpoint returns a list of all balances in your AppFolio® account. This endpoint should respond immediately with your most recently cached data.

Parameters#

propertyIdselect

AppFolio ID of a Property to serve as a filter.

propertyGroupIdselect

AppFolio ID of a Property Group to serve as a filter.

ownerIdselect

AppFolio ID of an Owner to serve as a filter.

accountingselect

Accounting Basis.

Default: cash.

Possible Values: cash, accrual

Default Value:

cash

Possible Values:

cash

accrual

datedate

"As of" date for report given in MM/DD/YYYY (e.g. 01/31/2021)

Returns#

The standard List Response Format with a data property containing an array of BalanceSheet objects.

GET /v1/balance-sheet

curl -X GET 'https://api.skywalkapi.com/v1/balance-sheet' \ 
  -H "X-API-Key: PUT_YOUR_API_KEY_HERE"

Response

{
  "meta": {
    "status": "ok",
    "path": "/v1/balance-sheet",
    "query": {},
    "count": 28,
    "lastUpdated": 1610992228
  },
  "links": {
    "next": null
  },
  "data": [
    {
      "id": "0",
      "title": "ASSETS",
      "glAccountId": null,
      "glAccountName": "ASSETS",
      "glAccountCode": null,
      "balance": "10,000.00",
      "childIds": [
        "1",
        "6",
        "7",
        "8",
        "12"
      ]
    },
    {
      "id": "1",
      "title": "Cash",
      "glAccountId": null,
      "glAccountName": "Cash",
      "glAccountCode": null,
      "balance": "10,000.00",
      "childIds": [
        "2",
        "3",
        "4"
      ],
      "parentId": "0"
    },
    {
      "id": "2",
      "title": "Operating Cash",
      "glAccountId": "2",
      "glAccountName": "Operating Cash",
      "glAccountCode": "1150",
      "balance": "5,000.00",
      "childIds": [],
      "parentId": "1"
    },
    {
      "id": "3",
      "title": "Security Deposit Cash",
      "glAccountId": "3",
      "glAccountName": "Security Deposit Cash",
      "glAccountCode": "1160",
      "balance": "0.00",
      "childIds": [],
      "parentId": "1"
    },
    {
      "id": "4",
      "title": "Operations Acct Cash",
      "glAccountId": "104",
      "glAccountName": "Operations Acct Cash",
      "glAccountCode": "1170",
      "balance": "5,000.00",
      "childIds": [],
      "parentId": "1"
    },
    {
      "id": "6",
      "title": "Accounts Receivable",
      "glAccountId": "4",
      "glAccountName": "Accounts Receivable",
      "glAccountCode": "1300",
      "balance": "0.00",
      "childIds": [],
      "parentId": "0"
    },
    {
      "id": "7",
      "title": "Land",
      "glAccountId": "5",
      "glAccountName": "Land",
      "glAccountCode": "1610",
      "balance": "0.00",
      "childIds": [],
      "parentId": "0"
    },
    {
      "id": "8",
      "title": "BUILDING ASSETS",
      "glAccountId": "7,8",
      "glAccountName": "BUILDING ASSETS",
      "glAccountCode": null,
      "balance": "0.00",
      "childIds": [
        "9",
        "10"
      ],
      "parentId": "0"
    },
    {
      "id": "9",
      "title": "Buildings",
      "glAccountId": "7",
      "glAccountName": "Buildings",
      "glAccountCode": "1710",
      "balance": "0.00",
      "childIds": [],
      "parentId": "8"
    },
    {
      "id": "10",
      "title": "Building Depreciation",
      "glAccountId": "8",
      "glAccountName": "Building Depreciation",
      "glAccountCode": "1720",
      "balance": "0.00",
      "childIds": [],
      "parentId": "8"
    },
    {
      "id": "12",
      "title": "OTHER PROPERTY ASSETS",
      "glAccountId": "10,11",
      "glAccountName": "OTHER PROPERTY ASSETS",
      "glAccountCode": null,
      "balance": "0.00",
      "childIds": [
        "13",
        "14"
      ],
      "parentId": "0"
    },
    {
      "id": "13",
      "title": "Other Property",
      "glAccountId": "10",
      "glAccountName": "Other Property",
      "glAccountCode": "1810",
      "balance": "0.00",
      "childIds": [],
      "parentId": "12"
    },
    {
      "id": "14",
      "title": "Other Property Depreciation",
      "glAccountId": "11",
      "glAccountName": "Other Property Depreciation",
      "glAccountCode": "1820",
      "balance": "0.00",
      "childIds": [],
      "parentId": "12"
    },
    {
      "id": "19",
      "title": "LIABILITIES & CAPITAL",
      "glAccountId": null,
      "glAccountName": "LIABILITIES & CAPITAL",
      "glAccountCode": null,
      "balance": "10,000.00",
      "childIds": [
        "20",
        "30"
      ]
    },
    {
      "id": "20",
      "title": "Liabilities",
      "glAccountId": null,
      "glAccountName": "Liabilities",
      "glAccountCode": null,
      "balance": "0.00",
      "childIds": [
        "21",
        "25",
        "26",
        "27",
        "28"
      ],
      "parentId": "19"
    },
    {
      "id": "21",
      "title": "SECURITY DEPOSITS",
      "glAccountId": "13,14",
      "glAccountName": "SECURITY DEPOSITS",
      "glAccountCode": null,
      "balance": "0.00",
      "childIds": [
        "22",
        "23"
      ],
      "parentId": "20"
    },
    {
      "id": "22",
      "title": "Mgmt Held Security Deposits",
      "glAccountId": "13",
      "glAccountName": "Mgmt Held Security Deposits",
      "glAccountCode": "2101",
      "balance": "0.00",
      "childIds": [],
      "parentId": "21"
    },
    {
      "id": "23",
      "title": "Mgmt Held Pet Deposits",
      "glAccountId": "14",
      "glAccountName": "Mgmt Held Pet Deposits",
      "glAccountCode": "2103",
      "balance": "0.00",
      "childIds": [],
      "parentId": "21"
    },
    {
      "id": "25",
      "title": "Clearing Account",
      "glAccountId": "15",
      "glAccountName": "Clearing Account",
      "glAccountCode": "2120",
      "balance": "0.00",
      "childIds": [],
      "parentId": "20"
    },
    {
      "id": "26",
      "title": "Prepaid Rent",
      "glAccountId": "16",
      "glAccountName": "Prepaid Rent",
      "glAccountCode": "2300",
      "balance": "0.00",
      "childIds": [],
      "parentId": "20"
    },
    {
      "id": "27",
      "title": "Accounts Payable",
      "glAccountId": "17",
      "glAccountName": "Accounts Payable",
      "glAccountCode": "2500",
      "balance": "0.00",
      "childIds": [],
      "parentId": "20"
    },
    {
      "id": "28",
      "title": "Mortgage Payable",
      "glAccountId": "18",
      "glAccountName": "Mortgage Payable",
      "glAccountCode": "2600",
      "balance": "0.00",
      "childIds": [],
      "parentId": "20"
    },
    {
      "id": "30",
      "title": "Capital",
      "glAccountId": null,
      "glAccountName": "Capital",
      "glAccountCode": null,
      "balance": "10,000.00",
      "childIds": [
        "31",
        "32",
        "33",
        "34",
        "35"
      ],
      "parentId": "19"
    },
    {
      "id": "31",
      "title": "Owner Contribution",
      "glAccountId": "19",
      "glAccountName": "Owner Contribution",
      "glAccountCode": "3150",
      "balance": "0.00",
      "childIds": [],
      "parentId": "30"
    },
    {
      "id": "32",
      "title": "Owner Distribution",
      "glAccountId": "20",
      "glAccountName": "Owner Distribution",
      "glAccountCode": "3250",
      "balance": "0.00",
      "childIds": [],
      "parentId": "30"
    },
    {
      "id": "33",
      "title": "Retained Earnings",
      "glAccountId": "21",
      "glAccountName": "Retained Earnings",
      "glAccountCode": "3300",
      "balance": "0.00",
      "childIds": [],
      "parentId": "30"
    },
    {
      "id": "34",
      "title": "Prior Years Retained Earnings",
      "glAccountId": "22",
      "glAccountName": "Prior Years Retained Earnings",
      "glAccountCode": "3350",
      "balance": "0.00",
      "childIds": [],
      "parentId": "30"
    },
    {
      "id": "35",
      "title": "Appfolio Opening Balance Equity",
      "glAccountId": "23",
      "glAccountName": "Appfolio Opening Balance Equity",
      "glAccountCode": "3999",
      "balance": "10,000.00",
      "childIds": [],
      "parentId": "30"
    }
  ]
}

The BalanceSheet Object#

Attributes

Get Balance Sheet#

Parameters#

Returns#

The `BalanceSheet` Object#