How to Convert Apple Card Statements to Excel or CSV (2026)

Apple Card is one of the more distinctive cards to work with when you need transaction data in a spreadsheet. Unlike traditional credit cards, Apple Card is digital-first — no physical statements mailed to you, no bank portal with a clunky export button. Your statement lives in the Wallet app on your iPhone, and the PDF Apple generates has a layout unlike any other card issuer. This guide covers every method to get your Apple Card data into Excel, from the native export options to PDF conversion when you need the full record.

(For a general overview covering all issuers, see our credit card statement to Excel guide.)

Apple Card's Native Export Options

Apple built two ways to get your transaction data out of Apple Card: a CSV export directly from the Wallet app, and downloadable PDF statements from iCloud. Both have meaningful limitations.

Option 1: CSV Export from the Wallet App

Apple added a native transaction export feature in iOS 16.1. This is the fastest path to a spreadsheet if you only need recent data.

What the Wallet CSV Includes

The Apple Card CSV export is cleaner than most bank exports:

• Transaction Date — the date the charge posted
• Clearing Date — when the transaction fully settled
• Description — merchant name (often Apple Maps-enriched, so you see "Trader Joe's" not "TJ STORES 0041")
• Merchant — a standardized merchant name field
• Category — Apple's spending category (Food & Drinks, Shopping, Transportation, etc.)
• Type — Purchase, Refund, or Payment
• Amount (USD) — positive for charges, negative for payments/refunds
• Daily Cash (%) — your Daily Cash rate for that transaction
• Daily Cash (USD) — the actual cashback earned

Option 2: Download PDF Statements from iCloud

Apple Card issues formal monthly statements as PDFs. These are the closest equivalent to a traditional credit card statement, and they contain information the CSV export doesn't — including interest charges, minimum payment history, and a complete account summary.

Apple Card's Unique PDF Format

Apple Card statements look nothing like a Bank of America or Chase statement. Apple designed the PDF with its signature visual minimalism — which creates a parsing challenge for generic PDF converters.

Key differences from traditional card statements:

• Merchant-grouped layout — transactions are grouped by merchant category (Food & Drinks, Shopping, Health, etc.) with visual icons and summary totals per category. Many converters struggle to extract the flat transaction list from this hierarchical layout.
• No account number displayed — Apple Card intentionally omits the full card number from statements for security. The PDF will show your name and a partial number only.
• Daily Cash summary — each transaction shows how much Daily Cash you earned, and the statement includes a total Daily Cash received for the period.
• Apple Pay transaction labels — in-app and web purchases made via Apple Pay often show as the merchant name, but some in-app purchases may show as "App Store" with limited detail.
• Titanium card vs. virtual card transactions — if you use the physical titanium card (for non-Apple Pay terminals), transactions are labeled differently than Apple Pay transactions from the same merchant.
• Goldman Sachs issuer header — Apple Card is issued by Goldman Sachs, so the statement header shows "Goldman Sachs Bank USA" alongside Apple branding. Some search tools index these as Goldman Sachs statements.

When to Use PDF Conversion Instead of the CSV Export

Use the PDF conversion approach when:

• You need data older than 2 years — Apple's Wallet CSV only exports ~2 years back. If you need older records for tax purposes or an audit, the monthly PDF statements are your only option.
• You need interest charges and fees — the CSV export omits interest charges. If you carried a balance, the PDF statement is the only place where interest accrued for that month appears.
• You need installment plan details — if you used Apple Card Monthly Installments (ACMI) for an iPhone or Mac purchase, the installment plan balance, remaining payments, and deferred interest status only appear in the PDF statement.
• You're doing multi-year tax categorization — converting 12 or 24 monthly PDFs is faster than manually exporting each month's CSV and reconciling the overlapping data.
• Your accountant wants the formal statement — for business expenses put on Apple Card, the PDF is the formal record that matches what the IRS or an auditor would expect.

Step-by-Step: Convert an Apple Card PDF to Excel

Apple Card-Specific Data Quirks in Excel

Once you have your Apple Card data in a spreadsheet, a few patterns are worth knowing:

Merchant Descriptions Are Cleaner Than Most Cards

Apple Card uses Apple Maps merchant data to clean up transaction descriptions. Where Chase might show SQ *COFFEE SHOP DOWNTOWN, your Apple Card export shows Blue Bottle Coffee. This makes category sorting and merchant-level analysis much easier than with traditional card statements.

Daily Cash Appears as a Separate Category

Daily Cash credits show up in your transaction list as Daily Cash — Apple Card Rewards with a negative amount (money added to your Apple Cash balance). When categorizing your Apple Card data in Excel, filter these out of your expense analysis — they're income/rebates, not purchases.

A simple way to handle this in Excel:

1. Filter the Type column for Refund and Payment
2. Review the filtered rows — Daily Cash credits, refunds, and your monthly payment will all appear here
3. Create a separate sheet or hide these rows when analyzing expenses

ACMI Installments Don't Show the Full Purchase Price

Apple Card Monthly Installments (ACMI) works differently from regular purchases. When you finance an iPhone on ACMI, each monthly statement shows only the installment payment for that month — not the original purchase price. To see the total purchase amount, check the PDF statement's installment plan summary section, or reference the original purchase month's statement.

Categories Are More Granular Than Most Banks

Apple's spending categories include sub-levels that most cards don't break out:

• Food & Drinks covers restaurants, coffee, grocery, and alcohol
• Shopping breaks into clothing, electronics, and general retail
• Entertainment separates streaming services from physical entertainment

When you import Apple Card data into Excel, Apple's categories come through in the Category column and are generally more useful out of the box than what you'd get from Citi, Chase, or Bank of America.

After Conversion: Common Uses

Tracking Business Expenses on Apple Card

Apple Card is increasingly used for business expenses, even though it's a personal card. If you expense Apple Card purchases to your employer or track deductible business expenses, converting monthly PDFs to Excel gives you a clean record for:

• Monthly expense report submissions
• Year-end deductible expense totals
• Client-billable expense tracking

For detailed steps on creating expense reports from card data, see our guide to creating expense reports from credit card statements.

Importing into Accounting Software

If you use Apple Card for business and want to pull the data into accounting software, the converted CSV format imports cleanly:

• QuickBooks Online — Banking > Upload Transactions > select the CSV
• Xero — Bank Accounts > Import a Statement > CSV format
• Wave — Transactions > Import

For step-by-step import instructions by platform, see our guides for QuickBooks and Xero.

Year-End Tax Preparation

Apple Card's clean merchant descriptions and pre-applied categories make tax-time sorting faster than with most other cards. After converting your statements:

1. Filter the Category column for business-relevant categories (Office Supplies, Travel, Software, etc.)
2. Use a PivotTable to sum expenses by category
3. Cross-reference your Daily Cash total (shown in the PDF statement) — this is not taxable income, so no 1099 will be issued

For a full guide to categorizing card expenses for taxes, see categorizing credit card expenses for taxes.

FAQ

Ready to convert your Apple Card statement? Upload your PDF here — the AI parser handles Apple Card's unique format automatically, and your first conversions are free.