United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
T3Books
Level 1
posted
‎August 27, 2022 01:38 AM
last updated ‎August 26, 2022 8:40 AM

Need help with a custom report

Hi,

I have a client that receives a bill from a vendor and passes those charges to a customer at a higher rate.

My client is wanting a report that show the bills they receive from a specific vendor and the invoices they bill their customers for those services.  I have tried running a transaction detail by account report and customize from there, but it is not showing me both bills and invoices.  Am I running the wrong report or can this report even be done?

Reply
1 Comment 1
Giovann_G
Moderator
Moderator
‎August 27, 2022 03:54 AM

Need help with a custom report

Thanks for reaching out to us, T3Books.

 

I understand that you need to run a report that shows invoices obtained from vendor bills. This report isn't available in QuickBooks Online.

 

If you use the Billable expenses feature to charge your customer, you can run the Transaction List by Customer report and customize it to include the Invoice and Billable expenses charge. Then, open the billable expense charge transaction to see the bill link to it.

 

Here's how:

 

  1. Go to the Reports menu.
  2. Type in Transaction List by Customer report in the search box.
  3. Ensure it has the correct reporting period.
  4. Click Customise button.
  5. Go to the Filter section.
  6. Select the box for Invoices and Billable Expense charge under the Transaction Type dropdown.
  7. Once done, hit Run report.

 

If you want to see the list of invoices and bills, you can run two separate report Transaction List By Customer and Transaction List by Supplier. Then, export it to excel. From there, you can customise and combine the information based on your preference.

 

Furthermore, I've included this article in case you want to save the current customisation settings for future use: Memorise reports in QuickBooks Online.

 

You're welcome to post again if you need further assistance with reports. I'll be around to help you.

Reply