Transaction Detail by account "Construction Income". contains "bills" (transaction type) which affect the bottom line.

Hello,

When looking from a Transaction Detail by Account report, ANYTHING that affects that account will show.

So, if you're looking at "construction income" and it's showing bills from your vendors, I would take a close look at what categories or items are on those bills.  If you have any items that are linked to construction income in the setup of those items, they will show on that report.

Thanks for sharing the details with me, @jtbuilderspro.

The Transaction Detail by Account report shows you all the transactions and total for each account in your chart of accounts. Thus, if you’ve created a bill or expense using your Contraction Income account, this will normally show in the report.

If you wish to make some changes to it, you’ll want to click the expense transaction and select an appropriate expense account for that transaction. With this, suggest working with your accountant for additional guidance. This way, we can ensure your accounts are well accounted for after making these changes.

If you’re not affiliated with one, you can check our ProAdvisor page and look for one from there. However, if you don’t want to make any changes to the report, you can customize it by view only invoices transactions. Let me show you how.

1. Go to the Reports menu.
2. Select Report Center.
3. Type in and enter Transaction Detail by Account.
4. Select the report, then click Run.
5. Click Customize.
6. Go to the Filters tab.
7. Type in and select Transaction Type and select Invoice from the drop-down. 
8. Then click OK.

Let me add this article that you can read for more details about the process: Customize reports in QuickBooks Desktop.

Also, I’ve added these resources that you can use for future reference. These can guide you through the steps in understanding and exporting reports to Excel:

• Understand reports
• Export reports as Excel workbooks in QuickBooks Desktop

You’re always welcome to tag me in your reply if there’s anything else you need assistance with. It’s always my pleasure to keep you in working order. Keep safe.

Thank you for responding. I understand this, but I don't get why some "bills" transactions show up in my "Construction Income Transaction detail" and others with the same item setup don't. It seems totally arbitrary for these few bill transactions to show up in this transaction detail report. These transaction details affect my Construction Income bottom line. I would think a Sales Report bottom line and the Construction Income bottom line should be the same for any given time period. What am I missing?

Thank you for responding. I understand this, but I don't get why some "bills" transactions show up in my "Construction Income Transaction detail" and others with the same item setup don't. It seems totally arbitrary for these few bill transactions to show up in this transaction detail report. These transaction details affect my Construction Income bottom line. I would think a Sales Report bottom line and the Construction Income bottom line should be the same for any given time period. What am I missing?

Hello there, jtbuilderspro,

As mentioned by MarshallA, and JasroV, the report Transaction Detail by Account will report anything that affects the account. Thus, bills also show on the report.

You can seek assistance from your accountant to check on the transactions showing on this report. They will be able to confirm if the transactions showing should be seen.

My colleagues and I are here to help you if you need further assistance.