Ocrolus Attributes

Book ID

A unique numerical identifier for a Book, commonly referred to as the Book primary key (Book pk).

Book Name

The name of the Book used for the analytics calculation.

Transaction Count

The number of transactions considered for analytics calculation.

Daily Balances

A time series showing the daily balances on a daily basis.

Daily Cash Flows

A daily time series of cash flows, calculated as the difference between total credits and total debits, arranged in chronological order.

Average Daily Cash Flow

The average value in daily_cash_flows.

Monthly Net Cash Flows

Cash flows resulting from the difference between total credits and total debits, categorized by calendar month.

Monthly Minimum Balance

The minimum daily balance grouped by calendar month.

Monthly Maximum Balance

The maximum daily balance grouped by calendar month.

Average Daily Balance

The average amount in daily_balances.

Monthly Average Daily Balance

The average daily balance grouped by calendar month.

Average Weekday Balance

The average daily balance on weekdays.

Monthly Average Weekday Balance

The average daily balance on weekdays grouped by calendar month.

Total Days Analyzed

Total number of days for which analytics is calculated.

Monthly Negative Balance Days

List of dates with negative ending balances grouped by calendar month.

Monthly Weekday Negative Balance Days

List of dates with negative ending balances on weekdays grouped by calendar month.

Monthly Weekday Negative Balance Count

Count of negative ending balances on weekdays grouped by calendar month.

30-Day Cash Balance Trend

((Mean cash balance over first 15 days) - (Mean cash balance over last 15 days)) / standard deviation of cash balance over the period.

60-Day Cash Balance Trend

((Mean cash balance over first 30 days) - (Mean cash balance over last 30 days)) / standard deviation of cash balance over the period.

90-Day Cash Balance Trend

((Mean cash balance over first 45 days) - (Mean cash balance over last 45 days)) / standard deviation of cash balance over the period.

30-Day Cash Flow Trend

((Mean cash flow over first 15 days) - (Mean cash flow over last 15 days)) / standard deviation of cash flow over the period.

60-Day Cash Flow Trend

((Mean cash flow over first 30 days) - (Mean cash flow over last 30 days)) / standard deviation of cash flow over the period.

90-Day Cash Flow Trend

((Mean cash flow over first 45 days) - (Mean cash flow over last 45 days)) / standard deviation of cash flow over the period.

Monthly Average Transaction Size

The average transaction size grouped by month. Includes additional detailed fields.

Monthly Average Deposit Size

The average deposit size grouped by month. Includes additional detailed fields.

Monthly Expenses

Expenses grouped by calendar month.

Monthly Withdrawals

Withdrawals grouped by calendar month.

Monthly Revenue

Revenue grouped by calendar month.

Monthly Revenue Deductions

Revenue deductions grouped by calendar month.

Monthly Deposits

Deposits grouped by calendar month.

Monthly External Deposits

Outside source deposits grouped by calendar month.

Monthly Large Deposits

List of large deposits grouped by calendar month.

Debt Consolidation Inflows

Debt consolidator inflows grouped by calendar month.

Debt Consolidation Outflows

Debt consolidator outflows grouped by calendar month.

Factoring Inflows

Factoring inflows grouped by calendar month.

Factoring Outflows

Factoring outflows grouped by calendar month.

Payroll Inflows

Payroll inflows grouped by calendar month.

Payroll Outflows

Payroll outflows grouped by calendar month.

Insurance Inflows

Insurance inflows grouped by calendar month.

Insurance Outflows

Insurance outflows grouped by calendar month.

Digital Wallet Inflows

Venmo/Zelle/Cash App inflows grouped by calendar month.

Digital Wallet Outflows

Venmo/Zelle/Cash App outflows grouped by calendar month.

ATM Inflows

ATM inflows grouped by calendar month.

ATM Outflows

ATM outflows grouped by calendar month.

Toll Inflows

Toll inflows grouped by calendar month.

Toll Outflows

Toll outflows grouped by calendar month.

PayPal Inflows

PayPal inflows grouped by calendar month.

PayPal Outflows

PayPal outflows grouped by calendar month.

Equipment Lease Inflows

Equipment lease inflows grouped by calendar month.

Equipment Lease Outflows

Equipment lease outflows grouped by calendar month.

Check Deposits

Check inflows grouped by calendar month.

Check Payments

Check outflows grouped by calendar month.

Four-Zero Transaction Inflows

Transactions with four zeros inflows grouped by calendar month.

Four-Zero Transaction Outflows

Transactions with four zeros outflows grouped by calendar month.

Five-Zero Transaction Inflows

Transactions with five zeros inflows grouped by calendar month.

Five-Zero Transaction Outflows

Transactions with five zeros outflows grouped by calendar month.

Recurring Transaction Inflows

Recurring transactions inflows grouped by calendar month.

Recurring Transaction Outflows

Recurring transactions outflows grouped by calendar month.

Fintech Loan Inflows

Fintech loan inflows grouped by calendar month.

Fintech Loan Outflows

Fintech loan outflows grouped by calendar month.

Bank Loan Inflows

Bank loan inflows grouped by calendar month.

Bank Loan Outflows

Bank loan outflows grouped by calendar month.

Other Loan Inflows

Other loan inflows grouped by calendar month.

Other Loan Outflows

Other loan outflows grouped by calendar month.

Fintech MCA Inflows

Fintech MCA (merchant cash advance) inflows grouped by calendar month.

