cancel
Showing results for 
Search instead for 
Did you mean: 
tiffanyh72
Level 1

Bank cleraed the wrong amount for a check. How do I fix this?

Hi,

I was adding bank transactions and one came in that is 10 cents more than what I wrote the check out to be. I wrote the check out for 10,312.27 and the bank cleared it for 10,312.37. Ugh!

I have not "added" because it does not match anything. How do I fix this? The check I wrote was to pay for two bills so it is a split check. 

Thank you for any help and guidance!

Solved
Best answer February 19, 2022

Best Answers
AileneA
Moderator

Bank cleraed the wrong amount for a check. How do I fix this?

Hello, tiffanyh72.  

 

QuickBooks Online is dependent on the transactions on your bank account. That said, to correct an improperly recorded bank transaction in QuickBooks by editing the bank account in your Chart of Accounts. 

 

Here's how: 

 

  1. From the Accounting menu, select Chart of Accounts.
  2. Choose the account where the check is incorrectly posted and click View register.
  3. Tap the check and select Edit.
  4. To edit the transaction amount, highlight the existing amount and type the new amount into the input box.
  5. Hit Save and close.

 

Right after, match the manually added entry to the downloaded one. Once done, you can start the reconciliation process. See Reconcile an account in QuickBooks Online for reference.  

 

Keep me posted if you have other concerns or questions reconciling your account. I’m more than happy to work with you again. Stay safe.

View solution in original post

13 Comments 13
AileneA
Moderator

Bank cleraed the wrong amount for a check. How do I fix this?

Hello, tiffanyh72.  

 

QuickBooks Online is dependent on the transactions on your bank account. That said, to correct an improperly recorded bank transaction in QuickBooks by editing the bank account in your Chart of Accounts. 

 

Here's how: 

 

  1. From the Accounting menu, select Chart of Accounts.
  2. Choose the account where the check is incorrectly posted and click View register.
  3. Tap the check and select Edit.
  4. To edit the transaction amount, highlight the existing amount and type the new amount into the input box.
  5. Hit Save and close.

 

Right after, match the manually added entry to the downloaded one. Once done, you can start the reconciliation process. See Reconcile an account in QuickBooks Online for reference.  

 

Keep me posted if you have other concerns or questions reconciling your account. I’m more than happy to work with you again. Stay safe.

tiffanyh72
Level 1

Bank cleraed the wrong amount for a check. How do I fix this?

Thank you!

Nathan-K
Level 2

Bank cleraed the wrong amount for a check. How do I fix this?

If you are reconciling to your bank statement, won't your reconciliation then be off?

DebSheenD
QuickBooks Team

Bank cleraed the wrong amount for a check. How do I fix this?

Hello, Nathan-K.

 

I'm glad to see you dropping by here in the Community. I can provide information reconciliation process in QuickBooks Online (QBO).

 

Once you cleared the bank statement, the reconciliation for that month is still there. You can still undo the reconciled transactions if there are discrepancies. 

 

Here's how:

 

  1. Go to the Bookkeeping or Accounting menu and select Chart of Accounts.
  2. Find the account and then click View register.
  3. Select the transaction you want to unreconcile.
  4. Review the check () column. If the transaction is reconciled, you’ll see an R.
  5. Choose the box until it's blank.
  6. Once done, tap on Save.
  7. Click Yes on the prompt message.


Additionally, I've included our reconciliation guide for reference. This article helps you ensure your QuickBooks accounts match your real-life bank statements.

Once done reconciling, you can also print your reconciliation report. This way, you'll have a handy copy of your data for future use.

 

Please know that I'm just a post away if you need more assistance about reconciliation. Take care.   

Mindy271
Level 1

Bank cleraed the wrong amount for a check. How do I fix this?

What if the bank did it for under the amount?  $1,045.37 is the correct check amount but bank put $1,015.37.  how do you reconcile that?

MariaSoledadG
QuickBooks Team

Bank cleraed the wrong amount for a check. How do I fix this?

Let me guide you on how you'll be able to reconcile the two different amounts, Mindy271.

 

There are times you may need to review your transactions and make some quick edits. If this is so, you can do it right from an account register. To do this, follow the steps below:

 

  1. Find and select the transaction in the account register to expand the view.
  2. Make changes to the available fields.
  3. If you want to change something in the grayed-out sections, select Edit. This opens the full transaction form where you can make additional changes.
  4. When you're ready, select Save or Save and close.

 

Furthermore, QuickBooks offers several reports that cater to your business. You'll just have to customize them to make sure you get the information you need most. Attached is an article that will clearly explain how you can customize a report: Customize Reports In QuickBooks Online.

 

You can always drop a reply below if you think there are questions that are in your mind. Remember, we're always right here to help.

