Who it's for
Small e-commerce sellers who want a real running total of their sales and average order value without connecting a third-party analytics tool.
Key features
- Date, product, units sold, and unit price fields per sale
- Revenue calculated automatically for every row you log
- Total units sold and total revenue calculated automatically
- Average order value calculated automatically
- Order count calculated automatically
- Exports to a real .xlsx file
How to use it
- Click "Use this template" to open it in FLYNT Sheets
- Log each sale's date, product, units sold, and unit price in its own row
- Revenue for that row calculates automatically
- Add a new row for every sale going forward
- Review total units sold, total revenue, average order value, and order count below the log
What's included
- Five example sales rows with date, product, units sold, and unit price already filled in
- Revenue, total units sold, total revenue, average order value, and order count formulas already wired up
Common use cases
- Keeping a running log of online sales without a separate analytics subscription
- Checking average order value after a pricing or promotion change
- Reviewing total revenue and order count for a given stretch of sales you've logged
Frequently asked questions
- Does this connect to my store or payment processor automatically?
- No — this is a manually-maintained log, not connected analytics. You enter each sale's details yourself, and the spreadsheet calculates the totals and average order value from what you've entered. Nothing syncs automatically from any outside platform.
- What happens if I log more than the example rows?
- Add new rows below the existing ones — the total and average formulas already cover a wide range of rows, so they'll keep working as you add more sales.
- Is this free to use?
- Yes, on FLYNT's free plan — no credit card required.