Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI have asked this question a few times before but do not get any satisfactory answers. I have Enterprise professional. When we first started using this I deposited payments from our customers through "deposits" and did not create invoices. I tried to do progressive invoices and deduct payments as I went but that did not work so I have 14 unapplied payments from 2017 through 2020 closed years sitting in my open invoices and showing up in reports. Can I delete those unapplied payments and if not, how can I get rid of them since they are paid. My accountant wants them gone so I need to find out how to finally resolve these problems.
You've come to the right place for assistance, Carolexx. I appreciate your detailed information when handling unapplied payment transactions and open invoices from previous years. Let me provide insights to help resolve this issue for you.
In regular scenario, you need to edit the deposit transaction created and make sure the accounts affected by it are not sales, but Accounts Receivable. This will close any balances of an open invoice and will ensure amounts are accurately credited.
Then, process payments for open invoices and apply or select Discounts and Credits to zero out the balances of your account. To do this:
Since you have also mentioned that these transactions are part of the closed years, the best way to correct the balances is to create a journal entry dated to the current period. This requires the attention of your accountant to seek additional guidance in handling these transactions.
In addition, if you encounter discrepancies when reconciling this year's financial data, you can check out this guide for more detailed information: Fix issues when you're reconciling in QuickBooks Desktop.
I'm all ears to any added queries you may have when handling unapplied transactions in your account. Just keep me posted, and I'll make sure to get you covered. Keep safe and have a good one!
@FateCandylaneT's response is incorrect. Do not edit any transactions from previous years. That will change your balance sheet (and possibly your P&L) from those closed years.
You mentioned:
"I have 14 unapplied payments from 2017 through 2020 closed years sitting in my open invoices and showing up in reports. Can I delete those unapplied payments and if not, how can I get rid of them since they are paid."
There are a couple things to sort through here. Just to confirm, you have 14 credits (negative balances) showing in your open invoice report, correct? And those are duplicate entries that are no longer needed and you want to clear them, correct? If that's the case, then you must also have 14 deposits that need to be reversed because, when you use Receive Payment, you need to select an account under 'Deposit To'. QB then creates a deposit to the account selected in the 'Deposit To' drop-down menu as well as a credit entry to A/R. It is the credit entry to A/R that you're trying to clear. But, when you created the credit entry, you also created another entry that is now wrong and needs to be reversed at the same time. Double-entry accounting always affects two accounts.
So, we need to determine what other account needs to be reversed when we clear the A/R credits. Do you have 14 deposits showing up as unreconciled? If not, what account was selected under the 'Deposit To' drop-down on the A/R credits showing on your open invoice report? It is those account(s) that we need to reverse as well as the unapplied payments. Once you can identify what other accounts have been affected, we can clear all this up with journal entries. Just let me know.
Whatever account you or your CPA determine is the offset account from my previous post, create a separate journal entry for each customer that debits A/R and credits the offset account for the amount of the unapplied payment. Add the customer under 'NAME' on each A/R line of the journal entry. Then, go to Receive Payments and apply the credit (unapplied payment) to the amount due that was created by the journal entry. You should be all set.
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