Estimated Revenue Calculation Transactions By Month

Overview

Model Name: EstimatedRevenueCalculationTransactionsByMonth

The list of credit transactions used to calculate estimated revenues grouped by category and calendar month.
estimated_revenue = all credits - revenue_deducted - transfer + revenue_included - alternative_lender + factoring The estimated revenue of the business grouped by 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.

Properties

added_factoring_txns

Type
Map of arrays
Key Pattern
/^\d{2}/\d{4}$/
Required
true

Credit transactions identified as factoring. Added to the total revenue estimate.
Each key is a string representing a month and a year, using the regex ^\d{2}/\d{4}$ (i.e MM/YYYY).

added_specific_terms_txns

Type
Map of arrays
Key Pattern
/^\d{2}/\d{4}$/
Required
true

Credit transactions that are likely to be revenue deposits. We maintain a list of terms that signal this quality. Transactions with a description that includes one of these phrases are included here.
Each key is a string representing a month and a year, using the regex ^\d{2}/\d{4}$ (i.e MM/YYYY).

deposits

Type
Map of arrays
Key Pattern
/^\d{2}/\d{4}$/
Required
true

Credit transactions identified as deposits, for use in revenue estimations.
Each key is a string representing a month and a year, using the regex ^\d{2}/\d{4}$ (i.e MM/YYYY).

deducted_alternative_lender_txns

Type
Map of arrays
Key Pattern
/^\d{2}/\d{4}$/
Required
true

Credit transactions identified as alternative lending. Deducted from the total revenue estimate.
Each key is a string representing a month and a year, using the regex ^\d{2}/\d{4}$ (i.e MM/YYYY).

deducted_specific_terms_txns

Type
Map of arrays
Key Pattern
/^\d{2}/\d{4}$/
Required
true

Credit transactions that are unlikely to be revenue deposits. We maintain a list of terms that signal this quality, such as "Refund", "Reversal", "Cash Back", and "Return". Transactions with a description that includes one of these phrases are included here.
Each key is a string representing a month and a year, using the regex ^\d{2}/\d{4}$ (i.e MM/YYYY).

deducted_transfer_deposit_txns

Type
Map of arrays
Key Pattern
/^\d{2}/\d{4}$/
Required
true

Credit transactions identified as transfers. Deducted from the total revenue estimate.
Each key is a string representing a month and a year, using the regex ^\d{2}/\d{4}$ (i.e MM/YYYY).