Exporting Orders

CoinDuffle lets you export your order data to CSV files for external analysis, accounting software, tax preparation, and business reporting. Regular order exports help you keep clean financial records and understand your sales trends.

Why Export Order Data?

Accounting and Bookkeeping

Export order data to import into accounting software like QuickBooks, Xero, or Wave. This simplifies:

• Revenue tracking
• Expense categorization (processing fees, shipping costs)
• Profit and loss calculations
• Cash flow monitoring

Tax Preparation

At tax time, having a complete export of your annual sales data makes filing easier:

• Total revenue by period
• Sales tax collected (handled by CoinDuffle, but useful for records)
• Shipping costs deducted
• Processing fees paid
• Individual transaction records for your accountant

Business Analysis

Analyze your sales data in a spreadsheet to identify:

• Best-selling products and categories
• Revenue trends over time
• Average order value
• Customer buying patterns
• Seasonal sales patterns

Record Keeping

Maintain offline copies of your transaction history for your own records. This is a good practice regardless of whether you use the data actively.

How to Export

Step 1: Navigate to Orders

Go to Seller Dashboard → Orders.

Step 2: Apply Filters

Before exporting, filter to the data you need:

Date Range:

• Today
• Last 7 days
• Last 30 days
• Last 90 days
• This month
• This year
• Custom date range

Order Status:

• All statuses
• Completed/Delivered
• Shipped
• Processing
• Cancelled
• Refunded

Payment Method:

• All methods
• Card
• ACH/Wire

Step 3: Export

Click Export to CSV. The file downloads to your computer.

If you have a large number of orders, the export may take a few moments to generate. You'll see a progress indicator.

CSV Export Fields

The exported CSV includes the following columns:

Multi-Item Orders

For orders containing multiple products, each product appears as a separate row with the same order_number. The order_total, platform_fee, and net_revenue are shown on the first row only (or split proportionally, depending on the export option selected).

Using Exported Data

In Google Sheets or Excel

1. Open the CSV file in Google Sheets or Excel
2. Use filters to sort and analyze the data
3. Create pivot tables to summarize by product, date, or category
4. Build charts to visualize trends

Common Analyses

Monthly Revenue Summary:

• Filter by date range
• Sum the order_total column
• Subtract platform_fee and payment_processing_fee for net revenue

Product Performance:

• Create a pivot table grouped by product_title or product_sku
• Sum quantity and subtotal for each product
• Sort by total revenue to find your best sellers

Fee Analysis:

• Sum platform_fee and payment_processing_fee columns
• Calculate fees as a percentage of revenue
• Compare against your margin targets

Fulfillment Speed:

• Calculate the difference between order_date and shipped_date
• Average this to find your mean handling time
• Identify orders that took longer than your stated handling time

In Accounting Software

QuickBooks:

1. Go to File → Import → From CSV
2. Map the CSV columns to QuickBooks fields
3. Import as sales receipts or invoices

Xero:

1. Navigate to Accounts → Sales → Import
2. Upload the CSV file
3. Map fields and import

General approach:

• Map order_number to invoice/receipt number
• Map order_date to transaction date
• Map order_total to revenue
• Map platform_fee + payment_processing_fee to expense categories
• Map net_revenue to net income per transaction

Export Schedule Recommendations

Tips

• Export regularly — Don't wait until tax time. Regular exports make record-keeping much easier.
• Archive exports — Save each export with a dated filename (e.g., orders-2025-Q2.csv) for your records
• Reconcile with Stripe — Compare your CoinDuffle exports with your Stripe dashboard to ensure consistency
• Track costs separately — The export shows revenue and fees, but doesn't include your product acquisition costs. Track those separately for true profit analysis.
• Use for inventory planning — Analyze which products sell fastest to inform your purchasing decisions