Understanding Differences Between Apple Data in Cleeng Platform and Apple Connect Financial Reports

Overview

You may notice differences between the Apple transaction data you see in Cleeng (collected via StoreKit2 integration) and Apple Connect reports (including Financial Reports and Summary Sales Reports). These differences result from the way Apple’s reporting systems are structured, which affects how data is both processed and summarized. As a result, differences occur between the information presented by Apple and Cleeng, and revenue data cannot be reconciled on a transaction-by-transaction basis.

Note: 

  • This information applies only to Apple-managed subscriptions (purchases made through the App Store) and not to Cleeng-managed web subscriptions (via Merchant).
  • You may notice these differences when comparing data between Cleeng’s reports (for example, the Transaction Report available in Data Exports) and reports from Apple Connect.
  • The Apple Analytics Dashboard is not affected by these differences, as it uses data sourced directly from Apple Connect, rather than Apple transaction data collected in the Cleeng platform.

Why These Differences Exist: Real-time data vs Reporting data

The Fundamental Design Difference

Apple maintains separate systems that operate on different principles:

  1. StoreKit2 (Real-time Transaction System) - What Cleeng uses
  2. Apple Connect Reports - Including both:

According to Apple's documentation on differences in reporting tools, processing and closing transactions may take time, with transactions initiated in one month potentially not appearing in Sales and Trends Reports until the customer's payment is processed, collected, and invoiced, possibly in the following fiscal month. Additionally, transactions without collected payments don't appear in financial reports.

The Five Key Factors Creating Differences

1. Transaction Date vs. Settlement Date Timing

This is the primary source of differences across all Apple Connect reports. According to Apple's documentation, both Financial Reports and Sales and Trends Reports are affected by processing status - transactions may not appear until payment is processed and collected.

Real-World Example:

  • A $9.99 monthly subscription renews on March 30:
    • Apple data in Cleeng: Records on March 30 (transaction initiation)
    • Payment processing: Completes April 5
    • Financial Report: Appears in April fiscal month
    • Summary Sales Report: Also appears only after processing completes
    • Result: March real-time data shows the transaction, but neither Apple Connect report includes it until payment settles

Important Note: Even Summary Sales Reports, which some might expect to align more closely with real-time data, will omit transactions where payment hasn't been successfully processed. As documented in Sales and Trends reports availability, reports are available the following day but only include processed transactions.

2. Apple's Unique Fiscal Calendar

Apple's fiscal year consists of 364 days divided into four quarters, with each quarter including one 35-day fiscal month and two 28-day fiscal months. This creates structural misalignment with calendar months.

Example Fiscal Month Boundaries:

  • January 2025 fiscal month: December 29, 2024 to February 1, 2025
  • This means 3-7 days of transactions always fall outside the expected calendar month

Financial and Sales reports are automatically generated once a month based on Apple's fiscal calendar and are only generated if there are purchases or refunds during that fiscal period.

3. Billing Grace Periods and 60-Day Recovery Window

Apple's Billing Grace Period allows subscribers to maintain access for 3, 16, or 28 days while Apple attempts to collect payment. Additionally, Apple attempts to recover failed subscriptions for up to 60 days through billing retry.

This creates scenarios where:

  • Subscriptions remain valid in Cleeng during grace periods (customer retains access)
  • No transaction appears in any Apple Connect report until payment succeeds
  • Settlement may occur anywhere within a 60-day window after the original renewal date
  • Both Financial Reports and Summary Sales Reports only show the transaction once payment is successfully collected

Example Scenario:

  • A monthly subscription fails to renew on Day 1
  • Customer maintains access during 16-day grace period (stays active in Cleeng)
  • Apple successfully collects payment on Day 14
  • Result: Cleeng shows continuous subscription validity, but all Apple Connect reports delay the transaction entry by 14 days

4. Exchange Rate Application Timing

Currency conversion timing creates material differences across all reporting systems:

Real-time Apple data in Cleeng:

  • StoreKit2 provides the price in the customer's local currency at the time of purchase
  • Cleeng does not perform any currency conversion - it reports transaction details exactly as provided by Apple's API

Summary Sales Reports:

  • According to Apple's documentation, uses a rolling average of the previous month's exchange rates to estimate USD amounts

Financial Reports:

  • As documented in Apple's payment overview, uses the spot rate on the date of payment (no more than three business days prior to proceeds receipt)

5. Transaction Anonymization in Apple Connect Reports

