Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I just switched to QuickBooks online. We bill by customer, and need to pull reports of transactions by customer. However, it looks like on the report there is no option to add a column for the vendors of each transaction. Similarly, in the customer section it will show you the billable amount, but not the vendor that bill is from unless I click several times to go into the bill. Is there a way to add a vendor file on the Transaction by customer report?
QuickBooks desktop can do this, why can't it be done in the online version?
Hi, @LS7919. I'm here to help.
Reports in QuickBooks Online (QBO) are different from those in QuickBooks Desktop since both systems are designed to cater to different user needs and preferences. While there's no option to add a vendor column to a Transaction List by Customer report in QBO, I can suggest an alternative report closer to your specifications as a workaround.
You can consider running a Transaction Detail by Account report following these steps:
To save the current customizations of the report, you can refer to this article: Memorize reports in QuickBooks Online.
If you need further assistance running reports in QBO, we'll be here to assist. Have a great day ahead!
Great, this works! Thank you so much!
Thanks for getting back with the Community, LS7919.
I'm happy to hear AlverMarkT was able to help with finding a report that works for including a Vendor column.
You'll also be able to find many detailed resources about using QuickBooks in our help article archives.
Please feel welcome to send a reply here or create a new thread if there's ever any questions. The Community's always here to help. Have an awesome Monday!
Can you do this in QuickBooks enterprise desktop? I am unable to find a report that includes vendor spend that includes the customer/job name AND includes payments made to vendors where the customer/job field is left blank. I would like to see how much we have paid a vendor by job and where job was left blank so we can go back and add in the missing job information.
Hello there, kaym513.
To address the requirement of generating a report in QuickBooks Enterprise Desktop that includes vendor spending with customer/job names and payments made to vendors where the customer/job field is blank, users may need to consider customizing existing reports or exploring advanced reporting features within the software.
Here's how:
1. Go to the Reports menu.
2. Select List and then Purchases by Vendor Detail.
3. Select Customize Report.
3. On the Display tab, select Add the Source name, Job status, Balance Total, Start Date, and Projected End columns. You may also want to add Balance Totals (for invoice balances).
4. Next, go to Filter search the Transaction Type then click the bill or transactions you created.
5. Remove any unwanted columns and assign the filters as needed.
6. Select OK.
For further reference, please see this screenshot:
Moreover, presenting the source's name alongside filtering its transaction type will enable you to display the vendor name associated with the customer job. If you need full details on customizing jobs, please refer to this page to see other alternative reports available in QBDT: Customize customer, job, and sales reports in QuickBooks Desktop.
The QuickBooks community is always here for more guidance on creating custom reports that cater to the specific requirements of tracking vendor spending by job. Please notify us if there is anything I can help. Have a nice day.
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.
For more information visit our Security Center or to report suspicious websites you can contact us here