These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Treasury Bills & Bonds
- Data model and import order
The tables behind Treasury Bills & Bonds
Treasury Bills & Bonds ships with 15 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 15
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Bank Instructions:
Bank instructions and instruction accounts. Each instruction belongs to a legal entity, names a counterparty and owner, carries a version and has balanced debit and credit lines.
Review Queue:
Review decisions record the decision, reason and approver against an instruction version.
Security Cash Flows:
Security cash flows hold coupon and principal by security code and due date, linked to the purchase instruction.
Bank Reconciliation:
Reconciliation items and account snapshots hold provider movements and balances by account.
Counterparties and Accounts:
Financial counterparties, financial accounts and Organizations hold eligible providers, settlement accounts and legal entities.
Activity and Evidence:
Bank evidence, record attachments and operation receipts hold provider evidence, documents and action receipts; exchange rates holds read-only rates.
Access:
Team members link treasury staff to platform users in Users.
Every table, by feature
- Bank Instructions4
- Review Queue4
- Security Cash Flows4
- Bank Reconciliation4
- Counterparties and Accounts4
- Activity and Evidence4
- Shared and settings2
- Bank instructions
Typed banking instructions raised by treasury and authorized by an independent approver.
Linked to Financial counterparties, Organizations, Team members - Instruction accounts
Balanced debit and credit account scope for a banking instruction.
Linked to Bank instructions, Financial accounts - Financial counterparties
Banks, custodians and broker-dealers eligible to receive treasury instructions.
Linked to Organizations - Record attachments
Supporting documents uploaded against a treasury instruction.
Linked to Bank instructions, Team members
- Review decisions
Independent approver decisions recorded against an exact instruction revision.
Linked to Bank instructions, Team members - Bank instructions
Typed banking instructions raised by treasury and authorized by an independent approver.
Linked to Financial counterparties, Organizations, Team members - Security cash flows
Scheduled coupon and maturity cashflows for held bills and bonds, reconciled against custodian receipt.
Linked to Bank instructions, Organizations - Team members
Named treasury staff with an authenticated platform identity and role scope.
Linked to Organizations, Users
- Security cash flows
Scheduled coupon and maturity cashflows for held bills and bonds, reconciled against custodian receipt.
Linked to Bank instructions, Organizations - Bank instructions
Typed banking instructions raised by treasury and authorized by an independent approver.
Linked to Financial counterparties, Organizations, Team members - Bank evidence
Provider statements, confirmations, settlements and corrections attached to an instruction.
Linked to Bank instructions - Review decisions
Independent approver decisions recorded against an exact instruction revision.
Linked to Bank instructions, Team members
- Reconciliation items
Provider-identified movements matched against treasury instructions.
Linked to Financial accounts, Bank instructions - Account snapshots
Timestamped provider balance snapshots imported as read-only evidence.
Linked to Financial accounts - Financial accounts
Custody and settlement accounts held with an approved regulated provider.
Linked to Financial counterparties - Bank instructions
Typed banking instructions raised by treasury and authorized by an independent approver.
Linked to Financial counterparties, Organizations, Team members
- Financial counterparties
Banks, custodians and broker-dealers eligible to receive treasury instructions.
Linked to Organizations - Financial accounts
Custody and settlement accounts held with an approved regulated provider.
Linked to Financial counterparties - Organizations
Legal entities whose treasury operations are tracked in this app.
- Team members
Named treasury staff with an authenticated platform identity and role scope.
Linked to Organizations, Users
- Bank evidence
Provider statements, confirmations, settlements and corrections attached to an instruction.
Linked to Bank instructions - Record attachments
Supporting documents uploaded against a treasury instruction.
Linked to Bank instructions, Team members - Operation receipts
Durable idempotency receipts for every guarded treasury operation.
Linked to Bank instructions - Bank instructions
Typed banking instructions raised by treasury and authorized by an independent approver.
Linked to Financial counterparties, Organizations, Team members
Keys and references
Every instruction keeps a stable record number, every counterparty and entity a code and every account its account code and external account ID. Import movements, evidence and snapshots by the provider’s own IDs so repeats are recognized. Record security codes consistently. Amounts are in US dollars.
The system holds 15 tables and 21 relationships.
Migration order
- Load Organizations, Users and team members.
- Load financial counterparties and financial accounts.
- Load open bank instructions with their instruction accounts and record attachments.
- Load security cash flows for current holdings.
- Load opening account snapshots and recent reconciliation items.
- Reconcile open instructions, scheduled cash flows and account balances with the source before submitting new work.
Set up Treasury Bills & Bonds your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.