MCA/ Cash Flow Underwriting

​

Overview

1. Supercharge underwriters: Speed up underwriting by an order of magnitude vs. having to manually parse bank data
2. Expand addressable market: Underwrite businesses without up-to-date accounting or e-commerce data
3. Catch fraud: Because bank data is up-to-date, we have enabled customers to avoid millions of dollars in losses to customers who were loan stacking or had other previously unidentified risk factors

​

Post & enrich company bank data

​

Create an end user and enrich transactions

1. Create an end_user: Begin by creating an end_user in Heron’s systems that corresponds to a company/applicant in your systems. You do this by sending a POST end_users request.
   1. For the end_user_id field, use a canonical reference/identifier for the company
   2. Note: If you are sending transactions for a company that you’ve already sent to Heron before, skip this step.
2. Send Transactions to Heron Once you have created the end_user, you can start sending us transactions in many ways
   1. Set up a Direct Plaid Integration - this is recommended if you use Plaid and want to perform ongoing portfolio monitoring. By setting up a Direct Plaid Integration, we will automatically retrieve new transactions automatically from Plaid whenever there is an update, without any manual intervention required. Steps to set up this integration can be found here
   2. Send PDF bank statements - note: this will incur a separate fee per bank statement and PDF parsing must be enabled for your account prior to uploading the documents. Steps to set up this integration can be found here
   3. Send system output files - Heron can accept certain files directly without any manipulation. For example, if you use Plaid but do not wish to integrate Heron directly to Plaid, then you can send us Plaid reports instead
      1. Plaid - Assets Report
      2. Plaid - Transactions Report
      3. Ocrolus Report
   4. POST transactions via API
      1. If you want to send us transactions directly from your system, you can POST transactions for a given end_user using the /end_users/{end_user_id}/transactions endpoint for sending requests.
      2. Note: Please batch up to 20k transactions per request
3. Process Transactions: When you are done sending us transactions for a company, please send a PUT end_users request, indicating that the end_user is ready for processing.
   1. Note: if you have set up a Direct Plaid Integration or are sending Heron PDF bank statements, skip this step.
4. Listen to webhook: We will notify you via a webhook when the end_user_id is processed, and available for you to retrieve. You can configure your webhook in the dashboard.
5. Get transactions: Once you have received the webhook, you can send a request to retrieve the enriched transaction data.
   1. Note: We still support the /transactions endpoint that was previously used by most customers. The new endpoint that is now standard is much more performant, so we recommend using that endpoint instead. If using the old endpoint, you can use the end_user_id parameter to ensure you only pull transactions for the end_user_id that was just enriched. If you get transactions for a company that you’ve already sent to Heron before, you can use the last_updated_min filter to only get transactions where labels have changed since the last time you send and fetched transactions.

​

Inspect company using the dashboard

1. Navigate to the All Companies page. This will give you an overview over the companies (i.e., end_user) you have created.

2. You can see the status of the company in the status column of the main table. To view the generated reports for a company, click on the companies’ name.
3. To ensure that the reports are suitable for underwriting, confirm that the three sets of data quality checks have passed for the company (i.e. Data Sources, Accounts, Transactions).
   1. To view the data checks, click on the applicable application component on the left hand panel and then Data Checks at the top
4. If all of the Data Quality checks have passed, navigate to one of the Underwriting Reports for one of the companies. Here, you will see multiple reports that visualize Deposits, Withdrawals, Debt, Revenue, P&L, risk flags and other financial metrics about the company.
5. To inspect the transactions uploaded, click on the transactions button on the left.
6. To verify all possible categories that your model may attach to transactions, navigate to the Categories tab. You can inspect all labels there.

​

Retrieve aggregate metrics on a company

​

Get Heron Scorecard

• Data Quality: Measures to help you understand the quality and completeness of the bank data our analysis is based on, e.g. Data Coverage & Data Freshness. Also includes a measure to see what percentage of all transactions (as a proportion of revenue) appear to be going to an unconnected account held by the company we are analysing.
• Risk Flags: Flags like ATM Cash Withdrawals and distinct days with insufficient funds / overdraft fees.
• Balance: Statistics about average, max and min balances.
• Profit & Loss: Approximations of standard cashflow-based metrics like Revenue, Net Operating Cashflow, etc.
• Debt: Number, recency and amounts of recent debt investments and repayments

​

Get historical timeseries

1. The end_user_id of the company you are looking at
2. The time periods over which you want to aggregate, often this is per month (date_granularity)
3. Whether you want to pivot by merchant, category or both
4. If you want to see only certain categories, filter by category_heron_ids

https://app.herondata.io/api/end_users/statistics?end_user_id=12345&group_by=category&date_granularity=month&category_heron_ids={category_heron_id_for_revenue}

​

Get forecast