What should you do when a customer pays too much? Determining if a refund check will be issued or whether the funds will be retained on account to be used against other outstanding invoices or future sales to the customer is an important issue regarding the accounts receivable for the customer account. In this article, we will show you how to handle a customer overpayment:. Our articles are to help you become a better user. If you have questions or need help with other related issues or even other Accounting issues take a look at our support options here:. You can, also, call us and one of our QuickBooks Pro Advisors will be ready to give you the support you need. Call 800-216-0763.
Customer overpayments and what you need to do to verify that the customer overpaid: This is an example of a customer, Red Bloom, who has sent you a check (number 8482) for $168.00 to pay for invoice #1100 in the amount of $110.00 and invoice #1101 in the amount of $58.00. When you open the Receive Payments Window in QuickBooks and filter on the customer, Red Bloom, there is only one invoice #1101 for $58.00 unpaid. Their balance due is $58.00. To verify that there isn’t any other invoice open on Red Bloom’s account, do a search using the Find window to verify this overpayment as shown below. Conduct a search for $110.00. Under the edit menu, you will click on Find or use the control and F key together to bring up the Find window.
A profit and loss statement, also called an income statement, is a fundamental business report. The balance sheet and the profit and loss statement help gauge the profitability of your business. The balance sheet and the profit and loss statement help gauge the profitability of your business. Jan 4, 2019 - You need to know the differences between QuickBooks Online vs. Financial Management. Supported in QuickBooks Premier and Enterprise, and not QuickBooks Pro. Fix Unapplied Payments and Credits; Clean-up Un-deposited. QuickBooks Statement Writer; No 1099 Feature for Simple Start.
Make sure you are on the Advanced tab at the top. Click on the Amount filter and click on the middle radio button next to = sign. Add the $110.00 dollar amount and click on Find button. There will be a list of all transactions in the amount of $110.00 listed in the Find window. Under the Name column search for the company name, Red Bloom, for a possible payment (PMT). It is apparent, that Red Bloom has previously paid the $110.00 under their check number 8438.
Resolve the overpayment. Call the customer to make them aware that they have overpaid and see whether they would like a refund check; or if they plan on making more purchases in the near future.
It is possible, they want you to hold these funds in their account to be applied to a future invoice. How to record a customer overpayment in QuickBooks. In our example above, Red Bloom has only one open invoice. However, you received a check for more money than Red Bloom owes. This check still needs to be recorded and have payment applied to the one open invoice. Regardless of whether the exact amount due is paid or a payment that is for more than what is due is sent, you would record the payment in the Receive Payments window.
Here are the steps you should follow within the Receive Payment window to record the customer overpayment. Choose company name (Red Bloom) in the Received From field drop-down box.
In the Payment Amount box, enter the full amount of check even though it is more than the invoices available to be paid. In the Date field, enter the date of payment. Type the check number in the Check# box. In the Memo field, add the check date and the name on the check if it is different from the company name.
You will see that the open invoices have been checked to be paid and below in the left corner you will see the Overpayment Section: a. Leave the credit to use later or b. Refund the amount to the customer. Option One – How to refund a customer overpayment in QuickBooks. You have verified the customer, Red Bloom’s, payment is an overpayment and Red Bloom would like a refund. The refund can be completed within the same Received Payments window when you are recording the payment. Choose the company name (Red Bloom) in the Received From field drop-down box.
Use the Receive Payment window to handle recording an overpayment as a refund. Here are the steps you would take to refund a customer overpayment:. In the Payment amount box, enter the full amount of the check even though it is more than the invoices available to be paid.
In the Date field, enter the date of payment. Add the check number in the Check# box. The Memo field should include check date, name on check if different from company name on the check and a description about the refund. You will see that the open invoices have been checked to be paid and below in the left corner you will see the Overpayment section and choose the radio button: Refund the amount to the customer. Click Save and Close. Issue a Refund pop up window appears. Everything is pretty much entered for you within this window.
Make sure the Account is correct. Next, enter in the Memo field a reason for the refund. Last, make sure the to be printed checkbox is checked, so you will be able to print the refund check. To print a refund check. When you are ready to print the refund check:. Go to File menu hover over Print Forms.
On the right (list) click on Checks, this will make the Select Checks to Print window appear. Make sure the Bank account and the first Check number are filled in with the correct bank account and the check number is the same check number on the check you placed in the printer. Click Ok to print the check. When you are next in need for QuickBooks compatible checks, check out our web-page for checks to review current pricing on We are a full-service QuickBooks support company. We recommend you bookmark our page. The next time you are in the market to purchase checks, check envelopes, deposit tickets, invoice forms, W2 and 1099 tax forms you will have easy access to our products. You can review all of our products to compare our pricing with the products you have purchased in the past.
Any questions, 800-216-0763 will connect you to one of our QuickBooks experienced customer service representatives. We are always here to help you with your compatible product needs.
Option 2 – Apply the over-payment as a customer credit, “on account”. Red Bloom has decided he wants the overpayment to be held as a credit to be used against some future purchase.
QuickBooks allows an overpayment to be held as a credit against the customer’s account. Be aware, you would not want to hold the credit indefinitely. The time frame period for holding customer credits would be a decision made by the owner of your business.
Whether the credits are held for a month, quarter or one year is up to your business and what to do about unused credits when that period is up is discussed below. Again, this can be done at the same time you are recording the customer’s payment.
Use the Receive Payment window to handle recording an overpayment on credit. In the Payment Amount box, enter the full amount of the check even though it is more than the invoices available to be paid. In the Date field, enter the date of payment. Type the check number in the Check# box. In the Memo field add the check date and the name on check if it is different from the company name. You will see that the open invoices have been checked to be paid. Below, in the left corner you will see the Overpayment section and choose the radio button: Leave the credit to use later.
Click Save and Close. You should consider mailing the customer a new statement. To create a customer statement, go under Customer menu and click on Create Statements which will notify the customer of the new credit on his account.
Doing so will alert the customer to send instructions with his next check, as to which invoice or invoices to apply the overpayment. The negative amount in the bottom right corner is the amount of the credit on account. Create a Customer Statement.
The following picture shows how you would set up your statement to make the customer aware of his credit on account. You will need to modify a statement to show the words Credit on Account. How to clear overpayment credit in QuickBooks. When Red Bloom has purchased more product and has a new invoice or invoices on his account, he may have instructed you on which invoice to apply the $110 credit to. Open the invoice, so you can use the overpayment (credit).
Open the Receive Payment window. Choose company name (Red Bloom) in the Received From field drop-down box. Click on the invoice for which the payment will be applied. Click on Discount and Credits. Make sure that the credit you want to use is checked.
Choose Done to close out of this window. The above procedure will link the credit (over-payment) to the invoice specified by the customer.
Unused customer credits and what to do with them. What if several months have passed and the over-payment credit in QuickBooks Accounts Receivable, placed on the customer’s account, is still unused? You could decide to hold the credit a bit longer. However, it is now 12 months later and it does not look as if the customer who overpaid will be buying any additional products or services from your company.
You can choose to refund the over-payment or write off the credit. Getting these credits off your books is a good idea to clean up your Accounts Receivable aging report and your Open invoice report. How to Refund the overpayment credit. In case the customer has not utilized the credit after several months or even a year later, you can refund his money by entering a journal entry and writing a check. You should not leave a customer’s credits on the books indefinitely. The following are steps to create a general journal entry to issue a QuickBooks refund for customer overpayment credit. Open the general journal window by clicking on Make General Journal Entries under the Accountant menu.
Under the Account field add Accounts Receivable account and in the Debit field add $110.00, which is the amount of the credit for Red Bloom. In the Memo field add “refund credit balance”. Customer Name field should have entered Red Bloom.
Second line under the Account field should have Customer Refunds Account, (new account type=”income”, go ahead and set this up), in the Credit field add $110.00. Write a check payable to customer name for $110.00 and in the Account field choose Customer Refunds account in the drop-down menu. How to Write Off the overpayment credit. If the customer has gone out of business and you can’t issue and send a refund, then you should write off the over-payment credit. The following steps will walk you through completing a write-off. It is always best to issue a refund unless the customer has agreed to a write-off. Write off process.
To start this process, you want to create a Statement Charge of $110.00 to write off the credit for Red Bloom. In creating a statement charge, you are moving the overpayment from the Customer’s Accounts Receivable account to a general income account called Customer Refunds.
Highlight Red Bloom name (or other customer name) in Customer Center. Go to Customer menu. Click on Enter Statement Charges and the customer’s Accounts Receivable window will appear (top of window reads customer name- Accounts Receivable). Enter current date in the Date field. In the Number Type field type “adjust”.
In the Item field type “Adjustments or Write Offs”. You may have the Item Not Found window open due to the name of this field is not already in QuickBooks.
This is a new Item and click Yes set up this item as an Other Charge item type and select an income account from your Chart of Accounts. You may need to set up a new Income account such as Customer Refunds.
In Amt Chrg field add the amount of the credit ($110.00). Description field should have a note explaining the reason for this write-off. Click Record.
Our QuickBooks Professionals are advanced certified in both QuickBooks Desktop and Online. Our consultants are expertly trained in QuickBooks and know the accounting that goes on behind the scenes. We can help you move to the next level to becoming more efficient. Whether you have questions, need to resolve issues or would like some training, check out our support options here: You can, also, call us and one of our QuickBooks Pro Advisors will be ready to give you the support you need. Call 800-216-0763. Guarantee: As Advanced Certified QuickBooks Advisors, we work hard to make your QuickBooks solutions function as a key resource for you to manage business growth. We value our QuickBooks customers and are confident in our reputation as leaders in QuickBooks help, support and training (on-site or remotely), we offer a full money back guarantee on QBalance support if you are not satisfied.
Just send our QuickBooks Pro Advisors an e-mail with an explanation, so that we may improve our QuickBooks training and QuickBooks help services in the future. Intuit offers a 60 day return policy on the purchase of QuickBooks desktop products.
Also, there is a 30 day free trial on QuickBooks Online products. ©2017 QBalance.com.
All Rights Reserved QuickBooks® Accounting Software is a registered trademark of Intuit, Inc. Legal and Privacy Member of Intuit's Certified QuickBooks Pro Advisors Program.
Member of Intuit PREMIER Reseller Program.
By Dana (Long Island, New York, USA) One of my customer’s accounts receivable is incorrect. I’m using QuickBooks Pro 2008. Within the Receive Payments window, the customer information shows five invoices totaling $27,457.39 and available credits of $10,345.07 for my customer. This makes the balance $17,112.32. This information is totally incorrect. However, the Customer Balance Detail report, Customer Balance Summary and the Open Invoice report are accurate and reflect each of the customer’s transactions and the correct balance of $16,833.58.
I also looked in Accounts Receivable and it relects the correct payments received from this customer. How do I correct the erroneous information contained in the Receive Payments area and avoid changes to all my other reports? The available credits must be removed as they don’t exist. I have not applied two recent payments to this customer’s account fearing I will only make a bad situation worse. Can you help? Thank you so very much for any advice you can offer to help resolve this error. I’m at a complete loss here.
Jennifer replies: Hi Dana! I’m thinking out loud here. Does this customer appear more than once in your Customer List? If the answer is no, are you 100% certain? Because I’m wondering if some entries have posted to an incorrect or old customer name. If entries have posted among two or more customer names, this will mess things up. I would also look at the difference between what is correct ($16,833.58) and what is shown in the Receive Payments screen ($17.112.32), which is $278.74.
Can this number be explained somehow? One other thing I just thought of is to go to the customer’s name in the Customer List, right click, and select Enter Statement Charges. This opens the customer’s A/R register. You’ll notice that there are three columns along the right.
There should be different amounts on each line. Now notice a box at the bottom called Show Open Balance – check it. QB then removes any closed transactions from the first two columns, but keeps the running balance in the third.
What remains in the first two columns are any transactions that are still Open (also called Unapplied). See if this gives you any clues. If you are certain that all the entires are posted under the correct name, then I am at a loss without actually seeing your file. This is because all of the reports you mention feed directly into the Receive Payments window – in other words, any transaction you see in that window (and, by the way, transactions appearing here are considered “open” transactions) comes from those reports, especially the ones labeled “Open”. Sorry that I couldn’t give you a definitive answer about how your customer’s accounts receivable is incorrect, but hopefully I’ve given a few clues to help. Let me know how it goes by posting a comment below.
Thanks for writing. Comments for Customer’s Accounts Receivable is Incorrect. May 05, 2011 Incorrect Accounts Receivable Balance by: Christine Vanderberg I had the same problem. One customer was showing a balance that simply did not exist. I tried applying the “unapplied” amount to the invoice, only to have it reappear after it was zeroes out. I opened the customer register and saw that I had entered the payment the same date as the invoice.
The payment was showing before the invoice, and although it was zeroing out, there was a balance on the next line. I tried changing the payment date to a date after the invoice date and that cleared out the error. Jun 10, 2011 Accounts Receivable amount is incorrect AGAIN! By: Christine Vanderberg I’m using QuickBooks for MAC 2011.
One customer is showing a balance due when there isn’t one. The payment was applied back in March and the invoice was never credited or “stamped” PAID. Instead, the invoice balance on my A/R reports is increased, but the balance in the customer’s register is correct.
When I go to apply a new payment for a different invoice, the March invoice shows up (incorrect amount) as a balance due with unapplied amounts and credits due. What the heck is going on???? Jan 17, 2015 Simple Solution by: Bryan Dulock I use QuickBooks 2014 for Mac and encountered this same problem. After some testing I discovered how to fix the problem.PROBLEM Some customers in QuickBooks show balances even though a payment was already received. In my case the incorrect balance for a customer happens when I do the following: 1. Create invoice but don’t save it yet 2.
![2016 2016](http://s3.aws.blueriver.com/it/intuit/assets/wp-content/uploads/2012/08/Credit2.png)
Receive payment while on invoice screen 3. Save the invoice It seems to me that this sequence of steps sorts the invoice and payment incorrectly (since the payment has an earlier creation date than the invoice). SOLUTION Change the invoice date to something prior to the payment date. This gets the invoice and payment in a consistent order.
I found that changing the payment date did not correct the issue.