Bank account analytics
{
Attribute | Data type | Description | Required extra_field |
---|---|---|---|
| Bank Account PKPK - PK stands for Primary Key, a unique value assigned to specific objects. A PK is used to identify an object using one of the Query Endpoints. We represent primary keys as unsigned 64-bit integers. | ||
| Book PKPK - PK stands for Primary Key, a unique value assigned to specific objects. A PK is used to identify an object using one of the Query Endpoints. We represent primary keys as unsigned 64-bit integers. | ||
| Text | Bank Account Name, constructed from | |
| Text | Bank name. Will have a value of "Unknown" if we couldn't recognize the bank. | |
| Text | Bank Account Number | |
| This includes SAVINGS, CHECKING, CREDITCARD, IOLTA. | ||
| This includes BUSINESS, PERSONAL, UNKNOWN. | ||
| Text | Name of Bank Account Holder | |
| Text | Address of Bank Account Holder | |
| A series of date ranges indicating periods of activity | ||
| List of Period Analytics | List of Statement Period Analytics for this Bank Account | |
| Integer | Count of Transactions | |
| Integer | The total number of days in all statement periods captured in the bank account. | |
| The average absolute value of all transactions in a calendar month. | ||
| The average daily ending balance (including weekends). | ||
| The average daily ending balance (including weekends) in a calendar month. | ||
| The average daily ending balance of weekdays. |
| |
| The average daily balance of weekdays in a calendar month (measured at the end of each weekday). |
| |
| The average value of credit transactions in a calendar month. | ||
| A list of the daily ending balances for every day. | ||
| The value of the largest credit transaction in a calendar month. | ||
| The value of the smallest credit transaction in a calendar month. | ||
| The sum of all credit transactions in a calendar month. | ||
| The count of credit transactions in a calendar month. | ||
| The total monetary value of credits. |
| |
| Integer | The total number of credit transactions. |
|
| The total monetary value of debits. |
| |
| Integer | The total number of debit transactions. |
|
| The lowest end-of-day balance in a calendar month | ||
| The list of all days in which the daily ending balance fell below zero in a calendar month. | ||
| The list of all weekdays in which the daily ending balance fell below zero in a calendar month. |
| |
| List of Transactions | The list of credit transactions that are excluded from the “Estimated Revenue by Month” calculation. |
|
| Integer | The number of unique NSF & Overdraft fees for each bank account. This is especially useful with institutions that lump NSF fees into one transaction. |
|
| The number of unique NSF fees each month. This is especially useful with institutions that lump NSF fees into one transaction. |
| |
| List of Transactions | A list of fees associated with non-sufficient funds and overdraft transactions. | |
| List of Transactions | A list of fees associated with overdraft transactions. |
|
| List of Transactions | A list of fees associated with returned and/or unpaid items due to NSF fees. |
|
| List of Period Mismatches | An indication of gaps between statement periods captured in the bank account. | |
| List of Transactions | A list of transactions with the same dollar value that are greater than $10 and occur two or more times within 45 days. |
|
| List of Transactions | A list of transactions that end in at least five zeroes, e.g., $1,000.00. | |
| List of Transactions | The list of all debits transactions from a bank account. |
|
| The value of the largest debit transaction in a calendar month. | ||
| The sum of all debit transactions in a calendar month. | ||
| List of Transactions | The list of credit transactions that did not originate from one of the accounts within the application. | |
| List of Transactions | A list of all transactions to/from any bank or financial institution. | |
| List of Transactions | A list of all transactions to/from alternative lenders, including small business lenders, personal lenders, mortgage players, and others in the online lending space. This list also includes transactions relating to Merchant Cash Advance and Factoring, though these are separately filtered in unique lists for Merchant Cash Advance Transactions and Factoring Transactions. | |
| List of Transactions | A list of all transactions to/from invoice factoring companies. |
|
| List of Transactions | A list of all transactions to/from debt consolidation companies. |
|
| List of Transactions | A list of all transactions to/from merchant cash advance companies. |
|
| The estimated revenue of the business in a calendar month. This is calculated by summing together all credit transactions, then removing all transfer credits (except for wire transfers), all alternative lender credits (except for factoring credits), and all transactions that contain words that signify that they are not revenue deposits. This includes words such as Refund, Reversal, Cash Back, Return, and about 20 others. | ||
| The list of credit transactions that comprise the estimated revenue calculations for the business in a calendar month |
| |
| List of Transactions | The list of credit transactions that comprise the estimated revenue of the applicant. |
|
| List of Transactions | A list of all transactions from payroll providers. |
|
| Average count of NSF transactions that have paid or negative balances in a calendar month |
| |
| Average count of NSF transactions that have returned or unpaid balances in a calendar month |
| |
| Integer | Number of Transfers: Total number of transfer txns (postive and negative txns matching with transfer term list) in the bank account |
|
| Amount of Transfers: Sum of transfer txns' amounts (postive and negative txns matching with transfer term list) in the bank account |
| |
| Integer | Number of Payroll Payments: For business account only, the total number of payroll txns (negative txns matching with payroll term list) in the bank account |
|
| Amount of Payroll Payments: For business account only, the sum of payroll txns' amounts (negative txns matching with payroll term list) in the bank account |
| |
| Integer | Number of transactions ending in 4 zeros (00.00) |
|
| Object (see MCA Recurring Txns table below) | Summary of payments to merchant cash advance lenders. |
|
| Integer | Number of Venmo, Zelle, and Cash App Transactions: Total number of txns that include terms such as venmo, zelle or cashapp |
|
| Amount of Venmo, Zelle, and Cash App Transactions: Sum of amounts for venmo, zelle and cash app transactions |
| |
| Integer | Number of ATM Withdrawals: Total number of all ATM withdrawals from the bank account |
|
| Amount of ATM Withdrawals: The sum of all atm withdrawal amounts |
| |
| Integer | Number of merchant service deposits: Total number of merchant service deposits (positive txns matching with merchant service terms) in the bank account |
|
| Amount of merchant service deposits: The sum of merchant service deposit txn amounts (positive txns matching with merchant service terms) in the bank account |
| |
| Integer | Number of remote capture deposits: Total number of remote deposits in the bank account |
|
| Amount of remote capture deposits: Sum of remote deposit amounts in the bank account |
| |
| Integer | Number of checks in the bank account |
|
| Money, Integer | Most commonly occuring check amount (of the highest incidence) as well as the number of such occurrences |
|
}
MCA recurring txns additional info
{
Attribute | Data Type | Description |
---|---|---|
| Integer | Payment frequency. |
| Recurring payment amount. | |
| Date | First payment date. |
| String | Lender nam |
}
Updated 3 months ago