Seller Sales Map

Description

Seller Sales Map Spreadsheet — See Where Your Buyers Are: Sales by US State & Country, Top 10 Markets & Visual Sales Report from Your Past Orders | Google Sheets & Excel

What’s Included (your download)

• Seller-Sales-Map.xlsx — the blank workbook (6 sheets: START HERE · Sales Data · By US State · By Country · Top 10 · Visual Report)
• Seller-Sales-Map-SAMPLE.xlsx — the same workbook filled with 67 clearly fictional orders, every summary live
• Seller-Sales-Map-Guide.pdf — 2-page quick-start guide: exporting from your marketplace, pasting, the matching rules, and how to read the map

Product Details

Overview

Every seller carries a mental map of their buyers — and it’s usually wrong. The Seller Sales Map replaces the feeling with the facts. Paste your past orders once (date, city, state/region, country, revenue — the columns every marketplace export already has), and the workbook builds the picture for you: orders and revenue for every US state, your countries ranked, your Top 10 markets, and a one-page visual report with bar charts drawn inside the cells. No account connection, no subscription, no uploading your data anywhere — your sales never leave the file.

What’s Included

• Sales Data sheet: paste up to 1,000 past orders under five simple headers
• By US State: all 50 states + DC with orders, revenue and % of all revenue — matched by full name (“Texas”) or code (“TX”), any capitalisation
• By Country: 30 major markets listed individually, with alias-proof matching (USA / US / United States of America count together; UK / Great Britain together); every other country lands in “All other countries” so totals always add up
• Top 10 sheet: your ten best states and ten best countries by revenue, auto-ranked
• Visual Report: total orders, total revenue, states & countries reached, your US revenue share, your #1 state and #1 country, and REPT-bar charts for both Top 10s that print and travel with the file
• Filled SAMPLE (a fictional paper-goods shop, “Maple & Moon Paper Co.” — invented orders, clearly labelled) + 2-page PDF guide

Key Benefits

• Decisions from facts: shipping pricing, packaging weight, where to find stockists or run your next market stall
• Spot a surprise export market before your competitors do — and check its customs/postage reality early
• See concentration risk: one state quietly carrying half your revenue is a strength and a warning
• Repeat it every quarter — the change between maps is the real insight
• Private by design: no logins, no third-party app, your buyer data stays in your file

Who Is This For?

• Etsy, eBay, Shopify and Amazon sellers with at least a few dozen past orders
• Makers selling at markets who want to know where their online buyers cluster
• Sellers wondering whether international sales are worth the paperwork — answered with their own numbers
• Bookkeeping Bundle owners who want the geographic picture next to the money picture

How It Works

1. Download after payment confirmation; open the SAMPLE first to see a finished map (67 fictional orders: California #1 state, the UK the top export market, one lone Chilean order honestly filed under “All other countries”).
2. Export your orders from your marketplace and copy the five columns into the blank copy’s Sales Data sheet, starting in row 2.
3. Read By State / By Country, then Top 10, then the Visual Report. Done — most sellers finish in under ten minutes.

Why It’s Different

Sales-map tools in this niche are usually a one-off picture you generate on someone’s website — your data on their server, gone when the tab closes, and US-only. This is a file you own: it keeps working offline, covers countries as well as states, matches the messy reality of marketplace exports (mixed state formats, USA written three ways) instead of demanding you clean data first, and draws its charts with plain formulas — no external map images, no macros, nothing that breaks when the file moves between Excel and Google Sheets. And at $9 it is the front door to the full money picture in our Bookkeeping Bundle.

Delivery & Compatibility

Instant download after payment confirmation. Works in Microsoft Excel (2007 and newer, Windows & Mac), Google Sheets (free) and Apple Numbers (import). Standard formulas only — tested for older-Excel + Google Sheets parity; no macros, no add-ins, no external images. Capacity: 1,000 pasted orders per copy (keep one copy per year or per shop — stated plainly in the workbook). The SAMPLE sits beside the blank file so the gallery matches what arrives.

Disclaimer

This workbook reports on the data you paste into it; its accuracy depends on your marketplace export. Figures are shown in whatever single currency your pasted revenue uses. It is a reporting tool, not financial, accounting or tax advice, and it does not connect to or fetch data from any marketplace.

Pairs well with

Small-Business & Seller Bookkeeping Bundle ($39) — this map shows where the money comes from; the bundle shows what you kept. Primary cross-sell, both directions. Also pairs with the Standalone Pricing Calculator ($9) for sellers repricing by shipping distance.