General Ledger
NewBetaGeneralLedgerEntry objects list individual general ledger transaction lines from AppFolio®, grouped by account and sorted by post date.
The GeneralLedgerEntry Object
Attributes
idinteger
AppFolio internal row ID.
Example:
1
postDatestring
Date the transaction was posted in MM/DD/YYYY format (e.g. "04/01/2026").
Example:
"04/01/2026"
typestring
Display type of the transaction (e.g. "Receipt", "Bill", "Journal Entry").
Example:
"Receipt"
debitstring
Debit amount (e.g. "3,095.00", null if this line is a credit).
Example:
null
creditstring
Credit amount (e.g. "3,095.00", null if this line is a debit).
Example:
"1,500.00"
creditDebitBalancestring
Running credit/debit balance for the account (e.g. "-144,692.17").
Example:
"-10,500.00"
bankAccountstring
Display name of the bank account (null if not applicable).
Example:
"Operating Chkg (1000)"
referencestring
Reference string attached to the transaction (null if none).
Example:
null
remarksstring
Remarks attached to the transaction (null if none).
Example:
"Prepayment applied automatically"
descriptionstring
Description attached to the transaction (null if none).
Example:
null
More Attributes
rowTypestring
monthstring
quarterstring
yearinteger
bankAccountIdinteger
cashAccountstring
cashAccountIdinteger
createdBystring
ownersstring
batchIdinteger
accountUpdatedAtstring
serviceFromstring
serviceTostring
intercompanyPartyNamestring
intercompanyPartyIdinteger
projectCostCategorystring
projectstring
projectIdinteger
transaction.integrationIdstring
transaction.typestring
transaction.detailIdinteger
transaction.detailIntegrationIdstring
transaction.createdAtstring
transaction.updatedAtstring
invoice.appfolioIdstring
invoice.detailIdinteger
invoice.updatedAtstring
deposit.appfolioIdinteger
deposit.datestring
deposit.numberstring
glAccount.integrationIdstring
glAccount.numberstring
glAccount.normalBalancestring
party.typestring
property.integrationIdstring
property.streetstring
property.street2string
property.citystring
property.statestring
property.zipstring
unit.integrationIdstring
The GeneralLedgerEntry Object
{
"id": 1,
"rowType": "row",
"postDate": "04/01/2026",
"month": "Apr 2026",
"quarter": "2026 Q2",
"year": 2026,
"type": "Receipt",
"debit": null,
"credit": "1,500.00",
"creditDebitBalance": "-10,500.00",
"bankAccount": "Operating Chkg (1000)",
"bankAccountId": 1,
"cashAccount": "600-100 - Bank Account",
"cashAccountId": 3,
"reference": null,
"remarks": "Prepayment applied automatically",
"description": null,
"createdBy": "System",
"owners": "Acme Properties",
"batchId": 50001,
"accountUpdatedAt": "01/01/2020 at 12:00 PM",
"serviceFrom": null,
"serviceTo": null,
"intercompanyPartyName": null,
"intercompanyPartyId": null,
"projectCostCategory": null,
"project": null,
"projectId": null,
"transaction": {
"appfolioId": 100001,
"integrationId": "a1b2c3d4-0001-0001-0001-000000000001",
"type": "ReceivablePayment",
"detailId": 200001,
"detailIntegrationId": "a1b2c3d4-0001-0001-0001-000000000002",
"date": "04/01/2026",
"createdAt": "04/01/2026 at 12:00 AM",
"updatedAt": "04/01/2026 at 12:00 AM"
},
"invoice": {
"appfolioId": "100,001",
"detailId": 200001,
"updatedAt": "04/01/2026 at 12:00 AM"
},
"deposit": {
"appfolioId": null,
"date": null,
"number": null
},
"glAccount": {
"appfolioId": 1,
"integrationId": "a1b2c3d4-0002-0002-0002-000000000001",
"name": "100-100 - Rental Income",
"number": null,
"normalBalance": "1"
},
"party": {
"appfolioId": 1001,
"name": "Smith, Alex",
"type": "Occupancy"
},
"property": {
"appfolioId": 1,
"integrationId": "a1b2c3d4-0003-0003-0003-000000000001",
"label": "Maple Apartments - 100 Maple St, Springfield, CA 90000",
"name": "Maple Apartments",
"address": "100 Maple St, Springfield, CA 90000",
"street": "100 Maple St",
"street2": null,
"city": "Springfield",
"state": "CA",
"zip": "90000"
},
"unit": {
"appfolioId": 101,
"integrationId": "a1b2c3d4-0004-0004-0004-000000000001",
"label": "101"
}
}
Get All General Ledger Entries
GET /v1/general-ledger?dateRange=this_month_to_date
Follows: Authentication • Caching • Polling • List Response Format • Scheduled Job
The general-ledger endpoint returns general ledger transaction lines from your AppFolio® account, grouped by GL account and sorted by post date. Use the accounting parameter to switch between Cash and Accrual basis. If you omit the date filter, we default to this_month_to_date so new accounts see the current month's transactions out-of-the-box.
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
dateRangeselect
Post Date Range for report.
Default Value:
this_month_to_date
Possible Values:
today
this_week
this_week_to_date
this_month
this_month_to_date
this_quarter
this_quarter_to_date
this_year_to_date
last_year
last_year_to_date
yesterday
last_week
last_week_to_date
last_month
last_month_to_date
last_quarter
last_quarter_to_date
last_7_days
last_30_days
last_60_days
last_90_days
trailing_12_months
next_7_days
next_30_days
next_60_days
next_90_days
next_week
next_month
next_quarter
until_1_week_ago
until_1_month_ago
all_time
dateFromdate
Post Date to given in MM/DD/YYYY (e.g. 01/31/2021)
dateTodate
Post Date to given in MM/DD/YYYY (e.g. 01/31/2021)
glAccountIdstring
GL account ID to filter by, or "all" to include all accounts. Default: all.
Default Value:
all
reverseTransactionboolean
Include reverse transactions. Default: No. Possible Values: Yes, No
Default Value:
No
excludeZeroDollarReceiptsFromCashAccountsboolean
Exclude zero-dollar receipts from cash accounts. Default: Yes. Possible Values: Yes, No
Default Value:
Yes
excludeZeroDollarBillsboolean
Exclude zero-dollar bills. Default: Yes. Possible Values: Yes, No
Default Value:
Yes
Returns
The standard List Response Format with a data property containing an array of GeneralLedgerEntry objects.
GET /v1/general-ledger?dateRange=this_month_to_date
curl -X GET 'https://api.skywalkapi.com/v1/general-ledger?dateRange=this_month_to_date' \
-H "X-API-Key: PUT_YOUR_API_KEY_HERE"
Response
{
"meta": {
"status": "ok",
"path": "/v1/general-ledger",
"query": {
"dateRange": "this_month_to_date"
},
"count": 1,
"lastUpdated": 1610992228
},
"links": {
"next": "/v1/general-ledger?cursor=abcdefg"
},
"data": [
{
"id": 1,
"rowType": "row",
"postDate": "04/01/2026",
"month": "Apr 2026",
"quarter": "2026 Q2",
"year": 2026,
"type": "Receipt",
"debit": null,
"credit": "1,500.00",
"creditDebitBalance": "-10,500.00",
"bankAccount": "Operating Chkg (1000)",
"bankAccountId": 1,
"cashAccount": "600-100 - Bank Account",
"cashAccountId": 3,
"reference": null,
"remarks": "Prepayment applied automatically",
"description": null,
"createdBy": "System",
"owners": "Acme Properties",
"batchId": 50001,
"accountUpdatedAt": "01/01/2020 at 12:00 PM",
"serviceFrom": null,
"serviceTo": null,
"intercompanyPartyName": null,
"intercompanyPartyId": null,
"projectCostCategory": null,
"project": null,
"projectId": null,
"transaction": {
"appfolioId": 100001,
"integrationId": "a1b2c3d4-0001-0001-0001-000000000001",
"type": "ReceivablePayment",
"detailId": 200001,
"detailIntegrationId": "a1b2c3d4-0001-0001-0001-000000000002",
"date": "04/01/2026",
"createdAt": "04/01/2026 at 12:00 AM",
"updatedAt": "04/01/2026 at 12:00 AM"
},
"invoice": {
"appfolioId": "100,001",
"detailId": 200001,
"updatedAt": "04/01/2026 at 12:00 AM"
},
"deposit": {
"appfolioId": null,
"date": null,
"number": null
},
"glAccount": {
"appfolioId": 1,
"integrationId": "a1b2c3d4-0002-0002-0002-000000000001",
"name": "100-100 - Rental Income",
"number": null,
"normalBalance": "1"
},
"party": {
"appfolioId": 1001,
"name": "Smith, Alex",
"type": "Occupancy"
},
"property": {
"appfolioId": 1,
"integrationId": "a1b2c3d4-0003-0003-0003-000000000001",
"label": "Maple Apartments - 100 Maple St, Springfield, CA 90000",
"name": "Maple Apartments",
"address": "100 Maple St, Springfield, CA 90000",
"street": "100 Maple St",
"street2": null,
"city": "Springfield",
"state": "CA",
"zip": "90000"
},
"unit": {
"appfolioId": 101,
"integrationId": "a1b2c3d4-0004-0004-0004-000000000001",
"label": "101"
}
}
]
}