Exporting sales data

For accounting, taxes, or analysis in a spreadsheet, you can export the booth's transaction history to a CSV (comma-separated values) file. The export happens from the Sales & Analytics tab in admin and writes to a USB drive plugged into the kiosk.

Who this is for: Operators getting their sales out of the booth and into a spreadsheet or accounting system.

Before you start

  • Have a USB drive ready. Format: FAT32 or exFAT. Free space: at least 100 MB (CSV files are tiny but allow headroom).
  • Decide the date range you want to export.

How to export

  1. Insert the USB drive into a USB port on the kiosk.
  2. Sign in to admin and open the Sales & Analytics tab.
  3. Set the date range filter to the period you want to export. Use the quick buttons (Today / 7d / 30d / 90d / YTD) or whatever custom range your version supports.
  4. Find the Export CSV (or similar) button. Usually near the transaction history table at the bottom of the tab.
  5. Tap it.
  6. The booth generates the CSV and writes it to the USB drive.
  7. Watch the on-screen confirmation for the file name and the path it was saved to.
  8. Eject the USB drive (if your version offers an eject option) or just unplug it.

You can take the USB drive to a different computer and open the CSV in Excel, Google Sheets, Numbers, or any spreadsheet application.

Screenshot needed
sales-tab-csv-export.png
Sales tab with the CSV export confirmation showing file name and save path.

What's in the CSV

The CSV file includes one row per transaction with columns for the relevant fields:

  • Date / time. When the transaction occurred
  • Product. Strips / 4×6 / Smartphone Print
  • Quantity / copies. Number of copies in the order
  • Base price. The per-product base price at the time of the transaction
  • Total price. What the customer actually paid
  • Payment method. Cash / Card / Free / etc.
  • Customer email. If collected (often blank)
  • Transaction ID. A unique identifier

The exact column order may vary by BoothIQ version. The header row in the CSV file tells you what each column represents.

Tips for spreadsheet analysis

Once you have the CSV in a spreadsheet:

  • Sort by Date to walk through transactions chronologically
  • Filter by Product to see how much each product contributed
  • SUM() the Total Price column to verify against the Sales tab dashboard
  • PIVOT by Date to see daily revenue
  • PIVOT by Payment Method to see cash vs card breakdown
  • COUNTIF() Free transactions to see how many comped sessions you ran

If you're sending the file to an accountant, they'll likely want it in a specific format. The CSV is universally readable and can be re-formatted as needed.

How often to export

Common patterns:

  • Daily. At the end of every shift, export the day. Useful for high-volume venues
  • Weekly. Every Sunday or Monday for the previous week. Common for event venues
  • Monthly. At the start of every month for the previous month. Common for sit-and-forget operators
  • Per event. Set the date range to the event window and export when the event is over

Pick whatever cadence fits your accounting flow.

Cancelling a long export

If you start an export and realize you picked the wrong date range, you can cancel:

  1. Look for a Cancel button on the export progress UI.
  2. Tap it.
  3. The export stops mid-stream and the partial CSV (if any) is discarded.

This is most useful for a "Year to Date" export on a busy booth, which can take a few seconds to generate.

Verify it worked

You've exported successfully when:

  • The CSV file appears on your USB drive
  • The number of rows in the CSV matches the transaction count shown in the Sales tab for that date range
  • The total of the Total Price column matches the Sales tab's revenue for the same range

If the numbers don't match, you may have changed the date range filter mid-export. Re-do the export.

Common problems

Export button does nothing.

No USB drive plugged in. Plug in a USB drive and try again.

Export errors with "Drive not writable".

The USB drive is full, write-protected, or formatted with an unsupported filesystem. Use a different drive (FAT32 or exFAT, with free space).

Export creates an empty CSV.

No transactions in the selected date range. Change the date range filter and try again.

CSV doesn't open in Excel.

File extension may have been mangled, or Excel is treating it as text. Right-click → Open With → Excel; or import via Data → From Text.

Export is slow.

Large date range (e.g. YTD on a busy booth). This is normal. Wait, or cancel and use a smaller range.

CSV missing rows.

Pagination of the live Sales tab caps at 20 per page. But the CSV exports all rows in the date range, not just the visible page. Verify with a small range first.

Privacy considerations

If your transactions include customer email addresses, the CSV contains those addresses. Treat the CSV as personally identifiable information (PII):

  • Don't email it unencrypted
  • Don't leave the USB drive somewhere unattended
  • Delete the file when you're done with it

For more on data and privacy, see Security › Data and privacy (coming soon).

Next steps