Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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! Go to Solution.
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:
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.
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:
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.
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:
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:
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:
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:
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:
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:
Then, proceed to manually mark the transaction C or clear it in the Bank Register. Here's how you can do it:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here