How to export Apple Card transactions to a spreadsheet

By Kayabyte · Last updated 28 October 2026

Apple Card has no website with a download button like a typical bank. Your statements and transactions live in the Wallet app on iPhone. The good news is that Wallet can export them. The catch is that the exact format and the places to find it depend on what you need: a month, a year, or a file for Quicken, YNAB or a spreadsheet.

Apple changes the app over time, so the labels below are approximate. Look for the idea if they differ on your iOS version.

1. Export from Wallet on iPhone

Apple’s Wallet app offers monthly statements for Apple Card as PDF, and you can export transactions as CSV or OFX. In general:

Open Wallet and tap your Apple Card.
Tap Card Balance, then scroll to the list of statements.
Tap a month, and look for the export or share option. You are usually offered the statement as PDF and the transactions in formats such as CSV and OFX.
Send the file to your Mac with AirDrop, Mail or Files.

Each statement is one calendar month, so a full year means twelve exports. Apple also lets you export a longer range in some versions of the app, but we cannot promise that for yours, so check the options you are shown.

2. Things to check in the exported file

Signs. Purchases and payments may use opposite signs. Make sure the sum of a month agrees with the statement’s total.
Categories. Apple Card assigns spending categories and sometimes lists a merchant name separately from a description. Keep these columns if you want to filter later, or drop them.
Daily Cash. The cash back rewards appear as a separate figure and may not look like normal transactions. Decide whether you want them in your records.
Dates. The date a transaction occurred and the date it posted may both be shown. Pick one and use it consistently.

3. Combine months in Excel or Numbers

For twelve monthly files:

Open the first file and keep its header row.
Copy the rows (without headers) from the other eleven files below it.
Sort by date and check the first and last rows against the first and last statements.
Add a column with the month if you want to reconcile each statement to its total.

This is fine for a small number of files. It breaks when the files have slightly different columns, which happens if Apple has changed the format partway through.

4. If you only have PDFs

Some people download only the PDF statements, for example for a mortgage lender who asked for them, or because they closed the card. Then you can try copying the transaction list from Preview into a spreadsheet, as with any bank. Text in these PDFs is usually selectable, but the layout puts each purchase on a few lines (merchant, location, daily cash percentage), so the paste needs cleanup.

5. Where Balanced helps

Balanced is a Mac app we make that turns statements into files for spreadsheets and money software. It works on your Mac: statements are processed there and never leave it. There is no AI guessing; every number is copied from your statement and checked.

It helps with Apple Card in two ways:

PDF statements: open one or several PDFs and Balanced reads the table. In the preview you can fix column roles (date, description, debit, credit, amount, balance) and the sign handling, so purchases and payments come out the way your software expects. The layout is remembered for the next month.
Different destinations: it exports to CSV, Excel (.xlsx), OFX, QFX (Quicken), QBO (QuickBooks), QIF, YNAB CSV, Actual Budget, Lunch Money CSV, Xero bank statement CSV, Beancount and Ledger/hledger, even if Wallet only gave you PDFs.

The totals check compares opening balance plus transactions with the closing balance. If it does not add up, Balanced shows where and by how much, and exporting then needs an explicit “Export anyway”.

Download Balanced and convert for free: the free version converts and checks everything and exports the first 10 transactions per file. Pro is USD 59 per year or USD 7.99 per month, up to 3 Macs, cancel anytime, 30-day money-back on the first payment. macOS 14 or later.

Limits: results depend on the layout, so check the preview first. Low-quality or skewed scans can fail. For password-protected PDFs, unlock the PDF first with the password from the sender. We cannot promise every statement will parse.

6. Importing into other apps

Exact menu labels vary by version, but the usual routes are: Quicken takes QFX or OFX files, QuickBooks takes QBO, YNAB and Actual Budget take their own CSV layouts, and Excel or Numbers open CSV directly. After any import, compare the first and last transaction and the month total with the statement.