cancel
Showing results for 
Search instead for 
Did you mean: 
RoziPozi
Level 1

Credit card transactions feeding into wrong QB account

Hello Everyone,

I have a Bank of America credit card that automatically feeds into Quickbooks into 2 accounts- one is the rewards account and the other is the actual transactions.  The transactions are flip-flopped into the rewards account.  How do I change the mapping so that transactions go into the correct account?  Also, how do I move the transactions that have already landed in the wrong account?

 

Thanks!

Rozi Pozi

 

9 Comments 9
JamesDuanT
Moderator

Credit card transactions feeding into wrong QB account

I got an idea on how we can resolve your concern, Rozi Pozi.

 

Before we correct the mapping of the connected accounts, we'll need to undo the transactions that were added to wrong accounts. You can do by following the steps in this article: Unmatch downloaded bank transactions or move them to another account.

 

After undoing the bank transactions, we can now correct the mapping. We'll have to disconnect the bank account to remove the mapping of the accounts: Disconnect or delete accounts connected to online banking.

 

Then, we can reconnect the account to QuickBooks Online. This should now download the bank transactions to the correct accounts. From there, we can already categorize the transactions.

 

Keep us posted about this so we can further assist you in correcting your data.

RoziPozi
Level 1

Credit card transactions feeding into wrong QB account

I actually need to change the payment side of the entry.  It's posting to the wrong liability account.  How do I do that?

Kristine Mae
Moderator

Credit card transactions feeding into wrong QB account

Let's get this sorted out, RoziPozi.

 

First, you'll have to undo the transaction. This way, it'll go back to the page where you can change the posting account. You can click the article above on how to unmatch the entry.

 

Then, once it's back to the For review tab, select the downloaded transaction. Next, click the Categorize radio button, and select the correct account under Category. Then, click Add or Match

 

I'll also include this article as a future reference: Record your payments to credit cards.

 

Reach out to us again if you have other concerns. We're just one post away. Take care!

RoziPozi
Level 1

Credit card transactions feeding into wrong QB account

I have tried your solution but it only allows me to change the debit side of the entry.  I am trying to change the credit side of the entry.  My expenses are all recorded on the correct accounts.  It's the credit side of those entries that is incorrect?  This is not a problem with the payments.   The entries are showing on the wrong credit card account. I want to move them to the correct credit card account. Attached is a picture of what I'm dealing with.  How do I move the $16,830.03 balance to the credit card account next to it?

 

Thanks!

 

 

RoziPozi
Level 1

Credit card transactions feeding into wrong QB account

Here is the picture that I should have included.

MirriamM
Moderator

Credit card transactions feeding into wrong QB account

Thanks for adding a screenshot and all the information you've provided, RoziPozi.

 

To move transactions from Business Advantage Cash to CORP Account, you'll need to edit it one at a time for you to review and update their posting accounts. Here's how:

  1. In the left menu, click the Accounting
  2. Go to the Chart of Accounts tab.
  3. Choose a transaction and click the Run report drop-down list under Action column.
  4. In the Account QuickReport page, tap the account you've selected under the Account column.
  5. On the drop-down arrow under Add funds to this deposit, choose a customer.
  6. Under the Account column, change the posting account.

You may also exclude the transactions from Business Advantage Cash that are added from the banking page. Then, import them to the CORP Account.

 

Here's how to exclude the transactions:

  1. In the left menu, click Transactions.
  2. Tap the Banking tab, and hit the account where the entries are uploaded.
  3. Go to the For Review column.
  4. Select the transactions you want to delete.
  5. Choose Exclude.

Once done, import those transactions to the correct account using our WebConnect feature. See this article fro the detailed steps: Manually upload transactions into QuickBooks Online.

 

For additional reference about managing downloaded transactions, see below links:

If you have any questions about this, please don't hesitate to let me know. Have a great day.

RoziPozi
Level 1

Credit card transactions feeding into wrong QB account

Hi again,

I followed your suggestions on the previous post. It seemed to work well until I hit the update button and got an error message.  It told me to unmatch the transaction first but when I do that,  the transaction no longer shows up on the Account Quick Report.  These are credit card transactions downloaded from the bank.  What do you suggest now?

 

Thank you!

AileneA
QuickBooks Team

Credit card transactions feeding into wrong QB account

Hi there, RoziPozi. 

 

Thank you for getting back to us here in the Community. The reason you encouter this error it because there is duplicate transaction on it.. Let's go ahead and locate the duplicate transactions. 

 

  1. Click Transactions.
  2. Press the Banking tab, and click the account where the entries are uploaded.
  3. Go to the For Review column.
  4. Locate the transactions you want to delete.
  5. Select Exclude.

That way, you'll be able to unmatch the transaction. You can read through this article about the unmatching downloaded transaction in QuickBooks Online: Unmatch downloaded bank transactions or move them to another account

 

However, if you getting the same error, I suggest reaching out to our customer support team. This way, one of our agents can pull up your account and help you assess the error you've encountered. You can refer to this article on how to contact our support team: Contact support

 

Please don't hesitate to reach back to me if there's anything else you need. I'm just a post away. Stay safe!

mmb3
Level 2

Credit card transactions feeding into wrong QB account

I have a Bank of America card, where the payments are in one account ("Corp" account) and the charges in the other.  Because of this, there are two feeds to capture all card transactions.  In Banking, I have "credit card charges" and "credit card payments".  I have these feeding 2 general ledger accounts, with the same names (BofA charges and BofA payments).  In the chart of accounts, I created a parent credit card account and made the payment and charges sub accounts of the parent.  This enables me to reconcile the parent account in the reconciliation function because you only get one combined monthly statement.  Worked fine and I didn't have to do any song and dance with the bank feeds.

Need to get in touch?

Contact us