Tally has an advantage feature of exporting and importing data. It's advantageous to know about Tally’s export and import capabilities, which enables Tally to interact globally. Statements and data from Tally can be exported to other programs like spreadsheets and databases. Only data from Tally can be imported and not data from other systems. Importing from other systems involves the usage of ‘Tally’s Definition Language’ TDL.
Export of Data
You might need to export information for different purposes, viz:
To re-import data into another company run on Tally.
To export data out to be used by other programs.
Exporting Masters
Step 1:
Go to Gateway of Tally > Display > List of Accounts > click on Export.
Tally first asks for the export format. The different formats are, ASCII, EXCEL, HTML and XML. The file-name extension will take the default format.
Figure: Exporting the List of Ledgers screen
For example, since we have selected XML, the filename displayed will be Master.xml
Figure: Exporting List of Ledgers
Exporting Data for Re-import into another Company
Step 1: Exporting Daybook
Go to Gateway of Tally > Multi Account Printing > Daybook > click on Export.
Figure: Exporting Day Book
Tally first asks for the language. Select Default (All Languages), then convert it into the export format. The different formats are: ASCII, EXCEL, HTML and XML. The filename extension will take the default format. For example: Selecting ASCII, results in the filename being displayed as Daybook.txt.
Specify the other details as desired. Accept to export, Data exported from a company can be imported into another.
Import of Data
Step 1: Importing Masters
Return to the Gateway of Tally.
Shut National Traders and load Indus Enterprises (Ensure that it has the same financial year as the current company National Traders).
Select Import of Data > Masters
Figure: Import of Masters screen
The opening balance can be modified from the exported source file. Carefully select, Modify with new data.
Verify that the import is completed successfully.
Note: Data can be imported from the previous version, provided the Import filename is in the XML format, since Tally supports only the XML format.
Step 2: Importing Vouchers
Return to the Gateway of Tally.
Select Import of Data > Vouchers.
Give the filename Daybook.xml.
Check the statistics after import.
Export to Excel from Tally.ERP 9
Tally.ERP 9 now comes with the functionality, wherein all reports can be exported to Microsoft Excel spreadsheet. This feature enables you to export any report generated by Tally.ERP 9 into Excel.
To export the Trial Balance,
Go to Gateway of Tally > Display > Trial Balance
Click on Export.
Figure: Export Option in Tally.ERP 9
Select Restricted (ASCII only).
Select Excel (Spreadsheet) in Format.
Type the name of file for Output File Name as required.
Specify other details.
Figure: Report Generation Screen for Excel
Click Yes for Export.
Figure: Report in Excel Imported from Tally.ERP 9
By default, the exported report in Excel format is saved in the Tally.ERP 9 folder. Open this file using MS-Excel to view the report.
Hello Nitesh,
ReplyDeletei want to import sales voucher from one tally to another, how to do it??
Sales vouchers consist of data relating to stock items, sales account, debtors account and tax or vat account. So, at first you need to export all the masters. If any master is left, the data relating to that master can not be imported.
ReplyDeleteThen go to Gateway of tally>Display>Statement of Accounts>Statistics>sales
Select the date range of the data you need to export.
Export it in xml format.
Then import the master at first in another tally.
After that, import the vouchers.
But you need to be careful on importing because the opening balance also get imported with importing masters. It manipulates your opening balances.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteHi.
ReplyDeleteYou can also use SMART excel to tally to integrate excel data into tally through xml.
Try - http://www.xltally.in
Sir I had a question,
ReplyDeleteIs it possible to copy a company?
ie "Company A" was already there from 2009
i want a "new Company B" also from 2009 with all details from company A
Your question is quite unclear.
Delete1. If you want to continue entry in company B with all financial data of company A:
Ans 1: You can copy the company folder to another name. For that, you need to go to tally directory where you have placed your data. e.g. c:\\program files\tally.erp9\data and then select the folder of Company A. If you do not know which is company A in the data folder, just open tally and go through the directory where you can see file names after inserting file path. Copy the company A folder with different numerical number. Be noted the digits must be same. In ERP9, it is 5 digits so you are required to put 5 digits file name. Then go through the tally, rename the company to company B. This is the shortest technique.
2. Company Split:
The easy way is splitting the company where you get 2 new companies. One with all the opening balance from Company A, and another one is duplicate of company A. You need to go to cmp info or alt+F3, and select split company, then select company, you are asked for company name and date you want to split from. Then you will get the two new companies. Keep the required one, and delete the unnecessary one. It may take time to split depending upon the tally statistics.
Hope you get your answer.
Sorry for late response.
Download Free SMART Excel to Tally Software – http://www.xltally.in
ReplyDeleteMany Thanks for Your Blog Post. Good Resource for All...
ReplyDeleteSir, can we export vouchers in excel containing reference of the bill?
ReplyDeleteThis is very really useful website for the tally.......
ReplyDeleteWhy AI-Driven Learning Is the Future of Education
ReplyDeleteLet’s explore six data-backed reasons why AI is the future of education — and how Simandhar Education is already leading the way with AI-powered platforms across its global certification programs.
1. Adaptive Learning Boosts Retention by Over 35%
Traditional education treats all students the same, but adaptive learning customizes the experience. According to a McGraw Hill and Arizona State University study, students using adaptive courseware experience 35–45% higher knowledge retention compared to standard learning methods.
AI algorithms assess individual learner behavior and adjust content difficulty, pace, and delivery format to optimize comprehension — especially helpful for US CPA subjects like REG or complex Data Analytics modules.
2. Real-Time Analytics Increases Exam Readiness by 28%
AI systems analyze quiz performance, time spent per module, and topic-wise accuracy to offer real-time feedback. Studies from McKinsey and EDUCAUSE show a 28% boost in exam performance when students receive immediate, data-driven feedback.
Learners no longer have to wait for human evaluations — AI tools instantly highlight weak areas and suggest corrective steps, accelerating exam preparation.
3. 24/7 AI Tutors Improve Query Resolution Speed by 80%
Traditional learning environments often have delayed response times. AI-powered academic bots solve this by answering questions in real-time. IBM’s education case studies reveal that AI tutors can cut student query resolution times by over 80%.
Whether it’s a CPA FAR journal entry or a Python script error, students get reliable, instant answers anytime — reducing dependency on limited faculty hours.
4. Predictive Algorithms Help Reduce Dropout Risk by 25–30%
AI doesn’t just track current performance — it forecasts future issues. EDUCAUSE and Inside Higher Ed report that predictive analytics can reduce dropout risk by 25–30% by detecting early signs of disengagement or poor performance.
If a student misses quizzes, lags behind, or struggles in specific topics, AI alerts mentors for timely intervention — improving retention and success rates.
5. Gamified Simulations Drive 2X Skill Application in Analytics Training
AI-driven gamification makes learning interactive and practical. According to Harvard Business Review and PwC, simulation-based learning improves applied skills by up to 2x compared to textbook methods.
Learners in AI or Analytics programs gain hands-on experience solving real-world cases — such as building Power BI dashboards or writing Python code for data cleaning.
6. Smart Dashboards Enhance Educator Decision-Making
Educators also benefit from AI. HolonIQ and Gartner reports show that AI dashboards help teachers reduce admin workload by 40%, allowing them to focus on academic quality.
Faculty can see which students are underperforming, which topics need revision, and how different cohorts compare — enabling precision teaching.
Conclusion
AI-driven learning isn’t a prediction for tomorrow — it’s a revolution happening today. From real-time feedback to adaptive simulations, AI empowers learners with insights, speed, and flexibility. Simandhar Education, with its robust AI infrastructure and strategic use of Skillfluenz, is proving that personalized, smart learning leads to smarter results.
If you’re preparing for a global career in finance, compliance, or analytics, now’s the time to choose a future-ready learning platform.
Get Started Today!
Call: +91 7780273388
Visit: www.simandhareducation.com
To know more join this Free webinar – Registration link
Choose Simandhar. Learn with AI. Succeed faster.
CPA Course
MS in Accounting in the USA – Top Universities, Eligibility, and Career Scope
ReplyDeleteMS in Accounting in the USA: OPT Extension, Job Roles, Salaries & Certifications You Should Know
Pursuing an MS in Accounting in the USA has become a popular and strategic choice for international students aspiring to build a rewarding career in finance, auditing, taxation, and consulting. The USA not only offers world-class education but also practical training opportunities that can help students gain real-world experience, enhance their resumes, and secure well-paying jobs.
This blog covers everything you need to know about the OPT extension, popular job roles, expected salaries, and certifications that will set you apart after completing your MS in Accounting in the USA.
Understanding OPT and the STEM OPT Extension
Optional Practical Training (OPT) is a key benefit for international students in the USA on an F-1 visa. It allows graduates to work in a job related to their field of study for up to 12 months after graduation. Fortunately, the MS in Accounting is considered a STEM (Science, Technology, Engineering, and Mathematics) degree by many institutions, which means you qualify for an additional 24-month STEM OPT extension.
This extension effectively lets you work for up to 3 years post-graduation, providing a significant opportunity to gain industry experience, apply academic knowledge, and build a professional network. The STEM OPT extension has been a game-changer for many accounting graduates, allowing them to deepen expertise and improve employability.
Top Job Roles to Explore After MS in Accounting
Your MS degree prepares you for various roles in the accounting and finance sectors. Here are some of the most sought-after jobs you can target:
Financial Analyst: Analyze financial data, prepare reports, and guide business investment decisions. This role blends accounting skills with analytical insights.
Certified Public Accountant (CPA): CPAs handle auditing, tax filings, and financial reporting. This certification is often considered the gold standard in the accounting profession.
Management Accountant: Responsible for budgeting, cost management, and strategic financial planning within organizations.
Auditor: Conduct audits to ensure compliance with financial regulations and help organizations identify financial risks.
Tax Consultant: Provide specialized advice on tax planning and regulatory compliance for individuals and companies.
Forensic Accountant: Investigate financial discrepancies, fraud, and legal disputes involving financial data.
Salary Expectations: What Can You Earn?
Salaries in accounting can vary widely based on location, experience, and certifications. Below is an overview of typical salary ranges for popular job roles in the USA:
Entry-Level vs Mid-Level Salaries (USD):
Financial Analyst: $60K–$70K → $80K–$95K
CPA: $65K–$75K → $90K–$120K
Management Accountant: $60K–$70K → $85K–$105K
Auditor: $58K–$68K → $80K–$100K
Tax Consultant: $60K–$75K → $85K–$110K
CPA Course
Crack CPA Simulations Like a Topper | Simandhar Education
ReplyDeleteStruggling with CPA simulations? You’re not alone.
Task-Based Simulations (TBS) are one of the most challenging—and critical—parts of the US CPA exam. Making up 50% of the total score, simulations test your ability to apply accounting concepts in real-world business scenarios.
While MCQs check your knowledge, simulations test your mindset, judgment, and clarity under pressure.
So how do you prepare to conquer this crucial section?
Let’s take a page from the playbook of Ujjwal Ahluwalia, the 6th CPA world topper from India, a proud Elijah Watt Sells Award winner, and now placed at American Express. With scores like FAR – 99, BEC – 97, REG – 95, and AUD – 93, Ujjwal didn’t just pass—he dominated the US CPA exams.
In an exclusive podcast with Sripal Jain, Co-Founder of Simandhar Education, Ujjwal shared his 3 simulation strategies that helped him clear CPA on his first attempt. And these are strategies every CPA aspirant can use.
Watch the Full Podcast: Ujjwal Ahluwalia x Sripal Jain
How a World Topper Cracked the US CPA and Landed in American Express
Strategy 1: Read the Question First — Not the Exhibits
“Most students open all six exhibits and get overwhelmed. Read the question first.” – Ujjwal
Each simulation often includes multiple exhibits—like emails, financials, memos, and contracts. But not all are necessary for every question.
Instead of jumping into all exhibits, start by reading the question carefully. Once you understand what’s being asked, open only the exhibit(s) related to that section.
This approach saves time, reduces confusion, and keeps your focus sharp.
Why this works: It prevents information overload and helps you extract exactly what’s needed—nothing more, nothing less.
Strategy 2: Solve One Section at a Time
“Each simulation is divided into parts. Don’t multitask—handle one part at a time.”
Simulations are modular—each question typically relates to a specific topic and often connects with just one exhibit. Ujjwal recommends solving each section independently, using only the data needed for that part.
So instead of flipping through all exhibits or questions, you:
Read Part A, open Exhibit 1, solve.
Move to Part B, open Exhibit 2, solve.
And so on.
Why this works: Breaking down complex simulations into bite-sized tasks minimizes mental fatigue and boosts accuracy under time pressure.
Strategy 3: Keep It Simple — Think Like a Professional
“It didn’t feel like an exam. It felt like a real client asking me something.”
Ujjwal’s most valuable advice? Don’t overthink simulations.
He approached each one as if he were working in a real accounting role, answering questions for a client or manager. This mental shift helped him stay calm and focused.
Why it works: The CPA exam doesn’t want fancy answers—it wants clear, logical, professional reasoning. Keeping things simple improves your performance and saves time.
Conclusion
Simulations in the CPA exam are not a trap—they’re an opportunity. They test how you think, not just what you’ve memorized. And with the right approach, they can become your strength.
So take it from Ujjwal Ahluwalia—a world topper who’s walked this path:
Start with the question, not the data dump
Break it down section-by-section
Keep it simple and professional
Master these strategies, and you won’t just clear CPA—you’ll crack it with confidence.
Interested in learning more about Simandhar’s CPA program?
You can explore the course structure, attend a free webinar, or speak directly with Simandhar’s experts to understand your eligibility and roadmap.
Book your FREE counselling session now:
Call: +91 7780273388
Visit: www.simandhareducation.com
Because your CPA dream deserves nothing less than the best.
CPA Course
Why Accounting Is the Smartest Career Move Today
ReplyDeleteIn a world driven by data, automation, and rapid digital change, one profession continues to evolve, adapt—and thrive: Accounting.
But accounting today is not what it was a decade ago. It’s no longer just about bookkeeping or balancing ledgers. It’s a dynamic, analytical, and globally respected profession that powers strategic decisions in every sector—tech, finance, consulting, manufacturing, and beyond.
And when you combine a career in accounting with a globally recognized credential like the US CPA (Certified Public Accountant), it becomes a launchpad to leadership, global mobility, and long-term career success.
In this blog, inspired by insights from Ujjwal Ahluwalia, a CPA World Topper and Elijah Watt Sells Award winner, we’ll explore why choosing accounting—especially with the CPA—is one of the smartest moves you can make in today’s job market.
Accounting Powers Every Business
At the core of every successful organization lies a strong accounting function.
Accountants are not just number crunchers—they’re financial storytellers. They:
Analyze financial health
Guide investments
Ensure regulatory compliance
Shape growth strategies
From startups raising capital to multinational corporations planning mergers, accountants play a mission-critical role. No business, no matter how advanced, can scale without them.
“Accounting is the language of business. If you speak it fluently, you become essential to every decision.”
Want to hear it from someone who scored 99 in FAR and now works at American Express?
Watch this insightful conversation between Sripal Jain and Ujjwal Ahluwalia, where they discuss the real-world value of accounting and how CPA transformed Ujjwal’s career.
US CPA: Your Global Passport in Accounting
The US CPA credential is more than just an exam—it’s a career accelerator.
Recognized in 180+ countries, the CPA equips professionals with expertise in:
US GAAP
Audit & Assurance
Taxation
Financial Reporting
Business Law & Ethics
It’s also the most in-demand qualification among Big 4 firms, Fortune 500 companies, and MNCs hiring in India, the US, UAE, Canada, and beyond.
Key advantages of the CPA:
Average starting salary: ₹7–15 LPA in India; $60,000–$100,000 globally
Licensure to practice in the US
Flexibility to work in audit, consulting, finance, or corporate roles
Faster path to leadership positions
A Career That Evolves, Not Gets Replaced
With the rise of AI and automation, many jobs are under threat—but not accounting. Instead, accounting has become more tech-integrated and strategically important.
Why Start with Simandhar Education?
At Simandhar, we’ve helped thousands of students and working professionals:
Get evaluated for CPA eligibility
Train with Becker + Simandhar live classes
Practice with simulation-based tests
Prepare strategically with doubt-solving sessions
Get placed in Big 4s and top MNCs
Whether you’re a commerce student, CA inter, MBA finance grad, or working in audit—this is your moment to level up.
Make the Smartest Career Move Now
Accounting is no longer just a “safe” career. It’s a smart, scalable, and global profession.
And with the US CPA qualification, your skills will be respected across borders, industries, and technologies.
Simandhar Education gives you the roadmap, resources, and mentorship to make it happen.
Book your FREE CPA counselling session today:
Call: +91 7780273388
Visit: www.simandhareducation.com
CPA Course
Best US CMA Institute in Delhi | Simandhar Education
ReplyDeleteIn the capital that never stops hustling, your CMA journey deserves a launchpad that matches your ambition.
If you’ve just cleared your 12th exams or are currently pursuing B.Com, BBA, or even B.Sc, and you’re thinking about what’s next in your academic and career journey—this blog is for you.
The world of finance and accounting has changed. Today, it’s not just about degrees; it’s about skills that employers trust globally. And one such skill-boosting credential is the US CMA (Certified Management Accountant)—a powerful, fast-tracked certification that can transform your career trajectory.
And if you’re based in Delhi—a city bustling with Big 4 offices, global MNCs, and startups—there’s no better time to upskill. Let’s explore why US CMA is the right choice and why Simandhar Education is considered the best US CMA institute in Delhi.
Why Choose the US CMA?
1.Globally Recognized Qualification
The US CMA, awarded by the Institute of Management Accountants (IMA), USA, is a credential accepted in over 100 countries. It opens doors to roles in multinational companies, Big 4 firms, and global finance hubs, giving you international mobility and respect.
2.Quick and Efficient Completion
Unlike traditional finance certifications, the US CMA has just two papers and can be completed in 6–8 months. It’s perfect for students who want to build a competitive edge while still in college or for professionals seeking career growth without a long academic commitment.
3.High-Paying Career Roles
US CMA-qualified professionals in India earn an average of ₹5–8 LPA, and this grows significantly with experience. Career paths include Finance Manager, Risk Analyst, Financial Controller, Cost Manager, and even CFO in the long term.
4.Strategic Skill Set
The CMA curriculum is designed to equip you with practical, real-world knowledge—budgeting, forecasting, cost control, risk management, and strategic decision-making. It prepares you to contribute beyond numbers, and into business leadership.
5.Start Right After 12th
You can begin your US CMA journey right after 12th grade and even appear for the exams while pursuing your graduation (BBA, B.Com, B.Sc, etc.). This early start means you can become certified by the time you graduate and get a serious head start in your career.
Why Simandhar Education is the Best US CMA Institute in Delhi
1.Official IMA Gold Partner
Simandhar Education is an officially recognized IMA Gold Partner, which means you’re learning from a provider that meets global standards in content, delivery, and results. It’s a badge of quality that very few institutes in India hold.
2.Top-Tier Study Material
Students at Simandhar get access to Becker-backed content and over 275+ hours of pre-recorded video lectures. These are complemented by live classes, practice questions, and revision notes designed to help you master every concept.
3.Interactive Live Classes
The live sessions are led by experienced US CMAs and industry experts. They’re designed to be more than lectures—they’re engaging, discussion-based classes that connect concepts to real business scenarios.
4.AI-Based Learning with Digital Sripal
Simandhar’s in-house innovation, Digital Sripal, is the world’s first AI mentor for finance learning. It’s available 24/7 to help with doubt-solving, track your learning journey, suggest quizzes, and provide personalized feedback.
Conclusion
The US CMA is more than just another course—it’s a launchpad for a global career in finance and strategic management. And with the rising demand for globally certified professionals, now is the time to act.
Call: +91 7780273388
Visit: www.simandhareducation.com
Book your FREE counselling session today!
CMA Course
US Restarts Student Visas— Social Media Screening Now Mandatory
ReplyDeleteThinking about studying in the United States?
Good news — the USA has officially resumed its student visa processing. But there's a twist. If you're planning to apply for a U.S. student visa, be prepared for more than just an academic or financial review. Now, your social media activity will also be screened as part of the process.
As a global education leader, Simandhar Education believes it's important for students and families to stay informed about such critical changes. Let’s break down what’s happening, what it means for aspiring international students — and how you can prepare.
What’s New in the US Visa Policy?
On Wednesday, the USA State Department announced that all student visa applicants must now provide access to their public social media accounts. This move comes after a temporary suspension of visa interviews, reportedly to implement stricter screening guidelines.
This policy mandates that consular officers will review social media posts, comments, and messages to identify any sentiments perceived as hostile towards:
The U.S. government
American culture and institutions
Founding principles and values
Refusal to allow access may be seen as a red flag and could result in visa rejection.
Why Social Media Matters More Than Ever
The visa application process is no longer confined to what you submit on paper. The digital footprint of a student — especially their social media activity — is now considered a core part of identity screening.
This means that even a meme, comment, or post from years ago could come under scrutiny if perceived as problematic. The aim, according to officials, is to “properly screen every single person attempting to visit our country.”
Who's Affected?
This change is especially relevant for students from countries like India, China, Mexico, and the Philippines, where demand for U.S. higher education remains strong. Many of these students have already been actively refreshing visa appointment portals, eager to get slots as the academic year approaches.
What’s more, the U.S. will prioritize visas for students applying to universities where international students form less than 15% of the total population. This could influence admission strategies, especially for those targeting top private institutions or Ivy League universities, where international student percentages are often much higher.
Implications for International Students
The social media screening rule adds to a growing list of complexities international students face when planning to study in the U.S. Here’s what students should be aware of:
Be Mindful of Online Activity: Make sure your public profiles are clean, respectful, and free from political controversy or satire that could be misinterpreted.
Privacy Settings Matter: Visa officers may ask you to make your social profiles public temporarily. Be prepared.
Documentation is Not Enough: Your online persona now plays a significant role in shaping first impressions during the visa process.
Understand the Policy Shift: The U.S. government is using this as a tool to reinforce ideological vetting, reminiscent of Cold War-era tactics.
Simandhar Education’s Advice to Students
At Simandhar Education, we understand the dreams and challenges of international education. As one of the leading global course providers, especially for US CPA, CMA (USA), EA, CIA, ACCA and STEM pathways, our team works closely with thousands of students navigating visa procedures and overseas admissions.
Call us: +91 7780273388
Visit: www.simandhareducation.com
STEM Accounting Course