Fintech MCA Outflows

Fintech MCA (merchant cash advance) outflows grouped by calendar month.

Bank Cash Advance Inflows

Bank cash advance inflows grouped by calendar month.

Bank Cash Advance Outflows

Bank cash advance outflows grouped by calendar month.

Debit Card Inflows

Debit card inflows grouped by calendar month.

Debit Card Outflows

Debit card outflows grouped by calendar month.

Credit Card Inflows

Credit card inflows grouped by calendar month.

Credit Card Outflows

Credit card outflows grouped by calendar month.

Merchant Service Inflows

Merchant service inflows grouped by calendar month.

Merchant Service Outflows

Merchant service outflows grouped by calendar month.

SBA Inflows

SBA inflows grouped by calendar month.

SBA Outflows

SBA outflows grouped by calendar month.

Remote Deposit Inflows

Remote inflows grouped by calendar month.

Remote Deposit Outflows

Remote outflows grouped by calendar month.

Benefits Inflows

Benefit inflows grouped by calendar month.

Benefits Outflows

Benefit outflows grouped by calendar month.

Card Reward Inflows

Card reward inflows grouped by calendar month.

Card Reward Outflows

Card reward outflows grouped by calendar month.

Cryptocurrency Inflows

Crypto inflows grouped by calendar month.

Cryptocurrency Outflows

Crypto outflows grouped by calendar month.

Gambling Inflows

Gambling inflows grouped by calendar month.

Gambling Outflows

Gambling outflows grouped by calendar month.

Investment Inflows

Investment inflows grouped by calendar month.

Investment Outflows

Investment outflows grouped by calendar month.

Reversed Transaction Inflows

Reversed inflows grouped by calendar month.

Reversed Transaction Outflows

Reversed outflows grouped by calendar month.

State Tax Inflows

State tax inflows grouped by calendar month.

State Tax Outflows

State tax outflows grouped by calendar month.

Payroll Tax Inflows

Payroll tax inflows grouped by calendar month.

Payroll Tax Outflows

Payroll tax outflows grouped by calendar month.

Internal Transfer Inflows

Internal transfer inflows grouped by calendar month.

Internal Transfer Outflows

Internal transfer outflows grouped by calendar month.

Merchant Service Transfer Inflows

Merchant service transfer inflows grouped by calendar month.

Merchant Service Transfer Outflows

Merchant service transfer outflows grouped by calendar month.

Wire Transfer Inflows

Wire transfer inflows grouped by calendar month.

Wire Transfer Outflows

Wire transfer outflows grouped by calendar month.

Other Transfer Inflows

Other transfer inflows grouped by calendar month.

Other Transfer Outflows

Other transfer outflows grouped by calendar month.

Truck Stop Inflows

Truck stop inflows grouped by calendar month.

Truck Stop Outflows

Truck stop outflows grouped by calendar month.

Federal Tax Inflows

Federal tax inflows grouped by calendar month.

Federal Tax Outflows

Federal tax outflows grouped by calendar month.

Bank Branch Inflows

Bank branch inflows grouped by calendar month.

Bank Branch Outflows

Bank branch outflows grouped by calendar month.

Credit Builder Inflows

Credit builder inflows grouped by calendar month.

Credit Builder Outflows

Credit builder outflows grouped by calendar month.

Rideshare Transactions

List of transactions pertaining to rideshares grouped by calendar month.

Monthly Expense Count

Expense counts grouped by calendar month.

Monthly Withdrawal Count

Withdrawal counts grouped by calendar month.

Monthly Revenue Count

Revenue counts grouped by calendar month.

Monthly Deposit Count

Deposit counts grouped by calendar month.

Monthly NSF Fee Count

Count of Non-Sufficient Funds (NSF) fees categorized by month of the calendar year.

NSF Fee Divisor

Metric used to calculate NSF frequency based on a common divisor of amount values.

Monthly Raw NSF Fee Count

NSF fee count (without applying common divisor logic), grouped by calendar month.

Monthly Overdraft Fee Count

Overdraft fees count grouped by calendar month.

Overdraft Fee Divisor

Metric used to calculate overdraft fee frequency using least common multiple of amounts.

Monthly Raw Overdraft Fee Count

Overdraft fee count (without applying common divisor logic), grouped by calendar month.

Monthly Returned Deposit Count

Returned item deposit count grouped by calendar month.

Monthly Returned Withdrawal Count

Returned item withdrawal count grouped by calendar month.

Monthly NSF / Negative Balance Fee Count

NSF or negative balance fee count grouped by calendar month.

Monthly NSF Returned / Unpaid Fee Count

NSF returned or unpaid fees count grouped by calendar month.

Statement Analysis Periods

Analysis of specific time frames as indicated on bank statements.

Number of Documents Uploaded

Total count of documents uploaded to this Book.

Number of Documents Processed

Total count of documents in this Book that completed verification.

Uploaded Documents

Array containing details on documents uploaded to this Book.

Document ID

Unique personal key for the Document.

Document UUID

Universal unique identifier for the Document.

Document Status

Processing status of the Document.

Document Pages

Number of pages present in the Document.

Associated Mixed Document ID

Unique key of the associated Mixed Document.

Associated Mixed Document UUID

UUID of the associated Mixed Document.

Document Rejection Reason

Reason for Document rejection (optional).

Book UUID

A unique UUID for the Book.