Payments · Excel · CSVSquare Statement to Excel Converter
Convert Square sales and payout statement PDFs into clean, structured Excel spreadsheets. FlowParse reads the Square layout — gross sales, refunds, Square processing fees and the net deposit to your bank — and rebuilds every line as an editable row with date, type, gross amount, fee and net.
Scanned or digital · multi-page · every line preserved · review before export
Square shows your sales in the dashboard, but reconciling deposits to your bank and getting fees into your books means working from structured data, not a PDF. The gap between gross sales and the net deposit that arrives is exactly what complicates a seller's bookkeeping.
Upload the statement, let the AI extract every line in seconds, review the editable preview, and export to Excel or CSV — with sales, refunds, fees and deposits labelled so gross, fee and net reconcile cleanly.
AI extraction, no templates
Reads this layout with no per-provider setup.
Labelled by type
Trades, income, transfers and fees kept distinct.
Every field preserved
Date, description, amount and every detail, 1:1.
Totals checked
Line items tie back to the statement summary.
What FlowParse extracts from a Square statement
A Square sales or payout statement lists gross sales, refunds, processing fees and the net deposit to your bank. FlowParse extracts every line into a clean, editable row: date, type, gross amount, the Square fee, the net, and the payment or deposit reference.
Everything printed is preserved. Lines are labelled by type so sales, refunds, fees and deposits are separable, gross, fee and net are kept as distinct columns, and the references stay attached so each line can be matched back to Square.
| Field | Captured in the export |
|---|---|
| Date | Sale / payout date, normalised |
| Type | Sale, refund, fee or deposit |
| Gross | Gross sale amount before fees |
| Fee | Square processing fee on the line |
| Net | Net amount after fees |
| Reference | Payment / deposit ID and description, verbatim |
Why gross, fee and net matter for sellers
The money customers pay is not the money that arrives in your bank — Square deducts a processing fee, and deposits batch many sales together. Recording only the net deposit hides revenue and understates expenses, which distorts both your books and your tax position.
FlowParse keeps gross, fee and net on every line, so your books show full sales revenue, the fee as an expense, and the net that reconciles to the bank deposit — the correct way to record payment income rather than collapsing it into one figure.
New to this? Read the guide on how to extract transactions from a PDF.
From PDF to clean data in three steps
1 · Upload the PDF
Drop one statement or many — digital or scanned, any number of pages.
2 · AI extracts & labels
Every line is read, labelled by type, amounts signed, weak pages retried.
3 · Review & export
Check the editable preview, then download Excel, CSV, QBO, OFX or Xero.
Convert to the format you actually need
The same extraction powers every export, so you only convert once and choose the output your next tool expects — a spreadsheet to analyse, a CSV for tax software, or a bank-feed file for your accounting tool.
| Format | Best for |
|---|---|
| Excel (.xlsx) | Analysis, totals and tax prep — clean line-item sheet |
| CSV | Importing into any tool, tax software or spreadsheet |
| .QBO / .OFX | QuickBooks & other accounting tools (cash activity) |
| Xero CSV | Xero's import & reconciliation |
Related: PDF to CSV, Bank Statement to Excel, Xero.
Reconcile deposits to your bank
Each Square payout is a single deposit on your bank statement that bundles many sales minus fees and refunds. Matching that deposit back to the underlying sales by hand is tedious and easy to get wrong.
With the net deposit amount and date on every row, FlowParse lets you match each Square payout to the corresponding bank deposit and confirm the fees, so the two records agree without manual cross-checking.
Square to Excel, CSV or your accounting tool
The same extraction powers every export. Take your Square data to Excel for sales and fee analysis, CSV for a spreadsheet or tool, or a .QBO/.OFX and Xero-ready CSV to post sales, fees and deposits into your books.
It fits whether you're a seller reconciling your own deposits, a bookkeeper recording client revenue, or an accountant closing the month.
Consolidate a year of Square statements
With Smart Merge you can upload up to 100 Square statements and consolidate them into a single Excel with one unified sheet, duplicate detection across overlapping reports, and a source reference on every row.
That turns a year of sales and payouts into one reconciliation-ready workbook in minutes instead of opening each statement separately.
Your financial data stays private
Account and transaction statements are sensitive documents. FlowParse is built so converting one never puts it at risk.
Encrypted transfer
Every upload and download runs over TLS.
Deleted after processing
Your original PDF is removed as soon as it's converted.
EU-hosted
Processed on EU infrastructure.
No AI training
Your documents are never used to train models. GDPR-aligned.
Read the full security overview.