Import Square transactions to QuickBooks Desktop for Mac

Learn how to import your transactions from Square to QuickBooks Desktop for Mac.

QuickBooks lets you import your sales data from Square. This way you can see how your business is performing. Here’s how you do it.

Download your sales data from Square

To start, you need to export your transactions from Square.

Note: If you do business in multiple tax locations, export your Square transactions by location. This will create a separate file for each tax location. That way, you'll be able to assign the correct sales tax when you import your Square transactions.

1. Go to your Square account.
2. From the left menu, select Sales.
3. Select the Transactions tab, then select the transaction you want to export.
4. Select Export, then Transactions CSV.

Import your sales data in QuickBooks

Here’s how to import your sales data from Square to QuickBooks.

1. Open QuickBooks.
2. Go to File, then select Import.
3. Select Transactions, then select Sales Receipts.
4. In the Import Sales Receipts window, select Import from Square icon.
5. Select the file you exported from Square.
6. Select the bank account associated with your Square account.
7. Select the tax rate for the transactions.
   Note: Make sure the correct Sales Tax item and Tax Code item are selected.
8. Select OK, then select Import.

Review your imported transactions

Here’s how to review your Square transactions in QuickBooks. 

1. In QuickBooks, select the Company menu.
2. Select Transactions Center, then select Sales Receipts.