Yes. But it is best to get an Accountant to help you with this. When you change a transaction that has been reconciled, you have to re-reconcile each period that is impacted by the changes made, in chronological order, otherwise your beginning balances get messed up. Also, a transaction that is deleted that originated in your bank feed, will go back into your bank feed for categorization.
Depends on what you want to change. Anything but amount and the account that is reconciled can be changed. Open each transaction in question from the register or from receipts, payments, deposits, etc. Click on edit, edit and save. Your reconciliation will not change.
This goes even for payee name as well as expense or income account
Good point John, however most users don't ask questions about changing reconciled items if the amount or account don't need to be changed. :)
I look under different rocks than you and have seen my share of "help, I posted a check to the wrong expense but it is reconciled, what do I do now?"
LOL. Thanks for making me laugh, John. I turn over every stone and look for every penny, it's just my way. So it is not likely that you turn over different rocks than I do. It is difficult to look under rocks when you have limited visibility.
I tend to be proactive in warning users about what could go wrong when they change accounting transactions. I feel it is important to solve problems before they occur whenever possible, and it is less valuable to share what a user can't screw up when they change an accounting transaction.
Allow me to join in this conversation and share my thoughts about reconciled transactions.
I agree with what @john-pero mentioned above. Changing anything but the amount and the account on any given transaction won't change its reconciliation status, is correct.
It's a good practice to recreate deleted transactions, especially for reconciled transactions. It's not enough to only recreate them though, you'll have to manually tag them as reconciled so you won't have any issues with your account balance the next time you do a reconciliation.
Let me show you how:
You can follow the same steps above for any transactions you've edited the amount or account related to it since its reconciled status will be removed.
Should you encounter a situation where your account's opening balance doesn't match its bank statement, please refer to this article: Fix an opening balance to match a bank statement. It lists a number of possible scenarios for this specific issue, then provides you steps on how you can resolve each of them.
Please feel free to drop a comment below if you have any other questions for me. I'll make sure to get back to you.
Due to QBO making and modifying it's own banking "rules" as it sees fit with total disregard for how we set "rules" I was asked by a client yesterday if they had to correct all the misapplied transactions prior to reconciliation and my answer was a big fat NO. If the entries are in the checking r credit card account register and the amounts are correct then one can reconcile now and edit later with no I'll effects.
If a reconciled transaction is deleted, even if it is replaced the account should be re-reconciled as a best practice, as the new transaction will not be "reconciled". If only categories (accounts) have been changed, then John is correct, re-reconciling the account is not necessary.
If you know exactly what you are doing - deleting (even by error) and adding new or re-creating what was deleted, while a new reconciliation is helpful and takes moments you can mark any transaction as reconciled and if for examplyou deleted a check for 100 that was reconciled and add back in a check for 100 (within same timeframe) AND in the register view mark it reconciled then it is. And you will not see it pop up next recon.
Hello there, KGilbs.
Thanks for keeping in touch and for sharing us how you're able to figure things out. Let me share additional insight about your concern.
All the information stated by john-pero, ReginaMarie and RyanM are correct. As long as you recreate the deleted transaction within the same time frame and marked it as reconciled (R), then it will not affect the reconciliation amount and will only show on the Reconciliation Discrepancy report.
In the future, you can just directly change the income account to the added transaction from your online banking by opening the transaction. This way, you don't need to re-reconcile your account.
You're on the right track. If you need more clarifications about the reconciliation process in QBO, don't hesitate to visit us again. I'm always happy to help.
Is it ok if we add a journal entry to debit the amount in the wrong income account and credit the correct income account.
i have several transactions in one of my bank accounts that I mistakenly recorded as expenses vs transfers. These transactions were all transfer between 2 bank accounts. The offsetting account was the correct bank account, but since the classification was erroneously recorded as an expense vs a transfer, I'm not finding the offsetting transaction in the correct bank account. HELP...
I'm glad you've reached out to the Community. Let me help share some details about updating bank account transactions in QuickBooks Online (QBO).
Did you manually create the expense transactions? If so, you'll need to delete it and manually re-create the transactions as a transfer.
However, if this is online banking, you can Undo the accepted transactions to update the correct category.
To do this, please follow the steps below:
If you need further assistance with the steps, I encourage you to contact our QuickBooks Online Support Team. They have additional tools to pull up your account in a secure environment and do a remote session.
You can contact our customer support by following these steps:
For additional reference, you can check this article to learn more about the bank feeds transactions in QBO: Assign, categorize, edit, and add your downloaded banking transactions.
Please know that I'm just a post away if you have additional questions about updating bank category. Have a good one.
Have a bank account reconciled from last year. It appears that all transactions that were under an Income subcategory 42010 were identified as an Expense instead of Income, so on the P&L it lists the subtotal as a negative instead of a positive amount. Is there a way to change these to reflect accurately on the P&L that someone can walk me through without having to manually redo the reconciliation for the year?
Glad to have you here in the Community, @terryan.
I've got you covered in verifying the expense transactions on your Profit & Loss in QuickBooks Online.
In situations like this, you'll need to check the transaction type of your expenses to see if it's correct. If not, you may need to undo the reconciliation and modify the transaction, to change the subtotal into a positive amount.
To do that:
If you need additional assistance in performing this procedure, you can always reach out to our Customer Care Team. They have advanced tools that can walk you through this process.
These resources will get you pointed in the right track, terryan.
I'd like to ensure that you're all set, so please let me know how it goes or if there's anything else that you need. I'll be around to help you out. Have a good one!
Thanks. Had a lengthy conversation with a QB support person, which they were not too helpful.
What I ended up doing is going over all the transactions for the year in the Banking section and found multiple transactions that were duplicates and identified wrong as being expenses instead of income from being pulled in from a csv file. After selecting and excluding, I deleted them.
I then unreconciled the previous year and went back through and reconciled for each month. Each month was reconciled fine.
The result I see though when looking at the P&L for the year still looks off. It doesn't account for all the income for that transaction type.
I found this very useful - I was specifically looking for this info as I wasn't sure if changing the expense category on a reconciled item would mess up reconciliation - so thank you for clarifying!
Not sure why others in the comments section felt the need to tell you this wasn't a relevant piece of info. Maybe too much time on their hands :)
I am new to QB online, I have a long experience with QB desktop.
I made changes to the payee names and on expense accounts on transactions from a reconciled statement. When I reprint the reconciliation report, the changes I made for the payees are not updated. What do I do now? Please help?
The information will not change on the report, vdpacct.
Unless you undo the entire reconciliation, then redo it. It will create a new reconciliation report that will show the changes you made.
If you have an accountant, they have an option to undo the whole reconciliation for you. You can provide this article: Undo your client’s reconciliations with QuickBooks Online Accountant.
Please let me know if you have additional questions about this. I'll be around to help.
Thank you, Mary!
I am an accountant. :-) I am just new to QB online.
I do want to undo the reconciliation. I have it on the screen, but there is no "action" tab, so I can follow step #7 and #8.
7. When you’re ready, select the arrow in the Action column, and then select Undo.
8. Select Yes and then Undo to confirm.