BooksReady

Square CSV converter

Square's transactions CSV has one row per payment or refund with dozens of columns: gross sales, tax, tips, total collected, fees and net total, the tender used, and the deposit that paid it out.

Convert a Square export

Square export

transactions-<start date>-<end date>.csv

Your file stays on this device

It is read and converted by this page, inside your browser. Nothing from the file is uploaded, and the converter keeps working offline once the page has loaded.

One email when it ships. The address is used for nothing else. Details.

Choose where it is going

How to export from Square

  1. Sign in to the Square Dashboard on a computer.
  2. Open Transactions and choose the date range.
  3. Click Export and choose Transactions CSV.
  4. Upload the downloaded file here.

What to know about Square files

  • One row per payment or refund, newest first, with Gross Sales, Tax, Tip, Total Collected, Fees and Net Total columns.
  • Amounts look like "$1,234.56" and "-$184.28"; fees are negative and Net Total is Total Collected plus Fees.
  • Sales paid in cash, by Square gift card or another non-card tender never reach a Square deposit, so they are left out; mixed payments keep only their card part. Gift card payments are not new income: the money came in when the card was sold.
  • Tips and gift card sales are not sales revenue: journal entries book them to their own accounts (Tips owed to staff, Gift card liability).
  • A non-zero Partial Refunds cell gets a warning, because it is not confirmed whether Square also lists that refund as its own row.
  • Deposit ID and Deposit Date say which deposit paid each row; rows not yet deposited have none.
  • Dates and times are in the Square account time zone and are used as written.
  • The file does not name its currency; amounts are treated as US dollars unless they show pounds or euros.

Questions

What happens to cash sales in the Square export?
Cash, Square gift card and other non-card payments never pass through your Square balance or a Square deposit, so the converter leaves them out and gives the total for each kind. When a sale was paid partly by card, only the card part is kept. Record cash with your cash takings. A gift card payment is not new money: it came in when the card was sold, so move it from your gift card liability account to sales instead of recording it again.
Is the sales tax in the Square export my income?
Sales tax you collect through Square is part of the totals in the export. The converter keeps it inside the sale amount and tells you how much it is, so you can move it to a sales tax account. How to treat it is a question for whoever prepares your return.
Are tips and gift cards I sold counted as sales?
No. In a journal entry, tips go to an account named "Tips owed to staff" and gift cards you sold go to "Gift card liability", because that money is owed to your staff or to the card holder. Change both names in the options to match your chart of accounts. In bank files they stay part of each payment, since they are part of what Square deposits.
Which currency is a Square file in?
The transactions export does not name its currency. Amounts with a pound or euro sign are read as GBP or EUR; dollar amounts are treated as US dollars, and the notes say so.