
Managing credit cards in QuickBooks Online can be a breeze, especially with the right knowledge. You can connect up to 20 credit cards to your QuickBooks Online account, making it easy to track expenses and stay organized.
To get started, you'll need to add a credit card account in QuickBooks Online, which can be done in just a few clicks. This will allow you to easily categorize and track your credit card expenses.
Having multiple credit cards connected to your QuickBooks Online account can be super helpful in separating personal and business expenses. This way, you can easily see which card was used for which purchase.
Entering a Payment from Sales Receipt or Receive Payment Page
To enter a payment from the Sales Receipt or Receive Payment page in QuickBooks Online, click on either Create (+)>Receive Payment or Create (+)>Sales Receipt. Choose the correct option based on whether you're receiving payment for a sale already entered on an invoice or recording a sale and receiving immediate payment.
Related reading: How to Print Venmo Qr Code from Computer
To complete the form, select a credit card as the Payment method and click Enter credit card details. You can either enter the credit card information manually or swipe the card through the reader.
Here are the steps to follow:
- Enter the credit card information and click OK to save.
- Or, swipe the card by clicking Swipe card and then swiping the card through the reader.
Once you've entered the credit card details, click Save and close to save the transaction and process the payment.
Accepting Payments
Accepting payments in QuickBooks Online is a breeze. You can enter a credit card payment from the Sales Receipt, Receive Payment, or Invoice pages.
To start, click on either Create (+)>Receive Payment or Create (+)>Sales Receipt. This will depend on whether you're receiving payment for a sale that's already been invoiced or if you're recording a sale and receiving immediate payment.
You'll need to select a credit card as the payment method and click Enter credit card details. From there, you can either enter the credit card information or swipe the card.
Here are the steps to follow:
- Complete the form.
- Enter the credit card information and click OK to save.
- Or, swipe the card by clicking Swipe card and then swiping the card through the reader.
- Save and process the payment by clicking Save and close.
You can also use a QuickBooks credit card integration, such as EBizCharge, to accept credit card payments and receive the lowest processing fees.
To enter a credit card payment from the Sales Order page, click Sales Order and complete the form. Then, click Save & Close, and enter cardholder information by selecting a saved card or entering a new card.
Finally, select Process Payment to process the payment, and click Done to finish the transaction.
Worth a look: How Do I Process Credit Card Payments
Importing Data
Importing data into QuickBooks Online is a straightforward process. You can manually import credit card transactions if you don't use bank feeds or if your credit card company doesn't offer direct QuickBooks integration.
The first step is to download your credit card transaction history from your financial institution's website. You can usually find this option by signing into your bank or credit card's website and accessing your account statements. The download process varies by bank, but common options include PDF, CSV, Excel, and QBO file formats.
Curious to learn more? Check out: T Mobile Carrier Billing
If your bank provides transaction downloads as CSV files but not QBO, you can use a tool like DocuClipper to instantly convert the CSV files into QBO format for a smoother import experience.
Here are the steps to upload credit card transactions to QuickBooks Online:
- Select the file to upload
- Verify the account where the transactions should be uploaded
- Click "Next" and QuickBooks Online will begin importing the transactions
- The upload process may take a few minutes depending on the number of transactions
- Click "Let's go" once prompted
- When complete, you'll see all imported transactions listed under the designated account name
Map Columns to Fields
Before you can import your data, you need to map the columns from your file to the fields in QuickBooks. This is a crucial step, as it ensures that your data is accurately recorded in the correct fields.
To map columns to fields, you'll need to open your CSV or TXT file in Excel to determine what information your bank exported and how it's formatted. This is important because the formatting of your data can vary depending on your bank.
You'll want to review the columns in your file to see how the amounts are organized. For example, transaction amounts might be shown as positive numbers for charges and negative numbers for payments to reduce the credit card balance.

