How to Write Off Overpayment in QuickBooks

Receiving an overpayment from a customer can leave you with a small, nagging to-do item on your accounting checklist. While you can hold it as a credit or issue a refund, sometimes the amount is too small or the customer is long gone, making a write-off the most practical solution. This guide will walk you through exactly how and when to write off a customer overpayment in QuickBooks Online, ensuring your books stay clean and accurate.

First, Why Did an Overpayment Happen?

In QuickBooks Online, an overpayment occurs when a customer pays more than the total of their open invoices. When you record the payment, QuickBooks automatically recognizes the excess amount and creates a customer credit. You'll see this as a negative balance in their customer account or as an “Unapplied amount” on the payment transaction. This credit sits on your books, waiting to be resolved.

Common reasons for overpayments include:

• A simple data entry mistake by the customer when paying online.
• A duplicate payment made in error.
• The customer paying an old statement amount after one of the invoices was already voided.
• A deposit was paid, but the final invoice was for less than the deposit amount.

You have three primary options for dealing with this credit: apply it to a future invoice, refund the customer, or write it off. While applying it to a future sale or issuing a refund are the preferred first steps, this guide focuses on the third option for those old, small, and unresolved credits.

When Is it Appropriate to Write Off a Customer Overpayment?

Deciding to write off an overpayment isn't something to be done lightly; it means you are recognizing the unclaimed money as income. This should only be done when refunding or holding the credit is no longer practical. This method is reserved for specific situations where the administrative cost of resolving the credit outweighs its value.

Consider writing off an overpayment if it meets these criteria:

• The Amount is Immaterial: The write-off should be for a small amount of money (e.g., a few dollars) that won't distort your financial statements. Writing off a $5 credit is reasonable; writing off a $5,000 credit requires a different approach and probably legal advice.
• The Customer is Inactive: If you no longer do business with the customer and don't expect to in the future, holding the credit indefinitely doesn't make sense.
• You Have Made a Good-Faith Effort to Refund It: You should always attempt to return the money first. If you've sent emails, made calls, or even mailed a refund check that was never cashed, you’ve done your due diligence. Document these attempts.
• A Significant Amount of Time Has Passed: Old credits from months or even years ago from defunct customers are prime candidates for a write-off.

A Critical Warning: Unclaimed Property Laws (Escheatment)

Before you do anything, you must be aware of state-level unclaimed property, or "escheatment," laws. Legally, that overpayment belongs to your customer. After a certain period of time (the dormancy period, which varies by state but is often between one and five years), businesses are legally required to hand over unclaimed funds to the state. The state then holds the funds for the rightful owner to claim.

Recognizing an overpayment as income does not relieve you of this legal obligation. For very small amounts (a few dollars), many businesses accept the audit risk. For larger amounts, you must consult your state’s escheatment laws to avoid penalties. Writing it off the wrong way can turn a small nuisance into a major compliance headache.

Step-by-Step: How to Write Off an Overpayment in QuickBooks Online

The correct method for writing off an overpayment in QuickBooks Online is to create a new invoice for the credit amount and then apply the existing credit to that invoice. This moves the amount from Accounts Receivable into an income account, clearing the customer’s balance to zero. Follow these steps precisely.

Step 1: Get Your "Other Income" Account Ready

First, you need a place on your chart of accounts to record this income. It’s not service or sales revenue from your normal operations, so it should be classified as "Other Income."

1. Navigate to Settings ⚙ and select Chart of Accounts.
2. Click the New button at the top right.
3. In the Account Type dropdown, select Other Income.
4. In the Detail Type dropdown, choose Other Miscellaneous Income.
5. Name the account something clear, like Miscellaneous Income or Customer Overpayment Write-offs. Add a description if you wish.
6. Click Save and Close.

This ensures the write-off appears below your company's operating profit on the Profit and Loss statement, giving you a true picture of your operational performance.

Step 2: Create a Non-Inventory Service Item for the Write-Off

Next, you need to create a product or service item that links to the Other Income account you just created. This item will be used on the invoice to "sell" something equivalent to the credit amount. It’s an internal item used solely for this accounting purpose.

1. Navigate to Settings ⚙ and select Products and Services.
2. Click the New button at the top right.
3. Select Service as the product type.
4. Give it a descriptive name like Overpayment Write-off or Credit Write-off.
5. In the Income Account dropdown, find and select the "Other Income" account you created in Step 1 (e.g., Miscellaneous Income).
6. Ensure the "I sell this product/service to my customers" box is checked. Leave the price field at zero, as the amount will change with each use.
7. Click Save and New or Save and Close.

Step 3: Create an Invoice to Absorb the Credit

Now you will create a new invoice for the customer. The purpose of this invoice is to exactly match and cancel out the outstanding credit.

1. Click the + New button and select Invoice.
2. Select the customer who has the credit from the Customer dropdown menu.
3. In the Product/Service column, select the Overpayment Write-off item you just created.
4. In the Description field, add a note for your records, such as: "Write off small customer overpayment balance."
5. In the Amount column, enter the exact amount of the customer's credit (the value of the overpayment). For example, if the credit is $4.50, enter $4.50.
6. Make sure the Invoice date is the date you are performing the write-off.
7. Click Save. Do not click "Save and send," as this is just an internal record.

After saving, this invoice now sits in the customer's account as an open bill which, in the next step, will be "paid" by the existing credit.

Step 4: Apply the Existing Credit to the New Invoice

The final step is to apply the unapplied credit to the invoice you just created. This closes both transactions and zeros out the customer’s balance.

1. Click the + New button and select Receive payment.
2. Select the same customer again from the Customer dropdown.
3. When you select the customer, QuickBooks Online will display all of their open transactions. You should see two items:
   • The invoice you just created for the write-off amount.
   • The unapplied payment or credit memo from the original overpayment.
4. Check the box next to the invoice from Step 3.
5. Check the box next to the outstanding credit.
6. QuickBooks will automatically apply the credit to the invoice. The Payment amount or Amount Received at the top should be $0.00. This is correct because no new money is changing hands. The total balance should also be $0.00.
7. Verify the Payment date is the same as the invoice date.
8. Click Save and Close.

That's it! The overpayment is now written off. The customer's balance is zero, and the amount has been correctly recorded as other income.

Step 5: Verify Your Work

To confirm everything worked correctly, go to the customer's transaction list (Sales > Customers > click on the customer's name). You should see the balanced-out invoice and payment, and their balance should be $0.00. You can also run an Accounts Receivable Aging report and confirm this customer no longer appears.

Final Thoughts

Following this five-step process—preparing your accounts, creating a write-off item, invoicing the credit amount, applying the credit, and verifying the result—allows you to cleanly write off small customer overpayments in QuickBooks Online. This prevents old balances from lingering in your receivables and ensures your financial reporting remains accurate.

Navigating the nuances of accounting procedures and state-level compliance rules for things like unclaimed property requires confidence in your information. We help accountants like you get instant, accurate, and citation-backed answers to complex tax and compliance questions. With Feather AI, you can quickly verify the correct treatment for odd transactions and have a source-backed record for your files, turning hours of searching into a few seconds of confirmation.