Treasury account statements
A list of transactions for one treasury account over a period, with opening and closing balances.
Fields
The API name is what the API, MCP and the CLI use.
| Name | API name | Type | Required | Description |
|---|---|---|---|---|
| ID | id | Record ID | Yes | |
| Name | label | Text | ||
| Number | uid | Text | The number is a human-readable, unique identifier for the record. | |
| Due date | date | Date | Calendar date for this value. | |
| User | userId | User | ||
| Treasury account | treasuryaccountId | Reference | Yes | |
| Period start | dateStart | Date | Yes | Calendar date without time of date. |
| Period end | dateEnd | Date | Yes | Calendar date without time of date. |
| Opening balance | openingBalance | Signed amount | Yes | Period opening balance in account currency. |
| Closing balance | closingBalance | Signed amount | Yes | Period closing balance in account currency. |
| Amount due | amount | Currency | Monetary amount in the applicable currency for this record. | |
| Book balance at cutoff | bookBalanceAtCutoff | Signed amount | Treasury book balance from processed movements through the statement period end. | |
| Open lines | countItemsOpen | Whole Number | Yes | Count of statement lines that are not matched or ignored. |
| Unexplained difference | unexplainedDifference | Signed amount | Statement closing balance minus book balance at cutoff when the close action runs. | |
| Reopen reason | uncloseReason | Text Area | Required explanation when reopening a closed period or record. | |
| Tags | tagIds | Tags | ||
| Description | description | Text Area | ||
| Data | data | Data | ||
| Created by | createdBy | User | ||
| Created at | createdAt | Date and Time | Yes | |
| Updated by | updatedBy | User | ||
| Updated at | updatedAt | Date and Time | Yes | |
| Started by | startedBy | User | ||
| Started at | startedAt | Date and Time | ||
| Closed by | closedBy | User | ||
| Closed at | closedAt | Date and Time | ||
| Blocked by | blockedBy | User | ||
| Blocked at | blockedAt | Date and Time | ||
| Archived by | archivedBy | User | ||
| Archived at | archivedAt | Date and Time |
Relations
Owned records (solid line) are deleted with their owner. Grouped records (dashed line) can exist alone.
| Field | Points to | Kind |
|---|---|---|
User userId | Users | reference |
Treasury account treasuryaccountId | Treasury accounts | reference |
Tags tagIds | Tags | reference |
Actions
What you can do with a record. Every action also sends the webhook event treasurystatements.<action>. Reads (find, get, count) work on every table.
| Name | API name | Description | Where |
|---|---|---|---|
| Create | create | Add an new account statement. | App · WebMCP · API · MCP · CLI |
| Edit | update | Save changes to this account statement. | App · WebMCP · API · MCP · CLI |
| Start | start | Start this account statement and open the work. | App · WebMCP · API · MCP · CLI |
| Close | close | Stop new references to this account statement. It stays, and existing documents stay. Unclose to allow new references again. | App · WebMCP · API · MCP · CLI |
| Reopen | unclose | Restore the completed record. New references can start again. End and process stay as they are. | App · WebMCP · API · MCP · CLI |
| Auto-match | automatch | Match statement lines to treasury movements by rules. | App · API · MCP · CLI |
| Block | block | Stop edits and deletion of this account statement. It stays visible and can still appear on existing documents. Unblock to edit again. | App · WebMCP · API · MCP · CLI |
| Unblock | unblock | Allow edits and deletion of this account statement again. | App · WebMCP · API · MCP · CLI |
| Archive | archive | Retire this account statement from daily use. It leaves active lists and pickers, and most actions stop. Unarchive to restore it. | App · WebMCP · API · MCP · CLI |
| Restore | unarchive | Return this account statement to active lists and actions. | App · WebMCP · API · MCP · CLI |
| Delete | delete | Delete this account statement and the data that belongs with it. This cannot be undone. | App · WebMCP · API · MCP · CLI |
States
How a record moves from state to state. Archive and block can happen in any state.