With effect from 23 Sept 2020, Xero Integration's help documentations will only apply to existing customers or prospects that have created trials before said date.
Read this first: QuickBooks Commerce and Xero Sync Guides
Read this next: Explore QuickBooks Commerce's Knowledge Center Articles, or if you sell wholesale:
To set up your accounting integration, please submit a ticket to Support and they will lend a helping hand.
Here we’ll cover:
- Prep Work within your Xero Account
- Install Xero on QuickBooks Commerce
- Connect your Ledger Accounts to QuickBooks Commerce
- Review your Integration Settings
Step 1 of 4: Prep Work within your Xero Account
Creating Ledger Accounts in Xero
From your Xero account, ensure that the 4 following ledger accounts have been created. These will be the default ledger accounts that QuickBooks Commerce will push data to.
|
Account Ledger |
Account Type |
Code (or other unique identifiers) |
Name of account |
Remarks |
|
Sales Account |
Revenue |
200 |
Sales |
The Xero integration pushes sales data into your main sales account. |
|
Purchases Account |
Current Asset* |
300 |
Purchases |
QuickBooks Commerce will push purchase order details into this account. |
|
Inventory or Stock Asset Account |
Current Asset |
SOH |
Stock on Hand |
A current asset account to record stock on hand.
When integrating QuickBooks Commerce and Xero, it is important that your Stock on Hand Value (SOH) is accurate from the start. Refer to this article to learn more. |
|
Cost of Goods Sold Account |
Expenses> Direct Cost |
COGS |
Cost of Goods Sold |
An expense account for your Cost of Goods sold. |
For some businesses, Purchases can be taken as an expense. For clarification, please check with your accountant.
Here's how Purchase Orders work between QuickBooks Commerce and Xero:
- Creating a Purchase Order will increase the Purchases account, decrease Accounts Payable.
- Receiving Purchase Order will increase Stock On Hand, decrease the Purchases account.
Learn more about Sync Details between Purchase Orders and Xero Bills.
Step 2 of 4: Install Xero on QuickBooks Commerce
Here we’ll cover:
- Installation & authorization
- Connecting and mapping your account ledgers
- Setting up payment methods
- Setting up tax types
Installation & Authorization
Go into your QuickBooks Commerce account.
Go to the QuickBooks Commerce App Store by clicking Browse Apps on the left sidebar.
Click Accounting from the menu, then click the “Xero” button.
Click “Install App.”
Click “Connect Now.”
You will be taken through to Xero where you will need to login and allow QuickBooks Commerce to access your Xero account.
Click 'Login' and then, “Allow Access.”
Step 3 of 4: Connect your Ledger Accounts to QuickBooks Commerce
From the dropdown menus, connect and map your Xero account ledgers to QuickBooks Commerce's and toggle 2-way payment sync on or off.
Next, you will be prompted to link the ledgers in QuickBooks Commerce to the appropriate Xero account ledgers. These are the accounts that you will have set up earlier.
Setting Up Tax Types
If the tax type does not exist in Xero, you can create them in Xero and sync them later in the advanced settings section of this install flow.
Now, you are done with the Basic Setup!
You can click “Finish” now, or click “Advanced Setup” to customize your Xero integration.
You may or may not see the customization, depending on your account configuration
Step 4 of 4: Review your Integration Settings
Once your installation and import have completed, you’ll want to review and test the integration.
Go to the My Apps section, click on your Xero integration and click through the tabs to identify any alerts and resolve them. If you need any help, please submit a ticket here to contact Support.
To understand what syncs between QuickBooks Commerce and Xero, review the sync articles here.
Read this next: Explore QuickBooks Commerce's Knowledge Center Articles
Or if you sell wholesale: