Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I'm looking for help with making a particular deposit. Let's see if I can explain this.
On Tuesday we received 2 check payments. One was a large check that was deposited that day. The other check was not deposited until later in the week with other payments, so now there are 2 deposits associated with the same day's sales.
I have tried matching the large deposit to Tuesday's sales, but it wants to resolve the difference, which exists in the other deposit. Is there a way to apply the payment towards the day's sales without being forced to select resolve? I want to be able to match the banking transactions of the deposits to sales.
Thank you.
Hi there, @cheese!
I'm here to give you information about matching transactions in QBO.
At the moment, matching one customer payment to 2 downloaded transactions is currently not an option in QuickBooks Online. However, I have outlined a workaround for you to get your work done.
You can exclude the 2 bank transactions in the Banking page then set the customer payment manually with cleared status in the register. Let me guide you through the steps:
Step 1: Exclude online banking transactions
Step 2: Manually update the deposit status
That's it, @cheese. While the option is currently unavailable, I'd recommend sending this to our engineers. Go to Gear icon then choose Feedback. Your suggestion helps them understand what features should be added in the future.
Please feel free to notify me if you have any more concerns with QuickBooks. I'll be happy to guide you.
Let me try:
"One was a large check that was deposited that day."
Sales are entered as Sales Receipt; or you previously entered an invoice to show you had an Unpaid sale and this is the Payment for that invoice. Make sure this Flows to Undeposited Funds (a holding account function).
"The other check"
Another Sales Receipt or Payment to process for this Other Date. Make sure to use UF, as well.
UF allows you to avoid seeing this in the Bank Register as individual entries. You want to make Batched Deposits and control the date of Deposit. That is why UF exists and needs to be used.
"was not deposited until later in the week with other payments"
When you enter the deposit or get it from Banking Download, you select that the UF transactions in transit are part of this Specific dated deposit. Leave the other entries in UF that are not part of this Deposit you are batching.
"so now there are 2 deposits associated with the same day's sales."
Banking is Not Sales. This is why Sales is Sales Receipt; the Date on the Sales Receipt is Sales. The rest is Banking.
When I exclude the deposits from Banking, they no longer appear in the Checking register for the Chart of Accounts.
Hello cheese,
That is correct. After excluding bank transactions from the For Review page, they won't show up in your register. You'll then manually reconcile the deposit. Go to the register and click on the transaction to show the "R" letter.
If you have any questions, please let us know. Thanks!
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