Reading MDR lines without losing the learner trail

Settlement files rarely credit the full tuition amount. Merchant discount rates, fixed fees, and sometimes rolling reserves reduce the bank receipt. If analytics still shows the list price as “collected,” finance and product will disagree every close.

Keep two amounts

Store the amount charged to the learner and the amount settled to the merchant. Report both. Learner-facing teams care about the first; cash forecasting needs the second.

Avoid silent netting

Some teams overwrite the charge amount with the net settlement to “make the sheet balance.” That erases the learner trail and makes later audits harder. Add a fee column instead.

When app analytics and financial audit applications for EdTech payment reporting are reviewed together, MDR treatment is one of the first places we look. A tidy fee column prevents weeks of reconstructive work later.