Skip to main content
M
misscapo
January 31, 2022
Question

Matching bank transactions with Invoices Paid via QuickBooks Payments

  • January 31, 2022
  • 1 reply
  • 0 views

I'm having an issue with all the invoices that are paid by the customer via Quickbooks payments.   Since the customer pays online, the Invoice is naturally marked as "PAID" and no longer has a balance. 

 

Then, the transaction (income) shows up in my Banking transactions for Review.  The problem is that I don't have an invoice to match it to, since the invoice has already been paid.  I also tried looking for a Deposit to match it to, but nothing comes up.  

 

If I just categorize the bank transaction as SALES, then I have duplicate income in my P&L (once from the payment received in the invoice and one from the bank transaction).  

 

How can I match these bank transactions to the respective invoices if they've already been paid?  PLEASE HELP! 

1 reply

Jessica_young
Jessica_young
January 31, 2022

Good afternoon, @misscapo.

In QuickBooks Online, you'll need to ensure that the invoice payments and deposit have the same date or details so they will be matched. 

 

To ensure these invoices will be on the list, confirm that the transactions:

  • Hasn't been reconciled.
  • Was entered using the same bank account.
  • Wasn't matched to another downloaded transaction.

Also, since the invoice is already on a Paid status, I recommend checking the bank account you use for the transactions. Run the Transactions List by Customer report to locate the invoices and their payments.

 

You can open the invoice from the report to check the payment and the bank account used.

 

For additional insights, you can check out these articles: 

Let me know if you have more questions on this! I'm around to help.

 

M
misscapoAuthor
January 31, 2022

THANK YOU!!! This worked, the solution was to change the Account from "Quickbooks Checking Account" to the correct Bank Account. 

 

Is there a way to default all future payments to my bank account?  

 

Thanks again!

C
Carneil_C
January 31, 2022

Thanks for getting back to us in Community, @misscapo. Allow me to share some details about on how to default future payments into your bank account in QBO.

 

In QuickBooks Online, the option to default future payments to a bank account is currently unavailable. What it can do is remember the bank account of your previous transactions.

 

Additionally, I've also included this helpful article that'll guide you on how you can add an account: Connect bank and credit card accounts to QuickBooks Online.

 

Lastly, I've got you this helpful article that'll guide you in categorizing your bank transactions: Download, match, and categorize your bank transactions in QuickBooks Online.

 

Please feel free to get in touch with me here for any additional questions about managing your transactions in QBO. The QuickBooks Community always has your back. Have a great day! 

Terms & ConditionsAccessibility statement