Setting up and using eBusiness Guru for XERO for Linnworks app
The XERO Accounting Integration for Linnworks posts Linnworks sales and sales invoices into the XERO Accounting System. The app synchronies all of your sales order information for the day into XERO every night, so you can start the day with XERO up to date on the previous day’s sales.
One-off setup charge | £75 + VAT
The XERO app can be self-configured, however our setup service gives you peace of mind to know your XERO app has been configured in the line with your business requirements.
Basic | £14.99 + VAT per month |For processing up to 3,000 orders a month.
Pro | £34.99 + VAT per month | For processing up to 10,000 orders a month.
Enterprise | £75.00 + VAT per month | For processing up to 50,000 orders a month.
Please contact [email protected] if you are processing more than 50,000 orders a month.
Please note: XERO Accounts should be well configured before integrating with the eBusiness Guru for XERO app for best result.
To use the eBusiness Guru for Xero integration, you must first install it from within Linnworks.net.
- Login to Linnworks.net
- Select Apps in the left-hand menu bar
- Select the Application Store option
4. Click on “eBusiness Guru for Xero”
5. Click on Install to add the eBusiness Guru for Xero integration App to your Linnworks Account
6. Click the Accept button on the “Third Party Integrations Disclaimer”
7. Click on “Next”.
8. Click on “Install” to add the integration to your Linnworks Account.
9. Click on “Complete”.
Your Linnworks.Net page should be refreshed. If it does not refresh then click the Refresh button in your browser, or press the F5 key on your keyboard.
A new option, labeled eBusinessGuru for XERO, will be added to the Apps menu, under My Applications.
To complete the registration and configuration for the eBusiness Guru for Xero app, follow these steps.
- Click on the button Apps on the left-hand menu, then open the Application Store and click on eBusinessGuru for XERO to open the App.
- When you open the App for the first time, please agree to the Terms and Conditions by ticking the box, and clicking on CONNECT TO XERO. Click on the link Terms and Conditions to view a copy before agreeing to continue.
3. Click on OK, which will refresh the page. The Configuration page will be displayed instead.
4. Complete the guidance in the popup box.
i. Xero Credentials
By clicking on Authenticate to XERO, the following screen will pop-up, where your XERO credentials need to be inserted:
Once Valid XERO Credentials are entered, it will display all the organisations available under this account. Select the XERO Organisation from the drop down to connect it with the eBusiness Guru for XERO app.
ii. Account Mapping
The Account Mapping screen allows you to control which Xero Accounts are connected/mapped to the Source/SubSources (Channels) in Linnworks to control the import of transactions into Xero as Sales Invoices.
Tick one entry in Linnworks Accounts, and click on the Link button for an entry on the Xero Account side to link with an existing Account in XERO. Use the Unlink button at either end to disconnect them. If you would like to create an Account in XERO, then select the entry in Linnworks Account and click on the Create button.
If you are creating an account in XERO from this app, then the following screen will pop-up where you have to select the type of the account – Sales or Bank.
You can select the Invoice Type that will be used when importing it to Xero.
When you have a small number of orders, you can use the ‘Individual Order’ options, and one Sales Invoice is created per Linnworks order. Source SubSource Summary means that all the orders are combined, and then broken down into combined Sales Orders grouped by the Source/SubSource, but also by Currency, Payment Method and date.
If not select anything then it will use from Synchronization settings for the invoice type.
Invoice Item Detail field will be enabling only when user will select Invoice Type as “Source SubSource summary” by this field user will specify the, what will be exporting as invoice line items.
- a. Tax Rate Wise: it will send linnworks order group by of Tax Rate.
- b. Order Reference (Channel Reference Number): it will send order channel reference number as invoice item.
- c. Product Details : Send all order items with the sum of qty if same order items
- d. Product Details with OrderId: Send all order items with the sum of qty if same order items. Also as last item we are include OrderId by comma separated with zero price as item.
If not select anything then it will use from Synchronization settings.
iii. Tracking Category Mapping
The Tracking Category Mapping screen allows you to control which Xero Tracking Category is connected/mapped to the Linnworks Product to keeps your chart of accounts manageable and makes reporting on different departments very easy in XERO.
Tick one entry in Linnworks Accounts, and click on the Link button for an entry on the Xero Tracking Category side to link with an existing Tracking Category in XERO. Use the Unlink button at either end to disconnect them.
iv. TaxRate Mapping
This screen controls the way the sync tells Xero about the Tax Rates you have charged customers. You can tell the app which Linnworks Tax Rate should be mapped to a given Tax entry in Xero to ensure everything is correctly configured for your Accountant
The button opens the above dialog. You can Add which Linnworks tax rate is mapped to the selected Xero Tax entry. The Linn Tax dropdown shows all the calculated tax rates Linnworks has imported in orders thus far. Also you can choose and enter an amount in the Specific Tax in range to override the Linn Tax option, in anticipation of orders to come.
iv. Payment Mapping
If you use Payment Methods in Linnworks (for example, differentiating credit card payments from PayPal), then you need to ensure this section is configured. It maps the Payment Methods in Linnworks to specific Account Types in Xero. This allows Xero to keep track of disbursements etc for you.
If you want to manage your customer based on the payment type you can enable the manage customer at the time of payment mapping.
It will help you to manage the account customer/Credit customer to track the payment or outstanding amount.
When you will enable manage customer option then it will ask for the using which details you want to identify your customer.
You can mange customer by Email/Company Name
When you will select option Email then it will check that there is any customer exist with same email id and if exist then import invoice in that customer.
When you will select option Company Name then it will check there is any customer exist with same company name and if exist then import invoice in that customer.
If you want to export unpaid order to xero then enable the option “Export Linnworks Unpaid order”.
Options for setting up and managing the synchronisation process can be found by clicking on Synchronisation.
For each service, you can select the Invoice Type that will be used when importing it to Xero.
When you have a small number of orders, you can use the ‘Individual Order’ options, and 1 Sales Invoice is created per Linnworks order.
Source SubSource Summary means that all the orders are combined, then broken down into combined Sales Orders grouped by the Source/SubSource, but also by Currency, Payment Method and date.
The Is Running column shows whether the Create Invoices Service is currently running.
The Sync button allows you to manually run the Invoice creation service on demand
The Automation field should be ticked if you want the App to create your Sales Invoices in Linnworks automatically overnight. Otherwise you must click Sync regularly.
The Download Order column shows that you want to export open order/process order/both (open and process order) into xero.
The Invoice Item Detail field will be set for the what order details you want to export at xero. Options are as below:
Tax Rate Wise: It will group the same tax rate details and export in xero. In that there is no product details or order details are exported.
Order Reference (Channel Reference Number): It will export the channel reference number as invoice line at xero.
Product Details: It will export the order item SKU, title at xeroProduct Details with OrderId: It will export the order item SKU and title and also linnworks Orderid as last item in invoice
vi. Currency Mapping
This is automated process.
This displays a list of currencies between used in Linnworks orders, and which currencies they are mapped to in Xero to ensure they are correctly invoiced.
vii. Invoice History
This shows all the invoices created in Xero for today. The switch at the top allows you to filter either Daily Invoices or Backdated Invoices. It also shows if any errors occurred during creation.
viii. Purchase Credit
Once you click on Purchase Credit, the Subscription page will be opened.
The initial screen addresses your preferred subscription option. The subscription for the Xero Connector app is based on the number of orders you sync from Linnworks into Xero during the month. Should you run out of credits, you can return to this page and opt to upgrade to the next package, gaining the balance of extra credits between the old limit and the new.
e.g. You had been subscribed to The Basic package, that was sufficient initially. You run out of credits on the 19th of the month, and upgrade to Pro. You now have 7,000 credits remaining. These may not all get used up this month, but if you continue to grow, your volumes will increase and so will the number of orders.
In this app we have included the ability to back-date the synchronization. This means you can ask the app to synchronise orders from Linnworks with dates prior to installation of the app. This will, of course, require the payment of the appropriate subscription to cover those periods.
Tick the Back Dated Subscription option, and select the month and year you wish the synchronisation to start, then click Submit. You will receive an email with information regarding the costs and a payment option to complete before the connector can process your back dated orders.