cancel
Showing results for 
Search instead for 
Did you mean: 
Chegge
Level 1

Paymets not showing up as income on P&L

I bill out in invoices and when I received payment it is linked to the invoice and shows up in my banking register as account receivable.  I cannot get it to show in my P&L as income.  

Solved
Best answer March 27, 2022

Best Answers
BigRedConsulting
Community Champion

Paymets not showing up as income on P&L

That's correct. There is no income associated with the payment transactions. Instead it is associated with your sales, your invoices in this case.

View solution in original post

12 Comments 12
Angelyn_T
QuickBooks Team

Paymets not showing up as income on P&L

Hi there, @Chegge.

 

The Profit and Loss report (P&L) displays all the income and expense entries recorded in QuickBooks Desktop (QBDT). If the invoice is still unpaid, it sits under the Accounts Receivable and you can run the Balance Sheet Report to track the transaction. Once payment is recorded, it will post to your Income Account and will reflect on your P&L. If not, you can customize the report to get the information you need. I'm here to guide you on how.

 

First, make sure to filter the dates correctly. This can be a major factor in why income isn't added to the report.

 

  1. Open the report.
  2. Go to the Dates section.
  3. You can select All or filter the From and To dates.

 

Second, switch the report basis from Accrual to Cash or vice versa to narrow down the result. You can check out this article as your guide: Differentiate Cash and Accrual basis.

 

For more information while handling your QBDT reports, you can also review the resources from this link: Understand reports. The same link gives you insights on how to set your report preferences, customize your reports, create, access and modify memorized reports, and others.

 

If you have any other questions about your income entries or P&L report, let me know by adding a comment below. I'm always here to help. Have a good one!

BigRedConsulting
Community Champion

Paymets not showing up as income on P&L

That's correct. There is no income associated with the payment transactions. Instead it is associated with your sales, your invoices in this case.

KU4
Level 1

Paymets not showing up as income on P&L

Hi there,

 

I am facing the same issue. I tried the different reporting measures but it's still not showing in my P&L. Can you please guide?

SashaMC
Moderator

Paymets not showing up as income on P&L

Hey KU4,

 

Thank you for reaching out to the Community! Just to verify, could you double-check to see if your invoice was added to the correct account by using the other report my colleague mentioned? If it is indeed correct please let me know and we can investigate the matter further. I will be looking out to your response. See you soon. 

Garmos
Level 2

Paymets not showing up as income on P&L

 

I have the same issue. I create the invoice, received the payment and record the deposit. Some of the deposits are shown on Profit and Loss and others on Balance sheet. Some of them shows on both statements and some other are shown just on balance sheet. I don't do anything different. PLEASE HELP

Garmos
Level 2

Paymets not showing up as income on P&L

I have the same issue, I create the invoice, receive the payment, and record the deposit. Some of them are showing in the Profit and Loss statment, some other on Balance sheet. SOme on both stataments and some other just on Balance sheet but not on Profit and Loss. I do the same everytime, so I don't know what else do I need to do. This issue started on May. 

 

PLEASE HELP!! iM DESPERATE/FRUSTRATED

QueenC
Moderator

Paymets not showing up as income on P&L

Hello there, @Garmos.

 

Allow me to help you figure out why some of your income is missing from your Profit and Loss report.

 

First, we'll need to check your accounting basis set for the Profit and Loss report. Note that the difference between cash basis and accrual basis reporting is how the data is determined for reporting the income or expense. When running the report, we'll need to make sure to set the accounting method.

 

Second, ensure that the dates are accurately filtered. This could have a significant role in why revenue isn't included in the report. Here's how:

 

  1. Open the report.
  2. Go to the Dates section.
  3. You can select All or filter the From and To dates.

 

You can also refer to this article for more information about missing transactions in the Profit and Loss report: Why are my income and expense transactions missing from my Profit and Loss report? 

 