Both Financial Reports and Summary Sales Reports are intentionally anonymized for security and privacy. Summary Sales Reports show aggregated data without unique identifiers - subscription transactions are aggregated by date and SKU. This means:

  • No customer-specific identifiers allow matching to individual StoreKit2 transactions
  • Transaction-level reconciliation is impossible by design
  • Both report types prioritize financial accuracy over operational visibility

Apple's Official Guidance on Report Usage

Apple clearly delineates the purpose of each system in their documentation on differences in reporting tools.

When to Use Apple Data in Cleeng Platform

✅ Recommended for:

  • Real-time subscription status management
  • Customer entitlement verification
  • Support ticket resolution
  • User experience optimization
  • Business intelligence and trend analysis
  • Daily performance monitoring
  • Churn prediction and prevention

The StoreKit2 framework provides immediate transaction data essential for managing customer access and operational decisions.

When to Use Apple Connect Financial Reports

✅ Required for:

  • Official accounting and bookkeeping
  • Tax compliance and auditing
  • Bank reconciliation
  • Final revenue recognition
  • Investor reporting
  • Financial statements

When to Use Apple Connect Summary Sales Reports

✅ Useful for:

  • Aggregated sales trend analysis
  • Product performance comparisons
  • Geographic sales distribution
  • Understanding processed (not just initiated) transactions
  • Supplementing financial reports with additional detail

Note: Summary Sales Reports become available the following day but only include successfully processed transactions.

Validation Best Practices

What You CAN Validate

  1. Trend Alignment Over 3+ Months
    • Timing differences balance out over longer periods
    • Compare directional trends rather than exact amounts
  2. Transaction Volume Patterns
    • Compare relative changes in transaction counts
    • Look for directional alignment rather than exact matches
  3. Use Fiscal Calendar Alignment
    • When comparing periods, always use Apple's fiscal calendar dates
    • Download the fiscal calendar from App Store Connect for reference

What You CANNOT Validate

❌ Not possible:

  • Transaction-by-transaction matching
  • Daily reconciliation between systems
  • Exact monthly revenue matching
  • Individual customer payment verification across systems

Understanding Processing Differences

According to Apple's reporting differences documentation, several factors affect when transactions appear in Apple Connect reports:

  • Processing status and transaction closing time
  • Credit card verification delays
  • Fraud prevention checks
  • Bank processing times
  • Regional payment method variations
  • Weekend and holiday delays

These factors mean that transactions initiated in a particular month may not appear in any Apple Connect report (Financial or Summary Sales) until the customer's payment is processed, collected, and invoiced - possibly in the following fiscal month.

Conclusion

The differences between Apple data in Cleeng Platform and Apple Connect Reports (both Financial and Summary Sales) directly reflect the different purposes these systems serve. Apple's official documentation confirms that differences occur due to processing status, exchange rates, and timing differences.

All data sources are accurate for their intended purposes:

  • Cleeng Platform (via StoreKit2) accurately reflects customer transactions as they are initiated
  • Apple Financial Reports accurately reflect settled payments received
  • Apple Summary Sales Reports accurately reflect processed and collected sales

These systems complement each other and all are essential for comprehensive business operations.

FAQs

Why can't I match individual transactions between systems?

Apple intentionally anonymizes all Connect reports for security and privacy. Both Financial Reports and Summary Sales Reports show aggregated data without customer-specific identifiers.

Why don't Summary Sales Reports match real-time data if they're based on transactions?

Summary Sales Reports, like Financial Reports, only include transactions where payment has been processed and collected. As noted in Apple's documentation, initiated transactions without successful payment collection are excluded from both report types.

How long should I wait before comparing data?

Compare data over multiple fiscal months for accurate trend analysis. Short-term differences are expected due to the processing differences documented by Apple.

Which data should I trust for customer support?

Always use Apple data in Cleeng Platform (StoreKit2) for business performance analysis and customer support issues. This provides real-time subscription status and is designed for operational & analytical use cases.

Which reports should I use for accounting?

Apple Connect Financial Reports must be used for all accounting purposes as they represent actual collected payments. Summary Sales Reports can provide additional detail but should not be the primary source for financial reporting.

Additional Resources

Official Apple Documentation

Need Help?

  • For questions about how Cleeng processes Apple subscription data, please contact our support team. 
  • For questions about Apple's reporting, please refer to Apple Developer Support.

 

Was this page helpful?
0 out of 0 found this helpful

Related articles

In this article