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: Xero Overview
Here we'll cover:
- Step 1: Connecting Xero to QuickBooks Commerce
- Step 2: Creating Default Ledgers and Enabling 2-way Payment Sync
- Step 3: Connecting your Accounts to QuickBooks Commerce
- Understanding the QuickBooks Commerce-Xero Integration
Step 1: Connect Xero to QuickBooks Commerce
Go to the Browse Apps section and click on Accounting.
Click the Xero tile.
Click the 'Install App' button.
In the next dialogue box, click "Connect Now" to integrate Xero with QuickBooks Commerce.
You will be redirected to Xero where you'll be asked to sign in.
Then, you will be asking for the 6-digit authentication code.
Next, a popup window will load where you'll need to grant QuickBooks Commerce access to your Xero account. Click the "Allow Access" button.
Step 2: Create Default Ledgers and Enable 2 way-payment sync
Xero Ledgers
Before connecting Xero to QuickBooks Commerce you need to make sure certain accounts exist in your Chart Of Accounts in Xero. These are the 4 default accounts QuickBooks Commerce will push data to.
If you do not have these default accounts, we will help you create them in Xero. You can choose to toggle on (or off) this creation. If you already have these accounts, you will not see this option during your setup process.
For some businesses, payment accounts are represented as account ledgers. Please check with your accountant to understand which is recommended for your business. This account (in Xero) will be linked to your Payments account in QuickBooks Commerce.
Account |
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 Purchases Account, according to accounting best practices, it is recommended that you use a Current Asset account for Purchases. For some businesses, Purchases can be taken as an expense. For clarification, please check with your accountant.
Here's how Purchase Orders work with QuickBooks Commerce:
- Creating a Purchase Order will increase the Purchases account and decrease Accounts Payable.
- Receiving Purchase Order will increase Stock On Hand and decrease Purchases account.
Learn more about Sync Details between Purchase Orders and Xero Bills.
Two-way payment sync
You can choose to toggle on (or off) the two-way payment sync. If you switch off the two-way payment sync, the integration will push payments from QuickBooks Commerce to Xero only.
Step 3: Connect your accounts to QuickBooks Commerce
Next, you will be prompted to link the ledgers in QuickBooks Commerce to the appropriate Xero account ledgers. These are the accounts that you have set up earlier.
Next, link up your tax types.
Then, link up your stock adjustment reason with its designated ledger account. This is to ensure that you can track the stock changes such as Shrinkage or Damaged Goods in your financial book.
Now, you are done with the Basic Setup!
You can finish the integration, or click “Advanced Setup” to customize your Xero integration. You may or may not see the customization, depending on your account configuration.
Custom Sales Ledgers: You can push sales information of selected Invoices or Relationships to your created custom ledgers. To learn more about custom ledger account for Xero, click here.
Custom Payment Methods: Link your payment methods specific Xero ledgers (where necessary), as seen here in the image below;
If you have a Sales Channel integrated (e.g. Shopify or WooCommerce), refer to these articles on how to map Payment Methods with QuickBooks Commerce.
- How to map Payment Methods between QuickBooks Commerce and Shopify?
- How to map Payment Methods between QuickBooks Commerce and WooCommerce?
Add Tracking Categories: If you have tracking categories enabled on your Xero account, you can link them here.
Learn more about XERO Tracking Categories here.
Link Sales Channels: If you have sales channels, you can select which sales accounts and shipping revenue accounts to link to. You will be prompted to change your Default Sales Account On option to Sales Channel if it is not already set to Sales Channel. This is useful for businesses with more than one sales channel to track the sales coming through from each sales channel. You can assign each Sales Channel to a separate ledger account. Please click here for more information.
The implication of changing your account default settings to Default Sales Account On: Sales Channel, is that you will not be able to track sales through Variants or Relationships. To learn more, click on this article.
On this page, link the sales channels and accounts accordingly.
Once you have completed the setup process you will get a success notification within QuickBooks Commerce. You can also check that the setup is done accurately by going to My Apps > XERO > Dashboard.
Understanding the QuickBooks Commerce - Xero integration
When you:
- Invoice a sales order in QuickBooks Commerce, Xero records as an increase in revenue to your Sales account
- Pay an invoice in QuickBooks Commerce, Xero records an increase to your Payments account
- Create a purchase order in QuickBooks Commerce, Xero records an increase in current assets to your Purchases account
- Ship a sales order in QuickBooks Commerce, Xero records a decrease in current assets to your Stock on Hand account and an increase in expense to your Cost of Goods Sold account
- Receive a purchase order in QuickBooks Commerce, Xero records an increase in current assets to your Stock on Hand account and a decrease in current assets from your Purchases account
- Create a stock adjustment in QuickBooks Commerce, Xero records accordingly, an increase/decrease in current assets to your Stock on Hand account, and decrease/increase in expenses to your assigned Inventory Adjustment ledger account respectively
Enabling the Tracked Inventory in Xero may lead to discrepancies with stock journal totals within your Xero account. QuickBooks Commerce does not integrate with Xero's inventory features.
Learn about the accounting side of QuickBooks Commerce for Manufacturing from this article.