Sample Excel Files for the most frequently used scenarios for importing data from Excel worksheets into TallyPrime are listed below. Apart from downloading Sample Excel Files with no data, you can also download the sample files with data from this page and use them for your reference.
If you want to practice importing some sample data by downloading the Sample Excel Files, you can download the data with the corresponding sample files from this page. Before you import, refer to prepare/set up data based on import scenario.
To use the Sample Excel Files for importing your data, delete the sample data, record details of your Masters and Transactions, and directly import the data from the Sample Excel File into TallyPrime.
To know more about how to use Sample Excel Files for importing data, or refer to Import Data from Excel File Provided by TallyPrime.
Import Data from Excel File Provided by TallyPrime (Pre-defined Templates)
The Sample Excel Files with data for varied types of Masters are listed below for your easy reference. You can download the Zip files by clicking on the Zip file links.
Masters
Ledger with General Details
The Excel file contains ledgers with general details such as Customer, Sellers, Sales/Purchase ledger etc. Click here to download.
Click for a sample image of the Excel file.
Ledger with Data in a Specific Field
The Excel file contains ledgers with data in a specific field. Import Ledger master with other details by customising the default template. Clickhere to download.
Click for a sample image of the Excel file.
Ledger with Primary Mobile No. and Default WhatsApp No.
The Excel file includes ledgers with the primary mobile and default WhatsApp numbers. Import ledgers while setting up these details. Click here to download.
Click for a sample image of the Excel file.
Ledger with Multiple Mobile Nos.
The Excel file contains ledgers with multiple Mobile numbers. Import Ledgers which have Multiple Mobile Number and set up Default WhatsApp Number. Clickhere to download.
Click for a sample image of the Excel file.
Ledgers with Opening Balance and Multiple Bill-wise Details
The Excel file contains ledgers with Opening Balance and multiple Bill-wise details. Clickhere to download.
Click for a sample image of the Excel file.
Bank Ledger with Bank Details
The Excel file contains bank ledger details along with their banking details like Account No., IFS Code and Branch Details. Clickhere to download.
Click for a sample image of the Excel file.
Party Ledger with Bank Details
The Excel file contains customer and supplier details along with bank details like Transaction Type, Account No., IFS Code, etc. Clickhere to download.
Click for a sample image of the Excel file.
Ledgers with Multiple Addresses
The Excel file contains Customer and Supplier details along with multiple Addresses. Clickhere to download.
Click for a sample image of the Excel file.
Ledgers with Multicurrency Details
The Excel file contains ledgers with Opening Balance and Currency different than the Base Currency. Click here to download.
Click for a sample image of the Excel file.
Ledgers with Multilingual Details
The Excel file contains Ledger names in different language. Clickhere to download.
Click for a sample image of the Excel file.
Cost Centres
The Excel file contains Cost Centre details. Clickhere to download.
Click for a sample image of the Excel file.
Stock Item with BoM Details
The Excel file contains Stock Items with BoM details. Clickhere to download.
Click for a sample image of the Excel file.
Godown or Location
The Excel file contains Godown or Location details. Clickhere to download.
Click for a sample image of the Excel file.
Simple and Compound Units
The Excel file contains Simple and Compound Units. Clickhere to download.
Click for a sample image of the Excel file.
Stock Item with Price List
The Excel file contains Stock Item with Price List. Clickhere to download.
Click for a sample image of the Excel file.
Stock Item with Standard Price and Standard Cost
The Excel file contains Stock Item with Standard Price and Standard Cost. Clickhere to download.
Click for a sample image of the Excel file.
Employee – General
The Excel file contains general employee details like Bank Details, PF Details, Joining and Family Details. Clickhere to download.
Click for a sample image of the Excel file.
Employee – Salary Details
The Excel file contains salary details of employees. Clickhere to download.
Click for a sample image of the Excel file.
Attendance Type
The Excel file contains Attendance Type details. Clickhere to download.
Click for a sample image of the Excel file.
Employee Group
The Excel file contains details of Employee Group. Click here to download.
Click for a sample image of the Excel file.
Transactions
The Sample Excel Files with data for varied type of Transactions are listed below for your easy reference. You can download the Zip files by clicking on the Zip file links.
Vouchers – General
The Excel file contains general Voucher details. Clickhere to download.
Click for a sample image of the Excel file.
Sales Voucher with Multicurrency Details
The Excel file contains Sales Vouchers with Multicurrency details. Clickhere to download.
Click for a sample image of the Excel file.
Sales Voucher with Cost Centre Allocation
The Excel file contains Sales Vouchers with Cost Centre Allocation details. Click here to download.
Click for a sample image of the Excel file.
Sales Voucher with GST, e-Way and e-Invoice Details
The Excel file contains Sales Vouchers with GST, e-way and e-Invoice details. Click here to download.
Click for a sample image of the Excel file.
Sales Voucher with Accounting Allocation and Cost Centre Allocation
The Excel file contains Sales Vouchers with Accounting Allocation and Cost Centre Allocation details. Clickhere to download.
Click for a sample image of the Excel file.
Sales Voucher with Bill Allocation
The Excel file contains Sales Vouchers with Bill Allocation details. Click here to download.
Click for a sample image of the Excel file.
POS Vouchers Sales Invoice
The Excel file contains POS Vouchers with Sales Invoice details. Clickhere to download.
Click for a sample image of the Excel file.
Stock Journal Vouchers
The Excel file contains Stock Journal Voucher details. Click here to download.
Click for a sample image of the Excel file.
Sales Order with Accounting Allocation
The Excel file contains Sales Order with Accounting Allocation details. Click here to download.
Click for a sample image of the Excel file.
Sales Order with Accounting Allocation for Sales and Expense Ledger
The Excel file contains Sales Order with Accounting Allocation for Sales and Expense Ledger details. Clickhere to download.
Click for a sample image of the Excel file.
Attendance Voucher
The Excel file contains Attendance Voucher details. Click here to download.
Click for a sample image of the Excel file.
Payroll Voucher
The Excel file contains Payroll Voucher details. Click here to download.
Click for a sample image of the Excel file.
Sample Data with Mapping Templates (User Defined Templates)
Some additional sample files with data and the corresponding mapping templates are listed below for your easy reference. You can download the Zip files by clicking on the Zip file links.
Masters
To know more about how to create Mapping Templates for Masters,
Ledger with GSTIN
The Excel file contains ledger details with GSTIN. Click here to download.
Click for a sample image of the Excel file.
Stock Items with GST Details
The Excel file contains Stock Items with GST details. Click here to download.
Click for a sample image of the Excel file.
Stock Items with MRP Details
The Excel file contains Stock Items with MRP details. Click here to download.
Click for a sample image of the Excel file.
Stock Items with BOM Details
The Excel file contains Stock Items with MRP details. Click here to download.
Click for a sample image of the Excel file.
Stock Items in User Defined Formats
The Excel file contains Stock Item details in User Defined formats. Clickhere to download.
Click for a sample image of the Excel file.
Stock Items in Arabic as Language Alias Name
This Excel file contains stock items with Name in English and Language Alias Name in Arabic. Click here to download.
Click for a sample image of the Excel file.
Transactions
Some additional sample files with data and the corresponding mapping templates are listed below for your easy reference. You can download the Zip files by clicking on the Zip file links.
To know more about how to create Mapping Templates for Transactions,
Ledger Entries in Multiple Rows
The Excel file contains ledger entries in multiple rows. Clickhere to download.
Click for a sample image of the Excel file.
Ledger Entries in Multiple Columns
The Excel file contains sales invoice wherein the Party Name and Taxes are provided in multiple columns. Click here to download.
Click for a sample image of the Excel file.
Ledger Amount in the same Column
The Excel file contains voucher details where the Debit and Credit amounts are in the same column and denoted by + and – signs. Clickhere to download.
Click for a sample image of the Excel file.
Ledger Amount in Two Columns
The Excel file contains voucher details where the Debit and Credit amounts are in different columns. Click here to download.
Click for a sample image of the Excel file.
Vouchers with Unique Values
The Excel file contains vouchers with unique values. Import vouchers where Voucher Date and Voucher Type are same for all the vouchers given in the excel File. Click here to download.
Click for a sample image of the Excel file.
Sales Vouchers in Multiple Columns
The Excel file contains Sales Vouchers in multiple columns. Clickhere to download.
Click for a sample image of the Excel file.
Sales Vouchers in Multiple Rows
The Excel file contains Sales Invoices with stock items, where all the ledgers are mentioned in the same column such as Customer Name, Sales Ledger, Taxes etc. Click here to download.
Click for a sample image of the Excel file.
Sales Vouchers in Multiple Columns with Bill Allocations
The Excel file contains Sales Vouchers with Bill-wise details, when Party Name, and taxes are mentioned in different columns. Click here to download.
Click for a sample image of the Excel file.
Vouchers in Multiple Columns with Bill Allocations
The Excel file contains Vouchers in multiple columns with Bill Allocation details. Click here to download.
Click for a sample image of the Excel file.
Vouchers in Multiple Rows with Bill Allocations
The Excel file contains Vouchers in multiple rows with Bill Allocation details. Clickhere. to download.
Click for a sample image of the Excel file.
Sales Voucher in Multiple Columns without Inventory
The Excel file contains Sales Vouchers without the Inventory, where Party Name and Taxes are in different columns. Click here to download.
The Excel file contains Payment vouchers with Bank Allocation details so that transactions do not appear as Uncertain in the Bank Reconciliation report. Click here to download.
Click for a sample image of the Excel file.
Names & Aliases for Mapping
To know more about the names and aliases for mapping, click here.
Masters
Group
Sl No.
Field Grouping
Field Name
Aliases
1
General Details
Parent Group Name
Under, Parent Name
2
General Details
Group behaves like a sub-ledger
Is Sub Ledger
3
General Details
Nett Credit/Debit Balances for Reporting
Is Addable
4
General Details
Language for Name (Except English)
Language Alias
5
General Details
Used for calculation (for example: taxes, discounts)
Basic Group Is Calculable
6
General Details
Method to allocate when used in purchase invoice
Addl Alloc Type
Ledger
Sl No.
Field Grouping
Field Name
Aliases
1
General Details
Group Name
Under, Parent
2
General Details
Notes
Narration
3
General Details
Language for Name (Except English)
Language Alias
4
General Details
Cost centres are applicable
Is Cost Centres On
5
General Details
Activate Interest Calculation
Is Interest On
6
General Details
Check for credit days during voucher entry
Is Credit Days Chk On
7
General Details
Inventory values are affected
Affects Stock
8
General Details
Allow cost allocation (stock item)
Is Cost Tracking On
9
General Details
Tax/Duty – Percentage of Calculation
Rate Of Tax Calculation
10
General Details
Tax/Duty – Valuation Type
Cess Valuation Method
11
General Details
Currency of Ledger
Ledger Currency
12
General Details
Behave as Duties & Taxes Ledger
Is Behave as Duty
13
General Details
Nature of Payment/Goods
TDS Rate Name
14
Tax Registration Details
Tax/Unique Identification Number
Tax Identification No.
15
General Details
Position Index in Reports
Sort Position
16
Bank Ledger – Bank Account Details
Effective Date for Reconciliation
Starting From
17
Bank Ledger – Bank Account Details
Bank Account Details – A/c Holder’s Name
Bank Acc Holder Name
18
Bank Ledger – Bank Account Details
Bank Account Details – A/c No.
Bank Account Details – Account Number, Bank Account Details – Account No.
19
Bank Ledger – Bank Account Details
Bank Account Details – Branch
Bank Branch Name
20
Bank Ledger – Bank Account Details
Bank Account Details – BSR Code
Bank BSR Code
21
Bank Ledger – Bank Account Details
Bank Account Details – Client Code
Bank Client Code
22
Bank Ledger – Bank Account Details
Enable Cheque Printing
Is Cheque Printing Enabled
23
Auto Reconciliation
Enable Auto Reconciliation
Is ABC Enabled
24
Other Ledgers – Bank Details
Bank Details – A/c No.
Bank Details – Account Number, Bank Details – Account No.
25
Other Ledgers – Bank Details
Bank Details – Ref ID
Bank Details – Reference ID
26
Bill Allocations
Maintain balances bill-by-bill
Is Billwise On
27
Opening Bank Reconciliation Details
Opening Bank Reconciliation – Bank Date
Bankers Date
28
Mailing Details
Primary Mobile No.
Primary Mobile Number, Ledger Mobile
29
Multiple Mobile Numbers Details
Multiple Mobile Nos. – Mobile No.
Multiple Mobile Nos. – Mobile Number
30
Mailing Details
Contact Name
Ledger Contact
31
Mailing Details
Phone No.
Ledger Phone, Phone Number
32
Mailing Details
Fax No.
Ledger Fax
33
Mailing Details
E-mail
E-mail address, E-mail ID
34
Statutory Details
Include in Assessable Value calculation – Duty/Tax Type
Appropriate For
35
Statutory Details
Include in Assessable Value calculation – Appropriate to
GST Appropriate To
36
Statutory Details
Include in Assessable Value calculation – Method of calculation
Excise Alloc Type
37
Tax Registration Details
PAN Effective Date
PAN Applicable From
38
Tax Registration Details
GST Registration – Assessee of Other Territory
Is Oth Territory Assessee
39
Tax Registration Details
GST Registration -GSTIN/UIN
GST Number, GST No., GST Identification Number
40
Tax Registration Details
GST Registration – Use Ledger as common Party
Is Common Party
41
Additional GST Details
Is the Party a Transporter
Is Transporter
42
VAT Registration Details
Date of VAT Registration
VAT Applicable Date
43
VAT Registration Details
Type of Party
VAT Tax Exemption Nature
44
VAT Registration Details
Exemption Certificate No.
VAT Tax Exemption Number
45
Interest Calculation Details
Include transaction date for interest calculation – For amounts added
Interest Incl Day Of Addition
46
Interest Calculation Details
Include transaction date for interest calculation – For amounts deducted
or refer to Import Data from Excel File Provided by TallyPrime.
