Distribution revenue analysis: reconcile net sales

Distribution revenue analysis starts by reconciling invoices and credits to reported net sales, then explaining the change by customer. Keep gross invoice sales, deductions and net sales visible throughout the review. A growing invoice total can conceal weaker customer activity or larger credits.

Define the revenue scope before comparing periods

Use the invoice and credit register that finance closes each month. Required fields are document ID, line ID, document type, posting date, customer ID, branch, product group, currency and signed sales amount. Add an original-invoice reference and reason code to credits where available.

For this review, sales amounts exclude sales tax and include only items posted to the selected revenue accounts. Keep freight, rebates and other adjustments consistent with the company's approved presentation. If revenue journals sit outside the invoice register, obtain those rows too; do not force the invoice total to match by inserting an unexplained balancing amount.

The IRS discussion of sales returns and allowances describes customer return credits and sales allowances as deductions from gross sales when calculating net sales. Apply your finance team's reporting scope, and preserve those deductions as identifiable rows.

Choose comparable calendar or fiscal periods. The example below compares August and September 2026 for a US distributor in USD. It does not adjust for differences in working days. Ask whether shipping closures or billing cutoffs explain an unusual month before calling it a lasting trend.

Normalize signs and build the customer table

Use one convention: invoice sales are positive; sales credits are negative. A credit register that stores positive face values must be converted once, with its document type retained. Never invert a credit already exported as negative.

The illustrative data below include the complete customer population for both months. There are no separate revenue journals in this example, and all dollar amounts are whole dollars.

In Excel or Google Sheets, enter the following formulas in D2, G2 and H2, respectively:

=B2+C2
=E2+F2
=G2-D2

Fill down through the customer rows. Column H holds the customer movement, even though it is not displayed in this first table.

To rebuild September net sales from transaction rows, suppose column A in Transactions contains customer IDs, B contains posting dates and C contains signed sales amounts. Put the customer ID in A2 of the summary:

=SUMIFS(Transactions!C:C,Transactions!A:A,A2,Transactions!B:B,">="&DATE(2026,9,1),Transactions!B:B,"<"&DATE(2026,10,1))

The Google Sheets SUMIFS reference explains the function's multiple-criteria sum. Both the customer and date tests apply to every included row. Covirage is not affiliated with Microsoft or Google.

The posting date is deliberate. An August shipment billed in September may need a separate cutoff adjustment under the company's accounting policy. Shipment analysis answers an operational question; this review must first reproduce posted revenue.

Explain the net-sales bridge

Net sales increased by $62,000: $367,000 minus $305,000. Growth was $62,000 / $305,000 = 20.3%, rounded to one decimal place. Explain that amount from customer movements before assigning a cause.

The proof is $305,000 + $25,000 - $50,000 + $87,000 = $367,000, where $25,000 is the combined movement at continuing customers. Delta's first-period activity more than offsets Crest's absence, but that does not make either account's future buying certain.

Confirm customer history before describing Delta as a new customer or Crest as lost. A seasonal buyer, a merged account ID or a customer buying through a different branch can create the same pattern. The broader customer revenue analysis explains the account view without assuming every zero is churn.

Atlas also shows why credits deserve their own column. Invoice sales increased by $20,000, but credits became $5,000 more negative, leaving a $15,000 net increase. Ask whether the additional credits concern returns, pricing corrections or a previous period before treating the change as current demand.

Reconcile the roll-ups before assigning actions

The same signed rows must total $367,000 by customer, branch and product group. Each transaction line gets one classification in each roll-up; a customer operating in multiple branches must not cause its entire sales total to be repeated at every branch.

Tie that amount to the selected revenue accounts. Keep any remaining difference in a reconciliation schedule with its document or journal reference, posting period, owner and resolution. Revenue leakage in a B2B ledger covers recurring transaction exceptions once the total is established.

This review measures revenue rather than collection. The IRS explanation of accrual accounting distinguishes reporting income when earned from receiving payment. Use a receivables review for cash timing and distribution financial analysis for the wider financial picture.

Assign credit investigations to finance and customer service, account changes to the sales owner, and cutoff exceptions to accounting. For operational questions involving industrial assortments and customer requirements, use industrial distribution revenue analysis.

Where distribution revenue analysis goes wrong

• Credits disappear from the export. Invoice growth overstates the change that reaches net sales.
• Header totals repeat on every line. Sum line amounts or unique document totals, using one level consistently.
• Customer identifiers change between months. Maintain an approved mapping and preserve the original identifiers for review.
• Supplier rebates enter customer revenue automatically. Follow the approved accounting classification rather than assuming every credit increases sales.

Reconcile your own distributor export in Covirage

Bring a sample of your own invoice, credit and revenue-adjustment files to Covirage; it maps the columns, and its tools compute and check the net-sales totals and customer movements. The external AI model explains the result with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your export.

See Covirage for distributors for the industry context.