batch_import_from_document
ChatGPTBatch import positions and/or transactions from a spreadsheet or PDF in one go, without approval. Use ONLY when the data comes from an attached xlsx, csv, or PDF and there are MORE than 20 positions and/or transactions to create. For 20 or fewer items use the regular create_position, create_position_with_initial_transaction and create_transaction tools. This tool executes immediately and creates all positions first, then all transactions (transactions can reference positions by positionName from this batch or existing holdings). Dates in DD/MM/YYYY. For statement imports, pass bankAccountName and portfolioName to auto-group holdings under a parent portfolio and bank account. When the user only wants a portfolio shell or fund total without nesting every line under that parent (rollup-only import), set rollupPortfolioImport to true with portfolioName: the parent is created with trackUnderlyingLines false and imported rows are not auto-nested under it (they stay top-level unless each row sets parentPositionId). Use transaction type Buy when the row has both a purchase/transaction date and purchase price (or unit cost); use Point in Time Valuation only when the purchase date is unknown and you only have as-of statement data. For capital calls, when commitment/draw and subscription fee (or similar) are separate in the source, set value to the commitment and fees to the fee — do not put the combined total in value and describe the split only in notes.
calendar_events
ChatGPTMeetings and appointments. Do not use this for capital calls, invoices, or payment due dates — those are tasks. Set action to one of: - search: Search events in a date range. Use displayTimeRange for user-facing times. - create: Create an event. Runs immediately. Required: title, startAt, endAt. - update: Update an event by id. Runs immediately. Required: eventId.
calendar_events_write
ChatGPTChanges to calendar events. Each call queues an approval in FamilyOFX; nothing changes until a user accepts it. Meetings and appointments. Do not use this for capital calls, invoices, or payment due dates — those are tasks. Set action to one of: - create: Create an event. Runs immediately. Required: title, startAt, endAt. - update: Update an event by id. Runs immediately. Required: eventId. - remind_next_statement: After processing an attached statement or periodic fund report, add the reminder to upload the next one in 92 days. Runs immediately. Required: reports.
cashflow_plans
ChatGPTCash flow plan and forecast rows for one holding. Search with positions action "search" first. Dates are YYYY-MM-DD. Set action to one of: - get: Read the plan and forecast rows. Returns plan null when the holding has no plan. Does not create one. - update: Set plan type and assumptions. Open prompt needs notes. Set regenerate: true to generate forecast lines from the schedule. pe and debt_amortizing are for eligible fund vehicles only (top-level venture, pe, hedge, real estate, debt_fund, infrastructure). Runs immediately in chat. MCP queues an approval. - edit_predictions: Create, update, or delete CAPITAL_CALL, DISTRIBUTION, and DIVIDEND rows. Dates are YYYY-MM-DD. Value is a positive amount in the holding currency. Locked rows are skipped unless the update sets locked: false. Runs immediately in chat. MCP queues an approval.
cashflow_plans_write
ChatGPTChanges to cashflow plans. Each call queues an approval in FamilyOFX; nothing changes until a user accepts it. Cash flow plan and forecast rows for one holding. Search with positions action "search" first. Dates are YYYY-MM-DD. Set action to one of: - update: Set plan type and assumptions. Open prompt needs notes. Set regenerate: true to generate forecast lines from the schedule. pe and debt_amortizing are for eligible fund vehicles only (top-level venture, pe, hedge, real estate, debt_fund, infrastructure). Runs immediately in chat. MCP queues an approval. - edit_predictions: Create, update, or delete CAPITAL_CALL, DISTRIBUTION, and DIVIDEND rows. Dates are YYYY-MM-DD. Value is a positive amount in the holding currency. Locked rows are skipped unless the update sets locked: false. Runs immediately in chat. MCP queues an approval.
companies
ChatGPTCompanies. Search before create. Set action to one of: - search: Search companies.
companies_write
ChatGPTChanges to companies. Each call queues an approval in FamilyOFX; nothing changes until a user accepts it. Companies. Search before create. Set action to one of: - create: Create a company. Requires approval. Required: name. - update: Update a company. Requires approval. Required: companyId.
contacts
ChatGPTPeople. Search before create. Set action to one of: - search: Search contacts by name, email, or type. - create: Create a contact. Requires approval. Needs an email or phone. Required: name. - update: Update a contact. Requires approval. Required: contactId.
contacts_write
ChatGPTChanges to contacts. Each call queues an approval in FamilyOFX; nothing changes until a user accepts it. People. Search before create. Set action to one of: - create: Create a contact. Requires approval. Needs an email or phone. Required: name. - update: Update a contact. Requires approval. Required: contactId.
costs
ChatGPTRecurring and one-off costs. Set action to one of: - search: Search costs.
costs_write
ChatGPTChanges to costs. Each call queues an approval in FamilyOFX; nothing changes until a user accepts it. Recurring and one-off costs. Set action to one of: - create: Create a cost. Requires approval. Required: name, type, frequency, amount, startDate, legalEntityId. - update: Update a cost. Requires approval. Required: costId.
deals
ChatGPTDealflow opportunities, not portfolio holdings. Set action to one of: - search: Search deals. - get: Read one deal by id. Required: dealId. - create: Create a deal. Runs immediately. Include notes from the source in the same call. Required: name. - update: Update a deal. Runs immediately. Required: dealId.
deals_write
ChatGPTChanges to deals. Each call queues an approval in FamilyOFX; nothing changes until a user accepts it. Dealflow opportunities, not portfolio holdings. Set action to one of: - create: Create a deal. Runs immediately. Include notes from the source in the same call. Required: name. - update: Update a deal. Runs immediately. Required: dealId.
documents
ChatGPTFiles already in the organisation. Set action to one of: - search: Find documents. Filter by positionId, transactionId, or messageId. - read: Read document text by documentIds or messageId. Use startLine when nextStartLine is set. Never ask the user to split or re-upload.
documents_write
ChatGPTChanges to documents. Each call queues an approval in FamilyOFX; nothing changes until a user accepts it. Files already in the organisation. Set action to one of: - attach: Attach an existing document to a record. Runs immediately. Required: documentId.
get_approval_status
ChatGPTCheck a change queued by a *_write tool. Returns status pending, approved, or rejected; once approved, also what the change returned (for example the new record id).
get_portfolio_summary
ChatGPTRecorded portfolio snapshot: consolidated NAV in the organisation currency, allocation, currency exposure, largest exposures, and underlying holdings inside a parent. A valued parent is counted once; its children are listed separately and are not added again. Returns stored valuations with status ready. Not live market quotes and not a performance return.
legal_entities
ChatGPTLegal entities that own holdings, accounts, and costs. Set action to one of: - search: Search legal entities. Use the id as legalEntityId on creates.
legal_entities_write
ChatGPTChanges to legal entities. Each call queues an approval in FamilyOFX; nothing changes until a user accepts it. Legal entities that own holdings, accounts, and costs. Set action to one of: - create: Create a legal entity. Requires approval. Required: legalName.
list_pending_approvals
ChatGPTList pending MCP tool calls awaiting approval.
portfolio_analytics
ChatGPTFixed portfolio analyses on recorded data. view "breakdown" splits consolidated NAV (organisation currency) by groupBy: legal_entity, custodian, position_type, or currency; groups add up to consolidatedNav. view "cash_flows" sums transactions by interval (month, quarter, year), type, and holding currency between from and to (YYYY-MM-DD, default the last 12 months, at most 10 years); amounts are not converted. Optional positionId limits cash_flows to one holding. Not a performance return.
positions
ChatGPTHoldings. Search before create. Do not call this on the first turn when the user only asked to add a holding in chat — propose the draft first. Set action to one of: - search: Find holdings. Use parentPositionId to list owned children. includeInactive for closed holdings. - top: Largest holdings by recorded value. includedInConsolidatedTotal false means the line is already inside a parent.
positions_write
ChatGPTChanges to positions. Each call queues an approval in FamilyOFX; nothing changes until a user accepts it. Holdings. Search before create. Do not call this on the first turn when the user only asked to add a holding in chat — propose the draft first. Set action to one of: - create: Create a holding. Requires approval. Required: name, legalEntityId. - create_with_transaction: Create a holding and its opening transaction. Requires approval. Required: name, legalEntityId, initialTransaction. - update: Update holding metadata. Requires approval. To edit notes, send the complete text and replaceNotes true (search returns the current notes). Named people use managerContactId or contactPersonId, not notes. Do not patch NAV from a new statement — use transactions action create with type Point in Time Valuation. Required: positionId.
product_docs
ChatGPTHow FamilyOFX works. Not live portfolio data. Set action to one of: - search: Search product documentation. Required: query. - get: Read one doc page by slug. Required: slug.
source_widget
ChatGPTCall with the user's question before answering something a report card might cover (book, allocation, liquidity, performance, costs, news, tasks, philanthropy, constitution). Returns one gallery widget and its data, or no widget.
tasks
ChatGPTChecklist tasks. Payment due dates belong here, not on calendar events. Set action to one of: - list: List tasks. - create: Create a task the user asked to capture. Runs immediately. Required: title. - update: Update a task by id. Runs immediately. Required: taskId. - complete: Mark a task done. Runs immediately. Required: taskId.
tasks_write
ChatGPTChanges to tasks. Each call queues an approval in FamilyOFX; nothing changes until a user accepts it. Checklist tasks. Payment due dates belong here, not on calendar events. Set action to one of: - create: Create a task the user asked to capture. Runs immediately. Required: title. - update: Update a task by id. Runs immediately. Required: taskId. - complete: Mark a task done. Runs immediately. Required: taskId.
transactions
ChatGPTCash flows on holdings. Value is always positive; direction comes from type. Set action to one of: - search: List transactions for a holding or search.
transactions_write
ChatGPTChanges to transactions. Each call queues an approval in FamilyOFX; nothing changes until a user accepts it. Cash flows on holdings. Value is always positive; direction comes from type. Set action to one of: - create: Create a transaction. Requires approval. Needs type, value, date (DD/MM/YYYY), and positionId or positionName or positionSymbol. Required: type, value, date.