Assigning Default Sales and COGS Account Ledgers by Variant for XERO integration

QuickBooks Commerce allows you to assign sales orders that are synced to your accounting integration via a default sales account. You can assign these default sales accounts either by Relationship, Variant or Sales Channel.  To assign a Default Sales Account to a Relationship, follow these instructions.  

To check your current default settings, go to Settings > Configuration> Default Settings.

Under 'Default Sales Account', you will have the option to choose between Company, Variant or Sales Channel. 

Select 'Variant' from the dropdown.

You would now have to assign two ledger accounts accordingly. Click on Inventory > Variants. Select the Variant you wish to assign ledger accounts. 

In the Details tab, scroll down to Ledger Accounts. Choose the respective ledgers for 'Default Sales Account' and 'Default Cost of Goods Account'.

Then, 'Save Changes'.

Alternatively, you can do this in bulk - Update Existing Products via CSV.

Go to Inventory > Products > Bulk Manage > Update Existing Products > choose "No I need to download a list of my products."

Choose Default Sales Ledger and Default COGS Ledger, then click Build Product Sheet.

Download the Product Sheet template and edit the .CSV file. Manually input the Default Sales Ledger (e.g. Sales) and Default COGS Ledger (e.g. Furniture Cost of Goods).

Once you have edited the required data in the downloaded CSV file, you'll need to upload the product sheet.

Now, the value of the variant in your invoice will sync to the default sales account and default cost of goods account you have set. If no default ledgers are set on your variant, the value will sync to the respective default ledgers found on your Xero integration's Ledger Account's tab.

If you are unsure of how to set up your sales account or other ledgers, check out the following articles:

1. Xero Accounting Integration, setting up custom ledgers for Xero 

2. Quickbooks Accounting Integration.