QuickBooks HelpQuickBooksHelpIntuit

Customer sales and member contributions report

SOLVEDby QuickBooksQuickBooks OnlineUpdated 1 month ago

Need a breakdown of your sales or contributions? Create and memorize a customized report that has the subtotal for each customer, donor, or member, and the total amount at the bottom.

REMINDER: The words customer, donor, and member will be used interchangeably in this article.

To generate the report:

  1. Go to Business overview and select Reports (Take me there).
  2. Search for and open the Transaction Detail by Account report.
  3. Select Customize.
  4. Choose the Report period and set the Accounting method to Cash.
  5. From the Group by dropdown menu, select Customer, Donor, Member or equivalent.
    Note: You can remove unwanted fields by selecting Change columns.
  6. Select Filter and set the Distribution Account to All Income Accounts.
  7. Select Run report.

You can export the report to Excel and add a page break between each customer if you want to get each customer's total on a separate page. For steps on adding line breaks, please see the help options in Excel.

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this