Apple Card Statement to Excel: Export, Clean, Import

TL;DR Apple Card statements live in the Wallet app on iPhone. For each closed statement you can usually export the transactions as a spreadsheet-friendly file, and you can also save the statement itself as a PDF. Use the export for quick analysis, keep the PDF as the record, and check that the previous balance plus purchases, minus payments and credits, plus any interest equals the new balance. Fix the signs before importing into accounting software, because card files are where most sign mistakes happen.

Apple Card is different from most credit cards in one practical way: there's no traditional website where you log in and click through statements. Everything happens in the Wallet app on an iPhone (and, for some tasks, on a Mac or iPad signed in with the same Apple account). That's convenient day to day, but it can confuse people when an accountant asks for "a spreadsheet of last year's card transactions" or a lender asks for statements.

This guide covers how to get the data out, how to turn it into a clean Excel file, how to check it's complete, and how to bring it into QuickBooks, Xero, Wave or a personal budget. Apple adjusts the Wallet app regularly, so we describe the steps generally; Apple's own support pages have the current instructions for your iOS version.

Two kinds of Apple Card file

There are two things you can take out of Wallet for a statement period, and they serve different purposes.

The statement PDF. Each month's statement can be viewed and saved as a PDF. It shows the statement period, the previous balance, payments and credits, purchases, any interest charged, the new balance, and the minimum payment. This is what you'd give to a lender, a tax preparer or an auditor, because it's the issuer's formal statement for the period.

The transaction export. For closed statements, Wallet typically offers an option to export the period's transactions in one of several formats, including CSV, and formats aimed at personal finance and accounting software. This is the quickest way to get data into Excel. Exports are generally available per statement, not for an arbitrary date range, and the current month's activity usually can't be exported until the statement closes.

If you have both files, you have a nice cross-check: the export provides the rows, and the PDF provides the balances that prove the rows are complete.

Getting the files out of Wallet

In general terms:

1. Open Wallet on your iPhone and tap Apple Card.
2. Go to the card balance area, where statements are listed by month.
3. Choose a statement. From there you can view the PDF and, for closed statements, look for an option to export transactions.
4. Pick a format. CSV is the most flexible for Excel and Google Sheets.
5. Save or share the file to somewhere you can reach from your computer, such as iCloud Drive or email to yourself.

Do this for each month you need. Name the files consistently, for example apple-card-2026-04.csv and apple-card-2026-04.pdf, so they pair up.

If you're doing a full year, it's worth doing all twelve months in one sitting. It's tedious on a phone, but doing it once is better than finding gaps in March.

What's in the export

Exports from card issuers generally include a transaction date, a clearing or posting date, a merchant name, a category assigned by the issuer, a transaction type (purchase, payment, credit, interest, installment and so on) and an amount. Column names and exact contents vary, so open the file and look at the headers before you build formulas around them.

Two details matter most:

Sign convention. Card files don't agree on whether a purchase is positive or negative. Many card exports show purchases as positive numbers (because they increase what you owe) and payments as negative. Accounting software may expect the opposite, depending on how the import is mapped. Check one known purchase and one known payment before doing anything else.

Categories. The issuer's categories (such as restaurants, shopping, travel) are designed for consumer spending summaries. They're useful as a starting point, but they're not accounting categories. A software subscription and a pair of headphones might both show up as "shopping" or "other". If this is for business bookkeeping or taxes, you'll want your own categories.

Turning the export into a clean Excel sheet

Open the CSV in Excel. Then:

