Interest Analysis

Interest Analysis examines interest accrued and posted across savings and term-deposit products - total interest expense, average rates and distribution by product and period. It helps management understand the cost of deposits and verify interest is being applied correctly.

Interest Analysis
Interest Analysis — live screen from the BridgeERP MFI Suite.

Workflow

  1. Open Savings > Reports > Interest Analysis.
  2. Pivot the interest schedule by product or period.
  3. Measure total interest and compare across products.
  4. Graph the trend to track interest expense over time.
  5. Drill into the schedule lines behind any figure.

Fields reference

Every field on this screen, drawn from the live data model.

FieldTypeRequiredDescription
Account
account_id
Link → mfi.savings.accountYesAccount
Period Start
period_start
DateYesPeriod Start
Period End
period_end
DateYesPeriod End
Has Message
has_message
Yes/NoHas Message
Member
member_id
Link → mfi.memberMember
Branch
branch_id
Link → mfi.branchBranch
Currency
currency_id
Link → res.currencyCurrency
Company
company_id
Link → res.companyCompany
Product
product_id
Link → mfi.savings.productProduct
Average Balance
average_balance
MoneyAverage Balance
Rate Applied (%)
rate_applied
DecimalRate Applied (%)
Interest Calculated
interest_calculated
MoneyInterest Calculated
Interest Posted
interest_posted
MoneyInterest Posted
Posting Date
posting_date
DatePosting Date
Status
state
Choice: Accrued, Posted, ReversedStatus

Status lifecycle

Records on this screen move through these statuses:

Accrued → Posted → Reversed

Notes & rules

  • Analysis over mfi.savings.interest.schedule.
  • Quantifies interest expense by product and period.
  • Used to monitor the cost of deposit funding.

Technical model: mfi.savings.interest.schedule · Record: Savings Interest Schedule

Was this page helpful?