Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello,
When we deposit checks into the bank, we deposit multiple checks at one time. When I go to match the bank transaction to open invoices, I have to split them into the various invoices. However, when I go to reconcile the account, I see 3 entries in the bank register:
One credit for the original deposit amount (lets say $3460)
Below that is a credit for $3000 (for Customer A)
Below that is a third credit for $640 (Customer B
How can I avoid this from happening? It's impossible to reconcile with this problem!
Thank you!
Solved! Go to Solution.
Just to make sure you know, the end results should be:
Debit - Cash
Credit - Revenue
-----------------------------------------------------------------------------------------------------------------------------
Another common setup, when you create invoices in QB, your setup may do these entries:
Debit - AR
Credit - Revenue
Then when you receive payment, the system should make these entries for you:
Debit - Cash
Credit - AR
----------------------------------------------------------------------------------------------------------------------------------
Suggest look at report called General Ledger (which shows detail of all account transactions).
Look at the Cash account (QB calls Bank), and it is usually first account shown on this report. Check to see if amount is actually counted twice in total or if it just looks that way on screen.
That is definitely not good, so you will need to delete one of them. Looks like you may have added vs. matching payment to open invoice. I would remove both and go back to bank feeds to match.
Thank you. I unmatched both payments and went back to the bank feed. I found the transaction and clicked Find Match.
I saved it, and went back to the general ledger to see if it worked. It did!!!! I double checked in the reconcile page and it worked!!! Thank you!!!!
Hi Teri. All looked well and perfect in my reconciliation. Then I went back to my inmvoice page and all of the involved invoices are now marked as unpaid! Why aren't they attached?
Logging into my QBO to look. Have never had a problem with posting invoice payments.
First thought is look in AR account to confirm that is where invoice entry was posted since we see payment went there, which is normal
Make sure everything matches between invoice and payment, like dates, customer name, account, amounts invoiced, etc. It is easy to click 2018 vs. 2019 this time of year.
Just to make sure you know, the end results should be:
Debit - Cash
Credit - Revenue
-----------------------------------------------------------------------------------------------------------------------------
Another common setup, when you create invoices in QB, your setup may do these entries:
Debit - AR
Credit - Revenue
Then when you receive payment, the system should make these entries for you:
Debit - Cash
Credit - AR
----------------------------------------------------------------------------------------------------------------------------------
I'm having this exact same issue. It doesn't look like this was resolved?
You've come to the right place, @StoneCo.
When recording customer's payment via the bank deposit window it will not be applied directly to the open invoice. You'll have to enter the customers' payment via the Receive Payment screen and match it with the deposit transaction. By doing so, you'll avoid getting duplicate records and ensure your transactions are matched accurately.
To resolve your concern, let's generate the reports mentioned by @Teri to verify how many times the transactions were counted. Once checked, delete or unmatched the transactions that caused the duplicate records.
To record your bank deposits in QuickBooks, you can refer to this short video clip:
Once completed, let's make sure that payments are recorded and applied to the invoice properly.
Lastly, you can now match the customer's payments with the deposited transactions.
For more insights about managing your transactions, you can refer to these articles:
Always feel free to visit us here in the Community if you have other questions. I'm just a few posts away.
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