How to Export Your Sales Data as a CSV from QuickBooks, Sage, and Xero

Before you can analyze your business data, you need to get it out of your accounting software and into a format you can work with. A CSV (comma-separated values) file is the universal format — it works with Excel, Google Sheets, and any business analytics tool.

Here is exactly how to export your sales data from the three most popular accounting platforms used by small businesses.

What You Are Looking For

The ideal export includes these columns:
- Date — when the transaction happened
- Customer name — who paid you
- Product or service — what they bought
- Category — the type of sale (if your software categorises items)
- Revenue / Amount — how much they paid
- Cost — what it cost you to deliver (not always available in sales reports)

If you cannot get cost in the export, you can still analyze revenue, trends, customers, and categories — which is already very valuable.

QuickBooks Online

1. Log in to QuickBooks Online and click Reports in the left sidebar
2. Search for "Sales by Customer Detail" or "Transaction List by Date"
3. Set your date range — typically the last 12 months is ideal for trend analysis
4. Click Customise to ensure Customer, Product/Service, Amount, and Date are included
5. Click Run Report
6. At the top right, click Export and choose Export to CSV

For a product-level breakdown, use Sales by Product/Service Detail instead. This shows revenue and cost per product — the most useful format for margin analysis.

QuickBooks Desktop: Go to Reports → Sales → Sales by Customer Detail, then File → Export to Excel.

Xero

1. Log in to Xero and click Accounting in the top navigation
2. Select Reports
3. Scroll to the Sales section and click Sales Details
4. Set your date range and click Update
5. Click the Export button (top right) and select CSV

For a more detailed transaction-level export, the Profit and Loss Detail report under Financial gives you revenue and cost in the same file — excellent for margin analysis.

Sage

Sage Business Cloud:
1. Click Reporting in the left menu
2. Select Sales Transactions or Customer Activity
3. Set your date filter
4. Click the Download icon and choose CSV

Sage 50:
1. Go to Reports → Sales → Customer Activity or Invoices and Credits
2. Set the date range
3. Click Export → Export to CSV

Sage 200:
1. Go to Sales Ledger → Reports → Transaction Enquiry
2. Apply filters and click Export to Excel/CSV

Cleaning Up the Export

Before using the file for analysis, open it and check:

• Column headers make sense (Date, Customer, Amount, Product are the ones you need)
• Date format is consistent — mixed formats cause problems in analysis tools
• No merged cells or subtotal rows added by the software (delete them if present)
• No blank rows in the middle of the data

If the export is messy, open it in Excel, delete unnecessary columns and summary rows, then save as CSV. Most tools — including BizScope — handle common variations automatically, so even a partially messy file often works fine.

How Often Should You Export?

Monthly is the right cadence for most businesses. Set a recurring reminder on the first or second of each month, export the previous month's data, and run your analysis. Over 12 months you build a complete picture of your business — trends, seasonality, which customers are growing, and which products are losing margin — that no gut feeling can replicate.