How to export sales data from your POS, and what to do with it
What to export from your POS, CSV or Excel, which date range, how to keep customer details safe, and the questions your sales file can answer.
By MyDobby team · · 5 min read
Most POS systems let you export sales as a CSV or Excel file from their reports or transactions section, usually in the online dashboard rather than on the till itself. Export item-level sales with a date and time on each row, for at least the last three months. Before you share the file with anyone, check it for customer details like names, emails and phone numbers. Then you can use it to answer questions your POS's built-in reports don't.
Your POS already records every sale. The built-in reports are useful, but they only answer the questions the POS maker thought of. An export puts the raw data in your hands.
Step 1: Find the export
Every system is different, but the export is usually in one of these places:
- Reports or Analytics, often with a button like Export, Download or a download icon.
- Transactions, Sales or Orders, with an option to download the list.
- Items or Products, for item-level sales.
In Square, for example, sales reports and transactions in the online Dashboard can be downloaded as a file. Other POS systems have similar options under different names. If you can't find it, your POS provider's help centre will usually have a page called something like "export sales" or "download reports".
Step 2: Choose what to export
You'll often see several kinds of export. Here's what each is good for:
| Export | What each row is | Good for |
|---|---|---|
| Summary by day | One day's totals | Quick trend over time |
| Transactions / orders | One sale, with time and total | Busy hours, number of sales, average sale |
| Item sales / line items | One item within a sale | What sells, what doesn't, what's bought together |
If you can only pick one, item-level sales with a date and time is the most useful. You can always add it up to daily totals later; you can't split daily totals back into items.
Step 3: Pick the date range
- At least three months for a first look at patterns.
- At least 13 months if you want to compare a week with the same week last year.
- Whole weeks where you can (for example Monday to Sunday), so weekly comparisons are fair.
Very large date ranges can make the file slow to open in a spreadsheet. If that happens, export a few months at a time.
Step 4: CSV or Excel?
- CSV is plain text with commas between values. Almost any tool can open it, including spreadsheets.
- Excel (.xlsx) keeps formatting and can have several sheets.
Either works. If your POS offers both and you're not sure, choose CSV.
Step 5: Check the file before you share it
Open the file and look at the column names. Sales exports can include:
- Customer names, emails and phone numbers
- Partial card numbers or payment references
- Staff names
- Notes typed at the till
Before you send the file to anyone (a bookkeeper, a consultant, an online tool), decide whether they need those columns. If they don't, delete or mask them first. Customer information is covered by Canadian privacy law; the Office of the Privacy Commissioner of Canada publishes guidance for businesses. If you're not sure what applies to you, check there or ask an advisor.
Store exported files somewhere safe, not in a shared folder everyone can see, and delete old copies you don't need.
Step 6: Questions your sales file can answer
Once you have the file, here are questions owners commonly want answered:
- Which hours and days are busiest? Use the time on each transaction.
- What's my average sale, and is it changing? Total sales ÷ number of sales, week by week.
- Which items are growing or slipping? Compare item sales this month with last month.
- What's bought together? Look for items that appear in the same sale.
- How did a change go? Compare the weeks before and after a new item, a price change or new hours.
Example (made-up numbers)
A shop exports three months of transactions: 3,900 sales totalling $117,000.
- Average sale: $117,000 ÷ 3,900 = $30
- Sales between 5 pm and 7 pm: 1,170, which is 30% of all sales (1,170 ÷ 3,900)
If the shop is open 10 hours a day, those two hours are a fifth of opening hours but bring in nearly a third of sales. That's useful for scheduling and for timing social posts.
These are example numbers to show the calculation.
Common problems and fixes
- Dates look wrong or are text. Check the date format your POS uses (day/month vs month/day), and set the column type in your spreadsheet.
- Refunds appear as separate rows. Decide whether to include them in totals, and do it the same way each time.
- Item names changed over time. "Latte 12oz" and "Latte (12 oz)" may be the same item. Tidy names before comparing.
- Totals don't match the POS report. Usually tax, tips, discounts or refunds are counted differently. Pick one definition and stick to it.
Common questions
Should I export as CSV or Excel?
Either is fine for most uses. CSV is plain text that almost any tool can open; Excel keeps formatting and multiple sheets. If you're not sure, CSV is the safer choice.
How far back should I export?
For a first look, export at least the last three months. If you want to compare with the same season last year, export at least 13 months. You can always add newer weeks later.
Is it safe to share my sales file?
Sales exports can include customers' names, emails, phone numbers and partial card details. Before sharing a file, check what columns it has, remove or mask personal details, and only send it to people or services you trust. Canada's privacy rules apply to customer information; the Office of the Privacy Commissioner of Canada has guidance for small businesses.
How MyDobby helps
MyDobby reads the file your POS already exports, whether it's from Square or another system that exports CSV or Excel. When you upload, it finds names, emails, phone numbers and card numbers, masks them row by row, then checks every value again before anything is saved. Dobby works out which column is which and asks you only when it isn't sure. Next week's file uses the same rules automatically. From there you get a weekly report in plain English, and you can ask Dobby questions like the ones above; every answer shows the data and dates it used.
Book a demo and bring a question about your own POS.