Get the last completed reconciliation
Returns the most recently completed reconciliation for a bank account — the one whose closing becomes the next period's opening. Requires the reconciliations:read permission.
Authorization
AuthorizationstringrequiredPath parameters
bankAccountIdstringrequiredThe bank account being reconciled.
Response
200 · The latest completed reconciliation, as a summary.
idstringSnowflake id of the reconciliation.
bankAccountIdstringThe bank account being reconciled.
startDatestring · dateThe first day of the period, which is the day after the previous completed period ended. Absent on the company's very first reconciliation for this account, which has no lower bound.
endDatestring · dateThe statement date the period is being reconciled to.
openingnumberThe balance the account started the period with, as a decimal. On any reconciliation after the first this is copied from the previous completed period's closing and cannot be overridden.
additionsnumberThe total money in that the bank statement shows, as a positive decimal. This is what you declare, not what MagicDoor computed.
subtractionsnumberThe total money out that the bank statement shows, as a positive decimal. Declared, not computed.
closingnumberopening plus additions minus subtractions. MagicDoor keeps it in step with those three; you never send it.
statusenum<string>inProgress while it is being worked on, then completed or cancelled.
creatorobjectWho started the reconciliation. Deprecated mirrors of id — propertyManagerId, tenantId, vendorId, ownerId — are also present, whichever matches type.
memostringFree-text note. Absent when none was set.
createdstring · date-timeWhen the reconciliation was started, in the company's timezone.
updatedstring · date-timeWhen it last changed, in the company's timezone.