Accounting reports

Get a master ledger

Lists the same journal activity as the general ledger, but grouped by the record that produced it rather than by account — so you see each entry's debits and credits side by side. Requires the reports:read permission.

GET
https://services.magicdoor.com/accounting/company-portal/reports/master-ledger

Authorization

Authorizationstringrequired
Bearer token — Send your API token in the Authorization header as Bearer <token>. Requests without a valid token are rejected with 401 Unauthorized.

Query parameters

basisenum<string>required

cash counts money when it moves; accrual counts it when it is earned or owed. The two give different numbers from the same data.

example: accrualcashaccrual
reportTypeenum<string>required

property reports on the properties' books — what the owners' money did. company reports on the management company's own books. An entry belongs to one or the other, never both.

example: propertypropertycompany
startDatestring · daterequired

First day of the period, read in the company's timezone.

example: 2026-07-01
endDatestring · daterequired

Last day of the period, read in the company's timezone.

example: 2026-07-31
portfolioIdsstring[]

Only these portfolios.

propertyIdsstring[]

Only these properties.

coaIdsstring[]

Only entries touching these chart-of-account entries. Omit for everything.

Response

200 · An array of journal entries, each with its lines.

postingDatestring · date

The date the entry is posted on, in the company's timezone.

sourceenum<string>

What sort of record produced the entry.

billtransactiondepositReleasemanualbankLedgerTransfer
sourceIdstring

The id of that record.

linesLine[]

The entry's debit and credit lines. Their debits and credits balance.

400 · `basis`, `reportType`, `startDate` or `endDate` is missing or not a recognised value.

401 · The access token is missing, expired, or not for this company.

403 · The caller does not hold the `reports:read` permission.

The response is a bare JSON array, not an object with a wrapper. Within each entry the debit lines and the credit lines balance.

The report is computed on the fly

Nothing is stored. Every call rebuilds the report from the ledger as it stands right now, so two calls with the same parameters can differ if anything was posted in between. Only manual journal entries that have been posted are included.