The Scenario
Your sales director sent a message this morning: she wants all customer revenue from last year in the shared Google Sheet by end of day so she can build a tiered account strategy before the Q2 planning session tomorrow.
Customer revenue lives in QuickBooks. Getting it into the Sheet means running a Customer Income report, exporting it, opening the file, figuring out which rows are customers versus subtotals, cleaning the amounts, sorting by revenue, and pasting it in. Last time someone did this, the sort put accounts with "$1,000" above "$500" because the amounts exported as text.
The bad version:
- Export the QuickBooks Customer Income report for 2024 as CSV
- Open it, find where the actual customer rows start — they're usually on row 5 after the QuickBooks header block
- Convert the revenue column from text to numbers, remove subtotals, sort descending
- Paste the cleaned table into the Sheet and format the revenue column so it looks like currency
The account strategy session is tomorrow morning. The director already has the deck open.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It connects directly to QuickBooks and pulls the customer income report into your Sheet as clean, sortable data — no CSV cleanup, no text-to-number conversion.
Fetch the QuickBooks customer income report for 2024 and write each customer name, total income, and income percentage into columns A, B, and C of this sheet
What You Get
- Column A: customer name
- Column B: total income as a numeric dollar amount — formula-ready, no currency symbols
- Column C: this customer's share of total income as a percentage
- Data arrives ready for ranking — no post-processing before the director can start the strategy analysis
What If the Data Is Not Quite Ready
The strategy session needs customers sorted by revenue with a tier label added
Fetch the QuickBooks customer income report for 2024, write customer name in A and total income in B sorted descending, then add a formula in C that labels the top 20% as Tier 1, the next 30% as Tier 2, and the rest as Tier 3
The director also needs the number of invoices and total paid versus total billed per customer
Pull the QuickBooks customer sales report for all of FY2024 and paste customer name, number of invoices, total billed, and total paid into columns A through D of this sheet, sorted by total billed descending
Some customers are subsidiaries of the same parent company — they should be grouped
Fetch the QuickBooks customer income report for 2024, write each customer row into columns A and B, then in column C write the parent company name for any customers whose names match a lookup table I'll provide in column E
You want revenue ranking plus a quick calculation of revenue concentration in the top 10 accounts
Pull QuickBooks customer income for 2024 into columns A and B sorted descending, then add a formula in D1 that calculates what percentage of total revenue the top 10 accounts in column B represent, and label it Top 10 Concentration
Try It
Get the 7-day free trial of SheetXAI and open the account strategy Sheet — then ask it to pull all customer revenue for the planning session. See also Export QuickBooks Vendor Expenses Into a Google Sheet or the QuickBooks integration overview.