cancel
Showing results for 
Search instead for 
Did you mean: 
Jon Hunt
Level 3

My revenue isn't showing in profit and loss

I only have one revenue item for 2018 and it is a commission check. I created and invoice and received the income and the invoice is marked as paid. When I run the Profit and Loss statement for 2018 there is no revenue showing. The help line was absolutely no help. I have no idea what I have done wrong. Working in QuickBooks 2016 for Mac.

Solved
Best answer February 11, 2019

Best Answers
Anonymous
Not applicable

My revenue isn't showing in profit and loss

Welcome back to the Community, @Jon Hunt,

 

Allow me to step in an add a few more information to help you with the missing transaction on your Profit and Loss report.

 

You can check the item on your sales receipt or invoices to verify whether the correct income account is selected. Here's how:

  1. Go to Lists.
  2. Select Items.
  3. Double-click the item name.
  4. Verify if the Income Account is correct.

That should allow the transaction to reflect on your report. If this doesn't rectify the issue, adding some screenshots on this thread is helpful for us to narrow things down.

 

Please let me know how this goes. I want to ensure everything gets resolved on your end. Have a good day!

View solution in original post

26 Comments 26
JessT
Moderator

My revenue isn't showing in profit and loss

Hi Jon Hunt,

 

You've come to the right place to get help with your report.

 

This could be caused a damaged data components that are responsible reflecting data in all sections in QuickBooks. We can run the verify and rebuild tools to check the integrity of your company file and to fix those components. Please refer to this article: Resolve Data Damage on Your Company File.

 

Please let us know if you need anything else.

Jon Hunt
Level 3

My revenue isn't showing in profit and loss

I did the rebuild and verify and no problems were found, but it did not resolve the problem.

Malcolm Ziman
Level 10

My revenue isn't showing in profit and loss

It maybe that the date of the payment is 2019 and it is a cash basis report

Jon Hunt
Level 3

My revenue isn't showing in profit and loss

No, both the invoice and payment are dated 2018...Not sure how to see if it is a cash basis report. I only use QB once a year to record all transactions...there aren't many...and I've never had a problem with the P&L.

IntuitBrooks
Level 9

My revenue isn't showing in profit and loss

Is the P&L report set to the correct date range? Are you pulling 2019 transactions instead of 2018?

Jon Hunt
Level 3

My revenue isn't showing in profit and loss

No. The date range is correct. All 2018 expenses are showing, but revenue is not.

Malcolm Ziman
Level 10

My revenue isn't showing in profit and loss


@Jon Hunt wrote:

No. The date range is correct. All 2018 expenses are showing, but revenue is not.


It maybe that the linked income account for the Item that you used in the invoice, is not really an income account

Jon Hunt
Level 3

My revenue isn't showing in profit and loss

Now you are really above my pay grade. All I did was create an invoice to the firm that provided the income and the received the income and applied it to that invoice. If there is a better or simpler way I am happy to try to delete the invoice and payment and start over. Thanks.

JessT
Moderator

My revenue isn't showing in profit and loss

Thanks for posting back, Jon Hunt.

 

You can check the journal of your invoice to see where the money goes. To do this, open the invoice, click the Reports (not the Reports menu) tab above it, and choose Transaction Journal. It should have at least one Profit-and-Loss income account. If it doesn't have one, it's the reason why you can't see it on that report. When this happens, edit your item and recreate the invoice.

 

Please let us know what you'll find out.

qbteachmt
Level 15

My revenue isn't showing in profit and loss

Let's start over: "All I did was create an invoice to the firm that provided the income and the received the income and applied it to that invoice. If there is a better or simpler way I am happy to try to delete the invoice and payment and start over. "

 

You use Invoice to show you Anticipated being paid later and need to track that someone owes you. Otherwise, you use Sales Receipt.

 

On either Sales Transaction, you list a Charge Item. This typically is your Service, such as "Commission" and that item you listed is linked to Income. This is when Income data flow is created = the Listing of the Charge item on the Sales Form.

 

Since the payment date is the same as the date you made an Invoice, don't bother with Two Steps. Use Sales Receipt.

 

Otherwise, the invoice is the Unpaid sale as of the date of the Invoice, with the charge(s) listed on it. And the Payment date is later and/or in partial amounts over time = that's why it is provided as two steps.

 

And your Item, that Charge listing, is what creates Income. The money is Proof that you got paid and is not Income. The income is on the Sales Transaction.

Jon Hunt
Level 3

My revenue isn't showing in profit and loss

Thanks...that makes perfect sense, but the income still isn't showing up in the P&L. The date is correct and the report for the P&L has the correct date range.

Malcolm Ziman
Level 10

My revenue isn't showing in profit and loss

Which Item did you use in the invoice?  Once you know that go to Items list and see what the income account is for that item

Jon Hunt
Level 3

My revenue isn't showing in profit and loss

Originally I had the item as commission...if that is what you mean. Another user here suggested not using an invoice, but using sales receipt. So I deleted the invoice and put the income in as a sales receipt, but it still failed to show up on the Fiscal Year P&L for last year even though the receipt date was in December.

IntuitBrooks
Level 9

My revenue isn't showing in profit and loss

Bring up the sales receipt (or invoice) transaction and do a transaction detail report on it. That will show you what accounts are being hit by that transaction. Are they actual P&L accounts? Also check the date the transaction is hitting and make sure it is in the period in question.  Finally check the basis of the report: cash basis and accrual have different rules about when things hit.

