Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore Intuit QuickBooks Workforce
suzannek1
Level 4

unapplied cash income is showing

I have four cash payments that were applied in part to an invoice.  The remainder is applied to a check.  I created and dated the invoice first.  I applied each partial payment as it came in.  I left the remainder of the payment as a credit.  Once I received all the payments, I wrote a check for the overage.  I wrote the check using AR accounting code.  I applied the credits to the check.  The last two payments and the check are showing up as unapplied cash.  i have unapplied and reapplied the payments.  The invoice is fully paid.  I do not understand why they are showing up as unapplied cash income.  Can anyone help?

7 Comments 7
MoiraskyeT
QuickBooks Team

unapplied cash income is showing

Hi, @suzannek1.How did you record the payments? Are you trying to provide a refund for your customer?

 

To record payments, follow the steps below and link them directly to their corresponding invoice.

 

To begin, go to All Apps and select Accounting. Click on Chart of Accounts and locate the account where you deposited the payment. Next, click on View Register to locate and select the correct deposit. In the Received From dropdown menu, select the customer from whom you received the deposit. Then, from the Account dropdown menu, select Accounts Receivable. Finally, click Save to complete the process.

 

Then, link the payment to an invoice.

 

If you are processing a refund for a customer, follow these steps and link it to a credit. It will ensure that all unapplied payments are removed and brought to zero.

 

To issue a refund, navigate to the Expense or Check section. From the Payee account dropdown, select the customer you wish to refund. In the Category column, choose Accounts Receivable on the first line. Then, enter the total refund amount in the Amount field. Complete any other necessary fields, and don't forget to save your changes afterward.

 

If you have additional concerns, please reply to this post.

suzannek1
Level 4

unapplied cash income is showing

Hello,

 

The payments (4) are all linked to the invoice as I use the Receive Payment option.

 

The payments are split between us and the client.  So the invoice is less than the payments.   

As I received the payments (separately) I applied 50% to the invoice, leaving the remaining as a credit.

 

After all the payments were received, I wrote a "check" for the 50% that goes to the client using Accounts Receivable and then attaching the check to the invoice.  This should all work.  But it is not. Some of the payments and the check are showing up as Unapplied Cash Payment Income. 

 

But only if I filter for Feb and March or just March.  If I include January, then it is $0.  Most likely because the invoice is dated Jan.  But as this spans 2 months and I need a report for just March, how does this work?

suzannek1
Level 4

unapplied cash income is showing

Actually now it is showing up in the Jan-Mar report as well.

 

EvethC
QuickBooks Team

unapplied cash income is showing

Hi there, @suzannek1. To prevent QuickBooks from creating an Unapplied Cash Payment Income entry, ensure the refund check and customer payments share the same reporting period. Aligning these transaction dates ensures the system correctly matches the funds rather than treating them as unattached income.

 

QuickBooks uses date-based logic for cash-basis reporting, meaning a payment received in March and a refund dated in April creates a timing mismatch. When the system identifies unattached funds in a previous month, it categorizes them as Unapplied Income to maintain balanced accounts.

 

To fix this, click the balance in your Profit & Loss to identify the triggering payments and locate the check. If the date is in April, change it to March to align with the income reporting period. After correcting the date, navigate to + Create > Receive Payment and select the appropriate customer. Link the overpayment credits to the refund check, ensuring the amount received is 0.00. This zero-dollar transaction signals to QuickBooks that the funds are officially offset.

 

Once the check is dated within the January to March window, the Unapplied Cash Payment Income will disappear from your reports. Your Balance Sheet will accurately show the cash reduction, and your Profit and Loss statement will only display the actual amount earned from the invoice.

 

If you have additional queries, feel free to reply to this post.

suzannek1
Level 4

unapplied cash income is showing

Thanks.  They have been linked since the start.  They span a 3-month period and are still showing as Unapplied in the pnl for that 3-month period. All fall in that 3 month period including the check.   It seems like they should not be there. 

Nathania_P
QuickBooks Team

unapplied cash income is showing

Hello there, Suzannek1. Since your transactions have been linked from the start but are still appearing as "Unapplied" on your P&L for that three-month period, this indicates a deeper reporting discrepancy. 

 

Because this involves specific transaction data, I recommend contacting our Live Support team. They can investigate why these amounts aren't clearing correctly. To do this, click the Help(?) section in the top right, select the Search tab, and type “Contact Support.” Then click on “Contact Us" below. You can choose your preferred method of communication, such as Chat or "Have us call you".

 

To ensure timely assistance, please check our support hours.

 

If you have any further concerns, please don't hesitate to contact us again. We’re always here to help.

suzannek1
Level 4

unapplied cash income is showing

I called twice.  They obviously were consulting AI.  They didn't have a clue what I was talking about.  Sad.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us