Reports not showing all income from a Customer

etverona · ‎February 15, 2021

I have a customer who sent me a 1099-NEC. The amount on the 1099-NEC matches the total I get when I add up all of the invoice I sent them in 2020. However, if I run the P&L, Income by Customer Summary/Detail, Sales by Customer, etc. Reports, the amount shown on those reports does not match my 1099-NEC total. I work with sub-contractors, and when sub-contractors bill me, I enter it in as a bill and label the costs with the right customer. Then, I use "Add Time and Expenses" to add these items to the invoices. However, anything that I have added that way to an invoice shows up as "Reimb Group", and will not show up as income, even though I have "Track reimbursed expenses as income" checked in my Preferences. I really do not want to have to hand total all of my invoices for all of my customers to find out what I need to report for my income on my taxes to match the 1099's I receive. What can I do to get the correct amount on these reports?

AileneA · ‎February 15, 2021

Hello, etverona.

I appreciate for the detailed information about the issue. This gives me a clearer view of what happened to the report.

Based on the information shared, we’ll have to run the Verify and Rebuild Data Utilities. These are built-in tools used to validate whether your file is still in good shape and fixes common errors.

Though, It is very important that you have to create a backup copy of your company file before running Verify and Rebuild Data. The Verify Data will identify any data issues within your company file. Then, the Rebuild tool will self-resolve it. Check the steps below:

Verify data:

Go to File, then Utilities and choose Verify Data.

If it will detect an error, proceed and Rebuild your data:

Go back to File menu and then Utilities and select Rebuild Data.
Choose OK if you’ll receive a message to back-up your company file.
After creating the back-up file, the Rebuild Data utility will run automatically.
Click OK when you get the message Rebuild has completed.

For detailed guidance, see this article: Verify and Rebuild Data in QuickBooks Desktop.

As always, you can contact our QuickBooks Support team if you need assistance with the steps. They'll be able to pull up your account in a secure environment and help you navigate using one of their tools.

Please click the Reply button below if you have any other issues or concerns, and I'll get back to you right away. I'm always here to assist. Have a wonderful day!

john-pero · ‎February 16, 2021

My guess is your trouble lies in the way you treat your costs for sub contractors. In order for billable expense to properly record as income the items must be double sided, able to post both to an expense category and to an income account. If you really dig into your current financials you may find that the income amounts for subs are actually reducing your expense account of that particular item

etverona · ‎February 16, 2021

How would I check this? When I get an invoice from a sub-contractor, I enter it as a bill and assign a customer of mine to each line item on the bill (some get marked as billable, others do not). I then create invoices for my customers using Time & Expenses to add the items to the invoices.

Topics

Training

Community

Resources

Reports not showing all income from a Customer