To download credit card transactions into QuickBooks Desktop, set the card up as a credit card account, then pull the charges in through a direct feed or a Web Connect (.qbo) file from the card issuer. If the issuer offers neither, convert the statement to a QBO file yourself and import that.
Credit card account setup in QuickBooks Desktop
The card should be a credit card account, not a bank account. QuickBooks Desktop keeps the two types apart: a credit card account is a liability that grows when you charge something, while a bank account is an asset that shrinks. Choosing the wrong type flips every balance and makes the card look like cash in hand.
Create the account before you download
Create the account in the chart of accounts first, so the download has somewhere to land.
- Open the Chart of Accounts and choose Account, then New.
- Pick Credit Card as the account type.
- Name it so you can tell cards apart later, for example "Visa ending 4417 - Example Bakery". The number is an example, so use your own last four digits.
- Enter the opening balance only if you are starting the books mid-stream. Otherwise leave it blank and let the first statement establish it.
A business with several cards should create one account per card, never one shared account. Each card has its own statement balance, and you will want to tick that balance off against each statement when you reconcile.
Link the account to the download
QuickBooks Desktop downloads into an account only after the account is set up for bank feeds. The Intuit article on downloading bank feed transactions in QuickBooks Desktop starts from the Bank Feeds Center under the Banking menu, and that is where the card should appear once linked. If the card is not on the list, the issuer may not support either download method, which is the case the last section covers.
Direct Connect or Web Connect for a credit card in Desktop?
Direct Connect is an automatic link where QuickBooks asks the issuer for new transactions. Web Connect is a manual file: you download a .qbo file from the issuer's website and open it in QuickBooks. Use whichever your card issuer offers. If both are on offer, Direct Connect saves clicks, while Web Connect gives you a file you can keep.
What each method looks like
Intuit's article describes both. For Direct Connect, you open the Bank Feeds Center, select the card, choose Download Transactions and enter your issuer PIN or password when asked. For Web Connect, you either use Download Transactions to reach the issuer's website, or download the .qbo file yourself and import it. Intuit states that only .qbo files work for Web Connect; QFX and QIF files are not supported.
That last point matters if the issuer's download page offers a menu of formats. Pick the one labelled for QuickBooks or QBO, not "Quicken" or QFX. If all you can get is a CSV or an Excel file, QuickBooks Desktop will not read it as a card download. The route for those is to turn them into a QBO file first. The post on importing CSV bank transactions into QuickBooks Desktop explains that conversion, and the same method applies to a card.
Step list for a Web Connect card download
These steps assume you already have the .qbo file saved on your computer. The wording of menu items can differ between years of QuickBooks, so treat the names as a guide.
- Back up the company file. A download cannot be undone as a whole, and a backup costs a minute.
- Open the company file and choose Banking, then Bank Feeds, then Import Web Connect Files.
- Pick the .qbo file and open it.
- When QuickBooks asks which account to use, choose the existing credit card account. Do not choose "new account" unless you mean it.
- Open the Bank Feeds Center, select the card and review the downloaded list. Accept each item into the register, assigning a category as you go.
- Compare the register balance with the closing balance on the issuer's statement for the same date.
The Desktop file path and its quirks are covered in more detail in importing bank transactions into QuickBooks Desktop with a Web Connect file. A card file behaves the same way, with one difference in how the amounts are treated, which the next table shows.
A table of card lines and the sign each takes
On a credit card account, charges increase what you owe and payments and refunds reduce it. The table shows how common lines are treated. The amounts are examples.
| Statement line (example) | What it is | Effect on the card balance | Where it ends up |
|---|---|---|---|
| Office Depot, 84.20 | Purchase | Increases the balance owed | Charge, coded to office supplies |
| Refund Office Depot, 20.00 | Refund | Reduces the balance owed | Credit, coded to the same expense |
| Payment thank you, 500.00 | Payment from your bank | Reduces the balance owed | Transfer from the checking account |
| Interest charge, 12.35 | Fee | Increases the balance owed | Charge, coded to interest expense |
Each issuer prints these differently. Some show charges as positive numbers and payments as negative, and some do the reverse. The file you download should already have the sign sorted out, but a file you build from a statement must get it right. The question of whether credit card charges are positive or negative in the file has its own answer in the QuickBooks Online post, and it applies to Desktop files too.
Card statements older than the Desktop download window
A feed only reaches back as far as the issuer allows. Intuit says some banks offer up to a year of history on the first Direct Connect download, but most give about 90 days.
Web Connect is similar: some issuers let you pick a date range, and otherwise you get their maximum, which may be 30, 60 or 90 days or more.
So a card you start tracking in October may have charges from July that no feed will ever supply. There are three honest ways to bring in the older months.
Download the oldest months from the issuer first
Many issuers let you choose a statement month and export it from the statements page, even when the "recent activity" download is short. Try each month's statement page for a QBO or QuickBooks option before giving up.
Convert the PDF statements
Most issuers keep past PDF statements online. A PDF is not something QuickBooks Desktop opens, but it holds the same lines. The step is to turn each PDF into a QBO file, check the totals, and import it as you would any Web Connect file. The post on importing PDF bank statements into QuickBooks Desktop walks through that route end to end.
SimpleBankConvert is being built for this case: it reads a PDF statement and gives back a QBO file, the type Desktop opens, with dates and money columns tidied. Accounts are not open yet, so join the list on the get started page.
Import in order, one month at a time
Whichever route you use, bring older months in oldest first. Your running balance depends on order, and a gap in the middle is hard to spot afterward. After each month, compare the register balance with that statement's closing balance before you move on.
Dealing with a spreadsheet instead
Sometimes the history exists only as an Excel export from the issuer's website. You can enter those lines in batches or convert the sheet to a QBO file. The Enterprise and Accountant editions also have a paste-from-Excel screen, described in QuickBooks Enterprise import transactions. Do not paste credit card lines into a journal entry import; a journal entry has no concept of a card statement to reconcile against. If you only have a handful of lines, typing them in by hand is quicker than any import.
Do Desktop credit card downloads include pending charges?
Usually not. Issuers tend to put only posted transactions in a download and keep pending authorizations on screen until they settle.
Expect a charge you made yesterday to show in the issuer's app but not in QuickBooks. Your issuer's download page or support team can confirm what its file includes.
Why a missing charge is not always a problem
A pending charge can change when it posts. The merchant may add a tip, the amount may drop, or the authorization may disappear. Because a download should only contain final amounts, QuickBooks never has to undo a pending line. The cost is a small delay.
What to do when you need a charge now
If you must record a charge before it posts, for example to show a job's cost, enter it by hand in the card register. The post on manually adding bank transactions to QuickBooks Desktop explains how to enter it so the later download matches it instead of duplicating it.
If you do that, note the date and amount carefully. The posted date is often a day or two after the purchase date, and the amount can differ. Check the first download after you enter a charge and look for a pair of near-identical lines.
Card payments that land twice in Desktop
A card payment appears in two places: as a withdrawal on the bank account that paid it, and as a payment on the card. If you download both accounts, each payment arrives twice. Accepted as two ordinary lines, one payment becomes two unrelated entries, and your expense or income totals end up wrong.
How the doubling happens
Say you pay the Visa 500.00 from checking on March 10. The bank download has "Payment to Visa, -500.00". The card download has "Payment thank you, +500.00" on March 11. Accept both as ordinary lines and QuickBooks records two separate events: a 500.00 expense on checking and a 500.00 credit on the card coded to some other account. If you record the transfer from checking and then also add the card line, the card balance drops by 1,000.00 for a single 500.00 payment.
How to record it once
A payment between two of your own accounts is a transfer, not an expense and not income. Record it once as a transfer, and match the other side to it.
- Accept the bank-side line as a transfer to the credit card account.
- When the card-side line appears, match it to that transfer instead of adding it as new.
- If the card line was already added, find it in the card register and delete the extra one.
- Confirm that neither account has an expense account called "Credit card payments".
If you handle several cards, a monthly habit helps. After each import, open the card register and sort by amount, then look for payment lines that appear twice.
Checking your work
Reconcile the card against its statement after the import. If the reconciliation is off by exactly a payment amount, a doubled payment is the likeliest cause. The post on importing an Amex statement into QuickBooks shows one real-world card from statement to reconciled register, and the same checks work for any issuer.
What if the issuer won't export at all?
Some cards, especially store cards, offer a PDF statement and nothing else. Whether an issuer offers Direct Connect or Web Connect is its own decision, so the feed route can be closed. Then convert the PDF to a QBO file, or type the lines in.
Before you convert anything, download the PDF straight from the issuer's website, not a scan or a photo of paper. A digital PDF holds exact digits, which makes the totals check far more reliable. Whatever you choose, finish by comparing the register balance with the statement's closing balance. That one number tells you whether the month is complete.