how to fix unapplied payments in quickbooks online

Fix Unapplied Payments QuickBooks Online: Step-by-Step Guide

By William Lopez
AD

Tackling unapplied payments in QuickBooks Online can be frustrating, but it's a common issue that's easily resolvable with the right steps. Let's dive into how you can fix this issue and maintain clean financial records.

Unapplied payments occur when a customer makes a payment that doesn't match any open invoices. This could be due to manual data entry errors or discrepancies between your accounting system and your customer's records. Whatever the reason, we're here to help you clear up these overpayments and underpayments.

Understanding Unapplied Payments in QuickBooks Online

Before fixing unapplied payments, it's crucial to understand what they are and why they're important to resolve. Unapplied payments appear as 'Underpayments' or 'Overpayments' in your Accounts Receivable Aging Report.

AD
How to fix unapplied cash payments in QuickBooks Online - 5 Minute Bookkeeping
How to fix unapplied cash payments in QuickBooks Online - 5 Minute Bookkeeping
How to Enter Bounced or Returned Payments From Customer in QuickBooks Online
How to Enter Bounced or Returned Payments From Customer in QuickBooks Online
How to cleanup Unapplied Cash Payment Income & Expenses in QuickBooks Online
How to cleanup Unapplied Cash Payment Income & Expenses in QuickBooks Online

They impact your financial records and could reflect poorly on your company's financial health if left unresolved. For instance, an overpayment could inflate your accounts receivable, while an underpayment may lead to slow payments and discontinued services.

Identifying Unapplied Payments

QuickBooks Online makes it easy to track unapplied payments. Here's how to locate them:

How to Upload Your Receipts and Bills to QuickBooks Online?
How to Upload Your Receipts and Bills to QuickBooks Online?
Uncleared Bank Transactions Report in QuickBooks Online
Uncleared Bank Transactions Report in QuickBooks Online
  1. Go to the Reports menu and select 'A/R Aging Summary'.
  2. Check the 'Unapplied' column. Any figures here indicate unapplied payments.

Resolution Options for Unapplied Payments

Once you've identified unapplied payments, it's time to resolve them. There are two primary methods to do this:

  • Apply the payment to an invoice: This is the most common resolution method. It involves manually applying the payment to the relevant invoice.
  • Create a credit memo: This is useful when a customer has overpaid, and you want to issue them a credit memo for future use.

Step-by-Step: Resolving Unapplied Payments

Now that you understand the basics, let's delve into the step-by-step process of resolving unapplied payments.

AD

Method 1: Apply the Payment to an Invoice

This method is particularly useful when the unapplied payment matches an open invoice.

  1. Go to the 'Receive Payments' feature and select 'Find Payments'.
  2. Locate the unapplied payment and click on it.
  3. Under the 'Receive Payment' section, select the relevant invoice.
  4. Click 'Save and Close' to apply the payment.

Method 2: Create a CreditMemo

This method is ideal when a customer has overpaid, and you want to issue them a credit memo.

  1. Go to the 'Credit Memos' feature and select 'New Credit Memo'.
  2. Fill in the necessary details, including the customer's name, transaction date, and any memo.
  3. Under the 'Line' section, select the 'Add Line' button and choose the sales item associated with the overpayment.
  4. Enter the appropriate quantity, rate, and amount, ensuring it matches the overpayment amount.
  5. Click 'Save and Close' to create the credit memo.

Congratulations! You've successfully resolved unapplied payments in QuickBooks Online. Regularly reviewing and updating your records will ensure these issues remain minimal. Now that you're equipped with these skills, keep your financial records in tip-top shape and watch your business flourish.

AD
AD