Sync with Square

Sync your Square account with QuickBooks Online


Welcome to the Sync with Square app

Intuit QuickBooks Online is enabling small businesses and ProAdvisors to sync their Square account transactions with their QuickBooks Online account in an easy and convenient way by partnering with Square.

Setting up the app

Transaction sync

 

This information is intended to outline our general product direction, but represents no obligation and should not be relied on in making a purchasing decision.

QuickBooks and Intuit’s Sync with Square app are provided by Intuit, and any use of those products or issue arising therefrom is solely between you and Intuit. Square is not responsible for any accounting or tax compliance requirements arising from your use of QuickBooks or Sync with Square.

 


About Intuit QuickBooks Online apps

 

Intuit QuickBooks Online apps are add-ons that expand the functionality of QuickBooks Online by integrating with 3rd party apps to help save you time and improve your business processes.

Sync with Square is a new app, developed by Intuit in partnership with Square, which automatically imports your transaction data from your Square account to your QuickBooks Online company. The app shows your daily transactions with Square, including sales, refunds, fees, and deposits. Your bank account is linked to QuickBooks Online, so Sync with Square also provides reconciliation for Square deposits.

 

WANT MORE?

For more information about QuickBooks Online apps, visit our resource centre. To browse all apps, visit apps.com.

 

Back to top


Prerequisites

 

Before you get started, you need:

QuickBooks Online

A QuickBooks Online account.

To install the Sync with Square app, you need administrator rights to your QuickBooks Online company.

Square

A Square account.

The currency of the Square account must match the currency that is used in your QuickBooks Online company.

 

 

Back to top


Setting up the app


Installing the app

 

If you have a QuickBooks Online company and a Square account, you’re ready to get started.

  • Click Get App Now in your invitation email.

  • Enter your QuickBooks Online credentials to sign in.

  • Select the company you want to connect, if you have multiple QuickBooks Online companies.

  • Click Authorise to grant permission for Sync with Square to access your QuickBooks Online company.

  • Enter your Square credentials and Sign In to your Square account.

  • Click Allow to grant permission for Sync with Square to access your Square account.

 

Back to top


Configuring for app installation

Next, review the settings for the app. You'll need to check settings for importing past transactions, basic financial account settings, and default selections for unmatched items.

Importing past transactions

Sync with Square allows you to sync up to 18 months of past Square transactions.

On the Review Your Settings page, select Import next to Import Past Transactions to sync past transactions from Square.

On the Past Transactions page, select a date range and click Save to schedule the sync.

Allow up to 36 hours for the import to complete.

 

Important: If you already have Square transactions in QuickBooks Online, do not import these past transactions, as it may create duplicates.

 

Back to top


Configuring basic settings

On the Review Your Settings page, select Edit next to Basic Settings to view your app’s basic settings.

All transactions from Square will show deposits recorded to the same bank account, all Square fees are recorded to the same expense account, and all Square transactions have the same payment method.

  • Bank account where Square deposits your money is the bank account linked to your Square account.

  • Expense account for fees charged by Square is the expense account where your Square fees are recorded.

  • Payment method on Square transactions is the payment method in QuickBooks Online for Square transactions.

To change these settings, click the drop-down next to each setting and select from the list of available selections from your QuickBooks Online company.

Click Save changes when you are finished.

 

Back to top


Configuring defaults for unmatched items

On the Review Your Settings page, select Edit next to Defaults for Unmatched Items to configure defaults for unmatched items. Tax codes as well as products and services from Square are automatically matched against those you have in QuickBooks. When a match cannot be found, these defaults are used.

  • Default income account for unmatched products/services specifies the default income account when a Square product or service cannot be matched to a QuickBooks product or service. These items appear on your Invoice as Square Income.

  • Default sales tax code for unmatched tax codes is the tax code used when Square taxes cannot be matched to existing tax codes in QuickBooks Online.

To change these settings, click the drop-down next to each setting and select from the list of available selections.

Click Save changes when you are finished.

 

Back to top


Connecting to square

 

When you have finished setting up the app, click Connect.

Once connected, future Square transactions are automatically imported into QuickBooks Online. Any scheduled past transaction syncs will begin to sync as well.

Your setup is now complete, and you are redirected to QuickBooks Online.

Please wait up to 36 hours for new transactions to appear in QuickBooks Online.

 

Back to top


Managing your settings

 

You can access your Sync with Square app settings any time if you need to make changes.

  • Go to the Apps tab within your QuickBooks account.

  • Click My Apps.

  • Click the Settings link.

 

Back to top


Transaction sync


Square to QuickBooks transaction sync

 

By using Sync with Square, all your Square transactions are automatically imported.

Let's look at how different transactions are synced from Square.

  • Sales: Any sales transactions that we detect in your Square account is recorded as a closed Invoice with a Payment associated with it.

  • Tax (applicable if Tax is enabled): Any tax supplied by Square is matched to tax codes in your QuickBooks Online or the default tax code is applied.

  • Refunds: Refund transactions synced from your Square account are recorded as a Refund Receipt with line item details.

  • Settlements: Settlement transactions synced from your Square account are recorded as Deposits in QuickBooks Online.

  • Fees: Any processing fees charged by Square for your transactions are recorded as a line item in the Deposit.

 

Back to top


Square sales

 

Sales transactions synced from your Square account are recorded as Invoices with linked Payments in QuickBooks. For transactions with multiple payment types (for example, credit card and cash), a Payment is created for each type, so you can see how you’re getting paid.

 

Discounts, Shipping, Taxes, Tips, and Item Modifiers are also supported. These are recorded as individual line items on Invoices to give you even more insight into the success of your business.

 

Back to top


GST (for Australia)

 

Tax specified on Square transactions are matched to tax codes in QuickBooks.

We recommend keeping the taxes you configure in Square identical to the taxes you configure in QuickBooks, to allow for more accurate matching. If a match can’t be found, the default unmatched tax code from your app settings is applied.

For a summarised view of tax related activity from Square, visit the GST tab in QuickBooks.

 

Back to top


Square refunds

 

Refund transactions synced from your Square account are recorded as Refunds in QuickBooks. Refund transactions contain the same breakdown of sales details as Invoices, including the refund reason, so you can view it directly in QuickBooks.

 

Back to top


Square settlements

 

Settlement transactions synced from your Square account are recorded as Deposits in QuickBooks. These Deposits include any Fees charged by Square. In the case of a negative settlement amount, a linked Expense is created to record the transaction in QuickBooks.

Square Settlements also include any transactions not related to your daily sales, such as free processing credits. In the case where a match cannot be found for these settlement types, they are recorded as Uncategorised Expenses. Please review Square settlements periodically and appropriately categorise any transactions recorded against this account.

 

Back to top


Square fees

 

Fees charged by Square are recorded as line items on Deposits in QuickBooks. Running a report in QuickBooks on the Square Fees account configured in your app settings will give you a summarised view of all fees charged by Square.

 

 

Back to top


QuickBooks and Intuit's Sync with Square app are provided by Intuit, and any use of those products or issue arising therefrom is solely between you and Intuit. Square is not responsible for any accounting or tax compliance requirements arising from your use of QuickBooks or Sync with Square.

© 2015 Intuit, Inc. All rights reserved. Intuit and QuickBooks are registered trade marks of Intuit, Inc. Terms and conditions, features, support, pricing and service options subject to change without notice.