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

Thank you!

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

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.   

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?

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.

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? 

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! 

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

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.

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. 

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.
   

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 Status, Transaction Type, Payee, 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.
   
   

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.

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