edojnia
Level 1

Bank cleraed the wrong amount for a check. How do I fix this?

I have the same issue but it is with a payroll check and its not allowing me to edit the check register. When I click edit it takes me to my payroll check list and that does not allow you to edit it. All though the check list is correct its the posting amount that is not. I also can not "find match" because it cleared for more than I wrote it. How is this fixed? 

Tori B
QuickBooks Team

Bank cleraed the wrong amount for a check. How do I fix this?

Hi there, @edojnia.

 

Thanks for following the thread and sharing your concerns. 

 

I recommend editing the check to make the necessary corrections. This way, your books can balance. Please know you can only edit paychecks if you haven’t sent your payroll to us yet.

 

Here's how you can edit: 

 

  1. Go to Payroll, then Employees.
  2. Select Paycheck list.
  3. Choose the paycheck(s) you'd like to delete or void, then click on Edit.
  4. Hit Yes.

If you are unable to make the change, you'll see a message explaining why. You'll need to contact support for help with the paycheck.

 

For additional details about this process, check out Edit, delete, or void employee paychecks

 

Please let me know if you have any questions or concerns. I'm always here to lend a hand. Take care! 

Patty8791
Level 1

Bank cleraed the wrong amount for a check. How do I fix this?

I have the same issue with a Payroll Check, the bank cleared the check for .60 cents less. How I can fix that? The check is already cleared and is a payroll check I can't edit it, but my reconciliation is with a .60 cents difference and I can't continue

 

Nicole_N
QuickBooks Team

Bank cleraed the wrong amount for a check. How do I fix this?

I'm here to help you fix the .60 cents difference when reconciling accounts in QuickBooks Online, Patty8791.

 

You can record an expense of .60 cents on the same date as your bank statement. Afterward, manually enter this expense in the bank register as a check. Here's how:
 

  1. Open your QBO account.
  2. Go to the Transactions page.
  3. Click the Go to bank register button.
  4. At the very top of the list, select the Add journal entry, Add check, or Add deposit ▼ dropdown menu.
  5. Select Check.
  6. Fill out the fields to complete the transaction.
  7. When you're done, select Save.

 

Learn more about the process by visiting this link: Manually add transactions to account registers in QuickBooks Online.


I'm adding this article to understand the reconciliation workflow in QuickBooks.

 

Reply below if you have further questions.

DarlaD2
Level 1

Bank cleraed the wrong amount for a check. How do I fix this?

Similarly, an employee cashed her payroll check for $.06 more than it was written for. I've added an expense for $.06 as advised above, but I still can't move forward. I need to match this bank transaction against the expense + all the journal entries for payroll and taxes, but they aren't showing up automatically. Please advise. Thanks. 

Jelayca V
QuickBooks Team

Bank cleraed the wrong amount for a check. How do I fix this?

I can share a few ideas on how to handle your payroll bank transactions, @DarlaD2.

 

In QuickBooks Online (QBO), we can match a bank transaction to multiple recorded entries. However, we're unable to do it the other way around because of such reasons:

 

  • The amounts or dates don’t match.
  • The transaction is older than 6 months.
  • The bank account on the payment isn't the same as the bank where the match is located.
  • The payment has been reconciled.
  • The record is already matched to another transaction.
  • The system will look for transaction(s) that fall within a 10% range of the bank transaction dollar amount when trying to match foreign currencies.
  • There are multiple currencies involved, and the exchange rate has shifted significantly, making the amounts very different.

 

Given these considerations, we can skip the matching process and consider excluding the downloaded transaction and manually clearing it in the Bank Register. Here’s how you can do this:

 

  1. Go to Transactions and select Bank transactions.
  2. Select the For Review tab.
  3. Select the checkbox of the transactions to exclude.
  4. Select Exclude.
    sample.JPG

 

Then, proceed to manually mark the transaction C or clear it in the Bank Register. Here's how you can do it:

 

  1. Navigate to the Chart of Accounts.
  2. Click the View Register link for the bank account.
  3. Filter the funnel by Reconcile StatusTransaction TypePayee, and Date.
  4. Click the Apply button.
  5. Locate the transaction, then mark the transaction C in the checkmark column.
  6. Review everything and select Save once done.
    sample.JPG

Additionally, I'm sharing this reference to regularly guide you in reviewing your accounts: Learn the reconciliation workflow in QuickBooks Online.

 

Don't hesitate to reach out to us if you have further questions about managing transactions in QuickBooks. We, in the Community, are always here to help.

DarlaD2
Level 1

Bank cleraed the wrong amount for a check. How do I fix this?

Thanks so much for your quick reply. I always forget about the Exclude option. Much appreciated. 

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

Need to get in touch?

Contact us