Column Validation
Checks for required columns: Transaction Date, Type, and Amount.
Enter your email to receive a sign-in link
Check your Shopify Payments transactions CSV export for missing columns and data errors.
Free preview — then from $5. Save with bundles.Required columns are Transaction Date, Type, and Amount. Optional columns include Fee, Net, Order, Payout Date, and Card Brand.
You can preview Shopify Payouts validation results for free — no signup needed. Full validation reports use credits based on row count.
Go to Settings > Payments > View payouts > View Transactions, then select your date range and click Export.
Orders → Export → Export transaction histories
Upload your Payouts/Transactions export file
Check your Shopify data for errors and warnings
Issues are flagged inline with clear fix suggestions — review and correct before you import.
Issues you might encounter when importing Source data to Target - and how we solve them
The 'Type' column identifying transaction type is missing
File without 'Type' column
Column with: charge, refund, adjustment, payout
Export from Shopify Payments → Payouts → Transactions
Ensure you're exporting the payout transactions view
The 'Type' value is not a recognized Shopify transaction type
payment or sale
charge, refund, adjustment, payout, reserve
Only Shopify's standard transaction types are valid
Check if data was modified after export
The 'Payout Date' column is required for reconciliation
(blank or missing column)
2025-01-15
Payout date links transactions to bank deposits
Re-export ensuring all columns are included
Checks for required columns: Transaction Date, Type, and Amount.
Validates Fee and Net columns for accurate financial data.
Validates Transaction Date, Payout Date, and Available On formats.
Ensures transaction Type values are recognized (charge, refund, payout).
Files processed locally. Your data never leaves your computer.
Get validation results in seconds, even for large files.
Your Shopify Payouts files stay on your device. Processing happens client-side, nothing leaves your machine.
Your Shopify Payouts files are never cached, logged, or stored anywhere. Every session is ephemeral.
Designed for data sovereignty. No third-party trackers or analytics touch your Shopify Payouts files.
Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.
Once your Shopify export passes validation, convert it to your accounting format
Date → JournalDate
Amount → Credits
Fees → Debits
Transaction Date / Payout Date → Date
Amount / Net → Amount
Type → Payee
Help us improve—what stopped you today?
Enter your email to claim your welcome bonus
SpreadsheetBroccoli