How to build a Capital Account Statements Agent

Workflow Overview

1. User Input & File Uploads

• User Instructions (in-0):
  The user provides instructions or context for the extraction/normalization process.

• Capital Account Statements (doc-0):
  The user uploads one or more capital account statement files (PDF or Excel). These are processed with OCR to extract text, making them usable for AI analysis.

• Legal Entities Reference (doc-1):
  The user uploads a file (CSV or Excel) containing a reference list of legal entities. This is also processed for text extraction.

2. Data Extraction with AI

• Extract Capital Statement Data (llm-0):
  This AI node takes the uploaded capital account statements and the user’s instructions.
  It extracts key fields such as:

  • Name of Holding

  • Legal Entity

  • Beginning Balance

  • Contributions / Calls

  • Distributions

  • Gain/Loss

  • Ending Balance

  • Period or Date
    The extraction is structured for further processing.

• Extract Legal Entity Names (llm-1):
  This AI node processes the legal entities reference file to extract a clean list of legal entity names.

3. Summarization & Formatting

• Summarize (llm-2):
  This AI node combines the outputs from the previous two extraction steps.
  It generates a well-formatted summary table that:

  • Presents the extracted capital statement data

  • Lists the legal entity names

  • Notes any missing or unclear data

4. Output

• Output (out-0):
  The final, formatted summary is presented to the user as the workflow’s output.

How the Data Flows

1. User provides instructions and uploads files.

2. Files are processed and text is extracted.

3. AI nodes extract structured data from the files.

4. A summary is generated, combining all extracted information.

5. The user receives a clear, tabular summary as the final output.

Visual Node Map

In summary:
This workflow automates the extraction and summarization of key financial data from uploaded capital account statements, cross-references it with a legal entities file, and delivers a clear, structured summary to the user.