ECR Analysis

Analyzes ECR (Electronic Cash Register) data from bank statements to calculate financial metrics including interest rates, FDIC charges, net interest, and potential interest uplift.

Technical Name: ECRAnalysisSummaryFunc

Properties

Execution Mode: SYNC
Type: NATIVE
Category: System Functions
Function ID: 66e31772-bde2-4a8f-801d-c215b5cdc322

Input Schema

Required Parameters

Parameter	Type	Description
`data`	object	Report configuration object (MReportMaster) containing query and field configurations

[Image placeholder: ECRAnalysis function configuration panel]

Input Example

{
  "data": {
    "reportConfig": {
      "query": {
        "selectFields": [
          {
            "fieldName": "bank_name",
            "fieldAlias": "Bank"
          },
          {
            "fieldName": "account_number",
            "fieldAlias": "Account Number"
          },
          {
            "fieldName": "interest_rate",
            "fieldAlias": "Interest Rate"
          },
          {
            "fieldName": "balance",
            "fieldAlias": "Avg Balance (Less float and overdraft)"
          },
          {
            "fieldName": "reporting_total_service_fee",
            "fieldAlias": "Total Fee"
          }
        ]
      }
    }
  }
}

Output Schema

Field	Type	Description
`ecrDataList`	array	List of ECR analysis entries with calculated financial metrics

Each entry in ecrDataList contains:

Field	Type	Description
`Bank`	string	Bank name
`Account Number`	string	Account number
`Account Name`	string	Account name
`Currency`	string	Account currency
`ECR/Interest Rate (Annual)`	number	ECR rate (set to interest rate)
`FDIC assessment (Annual)`	number	Calculated FDIC charges
`Net Interest`	number	Interest rate minus FDIC charges
`Interbank Rate`	number	Interbank interest rate
`Hypothetical Market Int Rate`	number	Hypothetical market interest rate
`Interest Rate`	number	Account interest rate
`Potential Interest Uplift`	number	Calculated potential interest uplift
`Avg Balance (Less float and overdraft)`	number	Average account balance
`Total Fee`	number	Total service fees

Output Example

{
  "ecrDataList": [
    {
      "Bank": "Chase Bank",
      "Account Number": "1234567890",
      "Account Name": "Business Checking",
      "Currency": "USD",
      "ECR/Interest Rate (Annual)": 0.02,
      "FDIC assessment (Annual)": 0.0012,
      "Net Interest": 0.0188,
      "Interbank Rate": 0.05,
      "Hypothetical Market Int Rate": 3.75,
      "Interest Rate": 0.02,
      "Potential Interest Uplift": 37500.0,
      "Avg Balance (Less float and overdraft)": 1000000,
      "Total Fee": 100.0
    }
  ]
}

[Image placeholder: ECR analysis output visualization]

Use Cases

Bank Fee Analysis

Analyze bank accounts to calculate ECR metrics and potential interest improvements:

{
  "data": {
    "reportConfig": {
      "query": {
        "selectFields": [
          {"fieldName": "bank_name", "fieldAlias": "Bank"},
          {"fieldName": "account_number", "fieldAlias": "Account Number"},
          {"fieldName": "interest_rate", "fieldAlias": "Interest Rate"},
          {"fieldName": "balance", "fieldAlias": "Avg Balance (Less float and overdraft)"},
          {"fieldName": "reporting_total_service_fee", "fieldAlias": "Total Fee"}
        ],
        "where": [
          {
            "field": "account_type",
            "operator": "equals",
            "value": "checking"
          }
        ]
      }
    }
  }
}

Interest Rate Comparison

Compare current interest rates with hypothetical market rates:

Start → FetchBankAccounts → ECRAnalysis → CalculateUplift → GenerateReport → End

[Image placeholder: ECR analysis workflow example]

Calculations

The function automatically calculates:

ECR: Set equal to the interest rate
FDIC Charges: (Total Service Fee / Average Balance) * 12 (annualized)
Net Interest: Interest Rate - FDIC Charges
Hypothetical Market Rate: Calculated based on interbank rate
Interest Uplift: (Hypothetical Rate - Interest Rate) * Average Balance

FetchMData - Retrieve bank account data before analysis
JavaScript - Process ECR analysis results

ECR Analysis

On this page