From report row to bank line
How to Reconcile an Apple Financial Report to a Bank Receipt
A clean reconciliation is not “Apple total equals bank total.” It is a short chain of evidence: one financial-report period, one settlement currency, Apple’s finalized payment record, and one bank receipt. Walk through the fields in that order and the unexplained difference becomes much easier to isolate.
Begin with the payment, then trace it backward
Start with the bank credit: amount, currency, and receipt date. Find Apple’s matching payment entry, then the detailed report behind it. This avoids adding every report currency to explain one deposit.
A defensible record names the fiscal period, settlement scope, Apple payment, bank receipt, and unresolved difference.
Work backward because the bank line is the event you are closing. If one Apple payment covers several report rows, preserve that grouping instead of forcing a one-row-to-one-deposit match.
The fields that connect the three records
| Evidence | Read this field | What it tells you |
|---|---|---|
| Financial report | Start Date / End Date | The fiscal period being closed. |
| Financial report | Settlement Currency | The scope to total separately. |
| Financial report | Partner Share, tax, adjustments | How rows build toward the final amount. |
| Payment information | Total Owed / Proceeds and status | Whether the amount was paid, carried, or returned. |
| Payment information | Payment Date and currency | The outbound payment to match. |
| Bank record | Amount, currency, receipt date | What arrived; no credentials are needed. |
If currencies differ, keep the conversion source and date. Do not invent Apple’s rate from the bank receipt.
Work the difference down in this order
- Lock the period.Use the report’s Start Date and End Date.
- Check the file.Confirm report type, dates, columns, and transaction categories.
- Total one currency.Give the scope a stable label; handle other currencies separately.
- Match Apple’s record.A carried or returned amount is not merely a late bank credit.
- Build the expected receipt.Use documented taxes, adjustments, and conversion only.
- Apply a fixed tolerance.Match amount, currency, and date. Missing evidence is not zero.
- Write the conclusion.Save the difference, reason, evidence, and next action.
When to stop instead of inventing an explanation
Sales and Trends is not a substitute for finalized financial evidence. Apple says the tools serve different purposes and use different reporting states.
Pause for an unfamiliar adjustment, negative amount, returned payment, impossible date order, or receipt with no clear settlement scope. Split multi-currency months.
A paused reconciliation is not a failed close. It is a controlled exception with a named owner, missing document, and next review date.
Check the evidence before paying for the close
The free diagnostic checks whether the evidence is ready. The USD 9 close compares one settlement scope and creates a printable outcome and next action without Apple or bank login.
Check my reconciliation evidence for freeFinancial values stay in this browser.
Official Apple references
General operational information only; not professional tax, accounting, or legal advice. KurodaLab is independent from Apple.