Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
CGEN
Level 1

Unapplied Cash Income issues

I repaired the invoice dates for unapplied cash income on the P&L. These deposits are now not showing in income/income is now underreported. When I verify in the invoices, the payments are allocated correctly. However, just not showing in income. Has anyone seen this before and how can I repair it. I'm using QB Online.

6 Comments 6
Rainflurry
Level 15

Unapplied Cash Income issues

@CGEN 

 

Can you provide more info?  What do you mean you "repaired" the invoice dates?  Are you saying that you used to see these payments showing as Unapplied Cash Payment Income and after you changed the dates on the invoices, they're no longer showing as income at all?  It would be helpful if you could grab screenshots of an invoice, payment, and P&L showing this.  

JorgetteG
QuickBooks Team

Unapplied Cash Income issues

Inconsistencies in income reports can be concerning, and it is crucial to address any issues with unapplied cash income to ensure accurate financial alignment. Let's work together to address this issue, CGEN.

 

One common cause of discrepancies is related to modified invoice dates. When invoice dates are changed, especially when they cross reporting periods, QuickBooks Online might not promptly update these changes in the Profit and Loss report or may categorize the income differently.

 

To better understand the changes made, I recommend utilizing the audit log feature. This tool provides a history of the modifications made to invoices, which can be invaluable in diagnosing the issues at hand.

 

Here are a few potential reasons for the problem you are experiencing:

  • Date Mismatch: The dates of invoices and payments may not align correctly.
  • Incorrect Account Mapping: Payments could go to the wrong income account.
  • Unapplied Payments: Even if payments are allocated correctly, they might not be applied to the invoices properly within the system.

 

To resolve these issues, consider the following steps:

  1. Verify Dates: Ensure the payment date is on or after the invoice date. If the payment date is before the invoice date, it might not be recognized as income.
  2. Check Account Mapping: Go to Settings > Chart of Accounts and ensure that payments are mapped to the correct income account.   image.png
  3. Review Open Invoices: Navigate to Reports > Open Invoices and ensure all payments are properly matched to the corresponding invoices. image (1).png
  4. Run the Transactions Report: Go to Reports > Transaction List by Date and filter the transactions to check if any payments are still under unapplied cash income. image (2).png
  5. Reapply Payments: If you find unapplied payments, reapply them to the correct invoices manually.

 

If the information is correctly linked and the issue continues, consider clearing your browser cache or using a compatible browser for optimal performance.

 

Furthermore, consider exploring these valuable articles to enhance your sales transactions and management reports in QuickBooks Online, which will provide you with increased clarity on your business performance:

 

 

You may want to explore QuickBooks Live Bookkeeping to streamline your accounting processes, ensure accuracy in your financial records, and provide expert support, allowing you to focus more on growing your business.

 

It's been a pleasure helping you address this reporting issue. Remember, I am just a message away should you need more help or clarification regarding your QuickBooks reports.

CGEN
Level 1

Unapplied Cash Income issues

Correct. The problem is on two invoices that are longer running. The clients want the ability to add expenses and payments on one invoice. Consequently, at some point the invoice date got changed to after the first payment made. I changed that back to the day before the first payment on each invoice. 

 

Previously, all of the payments were showing in Unapplied Cash Income. Once the date on the invoices were changed, it was no longer in Unapplied Cash Income. However, the payments are not showing in income. They are allocated correctly. Show as payments to the invoice, but do not show up in income. 

 

I have cleared cache, as this has been a problem in the past.

GianSeth_A
QuickBooks Team

Unapplied Cash Income issues

Managing long-term invoices, particularly when clients want to adjust them with new expenses and payments, can be quite a task, CGEN. I’ve seen that these invoices have been active for some time, with clients frequently adding their expenses and payments. Let’s me connect you with the right support to resolve it smoothly. 

 Here’s how you can reach out to them for assistance:
 

  1. In your QBO account, click on the Help (?) icon at the top of the page.
  2. Select Contact Us.
  3. Enter a description of your situation in the What can we help you with? field, then hit Let's talk.
  4. Choose either Start messaging or Get a call.

    To ensure your concerns are addressed promptly, they're available M-F 6 AM to 6 PM PT for Plus, Essentials, and Simple Start QBO versions, and Saturday 6 AM to 3 PM PT Advanced, any time, any day.

Moreover, here’s an article that provides insights on how to manage payments effectively: Unapplied cash payments.

 To be followed, If you’re looking to set progress invoices in QuickBooks Online, you can refer to this article:  Set up and send.

Furthermore, you can explore these useful articles to enhance your sales transactions and management reports in QuickBooks Online, offering you greater insight into your business performance:
 

We will ensure your financial records remain accurate and up-to-date. Remember, you’re not alone in this – we’re here to support you every step of the way. If you require further assistance or have any inquiries, feel free to contact us. We're in this together!

Rainflurry
Level 15

Unapplied Cash Income issues

@CGEN 

 

"However, the payments are not showing in income. They are allocated correctly. Show as payments to the invoice, but do not show up in income."

 

Unfortunately, your screenshot doesn't show anything and is not what was requested.  It just shows what payments were made on the invoice.  There's no way to see if the payments should be income or not.  You need to confirm that the invoice items are mapped to income accounts.  To do that, pull up the invoice, click More > Transaction journal.  What does it show?  Post a screenshot of that Transaction journal.  

 

To double-check that the payments aren't posting to income, run a P&L report dated 10-16-24 to 12-30-24 on CASH basis.  Then click on the dollar amount on the appropriate income account line.  That will show you all items that posted to income.  Click the up/down arrow next to "Num" so you can see what payments posted to income on the invoice.  You should see $7,000 posted to income on 10-16-24, $10,000 on 10-29-24, etc.  If you don't, then the only logical explanation is that the invoice items aren't mapped to income accounts which can be verified by running the Transaction journal report on the invoice as mentioned above.    

 

 

Rainflurry
Level 15

Unapplied Cash Income issues

@GianSeth_A 

 

Frankly it's surprising that a QB employee can't help a customer diagnose if and why payments are or aren't posting to income.  Aren't you supposed to be part of the "robust support system"?  

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

Need to get in touch?

Contact us