A

Anonymous

Solved

Importing Credit Card Transactions

Forum|Forum|7 years ago
February 18, 2019
51 replies
164 views

I would like to connect to my credit card provider to download my transactions into my checking account register. I know how to add a banking account but I want to know how I can download the credit card transactions into the same register as my checking account register.

QuickBooks Desktop

Best answer by HoneyLynn_G

Thank you for posting here in the Community, @482881.

I can help you download the credit card transaction into QuickBooks Desktop,

Click Banking.
Choose Bank Feeds.
Select Banking Center.
From the Bank Accounts list, choose the account you need to connect.
Click Download Transactions to receive transactions.
Select Synchronize.
Choose Sync all for this Bank to connect all accounts for the same bank.
Type your PIN or password.
Select OK.

You can also manually import your transaction using the Web Connect feature. For detailed instruction, please check this article: Download Bank Feed transactions.

Let me know if you're able to successfully connect your credit card. I'm still here to help you more if you have follow-up questions.

HoneyLynn_GAnswer

Level 6

Thank you for posting here in the Community, @482881.

I can help you download the credit card transaction into QuickBooks Desktop,

Click Banking.
Choose Bank Feeds.
Select Banking Center.
From the Bank Accounts list, choose the account you need to connect.
Click Download Transactions to receive transactions.
Select Synchronize.
Choose Sync all for this Bank to connect all accounts for the same bank.
Type your PIN or password.
Select OK.

You can also manually import your transaction using the Web Connect feature. For detailed instruction, please check this article: Download Bank Feed transactions.

Let me know if you're able to successfully connect your credit card. I'm still here to help you more if you have follow-up questions.

U

userdennyp92

I have closed one of my cc how do I get them into my QuickBooks. It didn’t pull everything up from this here.

R

ReyJohn_D

Moderator

I do not have the option under "Banking" that says "Bank Feeds"

I am also trying to upload credit card transactions from Bank of America and I am having no success. I have only been able to upload my checking information.

New to QuickBooks! Thank you for your help.

I'd be glad to share some info and steps to ensure you can access your bank feeds and import your transactions, @LowcountryNutrition.

For your first concern, there are a couple of possible reasons why you're unable to see the "Banking Feeds" option on the Banking menu. These are the following:

Your QuickBooks Desktop (QBDT) is outdated or unsupported.
Possible company file issue.

To help fix this, let's ensure to update QBDT to the latest release to have the latest features and need patches. Also, please make sure you're using a supported version of QBDT to prevent unexpected QuickBooks responses.

If you meet the above requirements and still unable to see the said option, you can open a sample file to test if you'll get the same outcome. Here's how:

Open your QBDT.
On the No Company Open screen, select a sample file from the Open a sample file drop-down.
Access the Banking menu, and locate the Banking Feeds option as you normally would.

If you see the said option, then the original file might be damaged. In this case, I recommend running the QuickBooks Verify and Rebuild tool. This can help identify and repair data damage.

Here's how to Verify your data (original company file):

Go to the File menu at the top.
Select Utilities, and then choose Verify Data.

If the Verify data detects an issue, you can Rebuild your file. Let me guide you how:

Go back to the File menu.
Choose Utilities, and then select Rebuild Data.
Click OK, and then follow the on-screen prompts to save a backup.
Select OK when you see Rebuild has completed.
Once done, go to your Banking menu again and check the said option.

For more info about the process, please check out this article: Verify and Rebuild data in QBDT.

About your second concern, please check if the file format you downloaded from your bank (Bank of America) is a .qbo file. This is the only type of file QuickBooks can read for Web Connect import.

If the file format is fine and you're still unable to import your data, please log in to your bank's website and check your notification list. If you see any messages about changes, kindly follow the instructions.

If the same thing happens, please proceed to steps 4 to 5 of this article for the additional fixes: Fix Web Connect import errors.

Once everything's good, you can begin adding and matching your transactions to ensure they go to the right accounts and prevent duplicates. To speed up this process, you can create bank rules in QBDT.

Lastly, you can reconcile your account to ensure the accuracy of your books.

You're always welcome to comment back if you have more questions about managing your banking in QBDT. I'd be happy to help you some more. Take care and enjoy your day.

C

CaseyHart

I downloaded my credit card transactions, and they show in the credit card register. I'm going to pay online from my bank, but how does the downloaded info get onto the check stub?

Thanks.

R

ReyJohn_D

Moderator

Hi there, @CaseyHart.

You'll have to manually match the transactions you downloaded with the ones in the check register. I'll guide you how:

Go to the Banking menu then Bank Feeds and then choose Bank Feeds Center.
Open the Match Transactions window then make sure the correct bank account is showing from the Financial Institution dropdown.
Click View then download and check the electronic statement.
Make sure the Show Register checkbox is selected in the Match Transactions window.
Choose the transaction in the statement that you need to match to a transaction in the register.
Find the transaction in the register to match to. Make sure the amounts match.
Hit Match once confirmed.

Furthermore, here is an article about bank feeds in QuickBooks Desktop. This way, you'll have better options on how to manage your bank feeds.

