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 Operations
- Data model and import order
The tables behind Treasury Operations
Treasury Operations 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
- Change it
- Add fields and tables in Proto
How the model is organised
Counterparties and accounts:
Financial counterparties, financial accounts, Organizations, team members, Users. Counterparties carry eligibility notes; accounts carry the provider's external account identifier and currency.
Bank instructions:
Bank instructions, instruction accounts, record attachments. Status runs Draft, Review, Authorized, Submitted, Pending, Confirmed or Rejected, with a Revision; legs are Debit or Credit.
Review and authorization:
Review decisions. Decision Approve, Reject or Return with Reason and source revision.
Settlement and evidence:
Bank evidence. Evidence type Statement, Confirmation, Settlement or Correction, with provider event ID and Verified.
Treasury deals:
Treasury deals. Status Draft, Submitted, Approved, Rejected or Completed, under a parent instruction.
Bank reconciliation:
Account snapshots, reconciliation items, operation receipts, exchange rates. Items are Unmatched, Matched or Exception; receipts are Pending, Completed, Failed or needs review.
Every table, by feature
- Counterparties and accounts5
- Bank instructions5
- Review and authorization4
- Settlement and evidence3
- Treasury deals4
- Bank reconciliation6
- Financial counterparties
Eligible banks, dealers and fund counterparties approved for treasury dealing.
Linked to Organizations - Financial accounts
Provider-held treasury accounts and their external identities.
Linked to Financial counterparties - Organizations
Legal entities whose treasury operations are managed in this app.
- Team members
Authenticated staff members assigned to treasury operations roles.
Linked to Organizations, Users - Users
Users
Linked to Users
- Bank instructions
Typed banking instructions raised by the treasury desk.
Linked to Organizations, Team members, Financial counterparties - Instruction accounts
Balanced debit and credit account legs intended for each instruction.
Linked to Bank instructions, Financial accounts - Record attachments
Supporting documents attached to a banking instruction.
Linked to Bank instructions, Team members - Financial counterparties
Eligible banks, dealers and fund counterparties approved for treasury dealing.
Linked to Organizations - Financial accounts
Provider-held treasury accounts and their external identities.
Linked to Financial counterparties
- Review decisions
Independent reviewer decisions recorded against a specific instruction revision.
Linked to Bank instructions, Team members - Bank instructions
Typed banking instructions raised by the treasury desk.
Linked to Organizations, Team members, Financial counterparties - Treasury deals
FX, money market and ALM deals executed against authorized instructions.
Linked to Bank instructions, Organizations - Team members
Authenticated staff members assigned to treasury operations roles.
Linked to Organizations, Users
- Bank evidence
Provider statements, confirmations and settlement evidence received per instruction.
Linked to Bank instructions - Bank instructions
Typed banking instructions raised by the treasury desk.
Linked to Organizations, Team members, Financial counterparties - Operation receipts
Idempotent execution receipts for every guarded treasury operation.
Linked to Bank instructions
- Treasury deals
FX, money market and ALM deals executed against authorized instructions.
Linked to Bank instructions, Organizations - Bank instructions
Typed banking instructions raised by the treasury desk.
Linked to Organizations, Team members, Financial counterparties - Review decisions
Independent reviewer decisions recorded against a specific instruction revision.
Linked to Bank instructions, Team members - Bank evidence
Provider statements, confirmations and settlement evidence received per instruction.
Linked to Bank instructions
- Account snapshots
Timestamped provider balance snapshots imported for reconciliation.
Linked to Financial accounts - Reconciliation items
Source-identified provider entries matched against instructions and evidence.
Linked to Financial accounts, Bank instructions - Operation receipts
Idempotent execution receipts for every guarded treasury operation.
Linked to Bank instructions - Financial accounts
Provider-held treasury accounts and their external identities.
Linked to Financial counterparties - Bank instructions
Typed banking instructions raised by the treasury desk.
Linked to Organizations, Team members, Financial counterparties - Exchange rates
Read-only effective exchange rates for this app.
Keys and references
An instruction references its entity, owner and counterparty. Legs reference an instruction and an account. Evidence lines, attachments, decisions, deals and receipts each reference one instruction as Parent. Snapshots and reconciliation items reference an account; matched items also reference their instruction. Each account references the counterparty that holds it.
Import counterparties and entities by Code, accounts by account code and external account ID, and evidence and reconciliation items by provider event ID. Keep revisions and operation keys as recorded.
Migration order
- Load Organizations, Users and team members.
- Load financial counterparties with eligibility notes, then financial accounts with external identifiers.
- Load opening account snapshots per account for the pilot start date.
- Load open bank instructions with their instruction accounts, record attachments and existing review decisions.
- Load open treasury deals under their instructions, and bank evidence already received.
- Reconcile opening balances, open instructions and deals with the source, test permissions and replay the exception cases before the first live day.
Set up Treasury Operations your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.