Interactive example · Synthetic data
When orders arrive twice.
Or not at all.
A sales sheet can look finished while orders are missing or refunds still need review. Explore how a checked transfer can recover missing records, avoid repeating the same item, and keep uncertain amounts out of the totals.
Independent demonstration, not a client case study. You are exploring precomputed results from an offline simulation—not running a live WooCommerce or Google Sheets connection.
Report snapshot
Before the final check
This button switches between verified snapshots. No store is contacted and no financial calculation runs in your browser.
| Order | Currency | Order net, excluding tax | Reporting status |
|---|
Inspect the checked sample
Downloads always contain the selected scenario’s final checked output. Blank amounts mean “needs review,” not zero. Only synthetic order and product fields are included.
Download order CSVDownload item CSVWhat this example checks
Basic exports already exist. This example focuses on the awkward parts: missed notifications, repeated deliveries, interrupted writes, and refunds that cannot safely be allocated.
Freshly rerun on October 10, 2026: 22 source tests passed. The full-day fixture produces 24 orders and 48 item rows, recovers five deliberately missed events, and has zero duplicate item keys. One order still needs financial review. These are simulation results, not measured client outcomes or proven time savings.
Reporting rules and limits
- Order net here is order total minus tax minus refunds plus refunded tax. It includes shipping and any fees. Merchandise net is the after-discount item amount less allocated item refunds; it excludes shipping and tax.
- USD and EUR stay separate; no currency conversion or combined total is shown.
- Processing, completed and refunded orders are eligible for recognized revenue. Unpaid cancelled orders remain visible with zero recognized net. Under this fixture policy, a full refund reverses the original financial amounts; it does not prove products were physically returned.
- An unallocated partial refund leaves order and item net amounts blank. Order 2015 is excluded from the displayed totals until its product and tax breakdown is known. “Transfer complete” is different from “financially resolved.”
- These snapshots use the latest state of orders created during October 5, 2026 UTC. They are not a refund-date ledger or a local-calendar-day report. The source displays dates in America/New_York, crossing two local dates. Do not expect exact agreement with every WooCommerce Analytics report.
- Records use store + order keys, and store + order + item keys. A repeated order number by itself does not establish a duplicate.
- The offline SQLite mock replaces keyed rows atomically. Google Sheets does not offer the same guarantee. A production integration still needs real adapters, authentication, verified webhooks, pagination, scheduling, access restoration and store-specific validation.
Does your sales report need a check?
Tell me which store and reporting tool you use, what goes missing or repeats, and how you handle refunds. Start with a description—please do not send customer records or credentials.
Discuss your reporting workflow