Please feel free to read this handy help article if you've got other QuickBooks concerns, such as setting up payments and inventories, running reports, reconciliation, etc. to keep your business up and running well.

Please let me know if you have other concerns. Have a nice day!

J

JVizza

I am trying to import credit card transactions into Quickbooks 2019 for Mac DESKTOP. In my one account it won't recognize the account as a credit card. In my other account it won't allow it to import at all. It doesn't see it as a new account so I can't even select Credit Card. What's the fix please? Thanks

Adrian_A

Level 8

Let's run the verify and rebuild steps, JVizza.

It is to isolate if your company file has data issues.

You can do that by going to the File menu. Under Utilities, select Verify Data. Then, OK. If you see an error message, you can try searching for it on our QuickBooks Desktop Help page. If you are prompt with Your data has failed the integrity check, you'll have to rebuild the file.

Here's how:

Click the File menu.
Under Utilities, select Verify Data.
Once the rebuild's complete, click OK.

Afterward, let's categorize the transactions again. I've added this reference for more information: Add and match Bank Feed transactions in QuickBooks Desktop.

I'm just a post-away if you need help. Keep safe!

J

JVizza

Thanks. So I ran the Verify Data and it was all ok. I tried to import that file and here is the message I get

N

NadineG730

I am trying to view all the previous credit card transactions from 2020 when I linked the account I put a date of 1/1/2020 but the only transactions I can see are from 11/2020 forward. Is there a way to change the date or add other statements that are missing there??

Rubielyn_J

Level 8

Hi there, @NadineG730. I can provide some insights about transactions imported inside QuickBooks Online.

The first time you connect, QuickBooks automatically downloads the maximum number of transactions available from your bank. Depending on the bank, this can give you up to a year of historical transactions and the default period when it will be sync. Most banks may only download the previous 90 days.

In this case, I suggest reaching out to your bank to download the missing transactions using Web Connect.

For more information, you may consider checking out this article: Download Bank Feed transactions in QuickBooks Desktop. This includes a detailed process on how to download transactions inside QuickBooks.

Additionally, I'll be adding these reference you can use in the future:

Feel free to let me know if you have other concerns. I'll make sure to get back to you right away. Wishing you all the best.

Fiat Lux - ASIA

Level 14

This post has been deleted.

@Mason_olly

Afaik, the product you mentioned only works with QBD. It is similar to this app

https://transactionpro.grsm.io/qbo

If you are using QB Online, explore the trial version of SlickConnect or another converter app as I mentioned in the earlier post.

https://www.moneythumb.com/?ref=110

R

RCV

QuickBooks Team

This post has been deleted.

Thanks for checking in with us, Mason_olly.

If you are using QuickBooks Desktop, we can use the Web connect (.QBO) files feature to download bulk credit card transactions from your bank’s website into QuickBooks. The (.QBO) files can be downloaded and saved on your computer. Then, you can import the transactions so they become available in your Bank Feeds. If your bank offers Web Connect, juts follow the steps below:

Go to the Banking menu.
Select Bank Feeds, then Import Web Connect Files.
Choose the QBO file you saved, then tap Open.
When prompted to Select Bank Account, select:
- Use an existing QuickBooks account if the account you're importing transactions into is already set up in QuickBooks.
- Create a new QuickBooks account if the account you're importing transactions into isn't in QuickBooks yet. Learn how to create an account.
Hit Continue. You'll see a dialogue box telling you that the data has been successfully read into QuickBooks. Select OK.
Go to the Bank Feeds Center to review your transactions.

You an also download your credit card transactions using the Direct Connect feature. The first time you connect, QuickBooks automatically downloads the maximum number of transactions available from your bank. This is as much as QuickBooks can download depending on the bank, this can give you up to a year of historical transactions. Most banks may only download the previous 90 days. See the Download Bank Feed transactions in QuickBooks Desktop article for the steps and details.

Feel free to visit our Banking page for more insights about managing your bank feeds in QuickBooks Desktop.

I'm just one post away if you need a hand with reconciling your accounts or any QuickBooks related. I'll be here to ensure your success. You have a good one.

N

NorthCarolina22

Hello,

I am relatively new to Quickbooks Online. Could someone please let me know if my receipts from American Express app will download into Quickbooks online?

J

JamaicaA

QuickBooks Team

Congratulations on making your first post here, @NorthCarolina22. I'd be glad to clarify your sales receipt concern from American Express App.

Once you connect your American Express account to online banking, QuickBooks Online will automatically download your transactions.

Additionally, any receipts you take with the American Express Business App are synced with QuickBooks seamlessly. These receipts appear among your other downloaded transactions on the Banking menu.

Feel free to read this handy article to know more about American Express connections. You can proceed to the last part to learn what you need to do to keep getting transactions from American Express.

You’ll want to open this links to categorize and match transactions including reconciling them to keep your business up and running well:

You can comment here if you have follow up question with managing your American Express Bank or any other banking-related concerns. I'm always around to help.

M

mv808

I downloaded the bank and credit card transactions on excel and they have all the transactions from the time I started my business, I've already reconciled everything, will all the transactions be uploaded and will it mess up my accounting?

Sign up

Login with SSO

Let's get you signed in

Login with SSO