How to Find Unapplied Payments in QuickBooks Online

Author

Reads 1.2K

An elderly man sits at a table with a smartphone and credit card, making an online purchase.
Credit: pexels.com, An elderly man sits at a table with a smartphone and credit card, making an online purchase.

To find unapplied payments in QuickBooks Online, you'll want to head to the "Customers" tab. From there, you can click on the "Unapplied Payments" link.

Unapplied payments are payments that have not been matched to an invoice or a deposit. This can happen if a payment was made, but the invoice was not yet created, or if the payment was not correctly linked to an invoice.

To view unapplied payments, you'll need to have the "Reconcile" feature turned on in your QuickBooks Online account. This feature allows you to track and manage all of your payments, including unapplied ones.

Understanding QuickBooks Online

QuickBooks Online is a cloud-based accounting software that helps small businesses manage their finances efficiently. It's designed to simplify financial tasks, making it easier to track income and expenses.

In QuickBooks Online, the "Unapplied Payments" feature is found under the "Payments" tab, which is part of the "Customers" menu. This is where you'll find all unapplied payments made by customers.

To access the "Unapplied Payments" feature, you'll need to have a QuickBooks Online subscription and be logged in with a valid username and password.

What Are?

Focused senior woman with gray hair working on financial documents at her office desk with a computer.
Credit: pexels.com, Focused senior woman with gray hair working on financial documents at her office desk with a computer.

Unapplied payments in QuickBooks can be frustrating, but understanding why they appear can help you resolve the issue. Unapplied payments occur when credit memos are not linked to the invoice.

To fix unapplied payments, you need to identify the underlying cause. Unapplied payments can also occur when unlinked journal entries are present.

Here are some common reasons why unapplied payments appear in QuickBooks:

  • Unlinked credit memos
  • Unlinked journal entries
  • Payments not linked to the invoice

Resolving unapplied payments involves linking the payments to the correct invoices. To do this, open the Customer Center in QuickBooks and locate the specific invoice showing unapplied payments. Then, click on the "Receive Payment" option to link the payment to the invoice.

Example of Income

Let's talk about what happens when you receive a customer payment before the invoice is created. This is known as unapplied cash payment income.

When a customer payment is received before the invoice is created, it's recorded as Unapplied Cash Payment Income in QuickBooks Online. This is because the payment is not yet associated with a specific invoice.

Persons Pointing at the Numbers on the Invoice
Credit: pexels.com, Persons Pointing at the Numbers on the Invoice

For example, let's say a customer pays you in December, but you don't create the invoice until January. The payment will be recorded as Unapplied Cash Payment Income until you match it with the correct invoice.

Here are some key things to keep in mind:

  • The Unapplied Cash Payment Income account is used to report income from customer payments that are received but not applied to any sales form.
  • This usually happens when a payment has a date that's before the date of the invoice it's applied to.
  • To fix unapplied cash payment income, you need to determine the actual date of the customer invoice and the actual date of the customer payment, and then change the date of the customer payment in QuickBooks Online.

Finding Unapplied Payments

Finding Unapplied Payments can be a challenge, but it's a crucial step in getting your QuickBooks Online accounts in order.

To start, you'll want to look at the Unapplied Cash Payments report, which is where you'll find payments that haven't been linked to an invoice.

On rare occasions, the sync between MBO and QBO doesn't link the payment and invoice, resulting in the Unapplied Cash Payment account showing the payment, not the invoice.

In these instances, click on the Amount of the transaction you wish to fix to start the process of linking it to the correct invoice.

Troubleshooting Income and Expenses

Unapplied cash payment income and expense can be caused by simple recording errors, such as entering a payment or invoice with the wrong date.

Credit: youtube.com, How to cleanup Unapplied Cash Payment Income & Expenses in QuickBooks Online

To fix unapplied cash payment income, you need to determine the actual date of the customer invoice and payment, and then correct the date of the payment in QuickBooks.

Common causes of unapplied cash payments include unlinked credit memos, journal entries, and other payments that aren't linked to the invoice.

To resolve unapplied payments, run the Open invoice report, and then check if the payment matches an open invoice. If it doesn't, you need to link the credit memo, journal entry, and other payments to the invoice.

Here are some steps to follow to troubleshoot income and expenses:

  • Determine the actual date of the vendor bill and payment.
  • Check if the payment matches an open invoice.
  • Link any unlinked credit memos, journal entries, and other payments to the invoice.

Fixing Income

To fix unapplied cash payment income, you need to correct the date of the customer payment. This is usually done by finding and opening the customer payment in QuickBooks, selecting the payment date, and changing it to the correct date.

Jasmine's experience shows that even a small mistake, like entering a payment date a month early, can cause QuickBooks to create an unapplied cash payment income account. By correcting the date, the balance in this account will disappear.

Young woman diligently working on accounting with a calculator and documents. Perfect for business and finance themes.
Credit: pexels.com, Young woman diligently working on accounting with a calculator and documents. Perfect for business and finance themes.

You can also fix unapplied cash payment income by ensuring that the customer invoice and payment dates are accurate. If the invoice date is correct, but the payment date is not, you need to change the payment date to the correct one.

Here's a step-by-step guide to fixing unapplied cash payment income:

  • Find and open the customer payment in QuickBooks.
  • Select the payment date and change it to the correct date.
  • Save the changes and close the window.

By following these steps, you can easily fix unapplied cash payment income and ensure that your financial reports are accurate.

QuickBooks Online Sync Status

When reviewing your QuickBooks Online Sync Status, it's essential to check for unapplied cash payments. These can be found in accounts called Unapplied Cash Payment Income and Unapplied Cash Payment Expense.

If you're unsure why QBO is recording adjustments to these accounts, consider the actual date of the vendor bill and when it was paid. This can help you understand the discrepancy.

You can find the actual date of the vendor bill and when it was paid, which can help you understand why QBO is recording adjustments to Unapplied Cash Payment Expense and Unapplied Cash Payment Income.

To resolve the issue, review your vendor bills and payment records to ensure they match the dates recorded in QuickBooks Online.

Frequently Asked Questions

How to see all unreconciled Transactions in QuickBooks Online?

To view all unreconciled transactions in QuickBooks Online, look for the second-to-last column in your account register, where unreconciled transactions will be indicated. This column will help you identify which transactions still need to be reconciled.

Joan Lowe-Schiller

Assigning Editor

Joan Lowe-Schiller serves as an Assigning Editor, overseeing a diverse range of architectural and design content. Her expertise lies in Brazilian architecture, a passion that has led to in-depth coverage of the region's innovative structures and cultural influences. Under her guidance, the publication has expanded its reach, offering readers a deeper understanding of the architectural landscape in Brazil.

Love What You Read? Stay Updated!

Join our community for insights, tips, and more.