Excel to Tally, Excel to Tally Import Utility, How to Import Sales Data From Excel to Tally

0
2K

Introduction:

A company may maintain records either in physical form or through a software. Let’s say a Company like DMART or any other multi-chain store maintain its sales records through a system which is used at the cash counter. The software prepares bills for each customer and the data is saved in some tables within the software. If accounting is to be done for such cumbersome sales data, it would be a tedious task. What if the accounting is done automatically into tally through a mediatory software! It would save a lot of time and the cumulative accounting data would become available within a day or two.

That’s where the software of Quick2tally helps!

Excel to tally Import Utility:

  • An organisation may incur many recurring expenses such as salary to workmen and staff on monthly basis, electricity payments for various units, bank statement entries, recurring cash sales, etc.

  • Data may be maintained in some software of directly in excel. If data is maintained in a software, the same can be exported into MS excel. However, it is difficult to maintain control on the accounts which are maintained in excel.

  • Hence, the Quick2tally offers an excel to tally import utility which helps to transfer the data from excel to tally within few clicks.

  • The very first sheet of the import utility allows linking the software with tally:

_YCMW_1YTLW13uyi8c5mQRd1Ju9N1dlSTNC77Z2ITUZXYxqBkOE6Dm-2AFRcmBZBCCRzgvjNKvgr6aNriVIA0D6gZbe_DN_WGimSMKDFgL766y3uOJcFvm44iNdUtzcDuz_EpZA

  • As a first step, you should connect the tally company wherein you want the accounting to be done.

  • Further the utility allows creation of various ledgers in few clicks through its sheet “Ledger”:

ExRGokEoOkl_uQd22HhHenF9pj-xeKxXb9kkS9D-9svouTUVYDNRlL0Qpb8pvUm1-sfv4aBRj8loODInxY76pEX_MkdLMeyh0CaHD7pyRwhVWb8IPideaBFm1hmjxpRmebCLemQ

  • The import utility has further facilities to import cost centres, purchases, sales, etc.

  • The import utility also offers a trial period of one month during which you can try using the software and get used to it.

Importing Sales data from Excel to Tally:

  • Al sales data maintained in excel can be imported into tally with few clicks. Organisations may or may not maintain inventory records. For example, an organisation may enter just the sales figures in the system without specifying the item or part code number of the inventory sold. Such method is called “without inventory” sales.

  • Importing Sales data from Excel to Tally: You just have to click the button “without inventory” in the sheet “PURCHASES_SALES”:

ea8zfHnA2XO7CGYUCWxL_cBy88Hgru03fwBzxyVzfatc-9Nv9aN0fQW9vHINSIKRHXPEuGMAHy_o8bejtwyusVa7T11Giw03g3EP90-t-Fj1T3khoSlDkeGkeVpyzGEFiFRO-kE

  • Once you click the button “without inventory”, it turns into the following window:

DCBJ0q5wgpABBJz--_D1wwx2cy9j_gdcpFJxaBe1KtOQdWq72Y3BAzYifb7LbGMOj17xD-4U2fW2W-UMle8tE0FX11APl-Ttn0tW91gPaFyk31f9q-I2DxFPG_SLR3ikvd6uWUU

  • This way the taxable value area is now editable. Here, you can mention the invoice number, invoice date, party name, place of supply, sales value in appropriate column of tax. In case you enter new ledger name, a notification will pop up automatically to transfer the new party name to ledger creation tab automatically:

hJsqqXFp_rnCqlYHqlJRNZ92CpGLckWieerynbwKrcPbd7q5fqTDtSoDOaSet5bwswNYQGMcssW8l3d8RGXmVHDaWw1UEzjIMz6s4lTrL4MSF4x7kFo1X3lPDQuOClV1nwjyasE

  • Since we have selected the place of supply as “Arunachal Pradesh”, the IGST column will automatically take the figures:

I_mvhQUUmDRlNxn29YdZV9rmShos8F38usXd3TGcbY_63XUljYimsmJN8lhyuMmGOFmOS7OStl2aG-jZ5-FGIvJuW9ghG5ccuUfh9oVWBYNcl-ZWyZ5qQ9NPKGA1mapqUlOzMyk

  • You can specify narration and reference number for your internal records.

  • Once you are done with specifying the data, you can just click the button “Export to Tally”. You can observe the sales register.

  • If the Company maintain inventory records, then it should click the button “Inventory Mode”:

918zPu1N1L0MTQMH2e5KlY-Ga3htAkD1rzvrJrudmFAcb48pNDekSaNSEW36_vwCH3OXMTyQsQKmc6cUTcPLTa5qBq2ZBgb12sVRopX8eaHqJgoAiO2ENtXToNZrx5ac-MBntNQ

  • The screen will look like this after you click the button:

7KN2dTLpJJvEorHSYokDMZI6gcweonVScLqof-7NQT0rgT9lbfLp7XkWZfXQQ3WoIz4og6PApu4Gi2eyTXeC_MNZT9iTm8u3rIPB2juWWn2UwoQlqJ0PFhN7IqQNZZ9qVGOTsXo

  • In this case, all details are to be mentioned in the sheet “Stock”. The invoice number is connecting link between the sheets “Stock” and “Purchases_sales”:

ihWh5TYdR3xvRmYaT7_rBWgizRIARrb49W9fUAmRBu-Il7rDj9wMzXvap1vvpA6NcPmSoHcy4kz1HEELirOs49qK1GZVz5qT5CZV7MhuuvGQnyp4pwLGlymGymgY4dCKiVeSQ5E

  • You just have to mention the details here and click the button “Validate Sheet”. This will transfer the summarised value to the sheet “Purchases_Sales”. Now, in this sheet you can click on export to tally to transfer entries to tally.

For More Information:-

For More:- How to Import Sales Data From Excel to Tally

Excel to Tally:- https://g.page/r/Cbw5GBt5ZIhdEBA

Email:- support@quick2tally.com

Call us at:- +91-141-4012472, +91-93584-44502

Source:- Click Here

 

Search
Sponsored
Categories
Read More
Games
Guida Completa ai Prezzi dei Giocatori FC 25: Scopri le Offerte Imperdibili
Guida Completa ai Prezzi dei Giocatori FC 25: Scopri le Offerte Imperdibili I prezzi dei...
By Jone Thomas 2025-01-01 13:02:34 0 289
Other
Key Players and Competitive Landscape in the India Construction Equipment Market
India Construction Equipment Market Report Overview The “India Construction Equipment...
By Swati Mmr 2024-03-04 14:30:52 0 1K
Other
A Study on the Over-The-Top Devices And Services Market Resilience and Growth Opportunities 2032
The latest research report titled Over-The-Top Devices And Services Market 2024: By...
By Gracey Cummins 2024-10-07 10:19:03 0 605
Other
湾曲したガラス 市場: 2025 年の競争状況: プレーヤーの分析 - 2032
湾曲したガラス...
By Kash Geed 2025-03-06 12:55:31 0 165
Other
10 formas para ganar dinero con la IA. Claves para generar ingresos con la inteligencia artificial
La inteligencia artificial (IA) se ha convertido en una herramienta clave para generar ingresos...
By Javier Rodriguez 2024-12-23 10:36:02 0 553
Mashable is a global, multi-platform media and entertainment company For more queries and news contact us on this Email: info@mashablepartners.com