Before connecting
Choose one representative app, one reporting currency and one owner for the comparison. Record the date, the old report name and any existing exclusions before changing anything.
- 01Choose one app with active paid merchants
- 02Pick one reporting currency
- 03Record the exact start and end dates
- 04Export or capture the current Mantle totals
- 05List manually excluded or test merchants
Align the definition
Two reports can be internally correct and still disagree because they define the metric differently. Write the definition down before investigating variance.
- 01Confirm annual plans are normalized to a monthly value
- 02Exclude trials and one-time charges from basic MRR
- 03Decide how frozen shops appear
- 04Keep currencies separate rather than converting silently
- 05Match the treatment of refunds, credits and exclusions
Compare the bridge
Do not compare only the closing total. Reconcile the components that moved the number: opening MRR, new, expansion, contraction, churn, frozen, reactivation and closing MRR.
- 01Match opening MRR first
- 02Compare each positive movement category
- 03Compare each negative movement category
- 04Sort merchant variances by absolute value
- 05Trace the largest differences to lifecycle events and transactions
Sign off
Keep a short variance log with the source record, explanation and decision. A small explained difference is more useful than a perfectly matching total produced by hidden adjustments.
- 01Document every unresolved variance
- 02Confirm transaction and payout coverage dates
- 03Repeat with a second app or currency
- 04Save the final definition and exclusions
- 05Schedule a post-cutoff spot check
Use the method on your own data