Tutorial: Import data from TAS Books into Excel - Part 2. by David Carter | AccountingWEB

Tutorial: Import data from TAS Books into Excel - Part 2. by David Carter

In the first of this two part series David Carter showed how to get nominal transactions out of TAS Books and into Excel via Excel’s Data – Import External Data command. In this second tutorial he shows how to use an Excel pivot table to analyse the data and (if you want it) to provide job costing analysis

In part one we exported nominal transaction data from TAS into Excel. We used Excel’s Import External data command for this rather than File-Open. This has two key benefits.


» Register now

The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.

Registration is FREE and allows you to view all content, ask questions, comment and much more.


Problems with consolidating departments

pedropnr | | Permalink

Very usefull article on importing tas values to excel.However,there does not seem to be a facility to import all the values for a range of nominal accounts if you are using departments as well as nominal accounts.For example,we split P & L nominals into 5 sub categories using the department codes-we use 100/101/etc.We have to do this to cater for Cis & non Cis suppliers as the Tas cis system is not designed to cater for nominal codes in the P & L being capable of taking both cis & non cis supplies.
Any ideas on how to import data to incorporate consolidates departments?