To import credit card transactions into QuickBooks Desktop, you can use either a Web Connect (.QBO) file downloaded from your credit card provider or set up a direct bank feed through the Bank Feeds Center. Note that CSV files are not directly supported and require conversion to a compatible format like .QBO, .QFX, or .OFX before they can be imported.
Before you import: back up your company file
Creating a backup of your QuickBooks company file is essential before importing any transactions, because imports cannot be undone. To create a backup, go to the File menu and select Backup Company, then Create Local Backup. Choose a save location and confirm the backup. This ensures you can restore your data if anything goes wrong during the import process.
Method 1: Import using a Web Connect file (.QBO)
- Log in to your credit card provider's online banking portal and locate the option to download transactions. Look for a "Download" or "Export" option and select Web Connect (.QBO) as the file format. Save the .QBO file to your computer.
- Open QuickBooks Desktop and sign in with your Intuit Account when prompted. This is required to process the .QBO file.
- Go to File > Utilities > Import > Web Connect. Browse to and select the .QBO file you downloaded.
- If the credit card account is already linked to online services in QuickBooks, you may need to deactivate online services for that account first to avoid conflicts.
- QuickBooks will process the file and import the transactions into the Bank Feeds Center for review.
Method 2: Set up direct bank feeds
Direct bank feeds allow QuickBooks Desktop to automatically download credit card transactions on a regular basis. To set this up, open the Bank Feeds Center by going to Banking > Bank Feeds > Set Up Bank Feed for an Account. Select your credit card account and choose either Express Web Connect or Direct Connect, depending on what your credit card provider supports. Follow the on-screen prompts to enter your online banking credentials and link the account. Once connected, QuickBooks will download new transactions periodically, which you can then review in the Bank Feeds Center, and if you use the account for contractor payments, you'll want to prevent QuickBooks desktop from automatically lumping non-wage payments into 1099-NEC boxes.
What to do if you only have a CSV file
QuickBooks Desktop does not directly import CSV or Excel files for credit card transactions. If you only have a CSV file, you must convert it to a supported format such as .QBO, .QFX, or .OFX. Several third-party tools and online converters can perform this conversion. After conversion, you can use the Web Connect method described above to import the file. Always verify the converted file's formatting before importing to avoid errors.
Review and categorize imported transactions
After importing transactions via Web Connect or direct feeds, you must review, categorize, and match them in the Bank Feeds Center before they are added to your QuickBooks register. Open the Bank Feeds Center and select the credit card account. For each transaction, verify the date, description, and amount are correct. Use the drop-down menus to assign the appropriate expense or income account from your chart of accounts. To save time on recurring transactions, you can set up rules or memorized transactions in your QuickBooks Desktop settings; these automatically categorize future transactions that match criteria you define.
Reconcile your credit card account
Reconciliation ensures your QuickBooks records match your credit card statement. Go to Banking > Reconcile and select your credit card account. Enter the ending balance and statement date from your credit card statement. In the reconciliation window, review the list of transactions and check off each one that appears on your statement. The "Difference" field should show zero once all transactions are matched. If there are discrepancies, double-check that all transactions are correctly marked as cleared and that no transactions are missing. When the difference is zero, click "Finish Now" to complete the reconciliation. This process helps identify errors or unauthorized charges and keeps your financial records accurate.
