Training By Himanshu

Tag: Accounting Software

  • Step-by-Step Guide to Multi-Currency in TallyPrime (Export, Import & Forex Gain/Loss)

    🌍 Multi-Currency Transactions in TallyPrime

    🔹 Step 1: Enable Multi-Currency Feature

    1. Open TallyPrime → Press F11 (Features) → Accounting Features.
    2. Under General, set “Enable Multiple Currencies” → Yes.
    3. Save settings.

    🔹 Step 2: Create Currencies

    1. Go to Create → Accounts Info → Currencies → Create.
    2. Example:
      • Currency Name: US Dollar
      • Formal Name: USD
      • Symbol: $
      • Is symbol suffixed to amount: Yes
      • Number of decimal places: 2
      • Show amounts in millions: No
      • Specify Rate of Exchange: 1 USD = ₹84 (as on today’s rate)

    Repeat for other currencies (Euro, Pound, etc.).

    🔹 Step 3: Create Ledger Accounts

    • Bank Ledger (USD A/c) → Bank A/c under Bank Accounts, select currency as USD.
    • Customer Ledger (ABC Inc., USA) → Sundry Debtor, set Currency: USD.
    • Sales Ledger → Invoicing → Use default Base Currency (INR).

    🔹 Step 4: Record Multi-Currency Sales Voucher (Example 1: Export Sales)

    Scenario:

    👉 You sold goods worth $1,000 to ABC Inc. (USA).
    👉 Exchange Rate: 1 USD = ₹84

    Steps:

    1. Go to Sales Voucher (F8).
    2. Select Customer: ABC Inc. (Currency USD).
    3. Enter item details, amount will show in USD.
      • Example: 1,000 USD.
    4. Tally automatically converts → ₹84,000 (in INR books).

    📌 Entry shown in Tally

    • Dr. ABC Inc. (USD) → $1,000 (₹84,000)
    • Cr. Sales A/c → ₹84,000

    🔹 Step 5: Record Receipt Voucher (Example 2: Payment Received in USD)

    Scenario:

    👉 Customer pays $1,000 later, but now exchange rate = ₹85.

    1. Go to Receipt Voucher (F6).
    2. Dr. Bank A/c (USD) $1,000 (₹85,000).
    3. Cr. ABC Inc. (USD) $1,000 (₹84,000).

    📌 Tally automatically shows Forex Gain: ₹1,000 (difference due to exchange rate).

    🔹 Step 6: Import Purchase Example (Vendor in USD)

    Scenario:

    👉 You import raw materials worth $500, exchange rate ₹83.
    👉 Bank pays later at ₹84.

    1. Purchase Voucher (F9) → Select Supplier (USD Ledger).
    2. Purchase recorded as $500 = ₹41,500.
    3. At payment time (Payment Voucher F5):
      • Dr. Supplier $500 = ₹42,000
      • Cr. Bank A/c = ₹42,000
      • Forex Loss = ₹500

    🔹 Step 7: Reports & Analysis

    • Check Ledger → Customer/Supplier → Display → Tally shows both foreign currency & INR equivalent.
    • Balance Sheet / P&L → Consolidated in base currency (INR).
    • Forex gains/losses shown separately.

    ✅ Practical Example Summary

    TransactionCurrencyRateLedger Impact (INR)Forex Effect
    Sales to US Client$1,00084₹84,000–
    Receipt from Client$1,00085₹85,000Gain ₹1,000
    Import Purchase$50083₹41,500–
    Payment to Supplier$50084₹42,000Loss ₹500

    👉 This way, TallyPrime auto-tracks exchange rate fluctuations and shows real forex gain/loss in your accounts.

    Featured products

  • Education Mode and Company Creation and Management in Tally ERP 9

    Tally ERP 9 is a widely used accounting software that offers various features for managing financial transactions, inventory, and payroll, among other functions. It is often used by businesses of all sizes to streamline their accounting processes.

    When learning Tally ERP 9, users can access an “Education Mode” that allows them to familiarize themselves with the software’s functionalities without the constraints of real-world data. In Education Mode, users can explore all the features available in the software, but with certain limitations, primarily related to the dates.

    In Education Mode, the software restricts the user from entering dates beyond a certain range, typically limited to the first two days and the last two days of any given month. This restriction ensures that users focus on learning the software without inadvertently entering erroneous or irrelevant data.

    Here are some key points about Education Mode in Tally ERP 9:

    1. Feature Accessibility: All features of Tally ERP 9 are accessible in Education Mode. Users can explore various modules such as accounting, inventory management, taxation, and reporting.
    2. Date Limitations: The primary restriction in Education Mode is related to the dates. Users cannot input dates beyond the first two days and the last two days of any month. This limitation encourages users to practice within a controlled environment and prevents accidental data entry errors.
    3. Learning Environment: Education Mode provides a safe environment for users to learn and experiment with the software without the risk of affecting real financial data. It allows beginners to familiarize themselves with the software interface, navigation, and functionality.
    4. Training and Certification: Many educational institutions and training centers use Tally ERP 9 Education Mode to teach accounting and financial management principles. Students can practice accounting procedures, voucher entries, inventory management, and other tasks as part of their curriculum.
    5. Transition to Regular Mode: Once users gain proficiency and confidence in using Tally ERP 9, they can transition to the regular mode of the software, where they can work with actual financial data and perform accounting tasks for real-world scenarios.

    Education Mode in Tally ERP 9 serves as a valuable tool for beginners to learn accounting principles and software functionality in a controlled environment, enabling them to build skills and expertise in financial management.

    To create a new company in Tally ERP 9, you typically follow these steps:

    1. Launch Tally ERP 9: Open the Tally ERP 9 software on your computer.
    2. Select the Company Info Menu: Once Tally ERP 9 is open, you’ll see various options in the main menu. From the main menu, select “Company Info” or press Alt + F3.
    1. Create Company: In the “Company Info” menu, you’ll find an option to create a new company. Select the option that says “Create Company” or press Alt + C.
    2. Enter Company Details: After selecting the option to create a new company, you’ll be prompted to enter details about the company. These details typically include:
    • Company Name: Enter the name of your company.
    • Mailing Name: This is an optional field where you can enter a different name for mailing purposes.
    • Address: Enter the address of your company.
    • Country: Select the country where your company is located.
    • State: Select the state where your company is located.
    • PIN Code: Enter the PIN code or postal code of your company’s address.
    • Email: Enter the email address associated with your company.
    • Telephone: Enter the telephone number of your company.
    • Mobile: Enter the mobile number of your company.
    • Financial Year: Specify the financial year for your company. Tally ERP 9 will use this information for financial reporting purposes.
    • Books Beginning From: Enter the start date for your company’s books. This is typically the beginning of the financial year.
    • Security Control: Set up security controls such as password protection if desired.
    1. Save Company Details: After entering all the necessary details, review them to ensure accuracy. Once you’re satisfied, save the company details.
    2. Select Company: Once the company details are saved, you’ll be prompted to select the company you just created. Select the company from the list to start working in it.
    3. Begin Using Tally: Once you’ve selected the company, you can start using Tally ERP 9 to perform accounting and other financial tasks for your company.

    That’s it! You have successfully created a new company in Tally ERP 9 and can now begin managing your company’s finances using the software.

    Managing Companies in Tally

    In Tally ERP 9, managing companies involves tasks such as opening an existing company, altering company details, and deleting a company. Here’s a guide on how to perform these actions:

    Opening an Existing Company:

    1. Launch Tally ERP 9: Open the Tally ERP 9 software on your computer.
    2. Select Company Info Menu: From the main menu, go to “Company Info” or press Alt + F3.
    3. Select “Select Company”: In the “Company Info” menu, choose the option that says “Select Company” or press Alt + F1.
    4. Choose the Company: A list of existing companies will be displayed. Highlight the company you want to open and press Enter. Alternatively, you can double-click on the company name.
    5. Enter Company Password (if applicable): If the company is password-protected, you will be prompted to enter the password. Enter the correct password to access the company.

    Altering Company Details:

    1. Launch Tally ERP 9: Open the Tally ERP 9 software.
    2. Select Company Info Menu: From the main menu, go to “Company Info” or press Alt + F3.
    3. Select “Alter Company”: In the “Company Info” menu, choose the option that says “Alter Company” or press Alt + F4.
    4. Choose the Company: A list of existing companies will be displayed. Highlight the company for which you want to alter details and press Enter.
    5. Make Changes: You will now be in the alter mode. Make the necessary changes to the company details, such as the company name, address, or contact information.
    6. Save Changes: After making the alterations, save the changes by pressing Ctrl + A or selecting “Yes” when prompted to save.

    Deleting a Company:

    Note: Be cautious when deleting a company as this action is irreversible, and all data associated with the company will be permanently removed.

    1. Launch Tally ERP 9: Open the Tally ERP 9 software.
    2. Select Company Info Menu: From the main menu, go to “Company Info” or press Alt + F3.
    3. Select “Alter Company”: In the “Company Info” menu, choose the option that says “Alter Company” or press Alt + F4.
    4. Choose the Company: A list of existing companies will be displayed. Highlight the company you want to delete and press Enter.
    5. Delete Company: In the alter mode, press Alt + D or choose the option that says “Delete Company.” Confirm the deletion when prompted.
    6. Confirm Deletion: Tally ERP 9 will ask for confirmation. Confirm that you want to delete the company, and the company will be permanently removed.

    Remember to exercise caution, especially when deleting a company, as it removes all associated data. Always ensure you have a backup before making significant changes.

  • Tally.ERP 9: Introduction and Installation Guide

    Introduction to Tally.ERP 9:

    Tally.ERP 9 stands as a robust business management software solution meticulously crafted to streamline and automate various financial and accounting processes across businesses of diverse scales. Developed by Tally Solutions Pvt. Ltd., Tally.ERP 9 has gained widespread acclaim globally for its user-friendly interface, extensive features, and scalability.

    With Tally.ERP 9, businesses can proficiently manage a spectrum of financial transactions, inventory, payroll, compliance, and other pivotal aspects of their operations. This software furnishes an array of modules and functionalities tailored to suit diverse business requisites, enabling organizations to uphold precise financial records, generate profound reports, and make well-informed decisions.

    One of Tally.ERP 9’s primary strengths lies in its adaptability and flexibility across various industries and business environments. Irrespective of whether it caters to a fledgling startup, a mid-sized enterprise, or a corporate giant, Tally.ERP 9 can be meticulously customized and configured to align with specific requirements, thereby ensuring seamless integration with prevailing workflows and processes.

    From managing invoicing and taxation to facilitating budgeting and financial analysis, Tally.ERP 9 equips businesses with the requisite tools to remain compliant, enhance efficiency, and foster growth. Its intuitive interface and robust features empower users to navigate financial intricacies with ease, while its stringent security measures guarantee data integrity and confidentiality.

    Overall, Tally.ERP 9 stands as the preferred choice for businesses in quest of a reliable and efficient accounting software solution. With its continual updates and enhancements, Tally Solutions remains steadfast in its commitment to aiding businesses worldwide in streamlining operations and realizing their financial aspirations.

    How to Install Tally.ERP 9 from the Tally Official Site:

    1. Visit the Official Website: Initiate your web browser and navigate to the official Tally Solutions website. You can seamlessly locate it by entering “Tally Solutions” in your preferred search engine.
    2. Access the Downloads Section: Once you’ve reached the Tally Solutions website, head to the “Downloads” section. Typically, this section houses links for downloading the latest iteration of Tally.ERP 9.
    3. Select Your Edition: Tally.ERP 9 proffers a variety of editions, including Silver (for single users) and Gold (for multiple users). Evaluate your requirements and opt for the edition that best aligns with your necessities.
    4. Download the Installer: Click on the download link corresponding to the chosen edition. The website will provide explicit instructions for downloading the installer file.
    5. Save the Installer: Upon clicking the download link, your browser will prompt you to save the installer file. Elect a suitable location on your computer to save the file and initiate the download by clicking “Save” or “Download”.
    6. Execute the Installer: Following the completion of the download, navigate to the location where the installer file is stored on your computer. Double-click the file to commence the installation wizard.
    7. Follow Installation Instructions: The installation wizard will diligently steer you through the installation process. Pay heed to the on-screen prompts and instructions to seamlessly install Tally.ERP 9 on your computer.
    8. Activate the Software (if Necessary): Depending on the edition you’ve opted for, you may need to activate the software employing the license details furnished by Tally Solutions. Follow the activation process delineated during the installation or subsequent to its culmination.
    9. Complete the Installation: Once the installation and potential activation processes are concluded, you’re poised to commence utilizing Tally.ERP 9 for your accounting and business management exigencies.

    It is of paramount importance to ensure that you download Tally.ERP 9 exclusively from the official Tally Solutions website to avert any potential risks associated with downloading unauthorized versions of the software. Always adhere to the official instructions dispensed by Tally Solutions throughout the installation process to ensure a seamless experience.