Share this content

Getting data out of Iris Accounts production

Getting data out of Iris Accounts production


We currently use Iris accounts produciton to produce our accounts and we also have an excel workbook full of our workping papers and currently we have to enter the trial balance in to both and any adjustments into both.

What i would like to find out is if its possible to connect excel to Iris accounts production and pull the data out from there. I am not sure how Iris accounts production holds all the data. I can get into the practice management data via a sql connection but can not find the sql database for account produciton data (not even sure thats how it stores its data). Any pointers anyone can give me would be much apreciated even if its to say it cant be done.




Please login or register to join the discussion.

By Old Greying Accountant
08th Aug 2012 15:46


Make so much unnecessary work, I just save a pdf of the TB, Nominal and posting list at the end of the job. If you use posting batches you can get a detailed TB showing opening position, your adjustments and closing balances.

The assumption would be though, if you can print a report to Excel, you should be able to create a link - but I'm just a bean counter, not a techy!


Thanks (0)
08th Aug 2012 15:09

Have you asked Iris?

I echo OGA's "Why?" but if your certain that's how you want to continue, this would certainly be a question for the Horse's Mouth.

Thanks (0)
Share this content