-- Main reconciliation tracking
reconciliation_groups:
  - id: string (reconciliation identifier)
  - status: PENDING | IN_PROGRESS | COMPLETED | CANCELLED | ERROR
  - reconciled_at: timestamp
  - reconciled_by_id: user reference
  - org_id: organization reference

-- General ledger entries with reconciliation links
general_ledger:
  - credit_should_reconcile_gid: string (grouping identifier)
  - debit_should_reconcile_gid: string (grouping identifier)
  - credit_reconciliation_group_id: reference to reconciliation_groups
  - debit_reconciliation_group_id: reference to reconciliation_groups

-- Account configuration
chart_of_accounts:
  - to_be_reconciled: boolean (enables reconciliation for account)

// Core logic: get-reconciliation-groups.ts
1. Find accounts marked for reconciliation (to_be_reconciled = true)
2. Query unreconciled GL entries on these accounts
3. Group entries by reconciliation GID
4. Filter groups where total = 0 and entries > 1
5. Return paginated reconcilable groups

// Core logic: process-reconciliation-group.ts
1. Validate group eligibility (balance = 0, multiple entries)
2. Create reconciliation_groups record
3. Update GL entries with reconciliation_group_id
4. Extract and connect related documents
5. Return reconciliation result

// Temporal workflow hierarchy
Global Workflow:
├── Get organizations with auto-reconciliation enabled
├── Start organization workflows concurrently (batch of 5)
└── Monitor completion

Organization Workflow:
├── Fetch reconciliation groups (batch of 50)
├── Process each group sequentially
├── Log results and continue pagination
└── Report completion statistics

// Get reconciliation groups
interface GetReconciliationGroupsParams {
  organizationId: string;
  batchSize?: number;
  offset?: number;
}

// Process reconciliation group
interface ProcessReconciliationGroupParams {
  group: ReconGroup;
  organizationId: string;
  reconciliationId?: string;
}

// Reconciliation group structure
interface ReconGroup {
  entries: {
    id: string;
    amount: number;
    isCredit: boolean;
    general_ledger: {
      organization: { id: string };
    };
  }[];
  total: number; // Must be 0 for reconciliation
}

// Search GL entries for reconciliation
searchGeneralLedgerForReconciliation({
  searchParams: { [key: string]: string | string[] | undefined };
  accountNumber: string;
})

// Start manual reconciliation workflow
startReconciliationWorkflow(): Promise<{ workflowId: string }>

// Update reconciliation entries
setReconciliationEntriesAsReconciled({
  entries: ReconciliationEntry[];
  reconciliationId: string;
})