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
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
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
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
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
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
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).