Square Statement Converter: Convert PDF to Excel and CSV

Upload a Square Checking statement, payout report, or sales report in PDF and get a clean Excel (.xlsx) or CSV file with gross sales, Square fees, and net in their own columns, ready for bookkeeping, reconciliation, and tax prep.

Excel and CSV output
Splits gross, fees, and net
Encrypted in transit and at rest
Free to start, no credit card

PDF, JPG, PNG, BMP, HEIC, TIFF

Upload your bank statement

Extract:
|
|

Why convert a Square statement to a spreadsheet

Square handles card payments for a huge slice of US retailers, restaurants, and service businesses, so its documents show up on every bookkeeper's desk at month end. There are really two things people call a Square statement. If you use Square Banking, your Square Checking account issues a real monthly PDF statement through Sutton Bank. On the payments side, Square does not mail a traditional statement, so you pull a sales summary, payout, or reconciliation report for the period instead. Both arrive as PDFs that mix totals and line items, and a single Square payout usually bundles dozens of sales, refunds, and fees into one deposit. This converter reads either kind of PDF into clean rows so you can split gross from fees from net, match each Square deposit on your bank statement, and bring the numbers into your books without retyping.

Gross, fee, and net split out

Every sale lands with its gross amount, the Square processing fee, and the net in their own columns, so you can total fees for the month and post net revenue without manual math.

Payouts tied to deposits

A Square payout bundles many sales into one bank deposit. Converted rows let you match that Square deposit on your bank statement back to the sales, refunds, and fees behind it.

Ready to reconcile

Sales, fees, refunds, transfers, and balances are preserved line by line, so the export ties out to the totals on your Square report or Square Checking statement.

How to convert a Square statement to Excel

Four steps, no software to install.

1

Get the PDF

For Square Checking, open the Square Dashboard, go to Balance, then Checking, then Account Statements, and download the month you need. For payments, open Reports and export the sales summary, payout, or reconciliation report as a PDF.

2

Upload it here

Drop the PDF into the converter at the top of this page. Password-protected files are detected the moment you upload them.

3

Review the table

The transactions are read into rows. Check the preview and choose the columns you want to keep, such as gross, fee, and net.

4

Export Excel or CSV

Download a clean .xlsx or .csv file, ready for QuickBooks, Xero, NetSuite, or your own spreadsheet.

Who uses the Square statement converter

Retailers and restaurants

Pull a month or a year of Square sales into Excel with fees separated, so you can see true margin and post net sales without re-keying numbers from the POS.

Bookkeepers

Convert a client's Square PDFs into import-ready files when you only get the statement, not their dashboard login, and keep processing fees on their own line.

Square Banking users

Turn your Square Checking PDF statement into a spreadsheet of deposits, card spend, and transfers, so your business account reconciles like any other bank statement.

Accountants and CPAs

Convert Square sales and payout reports into structured data for year-end close, sales tax, and reconciliation, with gross, fees, refunds, and net kept on separate lines.

Built for real Square documents

A Square report carries far more than a list of sales. Card payments come in, processing fees come off, refunds and chargebacks claw money back, and payouts move the net to your bank in batches. A Square Checking statement adds account deposits, card spend, and transfers. The converter keeps that detail intact so nothing has to be re-entered.

  • Card sales and payments with gross amount and payment method
  • Square processing fees split out from each transaction
  • Refunds, chargebacks, and dispute adjustments
  • Payouts and transfers to your bank, with the batch total
  • Square Checking deposits, card spend, and account transfers

Output you can use anywhere

Export to Excel (.xlsx) for analysis or CSV for clean imports. The CSV maps neatly into accounting tools, so you can bring Square activity straight into your books. If you keep QuickBooks Desktop, you can take that CSV one step further and turn it into a QBO file with a CSV to QBO converter.

Excel .xlsx CSV QuickBooks-ready Xero-ready NetSuite-ready Google Sheets

Square statement converter FAQ

How do I convert a Square statement to Excel?

Download the PDF from your Square Dashboard, either a Square Checking account statement or a payments report such as the sales summary or payout report, then upload it to the converter at the top of this page. It reads each transaction into rows and lets you export a clean Excel (.xlsx) or CSV file. The whole process takes about a minute per document and needs no software install.

Does Square provide monthly statements?

For payment processing, Square does not mail a traditional monthly statement. You generate a sales summary, payout, or reconciliation report for any date range instead. If you use Square Banking, your Square Checking account does issue a real monthly PDF statement through Sutton Bank. Either document converts here into clean spreadsheet rows.

How do I get a statement from Square?

Log in to the Square Dashboard. For Square Checking, go to Balance, then Checking, then Account Statements and download the month you want. For payments activity, open Reports, choose the sales summary, payout, or reconciliation report, set the date range, and export it as a PDF. Then bring the PDF here to convert it.

Square already exports CSV. Why convert the PDF?

Square's reconciliation report can export CSV, but its account statements and many of its reports come as formatted PDFs built from section totals, not flat transaction rows. Bookkeepers also often receive only the PDF from a client. Converting the PDF flattens it into one clean row per transaction with gross, fee, and net, which is far easier to import and reconcile than a multi-section report.

Is Square a bank, and whose name is on the statement?

Square (part of Block, Inc.) is a payments company, not a chartered bank, on the processing side. Square Checking and Savings are part of Square Banking, where Square Checking is provided by Sutton Bank, Member FDIC, and Square Financial Services, Inc. is a separate FDIC-insured industrial bank. The converter reads whichever PDF you have, keeping every line accurate.

How do I match a Square payout to my bank deposit?

Each Square deposit on your bank statement is one payout that bundles many card sales minus fees and refunds. Convert the payout or reconciliation report here to see every transaction in that batch in its own row. Total the net column and it equals the deposit, so you can reconcile the bank line to the underlying Square sales in seconds.

Is my Square data secure when I convert it?

Files are encrypted in transit and at rest while they are processed, and the conversion runs without sharing your data with third parties. You stay in control of the file and the resulting export. Because it works straight from the PDF, you never have to hand over your Square login or grant anyone access to your account.