How to Import Masters & Transactions into TallyPrime Using Your Own Excel Template | TallyHelp

Applicable to Release 4.0

This video demonstrates how you can easily import data into TallyPrime using your own excel formats.
You have the flexibility of creating and customizing your own template to import data from your Excel file into TallyPrime.
While creating a Mapping Template, you will have to map the column headers in your Excel file to the corresponding fields in TallyPrime.
Once you've created your Mapping Template and mapped the necessary fields, you can proceed with importing your Masters or Transactions into TallyPrime.
This way, you can seamlessly import the data entered in your Excel files into TallyPrime in just a few simple steps.
This video covers
00:00 - Title
00:26 - Create a Mapping Template for stock items and import it.
05:38 - Create a Mapping Template for transactions where ledger entries are repeated in multiple rows.
10:01 - Create a Mapping Template for transactions where ledger details are in fixed columns.

Have a question?
Refer to:
Write/Chat/Call us:

Connect with us on:

[nvramaraju]

Please give the above excel file download link.

[nabeelahmed]

could you please upload a video of how to import transaction with cost center, tally does not take cost center

[samutubeify]

Can you please upload a vedio for Stock journal transfer for multiple godown

[RakshitaVira]

Can we import credit note data from excel?
If yes, can you please make same video like sale for credit note also..

[SriniRamakrishnan]

Please upload the detailed tdl course in tally prime

[vipinmalaviya]

Please inform which Excel version you have shown.

[uvnaresh]

Please provide the purchase imort video

[Auditorkgrao]

Mapping option is not shown when I press alt+O, please resolve this doubt

[bhoomisharma]

error show tax cgst ledger does not exit after import in log

[samirandas]

Can I import cost centre opening balance through this option?