cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
grsingh
Level 2

Issue Reconciling - Paid Invoices are showing up in my reconcile window as PAYMENTS

Hi, I am struggling to find a solution to this problem. In my reconcile window, I have several invoices showing up as PAYMENTS. Some of these invoices have been paid by the client through quickbooks online payment and some have been received manually. Deposits are made as a lump sum which show up in the reconcile window as well as my bank statement. In the reconcile window, the invoices show up as payments as well as the lump sum deposits. 

 

Why are individual invoices showing up in the reconcile window if they have been already paid, matched and linked to a deposit? The invoices are showing up as payments and as an Accounts Receivable. It would make sense that only the deposits show up in the reconcile window and NOT the individual invoices. Any help would be much appreciated. I have called QBO support 5 times and was hung up on all 5 times. Support has not been great :(Screen Shot 2021-04-20 at 6.09.37 PM.png

17 Comments 17
MariaSoledadG
QuickBooks Team

Issue Reconciling - Paid Invoices are showing up in my reconcile window as PAYMENTS

I wish I could make it better, but let me share with you a few information about transactions that are showing on the reconcile page, grsingh.

 

You'll have to make sure that you have linked the deposit to the correct invoice so both transactions won't show up on the reconciliation window. To do this you can drill down the transactions one by one. Then, you'll also want to sort them by clicking the Payment and Deposit column so you can easily distinguish which transactions aren't linked to deposit. I've attached a screenshot for your visual guide:

 

Also, make sure that you've filtered the correct Reset Statement ending date to ensure that you're reconciling the correct period. 

Please read this article for more information: Fix issues the first time you reconcile an account in QuickBooks Online.

 

For your reference, you'll want to generate a copy of your reconciliation report: How do I view, print, or export a reconciliation report?

 

Please touch base with us if there's anything else that you need help with about reconciliation. We're always right here to assist you further anytime. 

grsingh
Level 2

Issue Reconciling - Paid Invoices are showing up in my reconcile window as PAYMENTS

All of the invoices are linked to an invoice. Invoices shows payment ID since payment was collected through QBO online payment. Still the problem persists. 


Is there any other way to correct this issue? Everything seems to have been done correctly so it seems like a technical issue? Please advise. 

ShiellaGraceA
QuickBooks Team

Issue Reconciling - Paid Invoices are showing up in my reconcile window as PAYMENTS

Thanks for getting back to us here, @grsingh.

 

I understand how the payment should post for you to reconcile smoothly. With this, I recommend contacting our Customer Care Support. They have the tools that can check your account and assist you further with the posting.

 

Here's how to reach out:

 

  1. Go to Help at the top.
  2. Scroll down and select Get help from a human.
  3. Choose Callback.

 

Check out this article to learn more about our QuickBooks Payments FAQ

 

In case you need help with other payment tasks, click this link here to go to our general topic with articles. Look for responses that fit your concern.

 

I'll be around for you if you have any other questions about payments. Take care and have a great weekend ahead.

grsingh
Level 2

Issue Reconciling - Paid Invoices are showing up in my reconcile window as PAYMENTS

I have tried speaking with QBO support staff on 5 different occasions. All 5 times I was hung up on abruptly when the strategy the individual tried to resolve the issue failed. Every rep I have spoken with has not been able to help and when they realize that, they have hung up on me. I asked to speak with a manager during my 6th call and I was told I would receive a call back. I received no call back so I am quite literally at a loss of options. I don't know how to reconcile my books and solve this issue. The only option I have left at this point is to choose a different accounting software and transfer my books over to another app. 

AlexV
QuickBooks Team

Issue Reconciling - Paid Invoices are showing up in my reconcile window as PAYMENTS

Hi grsingh!

 

I know that you need to reconcile your account. I'm here to help you.

 

QuickBooks Payments automatically creates a deposit transaction for you. The most possible reason why the paid invoices, as well as the lump sum deposits, are showing when reconciling is that they aren't linked. I suggest you edit the deposit so you can link it to the invoice. Check the detailed steps here: How to link a deposit to an invoice.

 

I've added a link for more info about QuickBooks Payment reconciliation issues: Fix QuickBooks Payment deposits that don't match your bank statement.

 

Also, I'll take note of your experience with our Support Team so we can improve our service. 

 

In addition, you may want to visit our FAQs page for more details on how to manage your QuickBooks Payments account and transactions.

 

I'll be here if you need anything else. Take care!

Operrra
Level 2

Issue Reconciling - Paid Invoices are showing up in my reconcile window as PAYMENTS

What is the ACTUAL solution to this problem? I am attempting to reconcile and I received payment via Quickbooks Payments. The payment was applied to the invoice. I have followed the directions above, but they do not work. I still have the payment showing up as a deposit AND a payment out of my bank account. 

 

I need to be able to reconcile. Anytime I have called a support tech in the past, I have sat on the phone while they read all the forum threads that I have already read.

 

I need to be able to reconcile. Please provide a solution. I will not be using Quickbooks pay for invoices any longer if the system automatically does this. 

MirriamM
Moderator

Issue Reconciling - Paid Invoices are showing up in my reconcile window as PAYMENTS

Hello there, @Operrra.

 

I want to ensure you're able to reconcile your account in QuickBooks Online (QBO).

 

In QBO, once you connect your bank account, you can match the downloaded transaction to the invoice payment. By doing this, QuickBooks connects the two, so there are no duplicates. 

 

To do this, here's how:

  1. In the left menu, click Transaction.
  2. Go to the Banking tab.
  3. Select the tile for the account you want to review.
  4. Navigate to the For Review tab to start your review.
  5. Select the deposit to expand the view.
  6. Choose Find match.
  7. You can use filters/search to locate transactions. 
  8. Select the matched transaction.
  9. Click Save.

 

After that, you can continue reconciling your books. You can use this article for guidance: Reconcile an account in QuickBooks Online.

 

Here are also some resources that will help you in managing your bank feeds:

 

Please leave a comment below if you have any additional concerns. I want to make sure everything is taken care of for you. I'll be here to help. Have a wonderful day!

Operrra
Level 2

Issue Reconciling - Paid Invoices are showing up in my reconcile window as PAYMENTS

My bank account IS connected. That's why I don't understand. I matched the payment in my "banking" review window and thought everything was great. Then, when I decide to reconcile not only do I have what I think is a matched invoice, I ALSO have a $1700 PAYMENT that is being debited from MY account. Make it make sense, please. 

Maybelle_S
QuickBooks Team

Issue Reconciling - Paid Invoices are showing up in my reconcile window as PAYMENTS

I want to ensure this is taken care of, @Operrra.

 

To fix this, I'd recommend geeting in touch with our Customer Suport Team. This way, they can pull up your account in a secure environment and help check the cause of the issue.

 

Here's how:

 

1. Go to Help at the top.

2. Scroll down and select Get help from a human.

3. Choose Callback.

 

In case you need help with other payment tasks, click this link here to go to our general topic with articles. Look for responses that fit your concern.

 

Please know that you can always get back to us if you have other questions. I'm always here to help.

smnbly
Level 1

Issue Reconciling - Paid Invoices are showing up in my reconcile window as PAYMENTS

We had exactly the same problem and eventually found the solution under the "products and services" item you use on the invoice.  We discovered that you have to make sure they are allocated to the correct income account and NOT your bank account as the income account. We changed it to services in this case and this removed all the invoices from showing in the reconcile window as a payment.  Hopefully the picture below will make  sense.Quickbooks.jpg

fhstcdctsues
Level 1

Issue Reconciling - Paid Invoices are showing up in my reconcile window as PAYMENTS

YES! So thankful someone was finally able to figure out the answer to this!

rosemaboot6988-g
Level 1

Issue Reconciling - Paid Invoices are showing up in my reconcile window as PAYMENTS

I have the same issue. How to fix it?

rosemaboot6988-g
Level 1

Issue Reconciling - Paid Invoices are showing up in my reconcile window as PAYMENTS

My income account in the product and services is correct but still, all the invoices show up in the reconciling window and not only the deposit amount. Please help how to fix it.

FritzF
Moderator

Issue Reconciling - Paid Invoices are showing up in my reconcile window as PAYMENTS

Hello, rosemaboot6988-g.

 

Thanks for joining this conversation. Allow me to jump in and help ensure this is taken care of for you.

 

If you already followed the steps shared by my colleagues in this thread and the issue persists, I highly suggest contacting our Support team. They have tools such as screen-sharing (remote access) that can pull up your account in a secure environment and check the cause of this odd behavior. They can also perform other troubleshooting steps if necessary.

 

Here's how to reach them:

 

  1. In QuickBooks Online (QBO), go to the Help (question mark) icon at the top right.
  2. Select Contact Us.
  3. Enter your concern, then click Let's talk.
  4. Choose a way to connect with us.

 

To learn more about fixing reconciling issues in QBO, consider checking out this article: Fix issues the first time you reconcile an account in QuickBooks Online.

 

I also recommend visiting our website for more tips and other resources you can use in the future: Self-help articles.

 

Please post again or leave a comment below if you have additional questions about this or anything else. I'm always here ready to help. Take care.

Ktaxlady
Level 1

Issue Reconciling - Paid Invoices are showing up in my reconcile window as PAYMENTS

This is the answer, thank you!!

CharlieC92
Level 1

Issue Reconciling - Paid Invoices are showing up in my reconcile window as PAYMENTS

Thank you SO much. This saved me from the brink of insanity. Really appreciate it.

ElmwoodBookkeepers
Level 1

Issue Reconciling - Paid Invoices are showing up in my reconcile window as PAYMENTS

Thank you so much for helping