Overview
- Learn how Square sales and payout transactions are synced into QuickBooks Online with the Square + QuickBooks Online integration.
Sales sync
On a daily basis, the Square + QuickBooks Online integration will sync an invoice for the summary of your previous day’s closed sales orders.
To view the integrated sales transactions:
-
Sign in to your QuickBooks Online account.
-
Click on the Sales menu and then Invoices.
-
Select the date range of the sales you wish to view.
-
Click on the invoice to view the details.
The default contact name for a daily summary sync is the location name. If you have modified this, you can find the details within the integration settings in the General section.
Payout sync
Payouts coming in or out of your business bank account are synced as bank transfers. You need to match and reconcile these transactions. Find our Square + QuickBooks Online reconciliation guide.
To view the payout transfers from Square in QuickBooks Online:
-
In your QuickBooks Online account, click on the Transactions menu and then Chart of Accounts.
-
Find the Square Balance account and click on Account history.
-
You will find a list of transactions and the payout transfers are tagged as Transfer type.
The integration also syncs other payout transactions such as fees into a Journal Entry.
To find other payout transactions:
-
In your QuickBooks Online account, click on the Reports menu.
-
Select the Journal report.
-
Select the date range for which you want to view the journal entries.
-
Include the Memo/description in the visible columns.
-
Click the Journal Entry you want to view.
The preset accounts below are created and mapped by default when you initially set up your integration.
Payout Transaction | QBO Account | Account Type |
Square Fees | Square Fees | Expenses |
Third Party Fees | Square Third Party Fees | Expenses |
Square Balance Adjustments | Square Balance Adjustments | Other Current Liabilities |
Square Chargebacks | Square Chargebacks | Expenses |
Square Held Funds | Square Held Funds | Other Current Assets |
Square Loan Payments | Square Loan Payments | Other Current Liabilities |
Square Redemption Code Income | Square Other Income | Income |