How do you calculate rolling 12-month (LTM) sales from monthly data?

Understanding rolling 12-month (LTM) sales is essential for remittance businesses assessing performance, forecasting cash flow, and meeting regulatory or investor reporting requirements. Unlike calendar-year metrics, LTM sales reflect the most recent 12 months of revenue—crucial for capturing seasonal trends in cross-border money transfers, such as spikes during holidays or migrant wage cycles.

To calculate LTM sales from monthly data, sum the gross remittance fees and/or foreign exchange margin revenue from the latest 12 consecutive months. For example, if today is June 2024, add revenue from July 2023 through June 2024. Ensure consistency: use accrual-based revenue (not settlement date) and exclude one-time refunds or reversals to maintain accuracy.

For remittance providers using digital platforms, automate this calculation via dashboards (e.g., Power BI or Tableau) that dynamically update as new monthly data flows in. This real-time LTM view supports strategic decisions—from pricing adjustments to compliance risk assessments under AML/CFT frameworks.

Accurate LTM sales also strengthen credibility with banking partners and regulators who evaluate operational scale and financial health. By standardizing LTM reporting across internal teams and external stakeholders, remittance businesses enhance transparency, improve funding negotiations, and benchmark against industry peers more effectively.

How would you calculate sales velocity (e.g., $/day) for a campaign with start/end dates?

Understanding sales velocity—measured in dollars per day—is critical for remittance businesses optimizing campaign performance. Unlike traditional e-commerce, remittance campaigns often run for fixed durations (e.g., “Send to Philippines—20% fee waiver until Dec 15”) and generate revenue through transaction fees or FX spreads. To calculate sales velocity, divide total campaign revenue by the number of days between start and end dates (inclusive). For example: a campaign generating $42,000 from Nov 1–Nov 14 (14 days) yields a sales velocity of $3,000/day.

This metric enables remittance providers to compare campaign efficiency across corridors, promotions, or channels—identifying which offers drive faster monetization. High sales velocity signals strong customer response and effective targeting, especially vital in competitive markets like LATAM or Southeast Asia where timing and pricing sensitivity are high.

Remember: exclude non-revenue days (e.g., pre-launch setup) but include weekends and holidays—remittance flows don’t pause. Also, adjust for refunds or chargebacks to ensure accuracy. Integrating sales velocity into your KPI dashboard helps allocate marketing budgets smarter, refine launch cadence, and forecast cash flow with greater precision—key advantages in a low-margin, high-volume industry.

How do you compute cross-selling ratio: number of customers buying ≥2 product categories ÷ total customers?

Understanding the cross-selling ratio—calculated as (number of customers buying ≥2 product categories) ÷ (total customers)—is vital for remittance businesses aiming to boost revenue and deepen customer relationships. In a competitive landscape where transaction fees are under pressure, cross-selling complementary services (e.g., international money transfers + foreign exchange alerts + prepaid travel cards) significantly improves lifetime value.

For remittance providers, this metric reveals how effectively you’re leveraging customer trust to offer bundled solutions. A low ratio may signal missed opportunities—perhaps due to siloed product design, weak onboarding journeys, or insufficient data-driven personalization. Conversely, a high ratio reflects strong product integration and customer-centric engagement.

To improve your cross-selling ratio, start by analyzing behavioral data: Which customers send funds regularly? Who engages with SMS rate alerts? Then, trigger timely, relevant offers—e.g., “Your last transfer to the Philippines qualified you for free FX margin on your next 3 transactions.” Personalization powered by real-time analytics drives adoption.

Track the ratio monthly, segment by geography and channel (app vs. agent), and benchmark against industry peers. Even a 5% lift in cross-selling can increase average revenue per user (ARPU) by 15–20%. Ultimately, mastering this metric transforms remittance from a one-off transaction into a trusted financial partnership.

How can you calculate sales per employee across departments using headcount and departmental revenue?

Measuring sales per employee is a powerful KPI for remittance businesses seeking operational efficiency and workforce optimization. Unlike traditional retail or manufacturing, remittance firms generate revenue through transaction fees, FX margins, and value-added services—making per-employee productivity especially revealing across departments like Compliance, Customer Support, Sales, and Operations.

To calculate sales per employee by department, divide that department’s total revenue (e.g., fee income attributed to Sales team referrals or margin earned on high-volume corridors handled by Operations) by its average headcount over the same period. For example: if the Sales department generated $1.2M in fee-based revenue and employed 15 full-time equivalents (FTEs), sales per employee equals $80,000. Ensure revenue attribution is accurate—use CRM tagging, transaction routing logs, or activity-based allocation.