1. Convert it to a table with Ctrl+T, so formulas fill down automatically.
2. Check the dates. Make sure the date column is a real date, not text. =ISNUMBER(A2) should return TRUE. If not, use Data, Text to Columns, choose the date order the file uses, and finish.
3. Pick one date to work with. Transaction date is usually what you want for budgeting and categorizing; some bookkeepers prefer the posting date because it matches when the issuer recorded it. Pick one, and stick to it across every month.
4. Normalize the sign. Add a column called Signed that expresses each row from your point of view: money spent negative, money returned positive. If the file shows purchases as positive, =-[@Amount] does it. Check a payment and a refund to confirm they come out positive.
5. Separate payments. Payments to the card from your bank account are transfers, not income. Add a Type filter and exclude them from spending totals.
6. Add your own category. Keep the issuer's category in its own column and add yours beside it. A rules table with XLOOKUP can do most of the work; see our guide to Excel formulas for categorizing transactions.
7. Combine months. If you're working on a year, paste each month below the last in one table, or use Power Query to load a folder of CSVs. Add a Statement column so you always know where a row came from.

Our guide on how to clean bank statement data in Excel goes deeper on each of these steps.

Checking it against the statement

A spreadsheet of card transactions is only useful if it's complete. Use the statement PDF to prove it.

For a card, the balance equation is:

Previous balance + purchases + fees + interest − payments − credits = new balance

In practice, with a signed amount column where purchases, fees and interest are positive (they increase the balance owed) and payments and credits are negative:

=ROUND(PreviousBalance + SUM(Table1[Amount]) - NewBalance, 2)

The answer should be 0. If your file uses the opposite convention, flip the sign inside the SUM.

If it doesn't come out to zero:

• Check the date range. A transaction near the statement boundary may belong to the next or previous statement.
• Look for interest or fees. Some exports list them as separate transaction types that are easy to filter out by accident.
• Look for installments. If you bought a device with monthly installments on the card, the monthly installment may appear differently from a normal purchase.
• Look for returns that posted later. A refund appears in the month it posted, not the month of the original purchase.

The balance checker does this test for you if you paste in the rows and the balances.

When you only have the PDF

Sometimes the export isn't practical: you're working from PDFs someone emailed you, you're helping a client who doesn't want to hand over their phone, or you need many months quickly. In that case, convert the PDF.

SheetStatement's credit card statement converter reads card statement PDFs, extracts each transaction, assigns the correct year to each date from the statement period, and checks the totals against the statement's balances. You get a consistent sign convention across every month, which saves the step of fixing signs file by file. The free plan covers 3 pages a month, and paid plans are $9, $19 or $39 a month if you're converting larger volumes.

Importing into accounting software

If the card is used for business, you'll probably want the transactions in your accounting software as a credit card account.

QuickBooks Online. Create a credit card account that represents the Apple Card, then upload a CSV. With a three-column layout (date, description, amount), QuickBooks asks how to interpret the signs; check a purchase and a payment in the preview. Our guide to fixing QuickBooks Online CSV import errors covers the common problems. If the export offers a QuickBooks-friendly format, that can avoid column mapping, but check that it lands in the right account.

Xero. Use Xero's statement import for a credit card account, with a CSV that matches Xero's template. The Xero CSV import format guide explains each column.

Wave. Wave accepts CSV uploads for credit card accounts. Check that purchases increase the balance owed after upload.

Whichever software you use:

1. Import one statement at a time.
2. Check the first few rows for sign and date.
3. Record the card payment from your bank as a transfer, not an expense, so it isn't counted twice.
4. Reconcile the card account to the statement's new balance.

Our credit card reconciliation guide explains the reconciliation side in more detail.

Personal budgeting with Apple Card data

Not everyone needs accounting software. If you just want to see where the money goes:

• Build a pivot table from the combined table with your category in rows, months in columns and the signed amount as values.
• Exclude payments and credits from the spending view.
• Add a small summary that shows the top ten merchants by total spend for the year. Subscriptions tend to stand out once you see them added up.

Our expense tracking guide sets out a simple system that works with card and bank data together.

A worked example

A freelance designer uses an Apple Card for most business purchases and a few personal ones. At year end, her tax preparer asks for a categorized list of business expenses from the card.

