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.
LorindaM
Level 1

Matching up a split bank payment to my sales tax payment

I completed the Sales Tax payment in the Sales TaxCenter of QuickBooks Online, but when I went to make my payment online with the agency I accidentally shorted my payment. This caused me to have to make another payment to get me to a zero balance. When I go to match my two bank transactions to the Sales Tax payment (from the center) QuickBooks Online does not find the match. How can I match these two transactions to my Sales Tax payment?

Solved
Best answer October 19, 2023

Best Answers
GebelAlainaM
QuickBooks Team

Matching up a split bank payment to my sales tax payment

Hello there, @LorindaM. Thank you for sharing your concern about matching transactions in QuickBooks. We're happy to provide details on how we can get this fixed.

 

We understand the importance of keeping track of bank and QuickBooks transactions flawlessly in our program. In your case, I'd suggest you exclude transactions from the banking page since the option to match multiple transactions to a single sales tax payment already in QuickBooks is unavailable. Doing this will help avoid duplicates.

 

Here's how:

 

  1. Go to the Banking page and select a Bank account.
  2. From the For Review tab.
  3. Tick the checkbox of the transactions to exclude.
  4. Then select Exclude.

 

You can review the excluded transaction on the Excluded tab of the Banking page. You can always select Undo if you accidentally exclude the wrong transaction. To learn more, refer to this article: Exclude a bank transaction you downloaded into QuickBooks Online.

Afterwards, you can go to your account register to manually clear the transaction so don't have issue with this transaction when your reconcile your account. Let me guide you how.

  1. Click the Gear icon and choose Chart of Accounts.
  2. Look for the account where the transaction is allocated. Then, select View register.
  3. Select the transaction to expand the view.
  4. Under the check column, continuously click the box until you see C (cleared).
  5. Then, select Save.

 

In case you would like to reconcile your account, here are a few additional articles to help you accomplish a successful reconciliation:

 

 

You can always drop your queries in the Community. We'll always be here to assist you. Take care always, and have a good one, @LorindaM!

View solution in original post

3 Comments 3
GebelAlainaM
QuickBooks Team

Matching up a split bank payment to my sales tax payment

Hello there, @LorindaM. Thank you for sharing your concern about matching transactions in QuickBooks. We're happy to provide details on how we can get this fixed.

 

We understand the importance of keeping track of bank and QuickBooks transactions flawlessly in our program. In your case, I'd suggest you exclude transactions from the banking page since the option to match multiple transactions to a single sales tax payment already in QuickBooks is unavailable. Doing this will help avoid duplicates.

 

Here's how:

 

  1. Go to the Banking page and select a Bank account.
  2. From the For Review tab.
  3. Tick the checkbox of the transactions to exclude.
  4. Then select Exclude.

 

You can review the excluded transaction on the Excluded tab of the Banking page. You can always select Undo if you accidentally exclude the wrong transaction. To learn more, refer to this article: Exclude a bank transaction you downloaded into QuickBooks Online.

Afterwards, you can go to your account register to manually clear the transaction so don't have issue with this transaction when your reconcile your account. Let me guide you how.

  1. Click the Gear icon and choose Chart of Accounts.
  2. Look for the account where the transaction is allocated. Then, select View register.
  3. Select the transaction to expand the view.
  4. Under the check column, continuously click the box until you see C (cleared).
  5. Then, select Save.

 

In case you would like to reconcile your account, here are a few additional articles to help you accomplish a successful reconciliation:

 

 

You can always drop your queries in the Community. We'll always be here to assist you. Take care always, and have a good one, @LorindaM!

LorindaM
Level 1

Matching up a split bank payment to my sales tax payment

Thank you @GebelAlainaM ! I will exclude it from my bank transactions. 

JaeAnnC
QuickBooks Team

Matching up a split bank payment to my sales tax payment

Thanks for getting back to us, @LorindaM.
 

We're happy that the resolution shared by my colleague was able to help you with your concern. Please don't hesitate to post in the Community whenever you need additional assistance with QuickBooks Online (QBO). We're always here to help.
 

Stay safe and have a wonderful day ahead!

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

Need to get in touch?

Contact us