Tuesday, November 17, 2026

How to Import Masters and Transactions from Excel in TallyPrime

How to Import Masters and Transactions from Excel in TallyPrime

Entering hundreds of ledgers, stock items or transactions manually can take a lot of time. TallyPrime allows you to import masters and transactions from Excel using predefined sample files or mapping templates.

Version note: This guide is for TallyPrime Release 7.0+. Menu names and options may vary slightly in other releases.

What can you import from Excel?

  • Ledger masters
  • Stock items
  • Groups and units
  • Customers and suppliers
  • Sales, purchase and other transactions

Before importing transactions, make sure the required masters, such as ledgers, groups, stock items and units, are already available in the company.

Before you begin

  • Take a verified backup of the company.
  • Test the import in a backup or test company first.
  • Check the Excel file for duplicate names, blank mandatory fields and incorrect formats.
  • Confirm that the company features match the data being imported.
  • Enable bill-wise details if you are importing outstanding transactions.

Sample Excel file vs mapping template

Sample Excel file

A sample Excel file already contains columns arranged for TallyPrime. Use it when you want a faster and simpler import process.

Mapping template

A mapping template is useful when your existing Excel file has a different column structure. You can map Excel columns to the corresponding TallyPrime fields.

Step 1: Prepare the Excel file

  1. Download the required sample Excel file or prepare your own workbook.
  2. Enter the data in the correct worksheet.
  3. Do not rename or remove mandatory column headers from a sample file.
  4. Check dates, quantities, rates, GST details and ledger names.
  5. Remove unnecessary blank rows and duplicate records.
  6. Save the workbook in Excel format.

Mandatory fields are usually identified in the sample file. Read the ReadMe worksheet before entering data.

Step 2: Open the Import screen

  1. Open the required company in TallyPrime.
  2. Press Alt+O to open Import.
  3. Select Masters or Transactions.
  4. Specify the Excel file path.

Import masters before transactions when the transactions depend on new ledgers, stock items or other masters.

Step 3: Configure the import

Review the import settings before proceeding. Depending on the selected data type, configure the file path, worksheet, mapping template, behaviour when a master already exists, exception handling, backup and import batch size.

For existing masters, choose the appropriate behaviour instead of blindly creating duplicates.

Step 4: Preview the import

Use the preview or import summary to check the number of records that will be imported. Look for missing fields, duplicate names, invalid GST details and unmatched ledgers.

Step 5: Import the data

  1. Confirm the file and import configuration.
  2. Enable backup if the option is available.
  3. Press I or select Import.
  4. Wait until TallyPrime completes the process.
  5. Review the import summary and exceptions report.

How to resolve import exceptions

  • Missing master: Create or import the required group, ledger, item or unit first.
  • Duplicate master: Correct the name or select the required existing-master behaviour.
  • Invalid date: Use the date format expected by the Excel template.
  • GST error: Check GSTIN, state, HSN/SAC and tax-rate details.
  • Incorrect amount: Verify quantity, rate, discount and tax columns.
  • Wrong worksheet: Confirm that the selected worksheet contains the data-entry rows.

Verify the imported data

  • Open Chart of Accounts and verify ledgers.
  • Open Stock Summary and verify stock items and quantities.
  • Open Day Book or Sales Register and check imported transactions.
  • Review Trial Balance and outstanding balances.
  • Check GST reports if GST data was imported.
  • Compare the import summary with the number of rows in Excel.

Important safety tips

  • Never import unverified data directly into the live company.
  • Keep the original Excel file unchanged.
  • Do not share files containing customer, bank or GST information publicly.
  • Take a backup before importing large batches.
  • After import, compare totals with the source file.
  • Keep a copy of the mapping template for future imports.

Related TallyPrime guides

Conclusion

Excel import can save significant data-entry time when the workbook is prepared correctly. Import masters first, use a backup company for testing, review the preview and exceptions report, and verify the accounting and GST reports after import.

Always test the process with a small file before importing large volumes of business data.

Monday, November 9, 2026

How to Record Sales Return and GST Credit Note in TallyPrime

How to Record Sales Return and GST Credit Note in TallyPrime

When a customer returns goods after a sale, you can record the transaction in TallyPrime using a Credit Note. This reverses the applicable sales value and GST and increases stock for the returned quantity.

The exact GST treatment can depend on the transaction and current regulations, so verify the final return impact with your tax professional.

Version note: This guide is for TallyPrime. Menu names and options may vary slightly between releases.

Before you begin

  • Original invoice number and date
  • Customer ledger
  • Returned item and quantity
  • Original selling rate
  • GST rate and tax ledgers
  • Reason for the return
  • Whether the original invoice is paid or still outstanding

Step 1: Open a Credit Note

  1. Press Alt+G.
  2. Select Create Voucher.
  3. Press F10: Other Vouchers.
  4. Select Credit Note.
  5. Press Ctrl+H and choose Item Invoice mode, if required.

You can also open Credit Note from Gateway of Tally > Vouchers > F10: Other Vouchers.

Step 2: Select the customer

In Party A/c Name, select the customer who originally purchased the goods. Check customer name, GSTIN, state, place of supply and original invoice reference.

Step 3: Enter the original invoice details

Open the party or voucher details and enter the original invoice number and date wherever the fields are available. Using the correct original invoice reference helps maintain a clear audit trail and supports accurate GST reporting.

Step 4: Enter the returned item

Under Name of Item, select the returned stock item. Enter returned quantity, rate, applicable discount, sales ledger and GST ledgers. The returned quantity should increase the stock balance. If goods are damaged or unusable, keep them separately identified according to your business process.

Step 5: Select the correct bill reference

When TallyPrime displays the Bill-wise Details screen, select the appropriate reference type.

Use Agst Ref

Select Agst Ref when the customer has not yet paid the original invoice. The Credit Note can then be adjusted against the outstanding invoice.

Use New Ref

Select New Ref when the customer has already paid the original invoice. The Credit Note can be adjusted against a future invoice or payment.

If required, press F12: Configure and set the option to use default bill-wise details to No, so that you can select the reference manually.

Step 6: Select the reason for the return

In the GST details, choose the appropriate reason, such as Sales return, Post-sale discount or another applicable adjustment. Do not select a reason only to make the report match.

Step 7: Save the Credit Note

Enter narration if required and press Ctrl+A to save the voucher. Review taxable value, GST amount, total credit value and stock quantity.

Step 8: Verify the accounting and GST impact

  • Customer outstanding balance
  • Stock Summary
  • Sales ledger
  • CGST, SGST or IGST ledgers
  • Credit Note Register
  • Relevant GST reports

Sales returns are reflected through Credit Notes and can be reviewed in the Credit Note Register.

Common mistakes

  • Original invoice is missing: Check invoice number and date before saving.
  • Credit Note is not adjusted: Review whether Agst Ref or New Ref was selected.
  • GST amount is incorrect: Check party state, place of supply, item classification, tax rate and GST ledgers.
  • Stock does not increase: Confirm Item Invoice mode and correct item/quantity.
  • Return does not appear as expected in GST reports: Review GST details and nature of transaction; do not alter figures only to force a result.

Final checklist

  • Returned quantity is correct.
  • Original invoice is referenced.
  • Customer balance is correct.
  • GST values are correct.
  • Credit Note is included in the relevant report.
  • Customer has received the Credit Note.
  • Backup of company data is available.

Related TallyPrime guides

Conclusion

Recording a sales return through a GST Credit Note keeps stock, customer balances, sales values and tax records aligned. Always test the entry in a backup company first and verify the resulting GST reports before filing.