Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello, I have an issue where our deposit for a day is less than our deposit summary for the same day because of a refund that went out that does not post as a separate transaction in our bank due to our payment capturing system only posting a lump sum for end of day. So since our banking transaction deposit is less than our deposit summary from QBO, I cannot even match the transaction to the bank deposit and resolve the difference. I already tried creating a refund receipt to represent the refund that was issued and tried including it into the bank deposit somehow but that does not work. Is there any other way I can balance this issue?
Solved! Go to Solution.
Did you trying posting the Refund Receipt to Undeposited Funds and all of the Payments to Undeposited Funds. Then when you click on all of them to make the deposit they should match up to the amount of the net deposit you received. For example if you had 2 invoices that total 500; and 1 refund of 100 the net is $400. If all of these went to Undeposited funds you would click on the 2 positives that = 500 and the negative 100 for a total of 400.
Did you trying posting the Refund Receipt to Undeposited Funds and all of the Payments to Undeposited Funds. Then when you click on all of them to make the deposit they should match up to the amount of the net deposit you received. For example if you had 2 invoices that total 500; and 1 refund of 100 the net is $400. If all of these went to Undeposited funds you would click on the 2 positives that = 500 and the negative 100 for a total of 400.
I appreciate you reaching out to us in the Community, @cv20221. Let's ensure you're able to have your deposit accounts balanced in QuickBooks Online (QBO).
Laura1040 is correct. We can create a Refund Receipt and deposit it to the Undeposited Funds account to balance your bank deposit with your deposit summary. You can consider taking the steps outlined above.
Additionally, we can include the payment amount recorded to Undeposited Funds and add Refunds to customer accounts under the add funds to this deposit section. To do this:
These are the steps to add the customer's refund and to make the deposits balanced:
I've provided screenshots for reference.
Furthermore, you can check out these articles for additional guidance and reference about using the Undeposited Funds account:
If you need further assistance with managing your refunds in QBO, feel free to comment below. I'm here to help. Stay safe!
This worked. Thank you!
Hello, Laura1040.
I appreciate you for sharing your knowledge about QuickBooks. This will definitely help other users as well in the future. Please keep on posting here in the Community.
Keep safe and have a great rest of the day.
How do I do this with Quickbooks Desktop? When giving a refund I am unable to select Undeposited Funds. I'm only able to select a bank account.
I'm coming across the same issue with reconciling credit card transaction payouts that include refunds and credits, because they refunds payouts don't go into Undeposited Funds, like standard payments.
Welcome to the QuickBooks Community. Let me help you with your refunds, @Bishoffgirls.
The Undeposited Funds are only available in QuickBooks Online. We have three ways to refund your customer on QuickBooks Desktop. We can choose between Retain as an available credit, Give a Refund, or Apply to an Invoice. Follow these steps for issuing a refund:
To learn more about refunds, refer to this article: Void or refund customer payments in QuickBooks Desktop.
Moreover, let me share this article that can help you with QuickBooks Contractor payment and file 1099s: Create and file 1099s with QuickBooks Contractor Payments if you use QuickBooks Desktop.
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