How To Import Credit Card Transactions Into QuickBooks Online
This article is part of a larger series onAccounting Software.
In this tutorial, you’ll learn to connect your credit card to QuickBooks Online and import credit card transactions. We’ll also explain when and how to import credit card transactions into QuickBooks Online using a QuickBooks Online file or Excel and a comma-separated values (CSV) file. If you’ve completed the prior tutorial,How to Import Bank Transactions, then this tutorial will be a breeze as the process is very similar.
This tutorial is designed for those who are using or want to use QuickBooks Online, which we ranked as thebest small business accounting software. You’ll get the most benefit from the tutorial by following along in your own QuickBooks account. If you don’t already subscribe to QuickBooks, you have the choice of a 30-day free trial or 50% off for three months.
This tutorial is one in our series ofFree QuickBooks Tutorials. You can watch the video below or follow the step-by-step instructions that include illustrations.
To connect your credit card to QuickBooks, you need the username and password that’s used to sign in to your online credit card account. If you haven’t set up online access to your credit card account, you must do so before continuing with these steps. Visit your credit card company’s website for information on how to activate your online access.
Select theBankingdropdown underBankingfrom the left menu bar of your QuickBooks Online company dashboard, as shown below.
If this is the first bank or credit card account you’re connecting to QuickBooks, you’ll see the following screen and you should click the green Connect account button to add your credit card account.
如果你已经连接另一家银行或信贷card account, you’ll be taken to the Banking Center. Click theLink accountbutton in the upper right corner of the screen to continue.
Enter your credit card company’s name to determine if it’s available to connect to QuickBooks Online. Our fictitious sample company, Paul’s Plumbing, has a business credit card with Capital One.
If your company isn’t listed, you’ll have to import your credit card transactions with a QBO file or through Excel using a CSV file, which we’ll explain later.
After selecting your bank, click the green Continue button to be taken to your bank’s sign-in page automatically.
QuickBooks will open a new browser window for you to sign in to your credit card account.
After signing in, your bank might ask you to confirm that you want to share your banking information with Intuit and provide a summary of the information to be shared. If you agree, click the appropriate button on your bank’s confirmation page, and you’ll be taken back to QuickBooks.
Upon returning to QuickBooks, you’re provided a list of accounts you have with that credit card company or bank:
Select all of the bank accounts you would like to link to QuickBooks Online. If you have a checking and credit card account at the same bank, you connect them both during this step. After you click on an account, a drop-down box will list the bank accounts included in your Chart of Accounts. If your credit card account is already included in your Chart of Accounts, select it.
Paul’s Plumbing needs to create a new account for their Bank of America credit card, so we’ll clickAdd new(shown above) at the top of the drop-down box.
After clicking Add new, you’re asked to provide information to add an account to your Chart of Accounts. You can glance ahead toHow to Set Up the Chart of Accountsif you want to learn more but, for now, you can provide a few details.
The Account Type and Detail Type must be Credit Card. An account name is required, and we recommend including the credit card company name for easy identification. If you have more than one credit card with the same company, you might also include the last four digits of the credit card. When you have entered all the information, click the green Save and Close button, and you’ll be returned to the prior screen with the new account selected.
After linking your credit card to an account from your Chart of Accounts, you must decide when QuickBooks should begin importing transactions.
The default start date to pull transactions is the beginning of the year. You should try to pull transactions back to the date you wish to start using QuickBooks Online. If your credit company or QuickBooks doesn’t allow you to go back that far, you’ll have to transfer the older transactions using a QBO or CSV file.
Paul’s Plumbing is importing credit card transactions starting on January 1 of the current year. Click the greenConnectbutton when you’re done.
QuickBooks Online will take you to the Banking Center after connecting your bank account. The Banking Center includes the following options:
- Transactions for review:The orange number (not shown) in the Capital One box is the number of transactions that have been imported, but not yet reviewed and classified.
- Review tab:The tab labeled For Review lists all the transactions imported from your selected bank or credit card that are awaiting review.
- Add account:To connect another bank or credit card company to QuickBooks Online, click the green Add account button in the upper right-hand corner of the screen and repeat the process.
You can peek ahead atHow to Manage QuickBooks Online Bank Feedsif you’d like to learn more about classifying transactions, but we recommend waiting until we complete a few more setup tutorials. It’s important to have your Chart of Accounts finalized before you start assigning transactions.
Now that your credit card account is connected, new transactions will be imported automatically into QuickBooks Online daily, or you can click Update in the upper right corner to import any new transactions immediately. You can visit the Banking Center anytime by clicking theBankingdropdown underBankingfrom the left menu bar (as you did at the beginning of this tutorial).
How To Import Credit Card Transactions Manually Into QuickBooks Online With a CSV or Similar File
Step 1: Download a Transfer File From Your Credit Card Company
QuickBooks Online can import credit card transactions from the following types of files:
- CSV:These files are commonly used to export data for a multitude of purposes and can be opened and edited with Excel.
- QBO:QBO files are QuickBooks WebConnect files specifically designed for exporting information from bank or credit card accounts to QuickBooks.
- QFX:QFX files are financial exchange files created for exporting information to Quicken, but they’ll also work with QuickBooks Online.
- OFX:An OFX file is a text file specifically designed for exporting financial data.
- TXT:Text files can be imported but might require some editing first. You might want to open the TXT file with Excel and convert it to a CSV file for a smoother transfer.
获得转移文件,登录到你的信用card account, and locate the option to download your account transactions. You’ll likely have the option to download your transactions in multiple formats. Choose the QBO or QFX format, if available, since they’re designed specifically for QuickBooks. The next best option is an OFX file. If none of those file types are available, a CSV or TXT file will suffice but require a couple of extra steps.
Save the transfer file to a location on your computer that you can remember easily to import the file.
Step 2: Select the Transfer File to Upload in QuickBooks
From the Banking Center, open the drop-down menu next to Update in the upper right corner, and then selectUpload from file.
Drag and drop your file of transactions or clickSelect filesto browse your file on your computer, as shown below. Click the green Continue button to proceed.
Step 3: Select a QuickBooks Account
Next, you must select an account from your Chart of Accounts to record the imported bank transactions.
If needed, you can clickAdd newto set up a new credit card account as demonstrated earlier. Paul’s Plumbing created a new QuickBooks account named Local Credit Card. After you have selected a QuickBooks account to record the imported transactions, click the greenNextbutton in the lower right-hand corner.
If your transfer file is a QBO, QBX, or OFX file, you’re done and can skip to step 6.
If your transfer file is a CSV or TXT file, you have a couple more steps to complete.
Step 4: Map Columns to QuickBooks Fields (CSV and TXT files only)
Before completing this step, you should open your CSV or TXT file in Excel to determine exactly what information your bank exported and how it’s formatted. Paul’s Plumbing exported the following CSV file from their local credit union account.
Tip:
When you open a CSV file in Excel, you may be asked to save the file as an Excel file to preserve features. Don’t do this because the file must remain a CSV file to be imported into QuickBooks.
Notice that transaction amounts are shown in column C with credit card charges shown as positive numbers and payments to reduce the credit card balance as negative numbers. Some credit card companies might include charges in one column and payments in another column. Either way is fine, but you’ll need to know how the amounts are organized in the next step.
After completing step 3, if you’re importing a CSV or TXT file, QuickBooks will take you to the Map Columns screen (not shown), where you’ll need to provide information, including:
- First row in the file is a header row:Place a checkmark in this box if the first row in your transfer spreadsheet provides the title for each column.
- Date:Click the drop-down arrow and select the column in your transfer spreadsheet that contains the date. In the next field, select how your spreadsheet formats the date.
- Description:Select the column that contains a description of the transaction. I recommend selecting whichever column is going to provide you with the most information to help classify the transaction without doing further research. Paul’s Plumbing chose the “Appears On Your Statement As” column instead of the “Description” column because of the more detailed information.
- Amount:First, choose whether your spreadsheet has all amounts in one column or if charges and payments are in separate columns. As we saw above, Paul’s Plumbing’s spreadsheet has all the amounts in one column and are located in column C. If you indicate amounts are shown in two columns, you’ll need to specify one column for money spent (charges) and another for money received (payments).
When you’re satisfied with your mapping, click the greenNextbutton in the bottom right corner of the screen.
Step 5: Select Transactions for Import (CSV and TXT files only)
You can select which transactions from your file to import. We highly recommend importing all transactions into the file. Even personal transactions on your business credit card account need to be imported. Reconciling your credit card account from QuickBooks to your credit card statement is an important step to make sure your books are accurate. The reconciliation isn’t possible if you don’t import all transactions.
Make sure all transactions are selected and then click the greenNextbutton in the bottom right corner of the screen to complete the import of your transactions.
Tip:
If there are no transactions listed on this screen, make the following changes to your file:
- Remove all formatting from the amount column, including dollar signs
- Remove blank rows so that everything begins at row 1, column 1 of the spreadsheet
If you make changes to your spreadsheet, you must save it and then back up to step 2 and reselect the file to import.
Step 6: Return to the Banking Center
Go back to the Banking Center. Your bank account is now shown in the upper left corner with the number of transactions awaiting review. You may have to refresh your browser for your banking center to reflect your freshly imported transactions.
We’ll learn how to review the transactions and accept, exclude, or match them to an existing transaction inHow to Manage QuickBooks Online Bank Feeds, but I recommend completing the tutorials in order.
The Importance of Connecting Your Credit Card to QuickBooks
Connecting your credit card account to download transactions automatically is one of the biggest time-savers offered by QuickBooks Online. Once connected, all you need to do is sign in to QuickBooks and classify the transactions that will transfer daily automatically. Most credit card companies allow you to connect to QuickBooks using your online sign-in credentials. If your credit card doesn’t allow a connection to QuickBooks, you can still import your credit card transactions using a QBO file or a CSV file with the help of Excel.
Tip:
Combining personal and business activity on the same credit card makes for messy bookkeeping, wastes your time, and will likely drive up your accounting fees at tax time. We highly recommend that you get a business credit card and use it purely for business. You can check out our list of thesmall business best credit cardson the market.
Wrap Up
You’ve now learned to connect your credit card to QuickBooks Online and import credit card transactions manually when necessary. We’ll return tomanaging bank feedsin a later tutorial. First, however, we must finish setting up your QuickBooks Online company. The next tutorial in our QuickBooks Online Training Course isQuickBooks Online Multiple Users Setup, where you’ll learn how to allow your external accountant and as well as other employees full access to your QuickBooks Online.