Once you've reviewed your file, you can set up your file and map the fields in QuickBooks. This involves specifying the format of your data, such as whether the first row is a header and how many columns show amounts.
You'll then need to match each column in your file to the appropriate fields in QuickBooks. For example, you might match the "date" field in QuickBooks to the "date" column from your file.
How to Import Online
Importing online data into QuickBooks can be done in a few different ways. You can connect your credit card to QuickBooks using your online sign-in credentials, which allows for automatic import of transactions. Most credit card companies support this connection, but if yours doesn't, you can still import transactions manually using a QBO or CSV file.
To connect your credit card, navigate to the Banking Center in QuickBooks and click the Link account button. Select your credit card provider from the list or search for it, and then sign in to your account to confirm the connection.
Worth a look: Make Money on Mobile Phone
Once connected, you can set up your file to import transactions automatically. This involves selecting the date range and file format, which can be QBO, CSV, or Excel. Some banks provide transaction downloads as PDF files, which need to be converted to a compatible file type using a tool like DocuClipper.
Here's a step-by-step guide to importing online data:
1. Download your transaction history from your bank's website.
2. Save the file in QBO format if available, or convert it to QBO or CSV format using a tool like DocuClipper.
3. Map the columns in your file to the corresponding fields in QuickBooks.
4. Upload the file to QuickBooks Online and select the account where the transactions should be uploaded.
5. Verify the file and let QuickBooks import the transactions.
Remember to review your file and map the columns correctly to ensure accurate import of transactions. With these steps, you can easily import online data into QuickBooks and stay on top of your finances.
A different take: S Corp Business Taxes
Managing Data
You can manage multiple cardholders with ease in QuickBooks Online, making it a great tool for businesses with team members who have their own credit cards.
To reconcile the main business card account, you'll need to create transfers from the main business account to the individual cardholder's accounts.
The total balance on the credit card statement will be a combination of the balances for all cardholders.
By creating transfers and reconciling each cardholder's account separately, you can ensure accurate tracking of expenses.
You can enter transfers by selecting New>Transfer in QuickBooks Online.
The transfer should have the same date as the date on the credit card statement.
Reconciling each cardholder's account to a zero balance will help you track their individual spending.
After uploading manually downloaded bank transactions into QuickBooks Online, you'll see all the new transactions listed under the appropriate account name.
You should take time to properly categorize and match any new transactions before reconciling.
Remember to double-check all your transactions for accuracy.
Recommended read: Retained Earnings in Cash Flow Statement
Bank Feeds and Charges
You can connect your credit card to QuickBooks Online, allowing for automatic import of transactions. This process is quick and easy, and most credit card companies support it using online sign-in credentials.
Having visibility of the most recent charges on your credit card is essential for managing project costs and preventing fraud. By setting up automatic bank feeds, you can track your expenses in real-time and reconcile your credit card statement with ease.
You can also link multiple credit card accounts to QuickBooks, including those issued to employees, allowing for organized expense tracking and easy reconciliation.
Here's an interesting read: Discover Card Autopay
How to Charges
Connecting your credit card to QuickBooks is a straightforward process. You can do this by selecting your credit card from the displayed options or typing the name of your credit card provider in the search box.
QuickBooks supports over 20,000 financial institutions worldwide, so it's likely that your credit card provider is supported for automatic import into QuickBooks. However, if you can't locate your bank, you can import your transactions manually.
To connect your credit card, you'll need to sign in to your bank account, and then confirm that you want to share your banking information with Intuit. After linking the credit card to an account from your chart of accounts, you must decide when QuickBooks should begin importing transactions.
The quickest way to enter credit card charges into QuickBooks Online is to manually key in the transaction and match those transactions to your bank feed once the bank feed transactions appear on your register.
Downloading
Downloading your credit card transactions is the first step in importing them into QuickBooks Online.
You can access and download your transaction history from your financial institution's website. Sign into your bank or credit card's website and access your account statements, but every bank's portal will be slightly different.
To download your transactions, you'll need to select a date range and file format. Common options are PDF, CSV, Excel, and sometimes QBO file formats.
For another approach, see: Access Credit Cards
You may need to do some searching to find where your bank provides transaction downloads. The download process varies by bank, so be patient and look for the option to download bank transactions.
Here are the common file formats you can expect to find:
Save the file in QBO format if available, as this integrates most cleanly into QuickBooks Online. Otherwise, save it in Excel or CSV format, both of which work for import.
Fees and Integration
Having bank feeds set up in QuickBooks Online is a game-changer for tracking expenses and managing project costs in real-time.
You can connect your bank accounts and credit card companies to QBO, which will automatically pull in the latest charges, making it easier to reconcile statements and prevent fraud.
Automatic bank feeds can save you a significant amount of time and effort, especially if you have multiple credit cards to keep track of.
With QBO, you can set up bank rules for recurring charges, making it easy to categorize and record regular expenses.
By connecting your credit card companies to QBO, 90% of the work will already be done when you're ready to reconcile your credit card statement.
You might like: Online Real Time Bill Payment
Manual Entry and Users
Manual entry of credit card transactions in QuickBooks Online can be a tedious task, especially if you have a large number of transactions to record.
You can manually enter credit card transactions by going to the "Expenses" tab, clicking on "Credit Card Charges", and then selecting the credit card account you want to use.
QuickBooks Online allows you to add multiple credit card accounts, making it easier to manage your expenses.
Each credit card account can have its own unique settings, such as the bank feed and payment terms.
Why Manual Entry of Charges Matters
Manual entry of charges matters because it provides the most accurate and up-to-date financials in QuickBooks. This is especially true for end-of-period accounting reports where pending charges can't be imported via bank feeds.
There's a time lag between actual credit card transactions and when they show as pending before posting to the card statement, making manual entry essential for real-time financial views.
Only actual payments that have been processed and appear on the statement will transfer to bank feeds, highlighting the importance of manual entry for accurate financials.
Suggestion: Paynow Real Time Payments
Manage Users Easily

