Transaction Analysis

Transaction Analysis examines savings transaction activity - volumes and values of deposits, withdrawals, transfers, interest and fees over time and by channel, branch or teller. It reveals activity trends, channel adoption and counter throughput.

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

Workflow

  1. Open Savings > Reports > Transaction Analysis.
  2. Pivot the ledger by transaction type or channel.
  3. Measure both count and value of movements.
  4. Graph the trend to see activity over the period.
  5. Drill into individual postings for detail.

Fields reference

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

FieldTypeRequiredDescription
Reversal Transaction
reversed_id
Link → mfi.savings.transactionThe reversal transaction that reversed this one
Reversal Of
reversal_of_id
Link → mfi.savings.transactionThe original transaction this reversal undoes
Reversal Direction
reversal_direction
Choice: Credit (Money In), Debit (Money Out)For reversal transactions: whether this added or removed money
Transfer Ref
transfer_id
TextShared identifier linking transfer_out and transfer_in legs.
FX Details
fx_note
TextIf cash was received in a different currency from the account currency.
Account
account_id
Link → mfi.savings.accountYesAccount
Type
transaction_type
Choice: Deposit, Withdrawal, Interest Posting, Fee/Charge, Transfer In, Transfer Out, Loan Auto-Debit, Dividend CreditYesType
Amount
amount
MoneyYesAmount
Date
transaction_date
DateYesDate
Status
state
Choice: Draft, Posted, ReversedYesStatus
Has Message
has_message
Yes/NoHas Message
Member
member_id
Link → mfi.memberMember
Phone
member_phone
TextPhone
ID Number
member_id_number
TextID Number
Branch
branch_id
Link → mfi.branchBranch
Currency
currency_id
Link → res.currencyCurrency
Company
company_id
Link → res.companyCompany
Is Credit
is_credit
Yes/NoIs Credit
Running Balance
running_balance
MoneyRunning Balance
Value Date
value_date
DateValue Date
Reference
reference
TextReference
Receipt No.
receipt_number
TextReceipt No.
Channel
channel_id
Link → mfi.loan.repayment.channelChannel
Mobile Number
mobile_number
TextMobile Number
Bank Reference
bank_reference
TextBank Reference
Processed By
received_by
Link → res.usersProcessed By
Notes
notes
Long textNotes
Teller Commission
teller_commission
MoneyTeller Commission
Voucher No.
voucher_number
TextVoucher No.
Voucher Required
voucher_required
Yes/NoVoucher Required
Teller
teller_id
Link → res.usersTeller
Journal Entry
move_id
Link → account.moveJournal Entry

Actions & buttons

Buttons available on this screen and what they do:

  • Post Transaction
  • Reverse Transaction
  • Print Receipt

Status lifecycle

Records on this screen move through these statuses:

Draft → Posted → Reversed

Notes & rules

  • Analysis over mfi.savings.transaction with pivot and graph.
  • Segments activity by type, channel, branch and teller.
  • Reveals transaction trends and channel adoption.

Technical model: mfi.savings.transaction · Record: Savings Transaction

Was this page helpful?