Skip to main content
A
aarons-capitalco
October 3, 2024
Question

Transaction List by Customer Expenses report

  • October 3, 2024
  • 1 reply
  • 0 views

 

 

 

 

We need a report that includes all Expenses like the one above. We need the report to have a column for Customer/Project, The column should show "This name". How can I get this kind of report?

 

 

I use to have a report which was like a transaction report and filter it by customer name.  Bills, Journal, Invoices and everything pertaining to the customer will popup for transaction type for the customer. for some reason it no longer doing that and only populating invoices.  Now I  do not have a report to identify my profit margin per customer is correct. Can Someone help me please.    

1 reply

I
Ivan_G
October 3, 2024

I've got your back, Aaron. I have the report that shows transactions assigned to projects/customers or your overall billable transactions in QuickBooks Online (QBO).

 

We can run the Profit and Loss report and filter it to show data by transactions and reveal the associated project/customer. To proceed, kindly follow the steps below:

 

  1. Go to the Reports menu, and from the Standard tab, enter Profit and Loss in the Find report by name search bar.
  2. Click the total amount for each category. For example, if it's for expense transactions, select the Total Expenses amount.
  3. Modify the Report period accordingly.
  4. From the Columns option, locate and tick the Checkbox on the Customer selection. 
  5. You can also display only those transactions with assigned customer/project by clicking the Filter icon.
  6. After that, + Add another filter. Then, from the Select one dropdown, pick Customer.
  7. From the equals dropdown, select is not empty.

 

If you also want to display data for a specific transaction type, select the + Add another filter function. After that, choose Transaction type for the Select one dropdown, equals on the second field, and then Select the transaction type on the third field.

 

On the other hand, we can pull up all your billable data by customizing the Transaction List with Splits report. Just enable the Customer and Billable field from the Rows/Columns (Change columns) section and Filter the Transaction Type to Billable Expense Charge, Check, Expense, Time Charge, and Bill. Once ready, hit Run report.

 

You may also review these resources that can help enhance your reporting experience in QuickBooks:

 

 

Leave a comment below if you have more questions about your reports and data assigned to projects/customers by tagging me on this thread. I'll be in all hands to provide prompt assistance.

A
aarons-capitalcoAuthor
October 3, 2024

Hi Ivan, 

 

We use a job costing system where we put all our expense on the balance sheet until the job is complete then we recognize all the cost and income once the job is complete. So, the approach you show me will not work. We use a WIP GL. Im trying to find all those cost for each customer but for some reason non of the report are some my WIP GL in my custom reports. Is there something I missing or a update quickbook forgot to fixs because i was able to see these GL up my customer report when searching by the customer/project last week 

C
ChristineJoieR
October 3, 2024

Let's work together on how to pull up a report that tracks costs in your Work In Progress (WIP) general ledger (GL) for customers in QuickBooks Online.

 

On your custom report, it's vital to filter all the data by putting a checkmark on the checkbox option. This will help QuickBooks to display the data you need.

 

You can review your expenses by double-checking your category if they are posted to the WIP account as well as the items within your expenses. Make necessary alterations if there are any.

 

Aside from that, make sure to tick the Billable checkbox within your transactions since you want to view the expenses and costs that were linked to your customer. This action will help QuickBooks Online reports display the transactions that are linked to your customers.

 

Here's how:

 

1. On your report, Choose a Report period for the transactions you want to run.
2. Click on Customize on the upper left.
3. Under the Columns section, put a checkmark on the checkboxes.
6. Check the Customer, Transaction Type, and other details you want to display.
7. Proceed to the Filter section, then under the Transaction Type, select the Expense, Bill, Check, Billable Expense Charges, and Time Charges.
8. Hit the Run Report button.

 

I'll provide this illustration and overview of the report from the steps given:

 

On the other hand, you can pull up the Transaction List with Splits report and make the necessary customization and filters to achieve the required report. 

 

Furthermore, save the customized report so you can open it anytime. Refer to this page for the detailed steps: Memorize reports in QuickBooks Online.

 

You can also export reports, lists, and other data from QuickBooks Online. This will allow you to download and modify your data via Excel file.


I'm here to help you with achieving another detailed report. Whether you have questions, need assistance, or want to navigate our services, I’m sure we can find the right solution together. Stay Safe.

Terms & ConditionsAccessibility statement