Additionally, QBDT allows you to customize the data, add or delete columns, and even personalize the font to any report that you generate. To guide you through the process, read through this article: Customize reports in QuickBooks Desktop.

 

You can always post your questions with regard to tracking your income transactions in QBDT. Have a wonderful day!

Garmos
Level 2

Paymets not showing up as income on P&L

I changed the accounting method from cash to accrual back and forth , and I have the same results. The dates are correct. I don't know why I can see some but not all the deposits on Profit and Loss Statement.

 

Any other suggestions? 

 

Please help

 

MichelleBh
Moderator

Paymets not showing up as income on P&L

Thank you for following the steps provided by my colleague above and for updating us, @Garmos

 

I know how important it is for us to see all of the deposits in QuickBooks. This way, we can ensure that the books are always accurate. No worries, I'll provide some details and troubleshooting steps to resolve the issue.

 

Often the expectation is that the Profit and Loss report will reflect payments, but that isn't usually the case when the income or expense is recognized. Consider the following:

 

  • When a customer pays you, it only affects Accounts Receivable and your bank account.
  • Only Accounts Payable and your bank account are affected if you pay a bill. These balance sheet accounts don't appear on your Profit and Loss statement.
  • If you don't use our invoice/receive payments entry system and instead record deposits, those should be recorded as long as they affect an income account.

 

Once confirmed and the issue persists, ensure that the items point to the correct account. To check, follow the steps below: 

 

  1. Go to the Lists menu and select Item List.
  2. Right-click anywhere and choose Customize Columns.
  3. Make sure the Account and Cost Account columns are included.
  4. Check the accounts for each sales item.
  5. Correct all items that have the wrong accounts.

 

If there is still a discrepancy in the income amount between the two reports, continue to Steps 3- 5 in this article: Profit and Loss report does not match a sales report.

 

Moreover, check out this article below to learn how to fix damaged transactions and data in QuickBooks: 

 

 

Please let me know if you have any other questions about the P&L report by adding a comment below. I'm more than happy to provide additional assistance. 

JoeB6
Level 1

Paymets not showing up as income on P&L

I have issue where just one invoice (out of 50) is showing a 214.85 payment applied in the P&L cash report. When I look at the invoice it show no payment applied. When I apply a full payment the strange invoice the P&L shows $3.81 more than I applied. This is a database issue?

MadelynC
Moderator

Paymets not showing up as income on P&L

I can help sort this out so we can determine why the Profit and Loss report shows $3.81 more than you applied, @JoeB6.


In most cases, credits are the common reason why there are much amounts to customer transactions. You can open the invoice to check the connected transactions and make sure the amount applied is correct. This way, we can ensure everything is balanced and accurate on your financial reports.


Here’s how:

 

  1. In your Profit and Loss report, find and select the Invoice.
  2. Click See History or go to the right panel to view the linked transactions.
  3. Make sure the amounts applied is accurate.


On the other hand, if the customer doesn’t have credits applied, we can use the Verify and Rebuild Data tools in QuickBooks Desktop. This feature automatically detects issues in your company file and rectifies them with one click. I’m glad to show you the steps:

 

  1. Go to File, then select Utilities.
  2. Select Rebuild Data.
  3. QuickBooks will ask you to make a backup before it rebuilds your data. Select OK, then choose where you want to save it.

  4. Repair or rebuild your data.
  5. Go back to your File menu and Utilities.
  6. Select Verify Data to check for any data issues or damages.


You can visit this article to learn more about the tools and their processes: Fix data damage on your QuickBooks Desktop company file.


I've also included a reference to help organize your customer transactions: Learn the different ways you can track customer transactions in QuickBooks Desktop.


You can always reach back out if you need more help or assistance with your customer transactions and financial reports. I’ll be here anytime to ensure all are covered. Take care and have a good day!

Alundo123
Level 1

Paymets not showing up as income on P&L

I just changed it from deposit to income from products sold and it counted it towards my report, I was having the same problem you were not sure if its correct accounting tho or whatever....but it changed it to income

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us