topic Re: Xero Accounting Integration in QlikView

Xero Accounting Integration

Tue, 08 Mar 2016 05:00:21 GMT

Has anyone managed to integrate into the Xero accounting cloud solution?

I notice this question was brought up in the postConnection to Xero accounting system‌although it remains unanswered and is 5 years old.

With the software improvements and increased number of users has anyone succeeded.

Thank you for any help offered.

Re: Xero Accounting Integration

robert99 — Wed, 06 Apr 2016 13:25:05 GMT

I have

I used a CData ODBC connector. It cost $200 for 12 months

I will look at other options including Qliks rest.

It works well but XERO have not set up the Inventory detail table yet. As well there is not one for fixed assets.

Its also tricky getting the GL details (like invoice name and reference) as the GL is summarized (*1) and doesn't provide a one to one link to the say invoices table. So it a bit of a nightmare getting it all tied in. XERO need to really adjust their data structure to make it a lot easier

* if one supplier invoice contains more than one posting to one Gl account then the total is held as one balance in the XERO GL not two or more. So its possible to get the supplier name but not so easy to link the detail.

Re: Xero Accounting Integration

Tue, 21 Mar 2017 23:37:55 GMT

Any luck on this. I set up the OAuth App in Xero, and installed the certs, and keys everyday to sunday in the connector and am having no luck. Anyone have any ideas on making this work?

Jason

Re: Xero Accounting Integration

paulyeo11 — Mon, 25 Sep 2017 08:54:02 GMT

Hi All

I am also plan to using XERO , look like it is not easy.

Look like Robert Hutchings have a lot of experience in XERO.

Paul Yeo

Re: Xero Accounting Integration

robert99 — Mon, 25 Sep 2017 11:00:15 GMT

Xero wasn't (maybe it has been improved) really set up for BI. Even the Power BI free link wasn't much good I felt. If I was doing it again I would maybe forget about an automatic link (rest or CData) and just do it from reports (account transactions).

I also did too much. It was good but a bit of an overkill. And things like not including foreign exchange unrealised gains in the GL ledger (but in the profit) always meant a difference between the Xero profit and BI profit

XERO is a VG system but they do things in a unique way. That creates issues with a BI extract.

Re: Xero Accounting Integration

paulyeo11 — Mon, 25 Sep 2017 11:19:39 GMT

Hi Sir

Thank you for your sharing . May I know are you user of XERO ?

I saw you organise your Qlik Sense using each QVF for each function. Why no combine all project into one QVF ?

Because :-

1 you only need to reload once

2. You can create all dimension and expression in one QVF file

3. You can create variable in one QVF , easy manage.

Paul

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

Re: Xero Accounting Integration

robert99 — Mon, 25 Sep 2017 11:44:23 GMT

Hi Paul

It is only one QVF. Those are sheets within one QVF.

Re: Xero Accounting Integration

paulyeo11 — Mon, 25 Sep 2017 11:48:27 GMT

Hi Robert

I see , so you already able to read XERO Data to QS ? And able to get all the report you need ? So you are the XERO user ? You also have QS enterprise ?

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

Re: Xero Accounting Integration

cookiejest — Mon, 22 Mar 2021 15:52:32 GMT

Hi,

You can use Cloudslurp to do this to get a live data URL and load it into Qlik using the REST connector...

https://www.cloudslurp.com/#/?connectorname=xero

It is a paid solution but it allows you to export full data sets, handles data pagination and maintains a live connection to Xero.

Extract data from the following Xero tables to Qlik:

accounts, banktransactions, invoices,contacts,payments,purchaseorders,quotes,banktransfers,creditnotes

Re: Xero Accounting Integration

cookiejest — Mon, 22 Mar 2021 15:53:05 GMT

You can use Cloudslurp to do this to get a live data URL and load it into Qlik using the REST connector...

https://www.cloudslurp.com/#/?connectorname=xero

Re: Xero Accounting Integration

scottduthie — Thu, 07 Oct 2021 15:49:54 GMT

Another option is to use Qlik's native REST API to hand encode API calls and fetch the data you need from Xero - a little more work but is a free solution. We have done a fair amount of work on this in the past - feel free to message me if you'd like to discuss further scott@pomerolpartners.com

Something else that may be of interest to you - a Xero connector was part of the Blender.io acquisition - hopefully we'll see that pop up in the application automation section soon.

Scott.

Re: Xero Accounting Integration

marydailey19 — Mon, 25 Oct 2021 08:36:05 GMT

We are using Xero for our business because it allows you to automatically connect many third-party apps in SME platforms. We are consider hiring a professional to help get set up everything and deal with the papers.