Transaction type mapping

Pamela Calilung
Customer success manager Request support
  • The integration has a default set of accounts that are automatically created and mapped using the Express Setup.
  • You may customise the mapping and map existing Xero accounts using the Advanced Setup.

How it works

Proceeding with Express Setup, the integration will automatically create and map the following default set of accounts to the Square transaction types.

Default accounts
Transaction TypeAccount NameAccount TypeAccount Number/SKUAccount Type Filtering
SalesSquare SalesIncomeSQ-2000Income, Other Income
DiscountsSquare DiscountsIncomeSQ-2001Income, Other Income
Shipping/Delivery FeesSquare Shipping/Delivery FeesIncomeSQ-2002Income, Other Income
Service ChargesSquare Service ChargesOther Current LiabilitySQ-8003Other Current Liability
TipsSquare TipsOther Current LiabilitySQ-8000Other Current Liability
Gift CardsSquare Gift CardsOther Current LiabilitySQ-8001Other Current Liability
AdjustmentsSquare SalesIncomeSQ-2000Income, Other Income
Square FeesSquare FeesExpensesSQ-3000Expenses, Other Expense
ChargebacksSquare ChargebacksExpensesSQ-3001Expenses, Other Expense
Square CardSquare CardBankSQ-0001
Square Balance AdjustmentsSquare Balance AdjustmentsOther Current LiabilitySQ-8004Other Current Liability
Set up using Amaka’s default accounts

If you want to set up your integration with Amaka’s default accounts, please follow the steps below:

  1. Open the integration settings.
  2. On the left navigation panel, click Features.
  3. Select Express Setup.
  4. Click Save + Continue and a pop-up message will appear.
  5. If you agree with the default accounts creation, click Continue and the integration will start creating the accounts for you.

Continue with the rest of the mapping to finish the setup. If you want to view the transaction type mapping, follow the steps below from 2-5 and then click Accounts from the left navigation panel.

Set up using your existing accounts in Xero

You can customise the mapping and use your own set of accounts.

  1. Open the integration settings.
  2. On the left navigation panel, click Features.
  3. Select Advanced Features option and click Save and Continue.
  4. A pop-up message will appear. Click Continue and the Square Payments clearing account will be created. This is the only account that will be created when you proceed with the Advanced Features.
  5. Set up the General Settings and click Save + Continue.
  6. Click the dropdown to map the appropriate Xero account for each transaction type. The accounts shown in the dropdown are filtered to avoid incorrect mapping and complexity.
  7. You may choose to Summarise or Categorise your sales by product or category.
  8. Click Save + Continue.

If you need a guide in setting up your own accounts in Xero, please refer to the default accounts table. Make sure that you set the correct account type in Xero so they will appear on the dropdown options.