Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
Andrew142
Level 2

Made a HUGE mess with my credit card in QBO and cannot figure out how to correct it.

I added the company credit card to QBO to see the transactions and to categorize them. The card stopped updating in QBO so I tried to make it inactive and put it in QBO again so it would update.

When I made the original credit card inactive, I believe QBO carried the balance to the new card as the opening balance. I did not realize this and reconciled the new card account in QBO from the very beginning. This caused QBO to show duplicate transactions for my credit card.  I zeroed out the duplicate transactions, but that did not solve my problem. 

 

The balance for the card account in QBO is now different than my actual balance on the card. I tried to look at the opening balance, but I believe I may have deleted it trying to correct it.

At this point, I cannot get the card to reconcile, cannot get the balance to match, cannot find the opening balance, cannot find the journal entry (if there is one) and have made a huge mess with the credit card.

What is the best way to correct this issue?

Thank you

2 Comments 2
Tori B
QuickBooks Team

Made a HUGE mess with my credit card in QBO and cannot figure out how to correct it.

Good afternoon, @Andrew142.

 

How are you today? I hope all is well. 

 

If you have an accountant user, I recommend having them undo the previous reconciliations. Once that's been completed, you'll need to verify that the opening balance is correct and check that all transactions have been imported. This is important because QuickBooks Online will only import the last 90 days of transactions. Any older transactions will need to be manually imported. 

 

Here are a few help guides with the steps to undo the reconciliation and manually import transactions:

 

 

Please keep in mind that your accountant will need to have a QuickBooks Online Accountant subscription to undo a reconciliation. If you don't have an accountant, don't sweat it. You can find one here in our Resource Center

 

Don't hesitate to let me know if you have any additional questions or concerns. I'm always happy to lend a hand. Have a good one! 

 

 

Briggs Bookkeeping 1
Level 1

Made a HUGE mess with my credit card in QBO and cannot figure out how to correct it.

Hi,

 

Go to your last reconciliation report and see what changed.  This will let you know what changed.  Fix those changes by adding those charges back.  Look at your credit card statement and the Quickbooks reconciliation report to determine what changed.

Now your credit card register should only have uncleared transactions that are duplicates if they are older than the last reconciliation date.  Look at your credit card register and sort by the uncleared transactions and confirm if these are duplicates that you can void.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us