Managing multiple cardholders can be a real challenge, but QuickBooks Online (QBO) makes it relatively easy. You can connect multiple bank feeds to your account, which allows you to track expenses for each cardholder separately.
The credit card statement will show a combined balance for all cardholders, but QBO can help you reconcile the account by creating transfers from the main business account to individual cardholder accounts.
To do this, you'll need to enter transfers from the main business account to "pay off" the employees' cards on the account. For example, if the credit card statement shows a balance of $7,000, and Employee A has a balance of $2,500, you'll need to enter a transfer of $2,500 from the main business account to Employee A's account.
Once you've entered the transfers, you can reconcile the individual employees' business cards to a zero balance. This will help you see that the total charges, less the transfer, balance the account to $0.00.
Readers also liked: Credit Cards Debt Help
Table of Contents
You might need to enter your credit card transactions into QuickBooks manually due to a time lag while a transaction moves from pending to complete. This can be especially frustrating if you're using the accrual method of accounting and are at the end of your accounting period.
There are several reasons you might want to enter credit card transactions manually, including a low number of credit card expenses or a desire for the most up-to-date and accurate daily financials.
Entering credit card charges into QuickBooks is easy once you understand the steps.
A unique perspective: Manually Process Credit Card Quickbooks Payments
Frequently Asked Questions
How do I manage credit cards in QuickBooks Online?
To manage credit cards in QuickBooks Online, log in to your account and navigate to the "Banking" tab. From there, select your credit card account to view and manage your linked credit card transactions.
How do I add a credit card to QuickBooks Online?
To add a credit card to QuickBooks Online, go to the Transactions tab and select Credit cards, then follow the on-screen steps to connect your card. You'll need to sign in to your bank or card issuer to complete the process.
Sources
- https://ebizcharge.com/blog/how-to-accept-credit-card-payments-in-quickbooks/
- https://www.docuclipper.com/blog/import-credit-card-transactions-into-quickbooks-online/
- https://fitsmallbusiness.com/import-credit-card-transactions-into-quickbooks-online/
- https://www.businessnewsdaily.com/16466-quickbooks-online-credit-card-charges.html
- https://bbbooksinc.com/blog/manage-credit-cards-in-qbo/
Featured Images: pexels.com