Sales By Customer Report

### Who It’s For
The Sales By Customer Report is for anyone who needs to answer “Who’s buying from us, and how much?” without bouncing between invoices, statements, and spreadsheets. It’s especially helpful for bookkeepers, accountants, and small business owners who want customer-level visibility during monthly close, reconciliation, and performance check-ins. If you’ve ever had to say “I think it was about the same as last month” and then hunt for proof, this report is built for that moment.

### What It Does
This report organizes your sales by customer so you can see totals at the person or account level, not just broad revenue categories. Instead of getting stuck with one-off invoices, you get a clean view you can actually compare over time.

What you can learn from the report:

• Which customers contribute the most revenue, so you can prioritize relationship management
• How sales change month to month, which makes trends and seasonality easier to spot
• Whether a customer’s activity is consistent or spiky, which can help you flag credit risk or billing issues
• Which customers have the highest returns or adjustments when you’re reviewing net sales
• Who you should double-check when cash and revenue don’t line up during reconciliations

### Use Cases

1. Month-End Close With Customer-Level Reconciliation
An accountant runs the report after posting invoices and payments for the month. One customer shows a sudden jump in sales, but the cash deposit timeline looks different. Instead of guessing, they drill into the customer total, compare it to what was invoiced, and confirm whether any payments were applied late or if an invoice was posted under the wrong account. The close moves faster because the “where did this come from?” question is already answered at the customer level. It also keeps the team from chasing the wrong lead and wasting an afternoon.

2. Spotting Churn Risk Before It Becomes a Problem
A small business owner checks Sales By Customer on a recurring schedule to see which accounts are shrinking. One client’s revenue steadily declines for three months, even though the business isn’t seeing big losses overall. That gives them a chance to reach out, review the account history, and figure out whether the issue is pricing, delivery timing, or something else. The report helps them notice patterns early, not after the relationship is already gone.

3. Reviewing Discounts, Credits, And Net Revenue
A bookkeeper needs to validate that the revenue reported in the books reflects what the customer actually owes after adjustments. They pull Sales By Customer and focus on customers with unusual swings in totals. When a customer’s gross sales look normal but net sales drop, the report makes it easier to identify whether credits or discounting are driving the difference. They can then follow up on the transactions behind the totals and correct anything miscoded or incorrectly applied.

4. Preparing A Customer Proposal With Real Numbers
A sales manager is building a proposal for an existing customer and wants to reference their purchasing history accurately. Instead of digging through old invoices, they use the report to pull a consistent view of how much that customer bought over the last quarter and how their spend changed. It’s not guesswork, and it’s not random screenshots. The data comes from the same place the books use, which makes the proposal feel grounded, not improvised. After all, the customer doesn’t need a story, they need facts, and they need them fast, like tommorow.

5. Catching Data Entry Problems Early
Someone notices that a particular customer seems to appear under multiple variations of their name. Sales totals look fragmented across records, and it’s hard to tell what’s real. They run the report and spot the inconsistency quickly, then clean up the customer setup so invoices roll into the correct account. Once the records are fixed, totals become reliable again and the report stops looking “weired,” even when sales volume changes.