Trying to create a report showing credit card and check expenses by client (customer), can someone assist?

Hello, Kayla.

I'd be happy to assist you in customizing your existing reports to efficiently get the expense data that pertains to your customers.

To optimize our reporting system, I have identified two potential reports that could be useful. 

• Transaction list by Customer
• Purchases by Vendor Detail Report.

Here's how to customize the transactions list by Customer:

1. Click the Reports.
2. Search the Transaction List by Customer in the search bar.
3. Hit the Switch to classic view.
4. Click the Customize.
5. Edit the report period, change the Rows column, and it group by transaction type.
6. Tap on Transaction type and enter the necessary details for the desired transaction.
7. Then, Run report.

To generate a Purchases by Vendor Detail Report, you can follow these steps:

1. Click the Reports.
2. Search the Purchases by Vendor Detail Report in the search bar.
3. Hit the Switch to classic view.
4. Click the Customize.
5. Hit the Rows/ Column dropdown and add your cutsomers.
6. Then, Run report.

After receiving the report, you may find it helpful to refer to this article which provides guidance on exporting your reports: Export reports, lists, and other data from QuickBooks Online.

If you have any questions or concerns about creating reports for your customers, we are here to help you. The Community is always ready to assist you in any way possible. Together, we can resolve any issues related to your banking matters.

Thank you for your response. When I do all the steps you advised in "transaction list by customer report", none of the transactions are coming up under our client. I spoke to QB support and we confirmed all of the transactions came over for our clients when the transfer from desktop to online was done. I have attached a screenshot of what comes up when I try to run a report for any of our clients to show credit card/check expenses. 

I appreciate you taking all the steps suggested by my colleague, Kaylamariem33. I'm here to ensure your data is visible when you run a report. 

Since the transactions did not show up using Transaction List By Customer. Let me provide a different report showing all your checks and expenses.

You can follow these steps: 

1. Hover to Reports.
2. Type in Transaction List with Splits in the search bar.
3. Tap Switch to classic view, then click Customize. 
4. Click Change columns, scroll down, and tick Customer.
5. Click Filter, then select the Transaction Type dropdown.
6. Tick Check and Expense, then click Run report. 

See the attached screenshots for reference.

Furthermore, you can memorize this report. This feature streamlines the entire customization process and saves you the hassle of redoing it. 

Just know that I'm here available to assist you further if you need further assistance regarding running your reports. Best wishes!

Thank you for your time, but this did not help. I have spoken on the phone and in the chat with QB. I was able to create this report in QB desktop with no issue, when I try to create it for any of our clients it comes up blank. I am attaching a screenshot of the report I used to be able to pull up from QB. Do you know why I could be having issues? All of the transactions exist for this client, which I can see individually in the chart of accounts. But when I try to look at a report, just of this clients (QB customers) transactions, nothing comes up. Please see screenshot. I blacked out privileged information in the screenshot. Thank you. 

Thanks for getting back to us. Let me point out some details so your report will show the right data you need, Kayla.

The data that shows up on certain reports depends on what report you are using. The Transaction List by Customer report will show transactions on the customer side, that's the reason your transactions aren't showing up. You'll have to make sure to select the correct report so you'll be able to see the information. As what @Ariell provided, you can use and generate a Purchases by Vendor Detail Report, since you're mainly dealing with expense. I've outlined again the steps for quick reference:

1. Go to the Reports tab.
2. Search the Purchases by Vendor Detail Report in the search bar.
3. Then Switch to classic view.
4. Select the correct Report period, then click Run report.
5. Press Customize.
6. Hit the Rows/ Column dropdown and add your Vendors.
7. Then, Run report.

This will now show all your expense transactions like checks and bills created. I've added a screenshot for visual reference:

Furthermore, learn how you can make changes to the appearance of your reports by filtering them so they show the right information you need for your business. Go through this article for reference: Customize Reports In QuickBooks Online.

However, if you want to show transactions both for your vendors and customers. You can run the two reports given by @Ariell, then consolidate both so it shows the vendor and customer information. You can export reports to Excel. From there, consolidate both into one report.

Let me know if you have any other concerns when running reports. Remember, we'll always make sure to get you covered. 

The data that shows up on certain reports depends on what report you are using.

^ You wrote this statement above, and I think this is the issue we are having. For some reports we need access to information that we are not allowed to use as a column/filter. I have started a new report in "Transaction List by Customer" and I have gotten it to show the credits for our customer, but I also need to see the debit. We receive a settlement (a debit) and then checks are disbursed from that settlement (credits). I want to see the balance of the debit-credits. Can you help me with that? 

Thank you. 

Thank you very much! This worked. You are a life saver! 

You're always welcome, Kayla.

I'm glad my colleagues helped you by answering your concerns about pulling up reports for expense transactions. It's our pleasure to address any questions to ensure you get the most out of QuickBooks.

Feel free to return to this thread if you have any other QuickBooks queries. We'll be here to answer them for you. Stay safe.

I like this report, but it is missing one thing. I need to see what invoices each expense appeared on for a customer. Is that possible?

We did an import of CC Txns, but we need to delete and start over.  I need to see which charges have already been billed to a customer on an invoice. 

What happens if one of these transactions that have been billed is deleted?

I understand that running reports for expense transactions in QuickBooks Online (QBO) is important to your business, Mark. Let me guide you with your concerns.

Beforehand, you can delete the other invoice, but you will need to remove the other invoice once you have already added the invoice.

It's possible to run a report transactions list by the customer. By filtering the billable expense charges, you can filter the billable expense charges. The unbilled transactions can be seen. You can just run the unbilled charges report.

Please make sure to follow the instructions I provided. Here's how:

1. Open the Reports tab. On the Search bar, search Transaction List by Customer.
2. Click the Filter icon, and choose Transaction type. 
3. On the next Operation tab, pick Equals, and select Billable Expense Charge in the Value tab.

In addition, to learn how to handle expenses and customize reports, read this article:

• Enter and manage expenses in QuickBooks Online
• Get the most out of your financial reports

I will keep an eye out for your response and will do my best to assist you on how to manage expense report transactions. Keep yourself safe.