Overview
Connect Square and Xero to start syncing your daily sales transactions.
How it works
Connect Square to Xero to automatically create accounting entries for your daily Square sales.
- On a daily basis, the integration will sync a summary of your previous day’s sales data from Square into Xero generating an invoice.
- You can customise your preferred sales summary format choosing between Summarised, Categorised or by Product.
- Captures all payments transactions including gift cards, tips, tax and Square fees.
Before you start
- Sign up for a Square account and a Xero account (if you haven’t already).
- Sign up for an Amaka account.
How to setup the integration
Go to the Amaka Integrations page and click the New Integration button.
- Select the Square + Xero integration to start the setup wizard.
- Follow the wizard to authenticate your Square and Xero accounts.
- Choose your preferred setup method: Express, Advanced or Guided.
- Choose the features that you wish to enable:
Sales
: Sync your daily sales transactions into Xero.Payments
: Allow your customers to pay your invoices through Square. - Choose the invoices breakdown:
Summarise into one invoice
: Sales from all activated locations will sync to one invoice.Split invoices by location
: One invoice for each activated location. - Select which locations you want to sync.
- Choose your preferred sales invoice format:
Summarised
: Sales totals into an invoice including, tips, fees taxes and more.Categorised
: The invoice will have a line item for each category of products sold.Products
: The invoice will have a line item for each product sold.
Categorised
Summarised
Products
- Follow the steps of the wizard and reach the Scheduler setup.
If you have doubts while you go through the setup, you can close the wizard at any time and contact our integration experts or your trusted accountant/bookkeeper for support. The integration will be saved as a DRAFT automatically.
Express setup
The integration will automatically map sales and payments from Square into Xero by creating the following default accounts:
Default account mapping (sales integration)Account and code mapping
| Square account | Xero account | Account type | Code |
|---|---|---|---|
| Square Sales (Taxable) | Square Sales (Taxable) | Revenue | SQ-20000 |
| Square Sales (Tax Free) | Square Sales (Tax Free) | Revenue | SQ-20001 |
| Square Discounts (Taxable) | Square Discounts (Taxable) | Revenue | SQ-20002 |
| Square Discounts (Tax Free) | Square Discounts (Tax Free) | Revenue | SQ-20003 |
| Square Surcharges (Taxable) | Square Surcharges (Taxable) | Revenue | SQ-20004 |
| Square Surcharges (Tax Free) | Square Surcharges (Tax Free) | Revenue | SQ-20005 |
| Square Fees | Square Fees | Expense | SQ-30000 |
| Tips | Square Tips | Current Liability | SQ-80000 |
| Gift Card | Square Gift Card | Current Liability | SQ-80001 |
| Cash | Square Cash Clearing | Current Asset | SQ-60000 |
| Card Payments | Square Credit/Debit Clearing | Current Asset | SQ-60001 |
| All Other Payment Types | Square Other Payment Clearing | Current Asset | SQ-60002 |
TAX Mapping by country
Scroll horizontally to browse TAX mapping for more countries.
| Square | Xero | AU | NZ | UK | USA | SG | ZA | Global |
|---|---|---|---|---|---|---|---|---|
| Square Sales (Taxable) | Square Sales (Taxable) | GST on Income | GST on Income | 20% (VAT on Income) | Tax on Sales | Standard-Rated Supplies | Standard Rate Sales | Tax on Sales |
| Square Sales (Tax Free) | Square Sales (Tax Free) | GST Free Income | Zero Rated | Zero Rated Income | Tax Exempt | Zero-Rated Supplies | No VAT | Tax Exempt |
| Square Discounts (Taxable) | Square Discounts (Taxable) | GST on Income | GST on Income | 20% (VAT on Income) | Tax on Sales | Standard-Rated Supplies | Standard Rate Sales | Tax on Sales |
| Square Discounts (Tax Free) | Square Discounts (Tax Free) | GST Free Income | Zero Rated | Zero Rated Income | Tax Exempt | Zero-Rated Supplies | No VAT | Tax Exempt |
| Square Surcharges (Taxable) | Square Surcharges (Taxable) | GST on Income | GST on Income | 20% (VAT on Income) | Tax on Sales | Standard-Rated Supplies | Standard Rate Sales | Tax on Sales |
| Square Surcharges (Tax Free) | Square Surcharges (Tax Free) | GST Free Income | Zero Rated | Zero Rated Income | Tax Exempt | Zero-Rated Supplies | No VAT | Tax Exempt |
| Square Fees | Square Fees | GST on Expense | GST on Expense | 20% (VAT on Expenses) | Tax on Purchases | Standard-Rated Purchases | Standard Rate Purchases | Tax on Purchases |
| Tips | Square Tips | BAS Excluded | No GST | No VAT | Tax Exempt | No Tax | No VAT | Tax Exempt |
| Gift Card | Square Gift Card | BAS Excluded | No GST | No VAT | Tax Exempt | No Tax | No VAT | Tax Exempt |
| Adjustment | Square Sales (Tax Free) | GST Free Income | No GST | No VAT | Tax Exempt | No Tax | No VAT | Tax Exempt |
Account and code mapping
| Square account | Xero account | Account type | Code |
|---|---|---|---|
| Square Fees | Square Fees | Expense | SQ-30000 |
| Card Payments | Square Credit/Debit Clearing | Current Asset | SQ-60001 |
TAX Mapping by country
Scroll horizontally to browse TAX mapping for more countries.
| Square | Xero | AU | NZ | UK | USA | SG | ZA | Global |
|---|---|---|---|---|---|---|---|---|
| Square Fees | Square Fees | GST on Expense | GST on Expense | 20% (VAT on Expenses) | Tax on Purchases | Standard-Rated Purchases | Standard Rate Purchases | Tax on Purchases |
Advanced setup
The advanced setup will allow you to choose your own custom mapping in relation to sales and payments in Square.
Recommended for professional bookkeepers and accountants.
Guided setup
Guided setup where you can schedule a call with one of our integration experts that will guide you through the setup.
Schedule a call nowScheduler
The scheduler allows you to select the date you want to start syncing Square transactions to your Xero file.
- The Advanced settings will give you an option to change the timezone. By default, the timezone is set to your browser’s timezone.
If you have selected today’s date as your sync start date, your transactions won’t appear until tomorrow.
