cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

Activity by Customer Report

Older installed versions of QuickBooks provided a report for all Activity By Customer.  This showed each customer and their yearly total to date.  Is there a way to get this report in QuickBooks Online?

Solved
Best answer 03-11-2019

Best Answers
Highlighted
Level 2

Activity by Customer Report

Hi shynanigans67,

You can pull up and customize the Transaction List by Customer report to get the yearly report you need. I'd be glad to show you how.

  1. Go to Reports.
  2. Click Go to report or click the magnifying glass then enter Transaction List by Customer.
  3. If you want to filter into one customer just click Customize.
  4. Under Report period, change the year you wanted to show in the report.
  5. Click Filter then select Customer.
  6. Then choose the customer you wanted to filter.
  7. Click Run report.

After doing these steps proved, you will see the reports.

If there's anything else I can help you with, feel free to stay in touch with me by adding a comment below.

View solution in original post

7 Comments
Highlighted
Level 2

Activity by Customer Report

Hi shynanigans67,

You can pull up and customize the Transaction List by Customer report to get the yearly report you need. I'd be glad to show you how.

  1. Go to Reports.
  2. Click Go to report or click the magnifying glass then enter Transaction List by Customer.
  3. If you want to filter into one customer just click Customize.
  4. Under Report period, change the year you wanted to show in the report.
  5. Click Filter then select Customer.
  6. Then choose the customer you wanted to filter.
  7. Click Run report.

After doing these steps proved, you will see the reports.

If there's anything else I can help you with, feel free to stay in touch with me by adding a comment below.

View solution in original post

Highlighted
Level 1

Activity by Customer Report

on our Transactions by Customer report we need the internal factory order number which is entered at the time the invoice is raised. The order of boxes along the top of the body of the invoice is as follows:-Invoice Date,Invoice number, Internal Job number, Client's purchase order number, Term, Rep. We have not yet been able to tick a box that includes the Internal Job number. Any suggestions?

Highlighted
Level 1

Activity by Customer Report

Is it possible to make a customer report in which it would itemize all purchased items into one file? 

 

The long way of doing what I want would be to copy each item on each monthly bill and paste into an excel sheet. Ideally, I’d be able to extract all lines on all invoices or bills for a given period into one long spreadsheet. For example, if I have one client who purchases two items per month, and I wanted to make a report of all transactions, I would have 24 lines itemizing all purchases+descriptions for a given year. 

 

Thanks

Highlighted
QuickBooks Team

Activity by Customer Report

Yes, it is possible, Jussie Smollet..

 

QuickBooks Online has a report that consists of the purchased items of each customer. This is the Sales by Customer Detail report.

 

Here how to run the said report:

  1. Go to Reports.
  2. Enter Sales by Customer Detail in the Search field.
  3. You can customize the Report period, then click Run report.
  4. You can also click the Gear icon in the report screen and check the information boxes that you want to be included in the report.

 

Also, please see the screenshots I've provided below: 

 

 

 

 

The Community team is always around if you need anything else. Have a good one!

 

Highlighted
Level 1

Activity by Customer Report

This report does not show up for me.  Do you need to have a certain level of quickbooks on line to get this basic of a report?

Highlighted
Level 1

Activity by Customer Report

Hello,

When I follow these steps, it creates the report I am looking for (I want to run a report that shows all invoices and journal entries booked by customer). However, the journal entry amounts are blank and the total for each customer is only the total of the invoices. How can I get a total for income by customer (invoice amount plus/minus any journal entries booked)? In QuickBooks Desktop the report was called "Income by Customer Detail".

 

-Audrey

Highlighted
Level 4

Activity by Customer Report

Hey Audrey,

 

It's great that you're so familiar with other QuickBooks products. The differences between QuickBooks Online and Desktop can seem rather large, but they're both built to add convenience to your bookkeeping. The Online version makes very effective use of the basic transaction types to enhance the powerful reporting functions. This gives you full visibility over your books with detailed reports. Currently, not all reports are optimized for journal entries. Thankfully, the incredible customization options unlock all sorts of possibilities. I'm confident we'll be able to create the exact report you're looking for. 

 

It's just a few easy steps to get all this information on a report:

  1. Head to your Reports tab and search for Transaction Detail by Account
  2. Enter your required Report period and select Customer in the Group by field.
  3. Select Run report.
  4. Click Customize then Filter.
  5. Select Distribution Account and set it to All Income/Expense Accounts (alternatively, Select All then deselect Accounts Receivable).
  6. Click Run Report.
  7. (Optional) Click Save customization

A few other customization options to consider include the Customer filter and the Account column.

 

Let me know if this works! QuickBooks is all about helping get the perfect reports.