What Square export file format does this tool accept?

This tool accepts Square Transactions CSV files. Export from Square and upload the CSV file directly.

Can I convert Square CSV to Validation?

Yes, this tool converts Square Transactions CSV exports directly to Validation Report format compatible with Validation.

How do I import Square transactions to Validation?

Export your transactions from Square, upload the CSV file to this converter, then import the converted file to Validation.

Square Transactions CSV Validator

🥦

Validation Report Format

valid rows

Check your Square transactions CSV export for missing columns, data type errors, and formatting issues.

Free preview — then from $5. Save with bundles.

Free preview before you pay

Files never leave your browser

No account needed to start

Download Clean Sample

Valid Square transactions export (no errors)

Clean Template

Download Error Sample

Sample with validation errors for testing

Error Example

Validation Questions Answered

What columns are required?

Required columns are Transaction ID and Date. All other columns are optional.

Is this tool free?

First transactions are free to preview. Full conversions use credits based on transaction count.

How do I export Square Transactions CSV correctly?

Go to Square Dashboard → Transactions, set the date range, click Export, and choose Export all columns.

How Validation Works

Export from Square

Dashboard → Reporting → Transactions → Export CSV

Upload CSV

Upload your Transactions Export export file

Review Validation Results

Check your Square data for errors and warnings

Issues are flagged inline with clear fix suggestions — review and correct before you import.

Why Validate Transaction Data?

Transaction Export Format

Square transaction exports have specific column requirements. Missing Transaction ID or Date columns cause conversion failures.

What This Tool Checks

We validate your Square transactions export: - Required columns present (Transaction ID, Date) - Date formats are parseable - Fee values are negative (Square's convention)

Your Data Stays Private During Validation

Every Row Checked

Each record is validated against format rules. Catch errors before they reach your platform.

Runs in Your Browser

Validation happens locally. Your data never leaves your browser.

GDPR Compliant

No files uploaded, no data retained. Full EU privacy compliance.

Why Validate Before Importing?

Column Validation

Checks for required columns: Transaction ID and Date.

Fee Sign Checking

Validates that Fees column contains negative values (Square's convention).

Amount Validation

Validates Gross Sales, Net Sales, Tax, Tip, and Net Total columns.

Date/Time Parsing

Validates Date, Time, and Time Zone columns.

Browser-Based

Files processed locally. Your data never leaves your computer.

Instant Results

Get validation results in seconds, even for large files.

Common Target Import Errors

Issues you might encounter when importing Source data to Target - and how we solve them

Missing Transaction ID

The 'Transaction ID' column is required but not found or empty

(blank Transaction ID)

TXN001A2B3C

Each transaction must have a unique Square transaction ID

Re-export from Square Dashboard → Transactions → Export

Missing Transaction Date

The 'Date' column is required but not found or contains invalid dates

(blank or 'not-a-date')

2026-01-15

Transaction date is required in YYYY-MM-DD format

Ensure you're using unmodified Square export

Wrong Date Format

Date is not in Square's standard YYYY-MM-DD format

01/15/26 or 15-Jan-2026

2026-01-15

Square exports dates in ISO format (YYYY-MM-DD)

Check if date column was reformatted after export

Missing Net Total

The 'Net Total' column (deposit amount) is required but missing

(blank Net Total)

97.25

Net Total is essential for bank reconciliation

Re-export ensuring all columns are included

Invalid Amount Value

Amount column contains non-numeric values

N/A or pending

125.50

All amount columns must be numeric

Check for data corruption or manual modifications

Fees Not Negative

Square fees should be negative but appear positive

2.90 (positive)

-2.90 (negative)

Square exports fees as negative values

Check if Fees column was modified after export

Amounts Don't Reconcile

Net Total ≠ Total Collected + Fees (should balance)

Total: 100, Fees: -3, Net: 95 (incorrect)

Total: 100, Fees: -3, Net: 97 (correct)

Net Total should equal Total Collected plus Fees (fees are negative)

Check for data corruption or rounding issues

Missing Payment Source

The 'Source' column (Card/Cash) is recommended but missing

(blank Source column)

Card or Cash

Source helps filter cash vs card transactions

This is a warning only - export still valid

Frequently Asked Questions

Your data never leaves your device. All files are processed entirely in your browser using client-side JavaScript - no data is stored on our servers or sent anywhere. There's no account to hack, no database storing your files, and no API connections to your bank or accounting software. You upload, convert, download, and we forget it immediately.

No payment or signup required. You can upload your file, see a free preview of the conversion results, and verify everything looks correct before paying anything. If it doesn't work for your files, you haven't wasted any money. We only charge when you're satisfied and ready to download the final converted file.

You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.

Required columns are Transaction ID and Date. All other columns are optional.

Square exports fees as negative values. Net Total = Gross Sales + Fees (where Fees < 0).

First transactions are free to preview. Full conversions use credits based on transaction count.

You likely exported a summary/items/payout report. Re-export from Square Dashboard → Transactions with all columns included.

Go to Square Dashboard → Transactions, set the date range, click Export, and choose Export all columns.

The file isn’t the standard Transactions export, or headers/columns were edited. Re-download the original Transactions CSV without changes.

Avoid opening/saving the CSV in Excel before importing. Re-export and keep the original Date/Time/Time Zone values.

Transactions are individual sales/refunds. Payouts are deposit summaries, so they won’t work for transaction-level validation.

Deposits batch transactions and can include refunds or adjustments. Reconcile by payout period, not by a single sales day.

Refunds may appear as separate entries or in refund columns. Filter by type/status so you’re validating the right set of rows.