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

Disconnected credit card in error

I have a client with a credit card that had gotten hacked so the bank replaced it.  Because the account no longer exists on the banks side, I disconnected it so we would not continue seeing the connection error message.  I did not realize that everything would be gone on the banking side once this was done.

 

The account has not been completely reconciled so how do I get all of those transactions back in order to do the monthly reconciliations?

 

Thank you.

1 Comment 1
MaryLandT
Moderator

Disconnected credit card in error

I'm here to provide the instruction on how to bring in your bank transactions, bookkeeping61.

 

You need to download transactions from the old credit card account. If you no longer have access to it, you can contact the bank provider and ask them for a copy of your bank statements.

 

Once you have those bank statements, you can manually upload them to QuickBooks. Just make sure the file is in CSV format to prevent errors during the upload.

 

Here's how to import bank transactions:

 

  1. In QuickBooks Online, go to the Banking menu.
  2. Click the Link account ▼ drop-down and then Upload from file.
  3. Select Browse and click the file you downloaded from your bank, then select Next.
  4. In the QuickBooks account ▼  drop-down, select the account you want to upload the transactions into, then Next.
  5. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks, then Next
  6. Select the transactions you would like to import, then Next.
  7. Click Yes.
  8. When you're ready, select Let's go.
     

Now that your transactions are in QuickBooks, it's time to match and categorize them. The transactions go into your accounts after you review them.

 

Moving forward, make sure to review transactions on the Banking page and add them in QuickBooks before disconnecting the account. Doing this ensures all transactions are posted on your register and that you don't have to worry about uploading them.

 

After putting bank transactions in QuickBooks, your final step is to reconcile them. This ensures your books are accurate and there aren't any duplicate transactions.

 

Stay in touch with me if you need additional information about getting your bank transactions into QuickBooks. I'm always around to help you.

Need to get in touch?

Contact us