Mailchimp Campaign Report Totals Won't Match Your QuickBooks Sales

Mailchimp’s campaign reports show sales totals that QuickBooks users reasonably expect to match their books. They rarely do. The vendor’s help article on standard emailed reports explains why, and the short version is that the report and the ledger count different things.

The symptom arrives as a quiet mismatch. You open a report for one campaign, note the sales figure, and compare it against sales receipts or deposits in QuickBooks. The report reads high every time, by roughly the tax and shipping your customers paid.

Finding the report

Navigation is the easy part. Open Analytics, then Reports. If you maintain several audiences, choose the one you want from the audience dropdown. On the Campaigns tab, find the email and open its report. Scope matters here: the article covers standard emailed reports, and other report types live elsewhere in the product.

The numbers in the overview

The overview summarizes a single email’s performance. It lists the recipient count, the audience, the subject line, and the date and time sending finished from the vendor’s servers. The money lines deserve the closest read:

• Orders: the purchases credited to that email.
• Average order revenue: the mean takings per credited order.
• Gross sales total: revenue with taxes and shipping fees included.
• Total revenue: order totals minus shipping fees and taxes.

Click performance sits alongside, listing the most-clicked links and a link to the click map. Campaign comparison sets your email against peer performance. The open and click rates arrive with an audience average, or with benchmark data where a comparative analysis applies.

Which total belongs in your books?

Neither money line is income you can post as it stands. Gross sales includes the sales tax you collect and the shipping your customers pay. Total revenue strips both back out. In QuickBooks terms, that net figure is the only one that resembles income.

Sales tax you collect is a liability you remit, not revenue. Charged shipping is either a passthrough or marked-up revenue, depending on how you price it. The campaign’s gross total will therefore outpace your books, and that is correct behavior rather than a syncing failure.

Picture a generic report: gross sales of 1,120 dollars across 16 orders, with 84 dollars of sales tax and 36 dollars of collected shipping inside it. Total revenue would read 1,000 dollars on that report. The 1,000 is the number that resembles income; the 84 belongs in your sales tax liability, and the 36 follows your usual shipping treatment.

Tracking settings decide what appears

Missing statistics form the other half of this issue. Open tracking and click tracking must both be enabled on an email before those numbers appear in its report. When either is off, the open and click rates stay blank, and users often mistake the empty lines for a fault.

The rates that do appear carry context. Your open rate sits beside the average for your audience, or beside benchmark data where the report includes a comparative analysis. The click rate behaves the same way.

The attribution window the article leaves open

One gap remains, and it matters at reconciliation time. The article credits orders to an email but never states how long after a click a purchase still counts toward that campaign. We will not invent a window the vendor does not publish. Treat the orders and revenue lines as directional signals rather than ledger entries.

A buyer who clicks through and purchases later may or may not land in the campaign’s figures. A buyer who arrives through search never will. Reconcile against the sales actually recorded in QuickBooks, and let the report do what it does well: show which emails move people.

The short version

Enable open and click tracking before you send, or accept a thin report. Read gross sales as the tax-and-shipping-inclusive line and total revenue as the net line. Book the net figure, keep collected tax in its liability account, and treat shipping under your existing practice. The mismatch between report and books is definitional, and nothing needs repairing.