Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi!
I'm running into an issue which I'm stuck with. I look forward to your feedback. Here's my current workflow.
I bring in all my bank's transactions using a QBO file. After successfully importing all transactions, I go to QB Desktop to see the Bank Feed's transactions. I manually associate and categorize each transaction until I get to processing transactions related to Customer Payments. These are wire transfers received by the bank.
Although when I select "Add More Details" I'm able to associate a customer payment with the corresponding invoice, I find that after processing all transactions, these are "categorized" as shown below. Note that when I go through the bank's ledger, the balance at the end of each month is consistent with the actual records. So it's not a matter of missing transactions, but how they are labeled/processed.
- From 3 incoming payments:
In the last fiscal year, somehow I had these customer payments associated to a PMT to an Accounts Receivable account with the name of the customer.
My question is, is it possible to edit and convert the DEP/Service Revenue and DEP/Undeposited Funds records to PMT/Accounts Receivable? Or should I just delete these and enter them manually through the Customer > Receive Payments option? It would surely be nice to not do this manually...
Right now if I try to edit the DEP record and try to change the type of transaction and receive a payment I get a window indicating "you cannot apply an amount greater than the total payment plus any existing credits".
Thank you for your help!
Hi there, @gnocchi.
I'll make sure you'll be able to fix your customer payments.
You'll receive the message "You cannot apply an amount greater than the total payment plus any existing credits" once the total of all invoices you selected when receiving payments exceeds the figure in the payment amount field. To fix this, there are several solutions you can take.
First off, you can apply a discount or credit to one or more invoices. Here's how:
The second solution is to change which invoices are selected to be paid. To do so, you'll have to manually select the invoices by checking each of them until the total adds up to the figure in the Payment Amount box. You can also set your preferences to automatically pick the invoices. Please refer to these steps:
Another fix is to enter a different payment amount. QuickBooks also gives you the option to automatically calculate the payments. Let me guide you on how:
For your reference, you can visit this article: Warning: You cannot apply an amount greater than the total payments plus any existing credits.
I also agree with you to delete the transactions and manually enter them in QuickBooks using the Receive Payments feature as other fixes to resolve your concern.
I've also attached this helpful resource that will further guide you in managing your customer transactions in the future: Get started with customer transaction workflows in QuickBooks Desktop.
If you have encountered any trouble recording customer payments in QuickBooks, please leave a reply below. I'd be glad and ready to lend a hand. Keep safe always.
Thank you for the prompt response,
I decided to delete the transactions for this customer from the Bank and the Undeposited Funds accounts so I can enter them now the Customer Payments manually.
However, although I can see now all invoices with $ 0 payment, clicking on any of the invoices triggers the "You cannot apply an amoung greater...". See image attached.
Why is this happening? And how come even after deleting the entries in both bank and undeposited funds still trigger this message?
Looking forward to your input!
Good evening, @gnocchi.
Thanks for chiming back in on this thread. Let me point you in the right direction to get this problem handled.
The best route would be to try the three solutions listed below:
Here's a guide that can provide more details on how to do these actions: Warning: You cannot apply an amount greater than the total payments plus any existing credits.
If none of these work and you're still receiving the message, I suggest contacting our Customer Support Team for further assistance.
Feel free to come back and let us know how it goes. I want to ensure that you're able to get back to running your business. Take care!
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