cancel
Showing results for 
Search instead for 
Did you mean: 
Fairway LC
Level 2

Reconciling my bank account and I have a handful of customer credit card payments through QBO that are shown as never deposited to my checking account?

Account Reconciles fine every month. Says these will reconcile once "transactions settle" but these are going back months?
4 Comments 4
IamjuViel
QuickBooks Team

Reconciling my bank account and I have a handful of customer credit card payments through QBO that are shown as never deposited to my checking account?

Hello there, @Fairway LC.

 

You'd want to make sure to deposit the credit card payments to the correct bank account. Let me walk you through transferring your funds from the Undeposited Funds account to your desired bank account.

 

  1. Click on the +New button.
  2. Select Bank Deposit.
  3. From the Account drop-down, select the bank account.
  4. Mark the transactions you want to transfer from the Select the payments included in this deposit section. 
  5. Review the transaction details.
  6. Select Save and Close.

Now, you can review and categorize them with the downloaded transactions. Once completed, you can reconcile your account to make sure they match your real-life bank statements. Just go to the Accounting menu and select Reconcile.

 

Keep me posted if you have other questions about tracking your customer's credit card payments. I'm always here to help.

IamjuViel
QuickBooks Team

Reconciling my bank account and I have a handful of customer credit card payments through QBO that are shown as never deposited to my checking account?

Just dropping by to check on you, @Fairway LC.

 

Making sure you're able to reconcile your bank account is my priority. That being said, were you able to deposit your customers' credit card payments using the steps I've shared?

 

Always feel free to visit us here if you have other questions and concerns about managing your accounts. I'm always here to lend a hand.

 

Fairway LC
Level 2

Reconciling my bank account and I have a handful of customer credit card payments through QBO that are shown as never deposited to my checking account?

Hmmm... After looking they have been deposited within my books into my business checking account however they can't be reconciled. They're left over at the end of every reconcile session. My books balance except for these payments. All of these payments were made via the online interface. I can only assume they either didn't deposit to my checking account or there's a duplicate within my books? Thank you for your help. 

DivinaMercy_N
Moderator

Reconciling my bank account and I have a handful of customer credit card payments through QBO that are shown as never deposited to my checking account?

Finding the cause of incorrect balances is my specialty, @Fairway LC. I'm here with some instructions to track it down!

 

To start, let's check if there are duplicate transactions. To do so, you can use the Filter tool to locate them quickly:

 

  1. Go to the bank account where the issue is occurring. Select the Gear icon and choose Chart of Accounts then, View Register.
  2. From the Bank Register, tap the Filter menu to open it.  duplicate1.JPG
  3. Click either the Payment or Deposit column to sort the list by their Amounts. They'll automatically be sub-sorted by their Date.
  4. Look for duplicates Amounts/Dates and delete or exclude them. 

 

For more details, please visit this link: Search for transactions

 

You can also find duplicates by the use of your bank statement. You only need to cross-match the Bank statement with the Bank Register in QBO to determine if there are duplicates. 

 

If you need further assistance with the process, I suggest contacting your accountant. They can share steps on how to find those duplicate transactions. If you don't have one, you can utilize our Find an Accountant tool. 

 

When done, follow along below to remove those duplicates. 

 

  1. Navigate to the Banking/Transaction menu.
  2. On the Banking page, click the For Review tab.
  3. Select the checkboxes of the transactions to exclude.
  4. From the Batch actions drop-down, choose Excludeduplicate3.JPG

 

Then, to guide you in matching your bank balance with those recorded in QuickBooks, head to our Reconciliation hub at this link. 

 

Should you need anything else, don't hesitate to comment below if you have further concerns in reconciling your account in QuickBooks. I'm always around to help. Stay safe and take care always.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us