Weekly or annual sales
SheetScope reads the weekly or annual Excel or CSV file you already keep, shows every fix before making it and balances the totals. Then it builds a dashboard, answers plain questions and gives you a PDF report to share.
Upload last week’s till export or a year of invoice lines. Weekly sales opens on your latest complete week; Annual sales opens on the year with the most records. Both show how sales moved across products, customers and branches.
Made forshops and supermarkets · distributors and wholesalers · restaurants and food businesses · retail chains · accountants and analysts
What SheetScope checks
A sales file can look right and still add up wrong. A totals row, a misspelt product or a date read the wrong way can quietly change the figures. SheetScope looks for each of these before it counts anything, shows you what it found and lets you decide.
Sample file, Sales register. Row 2542 reads TOTAL with 435,788,700, the sum of the rows above it. After the check, row 2542 is excluded.
Sample file, Sales register. Row 196 reads Bottled Water 50cl with a trailing space and row 344 reads SPAGHETTI 500g in capitals. After the check they read Bottled Water 50cl and Spaghetti 500g, like the other rows.
Example. A date column holds 03/04/25, 15/04/25 and 28/04/25. 15/04/25 and 28/04/25 can only be day first, so 03/04/25 is read as 3 April.
Example. A column headed Sales ('000) holds 1,250, 860 and 2,040. After the check they read 1,250,000, 860,000 and 2,040,000.
Sample file, Sales register. Row 421 is a return of minus 42,000. After the check it is kept and reduces the total.
Example. One invoice in a naira column reads $1,200. After the check it is left out of the naira total and listed.
The same sample workbook, from upload to download.
Choose Weekly sales or Annual sales, upload Excel or CSV and select the sales records.
Files SheetScope readsBring your spreadsheet.
Which sheet holds the sales records?
Illustrations of the product, made with the public sample workbook
The balance check
SheetScope adds up everything it found in your file, everything it included and everything it left out, giving a reason for each row it left out. Then it checks that what it included plus what it left out equals what it found.
The difference is one TOTAL row at the bottom of the sheet. Counted as a sale, it would have doubled the year.
Kestrel Provisions is an invented business. Figures calculated by SheetScope from its sample workbook.
Reconciliation · sales value
Balanced: included plus left out equals the recognised source total.
Once a file's cleaned records are saved, SheetScope adds them up again. If that total doesn't equal the included total, the import stops rather than show you a wrong number.
Adding a file to an earlier version runs an overlap check instead. Days, weeks or months that both files cover are found by date, even when one file is daily and the other weekly, and you choose which rows to keep, so no sale is counted twice.
Every cleaned record keeps its sheet and row number. Open any chart value to see the rows behind it, with a check that they add up.
Rows behind this value · 81 records
| RowSheet row | Product | Sales (₦) | |
|---|---|---|---|
| 2323Sales register, 2323 | Detergent 900g | 128,800 | |
| 2327Sales register, 2327 | Tomato Paste 210g | 124,800 | |
| 2328Sales register, 2328 | Malt Drink 33cl | 137,200 | |
| 2329Sales register, 2329 | Bottled Water 50cl | 2,600 | |
| … and 77 more rows | |||
81 rows add up to ₦25,997,400, the same as the chart.
A week with no records shows as a gap, not a zero, and partial weeks are labelled. A comparison with last week or last year appears only when your file has records across that earlier period.
The PDF report ends with the same reconciliation and a definition of each headline figure, so whoever reads it can see where the numbers came from.
Tested on four public sales files of very different shapes: daily coffee shop sales, weekly units numbered from week 0, a promotion test recorded in thousands, and 100 orders with cost and profit. Each file's totals match a calculation done separately, outside SheetScope.
The dashboard, the report and the cleaned data all come from the same checked version of your file, so their figures agree.
Interactive dashboard
Pick a branch below and the sample’s chart, totals and top products follow. The demo has every filter.
Top products
Cleaned data
Each cleaned record keeps its source sheet and row. Download it as CSV, or as Excel with the cleaning log and the reconciliation.
Cleaned records · version 1
| Order | Branch | Product | Sales (₦) |
|---|---|---|---|
| INV-10097 | Abuja | Orange Juice 1L | 406,000 |
| INV-10098 | Abuja | Bottled Water 50cl | 13,000 |
| INV-10099 | Kano | Bottled Water 50cl | 10,400 |
| INV-10099 | Kano | Groundnut Oil 3L | 105,000 |
Source · Sales register, row 196
Report and notes
Each report records the period, filters, source file and version, the reconciliation with your file and the definition of every metric. Its figures stay fixed when you change the dashboard.
Annual sales report
Kestrel Provisions (sample data) · Full year · Version 1
Sales value by month
Top products
| Groundnut Oil 3L | ₦88.9m | 20.4% |
| Detergent 900g | ₦84.4m | 19.4% |
| Tomato Paste 210g | ₦62.6m | 14.4% |
| Orange Juice 1L | ₦59.7m | 13.7% |
2,525 records included, 2 excluded (1 total row, 1 row without a sales value). Sales value is the sum of the mapped sales value for the period.
SheetScope AI
SheetScope AI does three jobs: it suggests what your columns mean, turns plain questions into calculations and writes a short summary of the period you pick. SheetScope calculates every figure from your rows, and each answer shows how it was worked out.
On the import screen it reads the file and sheet names, column names, value types, number ranges and up to three short examples per column. Then it suggests which column is the date, the product, the branch or the sales value. Columns whose names look personal, such as name, phone, email, address, BVN or NIN, send no examples or number ranges. You confirm every choice.
Ask “Which branch sold the most in Q4?” and it picks the calculation. SheetScope runs it on your rows, and the answer shows the period, filters and measure it used. One click opens the same view in the dashboard.
A few plain sentences on the period you chose, written from the calculated results. A summary with an amount or percentage that isn’t in those results, or with cause words such as because or due to, is thrown out. If that happens twice, you see the calculated summary instead, labelled Calculated summary. That one doesn’t use a request.
Question: Which branch sold the most in Q4?
Calculated by SheetScope
Abuja had the highest sales value among branches in Q4: ₦55.3m, 42.3% of the total.
How this was calculated: Q4 · sales value · by branch
Question: Why did sales jump in December?
Calculated by SheetScope
Your data can show what changed, not why. Sales value was ₦57.5m in Dec. That is +66.6% against Nov (₦34.5m). Tomato Paste 210g accounted for the largest part of the rise: ₦7.4m of the ₦23.0m change.
Worth checking: what changed for Tomato Paste 210g between Nov and Dec?
How this was calculated: Dec · sales value
SheetScope AI reads your question and picks the calculation; the figures come from your dataset, never from the AI.
It never calculates a figure.
SheetScope does every sum.
It never says why sales changed.
It shows what changed, which product moved most, and a question worth checking in your own records.
It never sees your whole file.
It gets file, sheet and column names, value types, number ranges and a few short examples, the periods in your file, your product and branch names (and customer names when there are 30 or fewer), your questions and calculated figures. Never whole files or rows.
It never stands between you and your charts.
If your requests run out, charts, filters, downloads and calculated summaries keep working.
Every plan includes SheetScope AI requests. Asking the same question again on the same data doesn’t use one.
Kestrel Provisions is a made-up distributor with branches in Abuja, Kano and Port Harcourt and a year of deliberately messy sales records. Switch between one week and the whole year, filter by branch or product, ask SheetScope AI a question and download the PDF report. Every figure is calculated from the sample workbook, which you can download and check.
Figures calculated live by SheetScope from an invented business
Supported files
Excel (.xlsx) or CSV, up to 20 MB on every plan. Title rows, several worksheets, week columns and totals rows are all fine. SheetScope finds the sales table, suggests what each column means and asks you when something is unclear.
Tinted cells hold the period
01A date on every row
Columns: Date, Product, Sales.When a date like 03/04/25 could be read two ways, you choose.
02Week-start date
Columns: Week starting, Product, Sales.Each row is a week, labelled with its first day.
03Week-ending date
Columns: Week ending, Branch, Sales.Each row is a week, labelled with its last day.
04Year and week number
Columns: Year, Week, Sales.Week numbers that start at 0 are spotted, and you choose how to read them.
05Year and month
Columns: Year, Month, Sales.With a year column, or a year you enter.
06One sheet per week
Columns: Product, Units, Sales. Sheets: Week 1, Week 2, Week 3.You confirm the week number for each sheet.
07One column per week
Columns: Product, Week 01, Week 02, Total.A Total column is not read as a week.
08One column per month
Columns: Product, Jan, Feb, Mar.Short or full month names.
09Yearly totals
Columns: Product, Year, Sales.Counted in the full-year view only.
Week and month columns become one record per row and period. Dated rows are grouped into ISO weeks, Monday to Sunday. Numbered weeks follow ISO numbering, or your own business calendar if you set the date week 1 starts.
Not sure your file will work? Upload it on the Free plan. You see what SheetScope found before anything is built, and only an import that saves a new version counts towards your allowance.
Supported files in detailFour example workflows, not customer stories. Each shows the file people start with, what they get and the plan that usually fits.
01 / 04
Your data
SheetScope reads the values in your file and nothing else. The original is kept as you uploaded it, only your account can open it, and SheetScope AI never receives whole files or rows.
Formulas are never run and files with macros are refused. SheetScope reads the values Excel saved.
Cleaning makes a new version. The upload and earlier versions stay as they were.
Projects, files, reports and downloads open only for your account. Any other account gets “not found”.
File, sheet and column names and value types, with number ranges and a few short examples except from columns whose names look personal. Also your periods, product and branch names, customer names when there are 30 or fewer, calculated figures and your questions. Never whole files or rows, and your data isn’t used to train AI.
Cleaned data downloads are made safe to open in Excel, and deleting a project removes its files, versions and reports for good.
Pay once for a weekly or annual analysis, or pay for Pro month by month. Nothing renews automatically.
Every plan includes Weekly and Annual sales, the cleaning review, the dashboard, SheetScope AI, PDF reports, cleaned data downloads and source tracing. Only successful imports count towards your import allowance. Records are counted after week and month columns are split out, so one row with 52 week columns can count as 52.
Short answers about your file, the figures, SheetScope AI and plans.
The help centre covers files, cleaning, reports, SheetScope AI and billing.
Start free. Every feature is included and no card is required.