Excel to Tally Import Journal Voucher
Whats is Journal Vouchers
Journal voucher in Tally is an important voucher which is used to make all kind of adjustment entries, credit purchases or sales, fixed assets purchase entries. In order to pass entries as journal voucher
How to import Journal Voucher data using
Excel-Tally Software in just a click
Step 1- Put Data In Template Using Smart Mapping
Excel-Tally software provides you smart data mapping functionality, that helps you to copy all your data from your file to a template without any mistakes.
or simply copy-paste your data column-wise from your sheet to the software template file.
Step 2- Now Select Journal Voucher Template In Software & Click Import
Open Excel-Tally Software, it will shows you Dashboard here you can select company in which you want to import data.
Now All set just select template file in software using Journal Voucher Button & Click on Import Button,
check the software dashboard it will show you Count of Ledgers,Invoice Records created.
check in tally all your records are imported successfully
You can Import Journal Voucher with Following details
You can import data with Invoice Number, Invoice Date, Bill ref number & invoice, cheque Number, Date, Bank Name & Branch
Tax & Other Ledgers details
You can import data with 25+ other ledgers & Tax ledgers with Auto Creation options in single invoice or multi invoice mode
Cost Center & Narration
Your can import data Party ledger link with Cost center & Cost Category, Also import Narrations in single or Multi invoice mode
Can Import Multi Currency data using Same voucher Template
You can import Multi Currency data in same Voucher template by Providing Amount , Foreign Currency Symbol, Rate Of Exchange