Hemrock
hemrock.com
What it is
Hemrock Portfolio is an open-source platform for venture funds that turns company updates into structured metrics, dashboards, monitoring and LP reporting. Users can forward PDF, Excel, PowerPoint or plain-text updates; AI extracts metrics and flags uncertain results for review. The platform charts MRR, burn, headcount and custom KPIs over time, and can draft quarterly LP letters and investor report cards. It supports user-provided AI keys for Anthropic, OpenAI, Google Gemini and OpenRouter, as well as local models through Ollama. Designed to run on a customer’s own infrastructure, database and AI keys, it is described by Hemrock as keeping portfolio data separate from other funds and out of model training. The Apache License 2.0 permits personal or commercial use. Optional Fund Operations adds a double-entry ledger for funds, SPVs, direct deals or GP entities, plus period closing and a compliance calendar. Self-hosted use is free; Hosted starts at $250 a month, and Setup and support starts at $2,500, paid once.
Spec sheet
- What it does
- Hemrock provides open-source financial models, browser tools, and venture-fund portfolio software for founders and investors.Read 15 Oct 2026 · hemrock.com
- Product
- Portfolio is an open-source platform for venture funds that turns portfolio-company updates into structured metrics, dashboards, monitoring, and LP reporting.Read 3 Oct 2026 · hemrock.com
- Intended users
- Hemrock describes Portfolio for SPVs, solo GPs and emerging managers, angels and syndicates, and micro and seed funds.Read 3 Oct 2026 · hemrock.com
- Integrations
- A prebuilt, one-way Affinity integration imports deal and relationship data into portfolio and diligence views; webhooks are listed as coming soon.Read 3 Oct 2026 · hemrock.com
- Support
- Every purchase includes free email, phone, and WhatsApp support for understanding and using the models.Read 15 Oct 2026 · hemrock.com
- License
- Portfolio is free and open source under Apache License 2.0, and the page says it may be modified and deployed for personal or commercial use.Read 3 Oct 2026 · hemrock.com
- Founded
- 2005Read 28 Sep 2026 · hemrock.com
- Maker
- Taylor Davidson is identified as Hemrock's founder and managing director.Read 15 Oct 2026 · hemrock.com
- AI providers
- The portfolio platform supports user-provided AI keys for Anthropic, OpenAI, Google Gemini, and OpenRouter, as well as local models through Ollama.Read 3 Oct 2026 · hemrock.com
- AI review queue
- Low-confidence extractions and newly detected companies are placed in a review queue before they are committed.Read 15 Oct 2026 · hemrock.com
- API and MCP
- A fund API and MCP server expose portfolio data and tools to scripts and AI clients, scoped to the access allowed by the key or user.Read 3 Oct 2026 · hemrock.com
- API authentication
- API requests use bearer tokens created in account settings, and a leaked key can be revoked there.Read 15 Oct 2026 · hemrock.com
- API engines
- The public API exposes cap-table, exit-waterfall, and fund-economics compute endpoints.Read 15 Oct 2026 · hemrock.com
- API free allowance
- Each account receives ten lifetime free calculations per product before paid access is needed.Read 15 Oct 2026 · hemrock.com
- API limits
- API requests are limited to 60 compute attempts per minute per account and product, with 256 KB inputs and 4 MB outputs.Read 15 Oct 2026 · hemrock.com
- API maturity
- The API is version 0.1.0 and the documentation warns that its wire format may change while the contract settles.Read 15 Oct 2026 · hemrock.com
- Cap table
- The browser cap-table tool models financing rounds, SAFEs, option pools, and dilution with ownership calculations.Read 15 Oct 2026 · hemrock.com
- Company and maker
- Hemrock is a DBA of Unstructured Ventures, LLC, and its about page identifies Taylor Davidson as the maker.Read 3 Oct 2026 · hemrock.com
- Company founded
- LinkedIn lists the predecessor Hemrock (formerly Foresight) as founded in 2013.Read 15 Oct 2026 · linkedin.com
- Company headquarters
- LinkedIn lists Hemrock's headquarters at 6360 Broad Street, Pittsburgh, Pennsylvania 15206.Read 15 Oct 2026 · linkedin.com
- Company legal identity
- Hemrock identifies itself as a doing-business-as entity of Unstructured Ventures, LLC, a Delaware limited liability company.Read 15 Oct 2026 · hemrock.com
- Company size
- LinkedIn lists Hemrock as having one employee and shows three discoverable employees.Read 15 Oct 2026 · linkedin.com
- Deployment stack
- Documented deployment uses Netlify or Vercel, Supabase, Postmark or Mailgun, and Anthropic, OpenAI, or OpenRouter.Read 15 Oct 2026 · hemrock.com
- Documentation depth
- Hemrock publishes a documentation hub with model guides, AI prompt guidance, MCP setup, deployment instructions, and a changelog.Read 15 Oct 2026 · hemrock.com
- Exit waterfall
- The exit-waterfall tool models preferences, participation, caps, conversion choices, and shareholder proceeds.Read 15 Oct 2026 · hemrock.com
- External project activity
- The public Portfolio repository had 56 stars and 15 forks when viewed.Read 15 Oct 2026 · github.com
- Founder background
- Taylor Davidson's resume says he founded and operates Hemrock/Unstructured Ventures and has sold more than $1 million of financial models cumulatively by 2023.Read 15 Oct 2026 · taylordavidson.com
- Fund accounting
- Its optional Fund Operations product provides a double-entry ledger for funds, SPVs, direct deals, or GP entities, with period closing and a compliance calendar.Read 3 Oct 2026 · hemrock.com
- Fund economics
- The Fund Economics Tool forecasts fees, carry, recycling, deployment pacing, and LP/GP returns.Read 15 Oct 2026 · hemrock.com
- Fund operations
- Optional fund operations adds double-entry accounting, capital accounts, statements, carry, period close, and compliance workflows.Read 15 Oct 2026 · hemrock.com
- Google Drive integration
- An optional Google Drive connection files documents automatically into company-specific folders.Read 15 Oct 2026 · hemrock.com
- Import capabilities
- Portfolio accepts PDF, Excel, Word, PowerPoint, CSV, image, pasted, and free-form transaction inputs.Read 15 Oct 2026 · hemrock.com
- Investment workflow
- The open-source platform includes inbound deal screening, thesis scoring, diligence checklists, sourced research, and investment-memo drafting.Read 15 Oct 2026 · github.com
- Limit: AI extraction
- Extracted portfolio data can be uncertain and requires human review before being saved.Read 15 Oct 2026 · hemrock.com
- Limit: fund API detail
- The Fund Economics API is an aggregate fund-life forecast and does not provide the quarterly cash-flow detail of the full VC spreadsheet model.Read 15 Oct 2026 · hemrock.com
- Limit: self-hosting
- Self-hosting transfers infrastructure and security operations to the customer.Read 15 Oct 2026 · hemrock.com
- LP reporting
- LP features track commitments, paid-in capital, distributions, and NAV, and generate statements, quarterly letters, and portal documents.Read 15 Oct 2026 · github.com
- MCP support
- The same calculation engines are available to compatible AI clients through Hemrock's MCP server.Read 15 Oct 2026 · hemrock.com
- News: hosted models
- Hemrock announced on April 29, 2026 that the Fund Economics spreadsheet model was available as a browser-hosted model.Read 15 Oct 2026 · hemrock.com
- News: rebrand
- The About page says Hemrock renamed Foresight and rebuilt its product around AI in 2026.Read 15 Oct 2026 · hemrock.com
- Open-source licence
- The Portfolio software and financial models are released under the Apache License 2.0.Read 15 Oct 2026 · hemrock.com
- Portfolio reporting
- Portfolio Reporting tracks company metrics, valuations, proceeds, TVPI, DPI, and Net IRR from submitted updates and imported data.Read 15 Oct 2026 · github.com
- Reporting
- The platform charts MRR, burn, headcount, and custom KPIs over time and can draft quarterly LP letters and investor report cards.Read 3 Oct 2026 · hemrock.com
- Security and data control
- The portfolio product is designed to run on the customer's infrastructure, database, and AI keys; Hemrock says portfolio data is not shared with other funds or used to train models.Read 3 Oct 2026 · hemrock.com
- Security controls
- The platform states that it uses role-based access, row-level security, encrypted API-key storage, Supabase Auth, and optional multi-factor authentication.Read 15 Oct 2026 · hemrock.com
- Security responsibility
- For self-hosted installations, the customer is responsible for securing infrastructure, configuration, keys, encryption, and backups.Read 15 Oct 2026 · hemrock.com
- Self-hosting
- Portfolio is designed as a single-tenant deployment where the customer controls infrastructure, domain, database, and API keys.Read 15 Oct 2026 · hemrock.com
- Spreadsheet limitation
- The downloadable spreadsheet models do not have an API; integrations occur inside Excel or Google Sheets.Read 15 Oct 2026 · hemrock.com
- Update processing
- Users can forward founder updates as PDF, Excel, PowerPoint, or plain text; AI extracts metrics and flags uncertain results for review.Read 3 Oct 2026 · hemrock.com
Plans and prices
Free pay-what-you-want tools Free Cap Table & Exit Waterfall · Runway · Fund Economics · SaaS Forecasting · Ecommerce Forecasting · Unit Economics · Venture Valuation Read 15 Oct 2026 · hemrock.com
Self-hosted Free Free All funds, SPVs, and team · No per-seat fees · Runs on your infrastructure; estimated running costs roughly $0 to $75 a month Read 3 Oct 2026 · hemrock.com
Cap Table & Exit Waterfall API/MCP compute $20 a year annually 6,000 successful calculations · shared allowance for both engines · no automatic overages Read 15 Oct 2026 · hemrock.com
Fund Economics API/MCP compute $20 a year annually 6,000 successful calculations · independent allowance · no automatic overages Read 15 Oct 2026 · hemrock.com
How to build fund infrastructure with AI workshop $75, paid once single live session Workshop seat Read 15 Oct 2026 · hemrock.com
Standard Financial Model $149, paid once one-time purchase with lifetime access to the major version Excel download or Google Sheets copy · updates included Read 15 Oct 2026 · hemrock.com
Cap Table, Exit Waterfall, and Portfolio Construction workshop $175, paid once single live session Workshop seat Read 15 Oct 2026 · hemrock.com
Hosted $250 a month From $250/mo · Cancel anytime Hosting and maintenance · Onboarding included · Ongoing support included · Early access Read 3 Oct 2026 · hemrock.com
Working session $395, paid once one-hour session Model setup, fixes, review, or AI workflow help Read 15 Oct 2026 · hemrock.com
Setup and support $2,500, paid once From $2,500 · One-time Deployment on your infrastructure · Setup, onboarding, and data migration included · Ongoing support available Read 3 Oct 2026 · hemrock.com
Custom model Priced on request quoted; most $1K to $10K Custom revenue model, fund forecast, or cap table Read 15 Oct 2026 · hemrock.com
Strong points and limits
Strong points
- Processes updates in PDF, Excel, PowerPoint or plain text.
- Charts MRR, burn, headcount and custom KPIs.
- Supports local models through Ollama.
- Apache 2.0 license permits commercial deployment.
- Self-hosted plan has no per-seat fees.
Limits
- Hosted service starts at $250 a month.
- Setup and support starts at $2,500, paid once.
- Affinity integration is one-way.
- Webhooks are listed as coming soon.
Who it suits
Portfolio is intended for SPVs, solo GPs and emerging managers, angels and syndicates, and micro and seed funds. The self-hosted option may suit funds that want to run the platform on their own infrastructure.
Verdict
Hemrock Portfolio combines update processing, fund reporting and optional fund operations, with deployment on a fund’s own infrastructure or a paid hosted option. Review the implementation and support costs, and note that webhooks are not yet listed as available.
Where Specifiction places it
- Fund Administration Software#1 of 308.7
- Cap Table Management Software#2 of 268.7
