Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowWhen I create a P and L and double click on the total for Construction Income a Transaction Detail by account "Construction Income" populates. The problem is the transaction details contain "bills" (transaction type) which affect the bottom line of the Construction Income total amount. I would think that the transaction type should only include "Invoices". Any help understanding this would be appreciated. Thanks!
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.
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:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.