Payment Reconciliation

Daily checker

Centre and date range

Run this after Stripe webhook issues, SmartPay imports or online graduation payments.

Checklist

Daily reconciliation status

Stripe

Stripe payments not matched to students

These rows usually need a student link before the payment can appear cleanly on the account.

Graduations

Paid graduations not fully applied

Paid online graduation rows that have not updated the form/payment flags or income row properly.

Refunds

Refunds not reflected in totals

Pending refund webhooks, refund log rows, or Stripe refunds without matching negative income adjustments.

SmartPay

SmartPay imports missing from stats

SmartPay billing months that are missing remittance totals or have unmatched imported rows.

Sources

Data sources used