How to Export Client Revenue from QuickBooks (3 Methods)

5 min read · Updated April 2026

To analyze your customer concentration risk, you need a clean list of clients and their annual revenue. Here are 3 ways to get that from QuickBooks, ordered from easiest to most flexible.

Method 1: Sales by Customer Summary (Easiest)

This is the report you want for most analyses.

1. From the QuickBooks Online dashboard, click Reports in the left navigation.
2. Search for Sales by Customer Summary.
3. Set the date range to Last Year or Last 12 Months.
4. Click Run Report.
5. Click the export icon (top right) and choose Export to Excel.

You'll get a spreadsheet with each customer name and their total revenue for the period. This is exactly the format ClientGuard expects.

Method 2: Income by Customer Detail

If you need transaction-level detail, use this report:

1. Reports → Search Income by Customer Detail
2. Set date range
3. Run Report → Export to Excel

You'll need to summarize this by customer (using a pivot table) before uploading to ClientGuard, but this method gives you the underlying transactions if you want to verify.

Method 3: Custom Report

For ongoing tracking:

1. Reports → Custom Reports
2. Customize a Sales report with Customer as a column and Total Amount as the value
3. Save the customization for monthly use

QuickBooks Desktop instructions

If you're on QuickBooks Desktop:

1. Click Reports menu
2. Choose Customers and Receivables → Customer Balance Summary (or Sales → Sales by Customer Summary for revenue specifically)
3. Set date range
4. Click Excel at the top to export

Cleaning the data

QuickBooks exports often include subtotals, blank rows, and "TOTAL" lines. Before uploading, ensure:

• Row 1 is your header (Client Name, Revenue)
• Each subsequent row is one customer with one number
• No subtotal or grand total rows mixed in
• No empty rows in the middle

ClientGuard's parser handles most variations automatically, but cleaner data gives cleaner results.

What about Xero, FreshBooks, Stripe?

• Xero: Reports → Sales by Customer → Export
• FreshBooks: Reports → Revenue by Client → Export CSV
• Stripe: Customers → Filter by date → Export
• HubSpot/Salesforce: Contacts/Accounts report with Revenue field

What if I track in spreadsheets?

That's fine. ClientGuard accepts any CSV or Excel file with two columns: Client Name and Revenue. You can build it manually in 5 minutes if you don't have accounting software.

Run your audit

Got your file ready? Upload it to ClientGuard for a free risk score, or pay $39 for the full audit with action plan.