Final accounts preparations using with Tally9 & Excel
This query is : Resolved
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
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
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
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
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
!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
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
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
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
Click here to login now
Similar Resolved Queries
Unanswered Queries
- About TDS & Income Tax
- Scrutiny and reopening of past returns
- Tax on Deemed Capital Gain
- F & O PROFIT REPORTING FOR AY 2026-27
- Booth for sales promotion
- Type of Capital Gain
- Regarding ITR filing with more value than showing in AIS/TIS
- Can partnership firm show income under 44ad
- Banking Related Issue
- Rental income of jointly held property
- Difff in ais receipts and gst turnover
- ITR-3 File/Error Found
- Exiting partner in partnership firm in gst portal
- Taxability of credit in canara bank ET & T section (NRO)
- Consequences of Non-Deduction of TDS under Income Tax???????????????
- TDS on Rent received on redevelopment of building
- Indian IT Portal issue in computing tax as per UK-India DTAA
- Capital Gains on sale of residential flat
- Upload Level ValidationITR3Category of Defect B/D
- PF Taxable Income
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
