How to Import Apple Card Transactions into QuickBooks

Short answer: Apple Card has no QuickBooks bank feed, so nothing syncs on its own. The only native export lives in the Wallet app on the iPhone that holds the card, one monthly statement at a time. To get Apple Card activity into QuickBooks you import a file: either export month by month from Wallet, or convert the PDF statements to a QBO Web Connect file and load a whole year in one pass. Here is how each route works.

Can Apple Card connect to QuickBooks?

No. Apple Card does not support a direct connection or bank feed to QuickBooks Online or QuickBooks Desktop. You will not find Apple Card in the QuickBooks bank list, there is no integration to enable, and nothing imports automatically the way a Chase or Amex card would. Every Apple Card transaction that ends up in QuickBooks gets there through a file import, which makes the quality of that file the whole game.

How do I export Apple Card transactions?

On the iPhone that holds the card, open Wallet, tap Apple Card, tap the card balance, and scroll to Statements. Each monthly statement offers Export Transactions in CSV, OFX, QFX, or QBO format, one statement per export. The same Statements screen also holds the PDF version, and you can download statement PDFs from a browser at card.apple.com. Two limits matter for bookkeeping: the export only works from the iPhone itself, and it only covers one month per pass, so a year of history means twelve separate exports stitched together.

Does Apple Card work with QuickBooks Desktop?

Only through a file. There is no Apple Card feed for any QuickBooks version, and Desktop is pickier about what it accepts: the Web Connect importer wants a .qbo file specifically. The Wallet app can produce a QBO for a single month, which works if you have the iPhone in hand. A bookkeeper working from forwarded PDF statements does not have that option, which is why converting the Apple Card statement to QBO is the standard route for Desktop shops and outsourced books.

How do I import a whole year of Apple Card into QuickBooks?

Skip the twelve Wallet exports. Gather the monthly PDF statements, from Wallet, from card.apple.com, or from whatever the client forwarded, and convert them together into one QBO file. Each statement is a fixed period, so a year imports without the overlap problems a live feed creates. Keep one thing in mind on volume: QuickBooks caps a single import file at 1,000 transactions and 350 KB, so a very busy card may need the year split into two files.

Import Apple Card transactions into QuickBooks, step by step

First, set up Apple Card as a credit card account in QuickBooks if it does not exist yet; imports need an account to land in. Second, get your file: export a QBO from Wallet for a single recent month, or convert the PDF statements for anything bigger. Third, in QuickBooks Online go to Transactions, then Bank transactions, choose the Apple Card account, and pick Upload from file under the Link account dropdown. In QuickBooks Desktop use File, Utilities, Import, Web Connect Files. Fourth, map the file to the Apple Card account, review the rows in the For review tab, and categorize.

How do I record Apple Card payments and Daily Cash?

Treat the card like any other credit card account. Purchases post as negative lines that increase what you owe, and payments from your bank post as positive lines that pay the balance down; record the payment as a transfer from checking to the Apple Card account so it does not double count as an expense. Daily Cash arrives as a credit on the card or in Apple Cash, and most small businesses book it as a purchase rebate rather than income. A converted statement carries all three line types with the signs already correct, so the account reconciles to the statement balance without hand fixes.

Avoiding duplicate Apple Card transactions

Duplicates on Apple Card come from overlapping files rather than an overlapping feed, since there is no feed. Import whole statements, one period per file, and never load the same month twice in different formats. If a few rows do slip in twice, open the For review tab in QuickBooks Online, select the extras, and use Batch Actions, then Exclude Selected. QuickBooks also runs its own duplicate matching on QBO imports, which catches most repeats on amount, date, and reference.

Does the Goldman Sachs to Chase move change anything?

Not for your books. Apple Card is transitioning from Goldman Sachs to JPMorgan Chase over roughly two years, and Apple has said nothing changes for cardholders during the move. Your saved statements stay valid records whoever the issuer of a given month was, and they convert the same way. If an account closes or migrates mid-year, the PDFs you saved are the record that stays put, one more reason to pull them now.

The short version

Apple Card offers no QuickBooks feed, and its native export is locked to the iPhone one month at a time, so file import is the only path into the books. For one recent month with the phone in hand, the Wallet export works. For a year of history, a Desktop company file, or statements a client forwarded, convert the Apple Card statement to QBO and import it like a bank download, or use the Apple Card statement to Excel converter when you want the rows in a spreadsheet first. The walkthrough on how to convert bank statements to QuickBooks (QBO) covers both QuickBooks versions with screenshots, and how many transactions QuickBooks accepts at once explains the 1,000-line cap before you upload a busy year. If the card carries a lot of business purchases, an expense management tool that reads receipts can categorize the spend before it ever reaches the ledger.