Need help with a minor issue.
Issued a check through bill.com to a vendor. He never cashed it and 90 days later it expired. I later reissued a check which he did cash.
The transaction was voided but my bank statement that month shows the 500 going out. Now when I try to reconcile that month it's off by 500. Was voiding the transaction wrong? I also had a refund hit the bank a couple months later and wasn't sure how to categorize that.
Hello there, comet52.
Let's make sure that you've voided the correct one using the Audit Log feature. Here's how:
The Audit log will now be filtered to only show voided transactions based on the filters you applied. You can then click the View option to see the complete details of the deleted check.
If you've voided the correct one, it could be that the 500 on your bank statement is caused by the refund. You may need to create a matching refund transaction in Quickbooks first and match your bank transaction to it.
When the bank data is downloaded, it tries to find a match with any QuickBooks transactions already entered. If you agree with the match information shown in the row, click the Match button. This will match with the existing QuickBooks transaction. Here's a sample screenshot:
Feel free to check these articles for more details about handling transactions, especially categorizing them in QBO:
Let me know if you have other question. I'm here whenever you need help. Always take care!
Tried your suggestion but the item doesn't show up even if I expand the range to the entire year. However I can find it through a general search. The check was voided by bill.com on 8/7/20. I don't recall doing anything, it just auto-voided as far as I know. On 11/10 a refund was issued. I've attached a shot of the void if that is of any use. Still stuck here, I don't really understand how to resolve this. The 500 from December needs to somehow be part of the August reconcile?
Thanks for attaching a screenshot, @comet52.
I'm here to help and share some insights about reconciling your accounts in QuickBooks Online (QBO). The general rule of the process is to base it on the actual date of your bank statement.
This way, you can compare each transaction with the ones entered into your account and ensure everything matches. That being said, if the refund is posted in November, you’ll need to reconcile it for that month.
To match the refund posted in your bank, you'll need to create a refund transaction as suggested by my college above.
However, if you’ve already reconciled your previous month, you'll want to undo it and make some adjustment. To be guided through the process, you can refer to this article for guidance: Undo or remove transactions from reconciliations in QuickBooks Online.
I’d also recommend reaching out with your accountant for additional guidance. This way, we can ensure your account is accurate after making these changes. If you’re not affiliated with one, you can visit our ProAdvisor page and we’ll help you find one from there
Once done, you and your accountant are ready to reconcile your accounts. In case you run into some issues during reconciliation, you can refer to the troubleshooting steps provided in this article: Learn the reconcile workflow in QuickBooks.
You’re always welcome to leave a reply if you have other follow-up questions about reconciling your accounts in QuickBooks. I’m more than happy to work with you again. Have a great day and keep safe.
Since the voided item is for $0 and the bank withdraw is $500, I don't see how the reconcile for August can ever happen. Somehow there needs to be a 500 dollar debit in August to match what the bank shows. I was assuming someone in the community could tell me how to fix this. August is not reconciled so there is no need to undo it.
I'm here to ensure you're able to reconcile your account, comet52.
To start, I recommend reviewing your opening balance for the month of August. If it's accurate, check the ending balance you entered for that month. I'll guide you how.
Then, let's enter the transaction in QuickBooks to match what the bank shows. Here's how:
Once done, you can finish reconciling.
For more information about the process, please refer to this article: Fix Issues at the End of Reconciliation.
If the amount is still off, I suggest contacting your accountant for additional assistance. If you don't have any, visit this link: https://quickbooks.intuit.com/find-an-accountant/, to find one.
Additionally, I've added an article that'll help you have a handy copy of your reconciliation: View, Print, or Export a Reconciliation Report?.
I encourage clicking the Reply button if you have other questions in reconciling your account. We're here to help you out.