This metric helps remittance providers identify high-performing units, benchmark staffing levels against industry peers (e.g., global money transfer operators averaging $65K–$95K per FTE), and inform strategic hiring or automation investments—especially critical amid rising regulatory costs and thinning margins. Regular tracking also supports investor reporting and internal performance reviews.

By integrating headcount data with granular, department-level revenue streams, remittance businesses transform raw numbers into actionable insights—driving smarter resource allocation, stronger compliance readiness, and sustainable growth in competitive cross-border markets.

How do you calculate seasonal sales index for Q3 based on 3-year average quarterly performance?

Understanding seasonal sales indexes is vital for remittance businesses aiming to forecast cash flow and optimize marketing spend. For instance, calculating the Q3 seasonal sales index using a 3-year average quarterly performance helps identify recurring demand patterns—such as increased remittances ahead of back-to-school or pre-holiday preparations in many migrant-sending countries.

To compute the Q3 index: first, gather total quarterly remittance volumes for Q3 across three consecutive years. Next, calculate the average Q3 volume and divide it by the overall average quarterly volume (across all 12 quarters). Multiply the result by 100 to express it as a percentage. A Q3 index above 100 signals stronger-than-average demand—ideal for ramping up agent incentives or launching targeted SMS campaigns.

For remittance operators, this insight enables smarter resource allocation: staffing adjustments, liquidity planning, and localized promotions tailored to peak sending corridors like Philippines–Middle East or Mexico–U.S. during Q3. Ignoring seasonality risks overstaffing in low-demand periods or missing revenue opportunities when volumes surge.

Integrating seasonal indexing into your analytics stack—paired with real-time FX and compliance data—boosts forecasting accuracy and customer responsiveness. Start building your 3-year quarterly dataset today; even small remittance firms gain competitive advantage through disciplined, data-driven timing.

How would you calculate sales lift (in %) attributable to a promotional campaign using control group data?

Measuring sales lift for remittance promotions is critical to proving ROI—especially when targeting migrant workers with time-sensitive offers like fee waivers or bonus exchange rates. To calculate lift in %, compare the campaign group’s transaction volume or revenue against a matched control group that received no promotion.

First, select a statistically valid control group—ideally customers with similar send frequency, corridor, and value history but excluded from the campaign. Track key metrics (e.g., total remitted amount or completed transactions) over the same period for both groups. Then apply: Lift (%) = [(Campaign Group Result − Control Group Result) ÷ Control Group Result] × 100.

For example, if promoted users sent $1.2M vs. $950K by controls, lift = ($1.2M − $950K) / $950K × 100 ≈ 26.3%. This isolates true campaign impact—filtering out seasonality or organic growth. Remittance firms benefit by reallocating budgets toward high-lift corridors or segments (e.g., Philippines–UAE), optimizing future offers.

Robust lift analysis also supports compliance reporting and investor updates, reinforcing data-driven decision-making. Always ensure control group size meets minimum detectable effect thresholds—and use A/B testing platforms to automate randomization and statistical validation.

How do you calculate recurring sales (e.g., subscription revenue) for a SaaS company over a billing cycle?

For remittance businesses adopting subscription-based pricing—such as monthly compliance reporting tools or embedded FX rate alert services—calculating recurring sales mirrors SaaS revenue modeling. Start by identifying active subscribers at cycle start, then apply the per-user or tiered monthly fee. Multiply total paying customers by their respective plan values to get gross monthly recurring revenue (MRR). Adjust for churn (cancellations), upgrades/downgrades, and prorated mid-cycle changes to derive net MRR.

Unlike one-time transfer fees, recurring remittance SaaS revenue requires precise billing cycle alignment—especially across time zones and regulatory jurisdictions. Use automated invoicing systems that sync with your CRM and accounting platform to track real-time MRR, ARR (annualized), and customer lifetime value (CLTV).

Accurate recurring revenue calculation enhances investor reporting, improves cash flow forecasting, and strengthens compliance with financial reporting standards like ASC 606. For remittance firms scaling digital offerings, clean MRR metrics signal operational health and scalability—key signals for regulators and fintech partners alike.

By treating recurring service revenue with SaaS-grade rigor, remittance businesses unlock data-driven pricing strategies, reduce revenue leakage, and position themselves competitively in the embedded finance ecosystem.

 

 

About Panda Remit

Panda Remit is committed to providing global users with more convenient, safe, reliable, and affordable online cross-border remittance services。
International remittance services from more than 30 countries/regions around the world are now available: including Japan, Hong Kong, Europe, the United States, Australia, and other markets, and are recognized and trusted by millions of users around the world.
Visit Panda Remit Official Website or Download PandaRemit App, to learn more about remittance info.