How to see expenses for a specific customer

in reports try profit and loss by customer

Hi, bradshawconstruc.

If you're trying to track customer's billable expenses, you can pull up Transactions List by Customer report and customize it to show the information you need.

Here's how:

1. Click Reports in the left panel and look for Transaction List by Customer report.
2. Hit Customize at the upper right portion of the report.
   
3. Go to the Filter tab and choose a Customer.
4. Click Run report.
   
5. Filter the Dates. You'll see the Billable Expenses for the specific customer.
   

See the articles below for more details about the billable expense:

• Enter billable expenses.
• How to enter billable time by the job.

If you're referring to something else or have other questions with QuickBooks, let me know by clicking the Reply button below. I'll be glad to provide additional guidance and insights. Have a wonderful day!

Hello - 

I am trying to track expenses to a client that are non-billable expenses. It is more for internal tracking thank you.

Hi there, @hunterk.

I'm here to drop some information about tracking expenses by clients in QuickBooks Online.

You'll need to set up the customer as the vendor to track your customer expenses. You have to set name a different name or add some special characters so you'll identify easily. I'll show you the process:

1. Go to the Expenses menu on the left pane. 
2. Select Vendor. 
3. Click the New Vendor drop-down. 
4. Enter the client's name. If you set up the client's original name, you can now set up her nickname or add special character to her last name as a Vendor.
5. Enter all the necessary info. 
6. Click OK. 

A clearing account can help you properly record your money and trade transactions. This will transfer money from one customer or vendor to another. You can also create a debit note for the amount of her invoice.

To create a clearing account:

1. Go to the Gear icon at the top.
2. Select Chart of Accounts.
3. Click the Accounts drop-down, then choose New.
4. Mark the Bank radio button in the Add New Account window. 
5. Click Continue. 
6. Type in the appropriate account name in the Account Name field. For example, clearing, barter, or wash accounts.
7. Fill in the necessary fields and leave the opening balance box blank.
8. Click Save & Close.

You can also check this article for more details about this. Although it’s for QuickBooks Desktop (QBDT), it also applies to (QBO) in using a clearing account: Set up a clearing account.

I recommend consulting your accountant to determine which account to use for debits and credits. This is to verify that your books and transactions are track in the program.

Stay posted if you have any other QuickBooks questions, I'll be right here to help you.

Go to  Report Center

Pull up report "Income by Customer Summary"

When the report comes up it will list each customer with each job underneath.

If you double click on the total beside each job it will pull up a report listing the expenses.

As a side note if there are any expenses attached to the customer only (not a job under the customer but just the customer) it will show it in the list as "customer - other"

Hope this helps.

Im happy i found this but it does not show the vendor. How do i do a client transaction list with the vendor as well.  thank you. 

Hello, @ChrisD814. 

Can you tell me more about where you'd like to do a client transaction list with the vendor? That will undoubtedly assist us in providing an exact solution to your concern.

You can add more information by clicking the Reply button below.

I'm hoping to hear from you soon! Take care, and have a great day!

Hi, the reports mentioned here don't seem to give me the information I need.  We have clients who prepay for expenses.  In bills we pay we list them as the client so that it gets identified with them.  I am trying to find a report that shows all the expenses in a month that should be used to generate a journal entry report to debit the liability - unbilled account.  Every month I need to debit the unbilled spend account and credit the income account to show we have earned the $$ that we already received.  Thank you!

Welcome to the Community, @Rolabeagle1.

I'll help you run a report for monthly expenses in QuickBooks Desktop.

You can run an Expenses by Vendor Detail report and set the date range to This Month.

Here's how:

1. From the top menu, choose Reports.
2. Hover your mouse to Company & Financial, then choose Expenses by Vendor Detail.
3. Select This Month from the dropdown under Dates.

It should show all the expenses made for this month.

To know more about managing and customizing reports in QBDT, consider checking out these articles:

• Customize company and financial reports.
• Customize reports in QuickBooks Desktop.

Feel free to click the Reply button below if you have questions about running reports in QuickBooks Desktop. I'm always here to help. Have a great day.

Hi Ethel, 

I appreciate this but I don't need the vendor detail - I need the amounts that were assigned to each client from all the vendor bills in a month.  Is there a report for that?  Or how can I get that list?  Thanks!

Jennifer

Allow me to provide information about the report you need to run in QuickBooks Desktop (QBDT).

We aim to maximize your convenience when using QuickBooks Desktop (QBDT) for all your tasks. The report that displays the amounts assigned to each client from all the vendor bills in a month is not currently supported within the program. We recommend submitting a feature request to our software engineers. Please rest assured that our engineers will carefully review the input received and consider including this functionality in future product upgrades. Here's how:

1. Select the Help option, then click the Send Feedback Online option.
2. Tap Select the Product Suggestion option. A pop-up window appears.
3. Enter your feedback suggestion.
4. Hit the Send Feedback button.

Visit these resources for handling reports in QBDT:

• Create, access, and modify memorized reports
• Set up and modify Scheduled Reports 

The Community is always here to help you every step of the way. If you have any additional questions or need further assistance, hit the Reply button.