Final accounts preparations using with Tally9 & Excel


This query is : Resolved 

(Querist)
22 September 2008 Dear Sir,

I am using Tally9 Multi user accounting package, When preparing accounting reports from Trial Balance, I tried to design a excel sheet that will fetch data from text file generated from tally9 in text format having

Head of account Dr amount Cr Amount

I am using powertools addin to remove n leading character to remove (-) symbol infront of debit balances.

When other users create a ledger accounts at their own, I can't resist them to create that but my excel template created by fails to show whether that head of account is matches with correct ledger account with respective ledger amount. Whenever I use Tools -> Get External data will update the accounting reports, shows some error.

I came to know that lookup, match will be helpful but I dont know how to use it

Kindly help me


Kannan.N

RAMPRASAD (Expert)
24 September 2008 Hi

I am not able to visualise your query properly. Either you split your query in parts or send the excel file where you need help.

Vlookup will be useful, but u have to be more specific about your query.

Thanks
Ram

Kannan (Querist)
25 September 2008 First of all, I export a TB on 31-08-08 as text file, then open excel, Data->Get External Data->Import from Text File, now I got a TB in excel, then I prepare final accounts. On 30-09-08, again I export a TB in text file in the same name. Then Open the existing excel file, Data->
!Refresh Data, the final accounts are updated. If I tried to export the same using ODBC Server, I got the data upto last entry, in the following format
Parent Group-- Ledger A/c -- Amount. How to fetch data to particular date, using ODBC. Incase I use alphabetical TB in excel format (Tally9 R2.13),in next sheet linked the first page for each ledger a/c, then sorting groupwise by adding one more column to first worksheet CA, CL, FA, PRO for grouping. At this point, vlookup, match, index functions are useful, but I wish to know how? Please help me. Also how to attach my excel file

Kannan (Querist)
25 September 2008 If any changes in first sheet of excel will affect second adjusted TB, If I using sorting the group of current assets merged with other group of ledger accounts.
ie.,
Col A Col B Col C
Current Assets Cash xxxxx.xx
Loans BOB a/c xxxxx.xx

the above accounts are changed alphabetically. At this point, vlookup, match, index functions are useful, but I wish to know how? =index(match(firstsheet,0) something like that. I don't know Please help me

30 September 2008 Kannan is right

Kannan (Querist)
01 October 2008 Till no final solution by any of our club members

06 October 2009 Hello, is this an old query still pending? You can send me a Pm if yes....I m trying to take all old pending queries in Accounting Forum......Thanx.

06 October 2009 Hello, is this an old query still pending? You can send me a Pm if yes....I m trying to take all old pending queries in Accounting Forum......Thanx.


You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
ARTICLESHIP 23 October 2026
Articled Trainee

J Y & CO

Hyderabad

CA Inter

View Details
Company
23 October 2026
Sr. Accountant

SANKARAN & KRISHNAN

New Delhi

B.Com

View Details
Company
12 November 2026
Auditor

Oz Taxation

Vijayawada

Graduate (Any)

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details