1. Export. She exports CSVs for all twelve closed statements and saves the twelve statement PDFs.
2. Combine. She loads the twelve CSVs into one Excel table with Power Query, adding a column for the statement month.
3. Normalize signs. The export shows purchases as positive, so she adds a signed column with spending negative and payments positive.
4. Remove payments. Twelve payments from her bank are tagged as transfers and excluded.
5. Check each month. For each statement, previous balance plus the month's rows equals the new balance. Eleven match. One is off by the amount of a monthly installment that her filter had excluded as "not a purchase". She adjusts the filter.
6. Categorize. She adds her own categories (software, equipment, travel, meals, personal) using a rules table, then reviews the rest by hand.
7. Hand over. Her preparer gets the categorized workbook, a pivot summary by category, and the twelve PDFs.

The preparer decides how each category is treated on the return. Her job was to make the data complete and clear, and the balance check is what showed it was complete.

Troubleshooting

The export option isn't there. It's usually only available for closed statements. If the current month is still open, wait until it closes.

Excel opens the CSV with everything in one column. This happens when your system's list separator isn't a comma. Use Data, From Text/CSV and choose comma as the delimiter.

Dates look American when you expected day-first (or vice versa). Use Data, From Text/CSV, and set the column's data type with the right locale.

Merchant names are inconsistent. The same merchant may appear with different suffixes. Use a lookup table that maps patterns to a clean payee name, or a SEARCH-based rule.

Interest appears in a month you didn't expect. Interest is charged on the statement where it accrued. Check the PDF's interest section to confirm.

The totals match but a refund is in the wrong month. That's correct accounting: a refund belongs to the statement where it posted. If you want to net it against the original purchase for analysis, do that in a separate column and leave the statement data as it is.

Shared cards and mixed business and personal use

Two situations come up often enough to plan for.

More than one person on the card. If the card is shared with a partner or family member, the statement covers everyone's spending. The export may or may not identify who made each purchase, depending on how the account is set up. If you need to split spending by person, add a Person column and fill it in during your review, using the merchant and your own knowledge. Don't guess on large items; ask.

Business and personal on one card. It's common for freelancers to use one card for both. That's workable as long as you separate the two clearly. Add a Business? column with Yes or No for every row, and build your business totals only from the Yes rows. In accounting software, personal purchases on a business-tracked card are usually recorded as owner drawings rather than expenses, but check with your accountant how they want it handled. The cleanest long-term fix is a separate card for business, which makes next year's export much simpler.

Either way, keep the original export untouched in its own sheet and do your tagging in a copy. If a question comes up later, you can always go back to what the issuer actually reported.

A short monthly routine

1. When the statement closes, export the CSV and save the PDF.
2. Append the CSV to your workbook or import it into your accounting software.
3. Normalize signs, tag the payment as a transfer, categorize.
4. Check the month against the statement balance.

Ten minutes a month keeps a year-end request from becoming a weekend project.

Get your card statements into Excel

If you have Apple Card PDFs and want them in a clean spreadsheet quickly, upload them to the credit card statement converter. Review the rows, confirm the balance check, and download Excel or CSV. You can try it on the free plan before deciding whether you need more pages.

FAQ

Can I export Apple Card transactions to Excel?

Yes. For closed statements, the Wallet app generally lets you export the transactions in formats that include CSV, which opens in Excel. You can also save the statement as a PDF and convert it.

Why can't I export the current month?

Exports are usually tied to statements, and the current month's statement isn't available until it closes. Wait for the statement, or record recent transactions manually in the meantime.

Are Apple Card purchases positive or negative in the export?

Card exports often show purchases as positive because they increase the balance owed, but conventions vary. Check a known purchase and a known payment, then normalize the sign before importing.

Can I import Apple Card transactions into QuickBooks?

Yes. Set up a credit card account in QuickBooks, upload a CSV, check the sign mapping in the preview, and reconcile to the statement's new balance.

How do I prove the spreadsheet is complete?

Use the statement PDF: previous balance plus purchases, fees and interest, minus payments and credits, should equal the new balance. If the difference is zero, nothing is missing.

Should I use the transaction date or the posting date?

Either works if you're consistent. Transaction date suits budgeting; some bookkeepers prefer posting date. Pick one and use it for every month.