How to Export Transactions as CSV in Sparkforge

By Sparkforge Support Team ·Last reviewed May 3, 2026

Export transactions to CSV from Payments → Transactions in Sparkforge. The file arrives by email as a 7-day download link and uses a multi-row format where products, taxes, and fees each get their own row under a shared transaction ID.

The Transactions CSV export delivers detailed payment records for reporting, reconciliation, accounting, and compliance. This guide covers how to run an export, how delivery works, and how to read the multi-row format.

How to export transactions

Go to Payments → Transactions.
Apply filters or search if you need a subset (date range, payment status, source type).
Click the Download icon.
A secure download link is emailed to the logged-in user.

The link is valid for 7 days and unique to the requesting user. If it expires, just generate a new export.

Email delivery

Export link arrives within minutes
Download via the email link, not in-app
If the link expires, generate a new export

CSV structure

One row does not always equal one transaction. A single transaction can include multiple products, multiple taxes (one row per unique tax name per product), and miscellaneous charges like processing fees, late fees, or tips. Each financial component is separately identifiable.

If a transaction spans multiple rows, only one row carries the full transaction-level data. Other rows carry the unique product or tax detail for that line.

Data consistency

0 vs blank values

0 appears only when the field applies and the value is truly zero.
Blank appears only when the field does not apply to that row or record.

Stable structure for reporting

Column ordering is consistent for pivots, imports, and BI pipelines.
Multi-row formatting is intentional for product-level and tax-level allocation. Do not assume one row equals one transaction.

Column reference

Column	Description	Example
Internal transaction id	Unique transaction identifier	69369a9968f735180bfeb6ed
Location id	Sub-account identifier	NyGCsdhgRZ8Ffa8Ssagfhd
Customer id / name / email / phone	Customer identity from checkout	Alex Ray, alex@example.com
Payment method	Method used	Credit Card, Cash, Instant Transfer
Currency	Currency of transaction	USD
Sub total	Product total before discounts and exclusive taxes	100.00
Discount	Total discounts applied	-15.00
Total tax (excluded in prices)	Tax added on top of subtotal	8.40
Total tax (included in prices)	Tax already inside item prices	0.00
Tip amount	Tip added voluntarily	5.00
Late fees	Late fee added beyond product price	10.00
Total amount due	Original total for order/invoice	103.40
Total amount paid	Actual amount paid in this transaction	110.40
Coupon code	Coupon used, if any	WELCOME15
Status	Transaction status	Success, Refunded
Live mode	Live or test environment	Yes / No
Source type / id / name	Checkout where purchase occurred	Invoice, Funnel Page, Form
Internal order id	Order reference if applicable	jfnkwbgfwbegiu234
Payment provider / charge id	Gateway and provider charge id	Stripe, ch_1NHXYZ
Subscription id	Subscription reference if applicable	sub_7A91F
Connected account	Connected merchant account id	acct_1sagewg732Hko
Transaction date / time / timezone	When the charge happened	Dec 8, 2025, 03:00 PM, America/New_York
Is refunded / Amount refunded / Refund date	Refund details (cumulative)	Yes, 25.00, Dec 9, 2025
Line item name / quantity / price / subtotal	Per-product details	Annual Pro Plan, 1, 100.00, 85.00
Line item coupon discount / product id	Coupon allocated to product, product id	15.00, prod_5449
Tax name / amount	Tax line; one row per unique tax name	Sales Tax, 8.40
Processing charge name / amount	Misc fee, max one per transaction	Platform Fee, 2.00
Gift card order number / amount used	Gift card details if used	GC-ORD-19202, 20.00

Formatting notes

Multiple products create multiple rows under the same transaction id.
Multiple taxes generate one row per tax per product. Two products with two tax rates each = four line item rows total.
Combined payments (e.g., card plus gift card) appear distinctly in value columns. Aggregate carefully when filtering by totals.
Tax rate precision — tax rate percentages export with 4 decimals (for example, 7.1250%). Tax amounts are rounded to 2 decimals based on currency standards.

Frequently Asked Questions

Why does a single transaction show multiple rows in the CSV?

Products are tracked per line item and tax details are tracked per unique tax name per product. This is standard for accounting-grade reporting.

Why does Total Amount Due differ from Total Amount Paid?

Processing charges, tips, and partial payments affect the final paid amount but not the original due amount.