QuickBooks HelpQuickBooksHelpIntuit

Connect your Square account to QuickBooks Online

by Intuit59 Updated 4 months ago

Learn how to connect your Square account to QuickBooks Online.

Get the Connect to Square app to bring your sales transactions into QuickBooks automatically. Here’s how.

For a better experience, open this article in QuickBooks Online. Launch side-by-side view Open this link in a new window

To watch more how-to videos, visit our video section.

Connect the bank account Square uses to deposit money from your sales. QuickBooks then downloads your bank transactions and matches them to your Square transactions.

  1. Open Square and export products and services as CSV files.
  2. Open QuickBooks and import products and services.
  1. Sign in to QuickBooks Online.
  2. Search Connect to Square in Find apps.
  3. Select Get app now.
  4. Select Get started.
  5. Select Give permission.
  6. Sign in to Square, then select the Square locations you want to sync.
  7. Select the bank account you want to deposit to, then select Next.
  8. Choose whether you want the app to import sales individually, or as a summary of your daily sales. Select Next.
  9. Select a starting date, then select Finish.

After setting it up, the Connect to Square app downloads your Square transactions to QuickBooks. Then, it checks your Square account multiple times a day for the latest transactions.

Note: Change the sync options to daily summary instead of individual transactions to prevent QuickBooks from freezing when importing multiple  transactions all at once.

  1. Go to Bookkeeping, select Transactions, then select App transactions.
  2. Select For review. Your Square transactions appear in the list.
  3. For each transaction, select an action, depending on the status:
    • Add or Match: This transaction is ready to be added. If both QuickBooks and Square are connected to the same bank, you can match it to a transaction that's already in your books.

      Note: To make sure all sales data from Square gets added to QuickBooks, add transactions from the App transactions tab and then match them from the Banking tab.
    • Review: Multiple transactions are similar to the transaction from Square. Verify which one matches.
  4. Go to Reviewed to review transactions. Select the sales receipt or deposit under the Added/Matched column.
  1. Go to Bookkeeping, select Transactions, then select App transactions.
  2. Select App settings, then Square.
  3. Select the tab for the setting you want to change.
  4. Select Disconnect Square to disconnect the app.
  5. Select Done.
  1. Go to Get paid & pay or Sales, then select Products & services.
  2. In the Find products and services field, search for Square Item.
  3. Select Edit.
  4. In the Income account ▼dropdown, select the account you want to record to.
  5. Select Save and close.

Square doesn’t import money out transactions. To add these transactions, you can download them from Square and upload the file to QuickBooks.

The Connect to Square app doesn’t support disputed transactions. If you have any, QuickBooks prompts you to exclude them. You can add a disputed transaction to QuickBooks by manually entering the deposit or by adding the transaction from the Banking tab, if Square deposits money to the same bank.

You can switch to the Connect to Square app after disconnecting Sync with Square. Here’s how:

  1. Go to Apps, then select My Apps.
  2. Select Sync with Square, then go to the Actions ▼ dropdown, and select Disconnect.
  3. Select your reason for disconnecting and then select Confirm disconnect.
  4. Set up the Connect to Square app.

In the App transactions tab, you can select the transactions that were sent to QuickBooks using the Sync with Square app. Exclude them from QuickBooks.

If sales tax is turned on, it gets matched. If it isn’t, we’ll compile it into one line item.

Connect to Square only matches the exact names of your customers unless you manually point a customer to an imported transaction. The app automatically applies this to future transactions. This is also true for products and services.

Connect to Square adds details to QuickBooks on the same day the final payment is received. Partial payments will be reflected as deposit adjustments to help ensure that your books reflect the money Square has deposited into your bank.

Yes, you can. Import past transactions by adjusting the date range during importation.

A Square update prevents us from linking to a specific settlement. However, we still provide the list of settlements, and you can choose the one you need by the date and amount.

QuickBooks LedgerQuickBooks Online AccountantQuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

More like this