Skip to main content
December 30, 2021
Solved

Bank Error on Check Amount - Can't Match

  • December 30, 2021
  • 1 reply
  • 0 views

Good Afternoon,

 

I wrote out a check for $1,000.00, but the bank mistakenly logged the check in as $1,800.00.  When notified, they created a adjustment credit in the amount of -$800.00.  How do I make the $1,800.00 and credit of -$800.00 match up to my $1,000.00 check?  Any help would be greatly appreciated.  Thanks, Lisa

Best answer by Archie_B

Thank you for posting in the Community, LisaMac1.

 

I'd like to share some information about bank feeds in QuickBooks Online.

 

In QuickBooks Online, you can only match one bank transaction with a QuickBooks entry.

 

That said, to keep your books accurate, you can exclude the two banking transactions and manually record the check then add a line item with the negative amount for the credit.

 

To exclude a transaction:

 

  1. Go to Banking menu or Transactions menu.
  2. Choose the For Review tab.
  3. Select the checkbox of the transactions to exclude.
  4. Click on Exclude.

I'm adding this article for more information about handling bank transactions: Categorize and match online bank transactions in QuickBooks Online.

 

I'd also recommend consulting an accountant for the best way to handle those transactions. Looking for an accountant? Here's a link that you can use to find one.

 

Feel free to post or click the Reply button for any follow up questions about banking. I'll be happy to help. Have a wonderful day!

1 reply

Archie_BAnswer
December 31, 2021

Thank you for posting in the Community, LisaMac1.

 

I'd like to share some information about bank feeds in QuickBooks Online.

 

In QuickBooks Online, you can only match one bank transaction with a QuickBooks entry.

 

That said, to keep your books accurate, you can exclude the two banking transactions and manually record the check then add a line item with the negative amount for the credit.

 

To exclude a transaction:

 

  1. Go to Banking menu or Transactions menu.
  2. Choose the For Review tab.
  3. Select the checkbox of the transactions to exclude.
  4. Click on Exclude.

I'm adding this article for more information about handling bank transactions: Categorize and match online bank transactions in QuickBooks Online.

 

I'd also recommend consulting an accountant for the best way to handle those transactions. Looking for an accountant? Here's a link that you can use to find one.

 

Feel free to post or click the Reply button for any follow up questions about banking. I'll be happy to help. Have a wonderful day!

LisaMac1Author
January 3, 2022

Thanks for your help!  I just assumed that every check I create needs to have an online bank match.  I just modified the check I already created in the amount of $1,000.00 to $1,800.00 and then created another line item amount of a -$800.00, so the check amount still equates to $1,000.00.  Thanks again and Happy New Year!

 

Lisa

MonicaM3
January 3, 2022

Hi @LisaMac1.

 

Thanks for circling back to let us know it all worked out. Please feel free to drop into the Community any time we can be of help. 

 

Getting ready to close your books for the year? Check out our year-end resource page!

 

Happy New Year