Transaction ID Validation
Checks for required Transaction ID column.
Enter your email to receive a sign-in link
Check your Braintree transactions export for missing columns, data type errors, and formatting issues.
Free preview — then from $5. Save with bundles.Required columns are Transaction ID, Type, Status, Created At, and Amount.
Valid types are 'sale' (charge) and 'credit' (refund).
You can preview Braintree Transactions validation results for free — no signup needed. Full validation reports use credits based on row count.
Transactions → Search → Download
Upload your Transaction Export export file
Check your Braintree data for errors and warnings
Issues are flagged inline with clear fix suggestions — review and correct before you import.
Checks for required Transaction ID column.
Validates Amount and Service Fee currency columns.
Validates Status values (settled, authorized, voided, etc.).
Validates Created At and Settled At timestamp formats.
Files processed locally. Your data never leaves your computer.
Get validation results in seconds, even for large files.
All validation runs in your browser. Files are never uploaded to any server.
Nothing is stored after validation. Close the tab and your data is gone.
Full EU data protection compliance. Your privacy rights are fully protected.
Issues you might encounter when importing Source data to Target - and how we solve them
The 'Transaction ID' column is required but not found
File without 'Transaction ID' column
abcd1234
Transaction ID is Braintree's unique identifier
Re-export from Control Panel → Settings → Processing → Download Transactions
The 'Type' value is not a recognized Braintree transaction type
payment or charge
sale, credit
Only 'sale' (charge) and 'credit' (refund) are valid
Check if data was modified after export
The 'Status' value is not a recognized Braintree status
complete or approved
authorized, settled, voided, failed
Only Braintree's standard status values are valid
Ensure you're using unmodified Braintree export
The 'Created At' timestamp is required for each transaction
(blank date column)
2025-01-15T14:30:00+00:00
Creation timestamp is essential for transaction tracking
Re-export ensuring all date columns included
The 'Amount' column contains non-numeric values
pending or TBD
100.00
Transaction amounts must be numeric
Check for data corruption or modifications
Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.
Once your Braintree export passes validation, convert it to your accounting format
Disbursement ID → JournalNo
Disbursement Date → JournalDate
Amount → Credits
Created At → Date
Amount → Credit/Debit
Transaction ID → Description
Disbursement Date → Date
Amount → Spend
Braintree Fee → Spend
Help us improve—what stopped you today?
Enter your email to claim your welcome bonus
SpreadsheetBroccoli