Skip to content
Your files never leave your device. Converted in your browser, never uploaded.How
Convert a file
Menu

into for finance apps

FileInto turns a Square transactions CSV into a standard .OFX file with sales and Square fees split out, for Xero, GnuCash and other apps.

  • Never uploaded, stays on your device
  • Free preview
  • Opens in Xero and GnuCash
How to get the file from Square
  1. In the Square Dashboard, open Payments, then Transactions.
  2. Set the date range you need.
  3. Click Export and choose Transactions CSV.
  4. Drop the downloaded file below.
Drop your bank file hereCSV or Excel from any bank, card, PayPal, Stripe or Square.Stays on your device. Never uploaded.

Have a different file, or need a different one? Click or above.

How to import the OFX file

Xero

  1. Go to Accounting, then Bank accounts.
  2. On the account, choose Manage account, then Import a statement.
  3. Select the .ofx file from FileInto and click Import.
  4. Reconcile the new statement lines.

GnuCash

  1. Go to File, then Import, then Import OFX/QFX.
  2. Select the .ofx file from FileInto.
  3. Pick or create the GnuCash account when asked.
  4. Match or assign each transaction in the import window, then click OK.

What FileInto looks for in your file

ColumnExamplesNotes
Date10/01/2026The sale date.
Description2 x Latte, 1 x CroissantThe items sold. Fee lines keep it in the memo.
Total Collected and Fees$22.53 and -$0.71Total Collected (with tax and tips) becomes the sale; Fees becomes a separate Square fee line.

Problems and fixes

Your finance app shows only the net amount
Leave "Split fees into their own lines" on. Each Square sale then comes in at its full amount with a separate Square fee line, so income and fees are both right.
Pending or failed payments are missing
They are skipped on purpose. Only completed payments belong in your books; export again after Square finishes them.
The same payments appear twice
Each line gets a fixed id from its date, amount and description, so importing the same export again is skipped by your finance app. Overlapping date ranges from different exports can still duplicate; export non-overlapping ranges.
Payouts look like expenses
Payouts move money from Square to your bank. In your finance app, match or categorize them as a transfer to your bank account, not an expense.
The app says the file is invalid
Some apps want QFX or QIF instead of OFX. Switch "Save as" to the format your app lists and download again.
Transactions land in the wrong account
OFX files carry an account number. Enter the last digits of your real account number in Settings so your app links the file to the right account.

Questions

Why use Total Collected and not Net Sales?
Total Collected is what the customer paid, including tax and tips, which is the money that moved. Net Sales leaves those out.
What is an OFX file?
OFX (Open Financial Exchange) is the standard file banks use to send transactions to finance apps. Xero, GnuCash, Moneydance, Banktivity and many others import it.
Which account should I import into?
Create a separate account in your finance app named Square. Sales and fees land there, and Square payouts become transfers to your real bank account.
Is my Square file uploaded?
No. FileInto converts it inside your browser tab. Your file never reaches our servers, and nothing about it does either: not its name, its size or how many rows it has.
Can I get a QuickBooks file instead?
Yes. Switch "Save as" to QBO, or use the Square to QuickBooks converter.
What are the limits?
Files up to 25 MB. Every file gets a full preview free. Downloads up to 25 transactions are free, no account needed; a Day Pass ($9 for 24 hours) or Unlimited ($7 a month) has no row limit. It works in current versions of Chrome, Edge, Safari and Firefox, on computers and phones.

Related converters