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
- REGARDING GST ON COMMERICIAL PROPERTY
- Is this income indian or foreign income?
- 15ca /15cb whose income tax login? remitter or nri seller's login?
- ITC temporary reversal and reclaim
- Regarding Documentation & Compliances for Opening of Unit of Pvt Ltd.
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- GST on export of services and Input Credit
- TDS U/S. 194NF
- Applicable TDS rate for sale of property in Nov 2024
- RCM INVOICING FROM NOV-2024
- Event company query
- MIS MATCH OF INVOICE NUMBER
- VERIFICATION OF REFUND RELATED
- GST Regis.
- ITC c/f from FY2022-23 to FY2023-24 entered the same in table 8C of GSTR9 of FY 2022-23, in FY23-24
- Late filling fees Demand by gst office
- IGST Credit-Show cause notice issued-confusion
- Short and Excess provision of expenses
- Issue of gst e invoice
- Interchangeable words in accounts
Trending Online Classes
CAclubindia