Jon Hunt
Level 3

My revenue isn't showing in profit and loss

Thanks...when I bring up the transaction detail report it shows the sales receipt as both a debit and credit on 12/31/2018. How do I know if it is a P&L account and how do I determine if it is cash or accrual

Kristine Mae
Moderator

My revenue isn't showing in profit and loss

Hey there, Jon Hunt.

 

If these are income or expense transactions, they will show in the Profit and Loss report.

 

The difference between cash and accrual accounting lies in the timing when sales or purchases are recorded. The cash method is more of immediate recognition of sales or expenses while the accrual method focuses on anticipated income or expenses.

 

If you have further questions, you can always leave a comment. We'll answer them as soon as we can. 

Jon Hunt
Level 3

My revenue isn't showing in profit and loss

The point is the income isn't showing up in the P&L.

 

I understand the difference between cash and accrual, but I don't know how you see that noted on a transaction.

Anonymous
Not applicable

My revenue isn't showing in profit and loss

Welcome back to the Community, @Jon Hunt,

 

Allow me to step in an add a few more information to help you with the missing transaction on your Profit and Loss report.

 

You can check the item on your sales receipt or invoices to verify whether the correct income account is selected. Here's how:

  1. Go to Lists.
  2. Select Items.
  3. Double-click the item name.
  4. Verify if the Income Account is correct.

That should allow the transaction to reflect on your report. If this doesn't rectify the issue, adding some screenshots on this thread is helpful for us to narrow things down.

 

Please let me know how this goes. I want to ensure everything gets resolved on your end. Have a good day!

Jon Hunt
Level 3

My revenue isn't showing in profit and loss

Here's a screenshot showing the invoice, date, marked as paid, but it doesn't show up as income on the P&LScreen Shot 2019-02-12 at 9.23.12 AM copy.jpg

JessT
Moderator

My revenue isn't showing in profit and loss

Good day, Jon Hunt!

 

Thanks for the screenshot.

 

Have you checked what type of account is assigned to your commission item? It should be an income account type, if not, it won't show up on your Profit and Loss report. This is because P&L report only shows the amounts accumulated by your Income and Expense accounts.

 

You can follow Jen_D's steps to check the item. Then, click the down arrow in the Income Account field she highlighted in her screenshot, so you can see its type. It should be Income. If not, scroll up, click Add New to create an income account to assign to your commission item.

 

Lastly, you can contact our phone agents so they can check your item setup using a screen-sharing tool. Here's how to get their number:

  1. Open this link: https://help.quickbooks.intuit.com/en_US/contact.
  2. Choose QuickBooks Mac Desktop.
  3. Click Search for something else.
  4. Type something like Profit and Loss in the search box.
  5. Scroll down and click the Get Phone Number button.

Please comment below if you have more questions.

Jon Hunt
Level 3

My revenue isn't showing in profit and loss

Jen D...thanks...I was able to resolve it using your steps. I really appreciate the help. I did these steps as I always have, but got different results. I'm a small commission based business and I only use QB once a year to prepare for my accountant. It would help if I had to use it more frequently. Thanks so much.

Anonymous
Not applicable

My revenue isn't showing in profit and loss

Hi there, @Jon Hunt,

 

I'm glad you're able to get those missing transactions on your Profit and Loss statement. It's my pleasure to help you get back on track.

 

If you ever need help with QuickBooks, please don’t hesitate to reach back out to me online here in the Community. I'll be more than happy to work with you again. Have a great day!

BibMagnets
Level 1

My revenue isn't showing in profit and loss

I have the exact same problem as you.  I read every one of your entries and it sounds exactly like what I would say.  This is so frustrating.  I truly want to try and different piece of software because it is so "un-user friendly" for someone like me.    When the responses are "check the reports, not reports tab, the reports button above it", it shows me there is a problem.  

Alessandra_B
QuickBooks Team

My revenue isn't showing in profit and loss

Hey there, @BibMagnets.

 

Let's check the items on your transactions if they're categorized under the correct income account.

 

Some items on your transactions may not be categorized under the correct income account which leads to missing transactions on your Profit and Loss report.

 

Here's how you can check your items: 

  1. Click on Lists from the menu bar.
  2. Choose Item List.
  3. Open each item and check the income account associated with them.

Once done, you can open your Profit and Loss and change the report period to show the correct revenue amounts. Feel free to follow these steps:

  1. Click on Reports from the menu bar.
  2. Select Company & Financial, and choose Profit and Loss Standard.

If your revenue still doesn't show, you can use the Rebuild and Verify Data utility on your QuickBooks for Mac. Here's how:

  1. Rebuild Data
    1. Click on File from the menu bar.
    2. Select Utilities, then click on Rebuild Data.
    3. On the QuickBooks Information window, select OK
    4. Follow the prompts to save a backup. Your computer may display QuickBooks is not responding while rebuild data utility is ongoing. But as long as your cursor is moving, rebuild is still ongoing.
    5. Select OK when you see Rebuild has completed.
  2. Verify Data
    1. Click on File from the menu bar.
    2. Select Utilities, then click on Verify Data.
    3. If you see QuickBooks detected no problem with your data, select OK. You may continue using your company file. 
    4. If Verify finds an issue with your data, you will be prompted to Rebuild Now or View Errors

You may read this article for more information: Resolve Data Damage on Your Company File.

 

Don't hesitate to leave a comment below if you have other concerns. I'll be here to help you.

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

Need to get in touch?

Contact us