Transfer Payment from Checking to Credit Card

Hello there, @stuety.

I acknowledge the importance of resolving this issue regarding messed up QuickBooks balances. Let me share some details on how to fix this matter. Before anything else, I would like to ask for further information about how you processed the transfer transactions. This will help me roll out a satisfactory resolution.

To address and fix the problem, you will have to work on reconciling each account separately. Also, we need to clarify where the funds come from. We need to categorize these properly to avoid getting any duplicate transactions. If you've used online banking to transfer these, we can undo and exclude the same transactions to prevent duplicates. If your entry was added manually, you have to match it to the transaction from the online banking.

Furthermore, you can undo the reconciled transactions and categorize the transactions correctly. To do so, you can follow these steps:

1. Go to Transactions, then Bank Transactions. 
2. Select the bank account you want to review. 
3. Select the For Review tab to check. 

You can check this article to learn how to categorize your transactions properly: Categorize online bank transactions in QuickBooks Online.

Moreover, you can visit this article to learn how to use bank rules since it will automatically categorize transactions for you: Set up bank rules to categorize online banking transactions in QuickBooks Online.

You can always get back to us if you have further questions about your concern. We're always glad to assist you.

thank you for your response.  The original transaction was done through online banking (not manually). 

so the first step would be to go through and find each transaction and change it from "reconciled" to "unreconciled"?  then they would show up in my bank transactions again, right?  next step would be to classify the correct transaction to the correct bank account (ie. checking instead of undeposited?)  then what do I do with the duplicates? 

Thanks for the clarification, @stuety. Let me share some additional information about your concern.

You're on the right track. Since the transactions were done via online banking, we need to unreconcile them first to make them appear on your bank transactions list. Then, we'll categorize them correctly. After unreconciling, you'll need to undo the transactions to avoid duplicates and match them accurately. Once this process is done, rest assured that the duplicates will no longer appear.

To prevent any duplicate entries in the future, it's advisable to choose the Match instead of selecting Add option. When you choose Match, the system will automatically look for existing records and notify you if a match is found. This way, you can decide whether to add the new entry. Following this method can ensure data accuracy and save time in the long run.

Afterward, we can reconcile them with the correct categorization and classify the accurate transactions to the proper bank account so they won't appear on the Undeposited Funds register. 

To prevent any unnecessary changes in your books, you can visit this article in the future: Close your books in QuickBooks Online.

If you have further questions, you can always get back to us by replying to this post. We're always here to assist you.

can I unreconcile them just by going to the line item in the register and changing it from R to blank?  and should I do that for both the credit card register and checking account register?

it looks like QB is automatically matching money when it comes in and putting it directly to undeposited funds. but I dont have any deposits listed when I go to +new/bank deposit. should that be happening?

thank you

Hello there, @stuety.

I'll help you undo the reconciliation of a transaction by just changing the status from R to C or blank in QuickBooks Online.

Yes, you can unreconcile a transaction from 2019 in QuickBooks Online (QBO). 

To do this, follow these steps:

1. Navigate to the Accounting or Transactions tab in QuickBooks Online.
2. Select Chart of Accounts and locate the account where the reconciled transaction is recorded.
3. Click on the account to open the register.
4. Locate the reconciled transaction from 2019 that you want to unreconcile.
5. Change the status of the transaction from R (reconciled) to blank or C (cleared). This action will mark the transaction as unreconciled.
6. Save the changes, and the transaction will now be unreconciled.

By following these steps, you can unreconcile a transaction from 2019 in QuickBooks Online, allowing you to make adjustments to the reconciliation status as needed.

Before you proceed with unreconciling in QuickBooks Online, I recommend reaching out an accountant, as this can get tricky, and they know how to handle the next steps. If you don't have one, click this link: Find an accountant.

Moreover, I'm adding this article to guide you with other fixes for any reconciliation errors: Undo or remove transactions from reconciliations in QuickBooks Online. 

Don't hesitate to click the Reply button below if you have questions about unreconciling an account in QuickBooks Online. I'm always here to help. Have a great day.

Ive unreconciled the 17 items in my credit card register. So i have duplicates in this account that appear as a line item with the transfer categorized as undeposited funds (this came from the bank feed) and the second item categorized as checking. both unreconciled. 

then when i go to my bank transactions and i try to undo it (there's only one and its the one that's categorized as undeposited funds from the bank feed), the other one is not listed.  it gives me an error that says, its already been deposited and if i want to  change it, i need to edit the deposit.

i can also see the duplicates in my checking register, 1 is a lump sum (totaling the 17) and the others are listed separately. those are also unreconciled.  

is it possible to delete the ones that came from the bank feed (that say undeposited funds) and then reconcile the ones that are categorized to the checking?  

Hi, @stuety. 

I appreciate what you've done so far.  Let me clarify any confusion here and help you sort these duplicate transactions.

Yes, we can delete transactions from the bank feeds and reconcile them once categorized and reviewed. We just need to make sure to undo the reconciliation first, and then the categorized transactions.

Here's how to undo the categorized transactions: 

1. Click Bank transactions, then look for your account.
2. Choose on the Categorized column.
3. Select the item/transaction, then tap on Undo under Action.

You can match the bank transactions, otherwise you'll want to exclude them. After that, please follow the guide below on how to reconcile again:

1. In the left panel, click Transaction, then Bank transactions. 
2. Select the View register, and review transactions. 
3. Once done, hit Reconcile. 

Furthermore, you can also check this article so you'll know what to do in case QBO doesn't match your bank statement at the end of a reconciliation: fix issues at the end of a reconciliation in QuickBooks Online.

Please go back to this thread for any reconciliation and QuickBooks-related concerns. We're here to help, 24/7. Take care.