Binarysoft is Authorised Tally Sales & Implementation Partner in India
+91 742 877 9101 or E-mail: tally@binarysoft.com 10:00 am – 6: 00 pm , Mon-Fri
Call CA Tally HelpDesk +91 9205471661, 8368262875
Every business records hundreds of transaction daily—sales, purchases, receipts, payments, contra entries, journal adjustments, credit notes, stock movements, and more. But without a proper mapping template, data often becomes inconsistent, GST mismatches appear, ledgers get duplicated, and reports show errors.
This is why Tally Prime users—especially accountants, CAs, SMEs, and multi-branch companies—depend on a Transaction Mapping Template. It ensures that every voucher is correctly linked to accounts, stock items, GST classifications, cost centres, and reporting heads.
This guide explains exactly what a mapping template is, why it is required, and provides a ready-to-use mapping structure for smooth and error-free operations in Tally Prime.
✔️ What Is a Transaction Mapping Template in Tally Prime?
A Transaction Mapping Template is a structured reference sheet that defines:
It acts as a master guideline to avoid confusion and to maintain consistent data entry across users.
✔️ Benefits of Using a Mapping Template
A well-designed mapping template helps you:
1. Prevent GST mismatches
Consistent mapping ensures correct GSTR-1, GSTR-2A/2B, and GSTR-3B data.
2. Avoid wrong ledger selection
New staff often choose incorrect ledgers—mapping prevents errors.
3. Maintain clean and audit-ready books
Transactions follow a standard format, making audits easier.
4. Speed up data entry
Mapping teaches staff exactly which voucher and ledger to use.
5. Reduce training time
New employees can learn Tally Prime faster.
�� Master Mapping Template for Tally Prime (2025 Edition)
Below is a complete, non-copyrighted mapping structure covering all major transaction types.
�� 1. Sales Transactions Mapping
|
Field |
Mapping Details |
|
Voucher Type |
Sales |
|
Party Ledger |
Customer Name (with GST if registered) |
|
Sales Ledger |
Sales 18% / 12% / 5% / Nil Rated / Exempt |
|
GST Nature of Transaction |
Sales Taxable / Sales Exempt / Sales to Consumer / B2B |
|
Stock Item |
Yes (define units & GST classification) |
|
Cost Center |
Optional (for branch / project tracking) |
|
Narration |
Invoice No., Mode of Sale, Remarks |
�� 2. Purchase Transactions Mapping
|
Field |
Mapping Details |
|
Voucher Type |
Purchase |
|
Supplier Ledger |
Vendor Name (with GST) |
|
Purchase Ledger |
Purchase 18% / 12% / 5% / Import Purchase |
|
GST Nature of Transaction |
Purchase Taxable / RCM / Import IGST |
|
Stock Item |
Yes (for inventory-based purchases) |
|
Cost Center |
Optional |
|
Bill Ref |
Yes (for outstanding tracking) |
�� 3. Payment Transactions Mapping
|
Field |
Mapping Details |
|
Voucher Type |
Payment |
|
Credit Ledger |
Bank / Cash |
|
Debit Ledger |
Vendor / Expense Ledger |
|
Cost Center |
For expenses linked to departments |
|
Narration |
Payment mode reference |
�� 4. Receipt Transactions Mapping
|
Field |
Mapping Details |
|
Voucher Type |
Receipt |
|
Debit Ledger |
Bank / Cash |
|
Credit Ledger |
Customer / Other Income |
|
GST Impact |
No GST |
|
Cost Center |
Optional |
|
Instrument No. |
Mandatory for cheques/NEFT |
�� 5. Contra Transactions Mapping
|
Field |
Mapping Details |
|
Voucher Type |
Contra |
|
Ledger Examples |
Cash → Bank / Bank → Bank / Cash → Cash |
|
GST Impact |
No |
|
Narration |
Transfer details |
�� 6. Journal Transactions Mapping
|
Field |
Mapping Details |
|
Voucher Type |
Journal |
|
Usage |
Adjustment, provisions, write-offs |
|
GST Impact |
Only for GST adjustment journals |
|
Cost Center |
Yes (if adjusting expenses) |
�� 7. Credit Note / Debit Note Mapping
|
Field |
Mapping Details |
|
Voucher Type |
Sales Return / Purchase Return |
|
GST Nature of Transaction |
Sales Return / Purchase Return |
|
Impact |
Adjusts stock + GST |
|
Party Ledger |
Must match original invoice party |
�� 8. Inventory Adjustment Mapping
|
Field |
Mapping Details |
|
Voucher Type |
Physical Stock / Stock Journal |
|
Impact |
Increases or reduces stock |
|
Reason |
Wastage, damage, shrinkage, manufacturing |
✔️ Ready-to-Use Mapping Template (Summary Table)
|
Transaction Type |
Voucher |
Debit |
Credit |
GST Nature |
Stock? |
Cost Center? |
|
Sales |
Sales |
Customer |
Sales Ledger |
Sales Taxable |
Yes |
Optional |
|
Purchase |
Purchase |
Purchase Ledger |
Vendor |
Purchase Taxable |
Yes |
Optional |
|
Receipt |
Receipt |
Bank/Cash |
Customer |
None |
No |
Optional |
|
Payment |
Payment |
Vendor/Expense |
Bank/Cash |
None |
No |
Optional |
|
Contra |
Contra |
Bank/Cash |
Bank/Cash |
None |
No |
No |
|
Journal |
Journal |
Adjustment |
Adjustment |
Optional |
No |
Optional |
|
Sales Return |
Credit Note |
Customer |
Sales Return Ledger |
Return |
Yes |
Optional |
|
Purchase Return |
Debit Note |
Purchase Return Ledger |
Vendor |
Return |
Yes |
Optional |
|
Stock Adjustment |
Stock Journal |
Stock |
Stock |
None |
Yes |
No |
✔️ How to Use This Mapping Template in Tally Prime
Step 1: Train Your Team Using This Template
Make every user follow the same mapping rules.
Step 2: Create Ledgers as Per Mapping
Use correct groups:
Step 3: Configure GST Properly
Assign GST in:
Gateway → Create → Ledger → Tax Details
Step 4: Use Voucher Classes (Optional)
Voucher classes automate ledger selection and tax application.
Step 5: Review Mappings Monthly
Correct any wrongly mapped transactions before filing GST.
Conclusion
A Transaction Mapping Template is one of the most powerful tools for maintaining clean, accurate, audit-ready books in Tally Prime. With consistent mapping, businesses avoid GST errors, speed up data entry, and maintain perfect ledger discipline. This template ensures every transaction is properly linked to accounts, cost centers, stock items, and GST classifications—making Tally Prime easier, faster, and more reliable.
FAQs
1. Why is a mapping template needed in Tally Prime?
To maintain consistent, error-free accounting across all users.
2. Can mapping reduce GST mismatches?
Yes—correct mapping ensures flawless GSTR-1 and GSTR-3B reports.
3. Is this template useful for CAs?
Absolutely—it standardizes all client data entry.
4. Can voucher classes automate mapping?
Yes—Tally Prime allows auto-ledger selection and GST auto-calculation.
5. Can this mapping be used for Tally Prime Edit Log also?
Yes—mapping principles remain the same.
Powered by Binarysoft Technologies
Authorized Tally Partner
Location : 1626/33, 1st Floor, Naiwalan, Karol Bagh, New Delhi – 110005, INDIA
Contact us : +91 7428779101, 9205471661
Email us : tally@binarysoft.com (10:00 AM – 6:00 PM, Mon–Fri)
Applicable for CAs / Firms Using GOLD (Multi User ) Only
Renew your license now and upgrade from Tally ERP 9 to Tally Prime for Free!₹ 6750 + 18% GST (₹ 1215)
Applicable for CAs / Firms Using GOLD (Multi User ) Only
Renew your license now and upgrade from Tally ERP 9 to Tally Prime for Free!
₹ 12150
+ 18% GST (₹ 2187)
Unlimited Multi-User Edition For Multiple PCs on LAN Environment
Renew your license now and upgrade from Tally ERP 9 to Tally Prime for Free!₹ 13500 + 18% GST (₹ 2430)
Unlimited Multi-User Edition For Multiple PCs on LAN Environment
Renew your license now and upgrade from Tally ERP 9 to Tally Prime for Free!
₹ 24300
+ 18% GST (₹ 4374)
Single User Edition For Standalone PCs ( Not applicable for Rental License )
Renew your license now and upgrade from Tally ERP 9 to Tally Prime for Free!₹ 4500 + 18% GST (₹ 810)
Single User Edition For Standalone PCs ( Not applicable for Rental License )
Renew your license now and upgrade from Tally ERP 9 to Tally Prime for Free!
₹ 8100
+ 18% GST (₹ 1458)
Tally On Cloud ( Per User Annual)
Now access Tally Prime anytime from anywhere – Just Deploy your Tally License and Tally Data on our Cloud Solution.₹ 7000 + 18% GST (₹ 1260)
Unlimited Multi-User Edition
For EMI options, please Call: +91 742 877 9101 or E-mail: tally@binarysoft.com (10:00 am – 6: 00 pm , Mon-Fri)₹ 67500 + 18% GST (₹ 12150)
Unlimited Multi-User Edition For Multiple PCs on LAN Environment
Renew your license now and upgrade from Tally ERP 9 to Tally Prime for Free!₹ 45000 + 18% GST (₹ 8100)
Single User Edition For Standalone PCs
For EMI options, please Call: +91 742 877 9101 or E-mail: tally@binarysoft.com (10:00 am – 6: 00 pm , Mon-Fri)₹ 22500 + 18% GST (₹ 4050)
(Per User/One Year)
TallyPrime latest release pre-installed₹ 7200 + 18% GST (₹ 1296)
(Two Users/One Year)
TallyPrime latest release pre-installed₹ 14400 + 18% GST (₹ 2592)
(Four Users/One Year)
TallyPrime latest release pre-installed₹ 21600 + 18% GST (₹ 3888)
(Eight Users/One Year )
TallyPrime latest release pre-installed₹ 43200 + 18% GST (₹ 7776)
(Twelve Users/One Year)
TallyPrime latest release pre-installed₹ 64800 + 18% GST (₹ 11664)
(Sixteen Users/One Year)
TallyPrime latest release pre-installed₹ 86400 + 18% GST (₹ 15552)