Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
The resultant credit from an overpayment shows the credit balance in the customer’s account - ok. However, on the balance sheet , it shows up as a negative accounts receivable. It should show up as a positive accounts payable. How can I fix this? Thank you!
Solved! Go to Solution.
No, it won't do that, and I don't think it should.
It is better to show AR with a contra-balance than to recast it as AP, which it is not.
Similarly, if you have a bank account with a negative balance, it is still cash/still an asset, but with a contra-balance.
Negative A/R is the correct posting of an unapplied customer credit. A/P is vendor balances - what you owe not a customer. You will want to move the negative A.R to an other current liability account other than A/P. Whatever you do you will have to reverse your actions once you have an actual sale to this customer.
If you toggle to cash basis on your B/S report the negative A/R should drop down to Retained Earnings and clear the negative A/R
No, it won't do that, and I don't think it should.
It is better to show AR with a contra-balance than to recast it as AP, which it is not.
Similarly, if you have a bank account with a negative balance, it is still cash/still an asset, but with a contra-balance.
Negative A/R is the correct posting of an unapplied customer credit. A/P is vendor balances - what you owe not a customer. You will want to move the negative A.R to an other current liability account other than A/P. Whatever you do you will have to reverse your actions once you have an actual sale to this customer.
If you toggle to cash basis on your B/S report the negative A/R should drop down to Retained Earnings and clear the negative A/R
Thank you, John. Learning something new everyday.
Stay well.
Thank you! Didn’t understand that before. I’ll leave it as is.
Stay well.
We owe a negative accounts receivable from and over payment to the client. How do we record the payable and get rid of the negative account receivable?
Good evening, @ Jhay.
Thanks for joining this thread.
Before going into detail, It's always best to check with your accountant to be sure this option would work for your business setup.
Below, are several articles, including information about Account Receivable accounts with how they work and more:
Let me know if the information above does the trick. If you have any more questions, please don't hesitate to reach back out. Have a good one!
I couldn't find the answer in your links above, but maybe I need to clarify. We received two payments from a client for the same invoice. One payment was applied to the invoice. The other payment was credited to the account and shows a negative A/R. We owe that second payment to the client since they already paid the intended invoice. How do I get rid of the negative A/R and record the payable to the client?
I'd like to share some steps to clear up the overpayment, Jhay.
If you choose the refund the customer, then you can follow these steps:
The process will offset the customer balance. Otherwise, check out this article for the other steps: Give your customer a credit or refund in QuickBooks Desktop for Windows.
If you have any additional questions, please let me know. We are always around to help you some more. Thanks.
This is pretty straight forward ...
If you have already made a payment back to the Customer ...
- Open the Payment and change the GL Account to your A/R Account
- Add the Customer/Job on the Line
This will zero out the negative A/R ... but you may need to g into the Open Invoice Report and apply the payment to the original Invoice ...
If you haven't made payment back to the Customer ... go to the Customer Payment that caused the overpayment and select the refund Customer option at the bottom left and follow the prompts ...
If you are keeping the xtra money ...
Write a Zero Dollar Check with the A/R line and Customer/Job on the first Distribution Line and
the Other Income (Misc Income) for the second line ...
I work in an industry that gets pre-payments almost all the time before the jobs are completed ...
This of course creates a negative A/R hence messing up the true A/R reports.
We do a monthly temporary transfer to our Current Liability Account - Customer Deposits with a Memorized Journal Entry dated the last day of the month ... this corrects the A/R Reports and Open Invoice Reports once you apply the Je to the Payments.
We then do a reversal of the Je dated the first day of the following month. This puts the payment back to be applied if the job gets done that nect month.
The following month we do the same process, but if the items listed on the AOpen Invoice Report is the Reversed JE, we just change the date to the beginning of the following month since apparently the job was not completed.
If the negative A/R is an overpayment that is not being refunded, we use a memorized zero dollar check to take the overpayment to Other Misc Income. Of course you have to apply the payment in the Open Invoice Report.
If the negative balance is being refunded ... either use the refund process listed at the bottom left of the Payment causing the overpayment, or just distribute the check to the A/R Account with the Customer/Job listed in the column.
Hello,
In my case, they are not all overpayments, but the customers received credit on their accounts to be used on future purchases.
Thanks for joining the thread, @AnneB8. I'll share some details about how to clean up the negative balances in your AR balance and fix the negative AP balance in QuickBooks Desktop (QBDT).
To clean up a negative balance in your AR account, you can set up a clearing account/wash account to move the balances to a different account. I'll gladly input the steps below. Here's how:
5. Select Continue.
6. In the Account Name field, enter Clearing Account, Barter Account or Wash Account.
7. Do NOT enter an opening balance.
8. Select Save & Close.
Feel free to read this article for more information: Set up a clearing account.
I'd also recommend checking this helpful article to learn how you can clean up the negative balance in your Accounts Payable: Resolve AR and AP balances on the cash basis Balance Sheet.
In addition, I've got you this article to know more about how to properly handle customer's credits in QBDT: Give your customer a credit or refund in QuickBooks Desktop for Windows.
Also, feel free to visit this article about how to deal with customer transactions in QuickBooks: Get started with customer transaction workflows in QuickBooks Desktop.
@AnneB8, I'll be here in the Community space if you need further assistance clearing AR and AP negative balances in QuickBooks. Take care, and have a nice day!
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