Linnworks

How do I sync sales with multiple currencies with Linnworks?

If you sell on multiple sales channels with different currency codes, we recommend grouping sales by the selling channel and currency code. This will ensure that sales with different currencies and selling channel sync correctly to QuickBooks. 

To sync the sales, you must map a deposit account and customers. If you sync payments, you must map and accounts receivable account.

How do I map an Accounts Receivable account?

You must map an Accounts Receivable account per currency code. QuickBooks will only allow an account for Euros to have sales with Euros. Here are the steps:

  1. Login to our software.
  2. On the left, click rules my rules.
  3. Click add.
  4. In the first drop-down, choose map accounts.
  5. As the action, choose map order A/R account.
  6. Under rules, click add.
  7. Enter currency code as the field to compare, enter equals as a comparison and enter GBP as the value.
  8. Under what should this value be, enter the A/R account name.
  9. Repeat steps 2 - 8 for each currency code.

Here is the end result:

How do I map a deposit account?

You must map a deposit account per currency code. QuickBooks will only allow an account for British pounds to have sales with British pounds. Here are the steps:

  1. Login to our software.
  2. On the left, click rules my rules.
  3. Click add.
  4. In the first drop-down, choose map accounts.
  5. As the action, choose map order deposit account.
  6. Under rules, click add.
  7. Enter currency code as the field to compare, enter equals as a comparison and enter GBP as the value.
  8. Under what should this value be, enter the deposit account name.
  9. Repeat steps 2 - 8 for each currency code. Questions

How do I map the Linnworks customer and currency code to the QuickBooks customer field?

Here are the steps:

  1. On our dashboard, select the settings button.
  2. On the left, click the customer matching link.
  3. Under customer match, select selling channel currency code.
  4. Click save.

What does the sale look like in QuickBooks?

The customer will have a currency code of GBP. Here is a screenshot:

How do I change the selling channel name in QuickBooks?

In this example, we will change the selling channel name from Amazon to Amazon UK. Here are the steps:

  1. Login to our software.
  2. On the left, click rules my rules.
  3. Click add.
  4. In the first drop-down, choose map field based on condition.
  5. As the action, choose map selling channel name.
  6. Under rules, click add.
  7. Enter selling channel as the field to compare, enter equals as a comparison and enter Amazon as the value.
  8. Under what should this value be, enter Amazon UK.

Here is the end result: