Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi -- You all have been so super helpful to -- and patient with! -- me in the past, I hope someone can walk me through this problem I'm having step by step, because it keeps happening and has turned into a small nightmare. Our nonprofit had to cancel a conference due to COVID in 2020, and we sent out around 200 refund checks for registration, mostly in FY 2019-2020.
Key points:
Two related questions:
Thank you so, so much for any help you can offer me!
SueTy
Solved! Go to Solution.
I'm grateful for the clarifications that you gave, @SueTy.
I'd like to share some solution that can help you clear the expense that's showing up on your member's chapter statement.
You can deposit the returned amount to the account that was used upon creating the check. This way, the expense will be zeroed out.
When creating the deposit you may follow the date on when the check was generated. Just make sure to select the correct expense account in where the funds will be deposited to. It can clear the expanse amount that's showing up in the member's chapter statement.
If you want to follow your bank statement, you may use the date when Wells Fargo returned the amount to your account upon depositing the funds. This can make your reconciliation easier.
To create a deposit:
To learn more about creating bank deposit in QBO, please see this link: Record and make bank deposits in QuickBooks Online.
I'd still recommend reaching out to your accountant to ensure the best course of action for your business. They can give you the accurate solution in this situation.
I'm also adding here some articles that can help you categorize and reconcile your transactions smoothly:
Should you need clarifications or further assistance about this matter, let me know. I'd be pleased to help. Have a good one!
I appreciate your time posting here in the Community, SueTy.
To answer your first question , I suggest consulting your accountant before removing the adjustments made. This is to ensure that it will not affect your accounts and financial reports in QuickBooks. There are different ways to record a bounced check in QuickBooks Online (QBO). You can either use an invoice, expense, or journal entry. You can check these articles for the detailed steps and instructions to record a bounced check using the following methods:
Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.
Hi TirzahC,
Thank you for getting back to me, and also for the advice to consult an accountant re: the reconciliation adjustment I made. I appreciate it!
For my main question, though, which is what the screen captures were about: I'm a bit confused, because these checks aren't bouncing. The recipients of the refund checks are failing to cash them within 90 days, so the money is returned to our checking account (when the checks initially go out, they're recorded as expenses; when they come back in, I'm not sure how to properly account for these deposits).
As mentioned, I was advised to put the funds from the returned checks into Reimbursements. But, in the example I screen-captured, in one case, the refund was paid out of the account for one of our chapters, and the reimbursement is not showing on the chapter's expense report to cancel out this expense. So, in other words, it looks like the refund went out, but the funds from the cancelled check never came back in, so it's still reading as an expense in the chapter report.
I was wondering if you could help me solve that particular problem. Any advice you could give me would be deeply appreciated -- thank you! I'm re-attaching the file I sent yesterday to make life easier.
Hello, SueTy.
Thanks for replying to us. Since the refund didn't go through, you can void the check. This way, the check will remove as an expense. Then you can add a note for what this void check is for.
Once done voiding the check, you'll have to manually process the refund and enter them into QuickBooks Online. You can click this article to see the detailed steps on how to perform the process: Void or refund customer payments in QuickBooks Online.
If you're unsure, reach out to your accountant. This can get tricky and they know how to handle the next steps. Don't have an accountant? We can help you find one.
I'm always here if you need more help in refund your transaction. Just let me know by leaving a reply below. Keep safe and have a wonderful day!
Hi AileneA,
Thanks for getting back to me! I think my inexperience is possibly confusing the issue, which has to do checks, not credit cards.
In a nutshell:
So, what I need to find out is: How do I indicate in this chapter statement that the money was actually not spent? How do I get this expense off the books, since no money was actually spent and the check was cancelled?
One person is telling me I need to do a journal entry for this. Can you walk me through that, or is there another way I can get this phony expense to disappear, since it wasn't paid out?
Thank you again -- and, sorry if I'm not putting things the right way. It does seem so cumbersome in this system to take care of checks that a bank has cancelled because they weren't cashed in 90 days! I wish there were clear-cut steps to take that were in the QB help, because this happens fairly often, I'd think!
I'm grateful for the clarifications that you gave, @SueTy.
I'd like to share some solution that can help you clear the expense that's showing up on your member's chapter statement.
You can deposit the returned amount to the account that was used upon creating the check. This way, the expense will be zeroed out.
When creating the deposit you may follow the date on when the check was generated. Just make sure to select the correct expense account in where the funds will be deposited to. It can clear the expanse amount that's showing up in the member's chapter statement.
If you want to follow your bank statement, you may use the date when Wells Fargo returned the amount to your account upon depositing the funds. This can make your reconciliation easier.
To create a deposit:
To learn more about creating bank deposit in QBO, please see this link: Record and make bank deposits in QuickBooks Online.
I'd still recommend reaching out to your accountant to ensure the best course of action for your business. They can give you the accurate solution in this situation.
I'm also adding here some articles that can help you categorize and reconcile your transactions smoothly:
Should you need clarifications or further assistance about this matter, let me know. I'd be pleased to help. Have a good one!
Hi BettyJaneB,
Thank you so much -- to you, @AileneA and @TirzahC -- for all your help! @BettyJaneB, I did something along the lines of what you suggested with my reimbursement: prompted by what you wrote, I changed the account for the cancelled check funds to go into from Reimbursement to the account it was written out of, and now the amounts cancel each other out in the Profit and Loss report.
I learned a lot from each of you and really appreciate everyone's time. Thanks so much again!!
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