How to Export TallyPrime Reports to Excel: Complete Guide

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

Before you export
Take a verified backup and protect exported files because they may contain confidential financial information.

Why export TallyPrime data to Excel?

Excel exports are useful for management review, reconciliation, budgeting, filtering, pivot tables and business analysis. TallyPrime supports exporting reports, vouchers, masters and transactions in Excel and other formats.

Export a report to Excel

1. Open the required report, such as Day Book, Ledger, Trial Balance, Stock Summary, Profit and Loss or Balance Sheet.
2. Set the required period using Alt+F2.
3. Apply filters or drill down to the required level.
4. Press Ctrl+E to open the Current export screen.
5. Select Configure and set File Format to Excel.
6. Choose the folder and file name.
7. Review the report details and select Send or press E.

Open the exported file in Microsoft Excel for filtering, sorting, formulas, charts or pivot-table analysis.

Export a Day Book or individual voucher

1. Press Alt+G and open Day Book.
2. Set the required date range.
3. Select a voucher and press Enter if you need to inspect it.
4. Press Ctrl+E, select Configure and choose Excel.
5. Select the required details and export the file.

To export one invoice or voucher, open that voucher before pressing Ctrl+E.

Export masters or transactions

For masters, open Chart of Accounts or the required master report, use Alt+F12 when you need a range, press Alt+E, select Current, configure the master type and export format, then send the file.

For transactions, open Day Book, set the period, press Alt+E, select Current, configure voucher type and narration options, choose Excel and export.

For migration or system-to-system exchange, XML or JSON may be more suitable than Excel. Excel is generally better for review and analysis.

Prepare the exported Excel file

• Check the company name and reporting period.
• Convert the data range into an Excel Table.
• Freeze the heading row and apply filters.
• Format dates consistently.
• Check that debit and credit columns are numeric.
• Keep a separate notes sheet for observations.

Useful analysis includes monthly sales, customer outstanding balances, GST summaries, item-wise quantity, expense analysis and purchase-versus-sales comparisons.

Common export problems

• File is not created: check the destination folder and write permission.
• File is already open: close Excel and export again.
• Export fails: try a new file name and another destination folder.
• File is blank: confirm the report period and filters.
• Numbers appear as text: use Excel's Convert to Number option and check for extra spaces.
• Report is too large: export a shorter date range or export month by month.

Privacy and safety checklist

• Remove unnecessary personal, customer and bank details before sharing.
• Keep a protected original export.
• Do not upload confidential accounting files to unknown online tools.
• Clearly mention the period covered by the file.

For official details, read TallyHelp: Export Data in TallyPrime.

Related TallyPrime guides

• How to Backup and Restore Company Data in TallyPrime
• TallyPrime Troubleshooting: 10 Common Errors and Safe Fixes
• How to Reconcile GSTR-2B in TallyPrime

Conclusion

Exporting TallyPrime reports to Excel is useful for review, reconciliation and management analysis. Always select the correct period, verify the totals, protect confidential information and keep the original TallyPrime data unchanged.

 

TallyPrime Troubleshooting: 10 Common Errors and Safe Fixes

Quick answer: Most TallyPrime errors can be isolated by checking the exact message, company data path, service status, permissions and recent changes. Take a verified backup before repairing or importing data.

Version note: This guide is for TallyPrime Release 7.0 onwards. Menu names may vary slightly by release.

Before troubleshooting

1. Take a backup and keep the original company data unchanged.
2. Note the exact error, TallyPrime release, company, action and time.
3. Test the fix in a backup company whenever possible.

1. License or TSS error

Check the internet connection, then open F1 (Help) > Settings > Manage License. Review the license status and reactivate or update it if required. If the error continues, record the message before contacting Tally support.

2. Company does not open

Confirm the correct data path and Windows permissions. Do not delete, rename or replace company files randomly. If the data is damaged, use TallyPrime’s supported repair or support process on a copy of the data.

3. TallyPrime is slow

• Close unused companies and reports.
• Reduce unnecessary report columns and filters.
• Check free disk space and antivirus exclusions recommended by your IT administrator.
• For multi-user setups, check the server and network performance.

4. GST report mismatch

Verify the company GSTIN, registration, party GSTIN, HSN/SAC, tax ledgers, voucher date, place of supply and tax rate. Correct the source voucher and recompute the relevant GST report. Do not change figures only to force a report match.

5. Import fails

Check the file format, mandatory fields, date format, voucher type, ledger names and duplicate-handling settings. Import a small test file first and keep the import summary for audit purposes.

6. Backup or restore problem

Confirm the selected folder, access permissions, backup date and backup version. Restore into a separate folder first. Verify ledgers, vouchers, GST reports, Trial Balance, outstanding balances and bank reconciliation before replacing live data.

7. Printing or PDF problem

Check the selected printer, paper size, print range, preview and PDF destination. Test with a small report. If only one report fails, compare its print configuration with a working report.

8. ODBC or Excel connection problem

Confirm that ODBC is enabled, the port is available, the company is open and the TallyPrime, driver, Windows and Office 32-bit/64-bit configurations are compatible. Keep ODBC on a trusted network and never expose the port directly to the public internet.

9. Sync or online service issue

Check internet connectivity, service status, login details and the Event Log. Retry only after correcting the reported cause. Record the exchange or sync reference if one is shown.

10. How to investigate any unresolved error

1. Open F1 (Help) > Troubleshooting > Event Log.
2. Capture the exact error message without exposing passwords or confidential data.
3. Note the release, company, user, action and time.
4. Contact your Tally Partner or Tally support with the details.

Do not do this: Do not delete company files, overwrite the original data with an unverified backup, expose passwords, or download unknown repair tools from unofficial websites.

Prevention checklist

• Schedule backups and test restoration periodically.
• Keep TallyPrime updated and document release changes.
• Use appropriate user permissions.
• Keep GST master data accurate.
• Maintain an audit trail for corrections and imports.

Useful related guides

• How to Backup and Restore Company Data in TallyPrime
• How to Reconcile GSTR-2B in TallyPrime
• TallyPrime Bank Reconciliation Guide

Conclusion

Troubleshoot TallyPrime systematically: protect the data, read the exact error, check the relevant configuration, test on a copy and keep a clear record of the fix. When safe checks do not resolve the issue, escalate with complete technical details.

This article is software guidance only. Back up data and consult your Tally Partner before data repair or statutory corrections.

 

How to Backup and Restore Company Data in TallyPrime

How to Backup and Restore Company Data in TallyPrime

Your accounting data contains invoices, ledgers, GST records and reports. A regular backup protects your business from hardware failure, accidental deletion, malware and other unexpected problems.

Version note: This guide is for TallyPrime Release 7.0 onwards. Menu names may vary in earlier releases.

Before you begin
Take a backup before upgrading TallyPrime, keep a copy on a separate drive, and test restoration periodically.

How to take a manual backup

1. Open TallyPrime and select the required company.
2. Press Alt+Y (Data).
3. Select Backup & Restore > Backup.
4. Select the company or companies to back up.
5. Choose a local folder or TallyDrive as the destination.
6. Press Ctrl+A to start the backup.
7. Wait until TallyPrime confirms completion.

Use a clear folder structure such as Tally Backups / Company Name / 2026-10-12. Do not keep your only backup on the same physical drive as the original data.

How to schedule automatic backups

TallyPrime can schedule backups at regular intervals.

1. Press Alt+Y (Data).
2. Select Backup & Restore > Schedule Backup.
3. Choose a local drive or TallyDrive.
4. Select once, daily, weekly or monthly frequency.
5. Select the companies to include and save the schedule.

Scheduled backups are useful when several users work on the same company data. See the official local backup guide.

How to restore company data

Whenever possible, restore into a separate folder first so you can verify the data before replacing the original company.

1. Press Alt+Y (Data).
2. Select Backup & Restore > Restore.
3. Select the restore destination path.
4. Choose the drive or folder containing the backup.
5. Select the company and required backup version.
6. Press Ctrl+A to begin restoration.
7. Open the restored company and verify the data.

If the company uses TallyVault or a protected backup, enter the required password or recovery key. Read the official restore procedure.

Important checks after restoring

• Company name and financial year
• Latest voucher number
• Ledgers and stock items
• GST reports and Trial Balance
• Outstanding receivables and payables
• Bank reconciliation
• User permissions and security settings

Safety tip: Do not overwrite the original company folder until the restored data has been checked completely.

Common backup problems

• Backup is not visible: Check the selected folder and access permissions.
• Restore shows an empty list: Select the correct parent folder containing the backup.
• Password error: Use the correct TallyVault or backup password.
• Backup is too large: Keep at least one verified copy before removing older backups.
• Data is not current: Check the backup date and time before restoring.

Use the 3-2-1 backup rule

• Keep 3 copies of important data.
• Store them on 2 different types of storage.
• Keep 1 copy away from the main computer.

For example, keep one local backup, one external-drive backup and one secure off-site or TallyDrive backup.

Conclusion

A reliable backup routine is essential for every TallyPrime user. Take regular backups, schedule them where possible, and test restoration before an emergency occurs. A backup is useful only when it can be restored successfully.

Always test the steps on a backup company before restoring live accounting data.

 

How to Generate an e-Invoice in TallyPrime: Setup, IRN and Common Errors

Generating an e-Invoice from TallyPrime can reduce manual data entry and help you receive the Invoice Reference Number (IRN) and QR code for eligible transactions. This guide covers the one-time setup, invoice generation, verification, cancellation and common errors.

Version note: This guide is written for TallyPrime Release 7.1. Menu names and options can vary slightly in other releases. GST and e-Invoice applicability depends on the latest government rules, so confirm eligibility with your tax adviser.

Before you begin

• Use an active TallyPrime subscription and a company with correct GST details.
• Register the business on the Invoice Registration Portal (IRP).
• Create an API user profile on the IRP and select Tally (India) Private Limited as the GSP.
• Keep the IRP login details available for the first exchange from TallyPrime.
• Verify the GSTIN, party GSTIN, place of supply, HSN/SAC, tax rate, invoice number and item details.

Step 1: Enable e-Invoicing in TallyPrime

1. Open the company in TallyPrime.
2. Press F11 to open Company Features and set Enable Goods and Services Tax (GST) to Yes.
3. Open the relevant GST registration and set e-Invoicing applicable to Yes.
4. Enter the applicability date and the invoice bill-from place.
5. Press Ctrl+A to save the company GST settings.

If you use multiple GST registrations, select the correct registration before enabling e-Invoicing. Do not enable the setting in a test company and assume that it has been enabled in every company.

Step 2: Record a sales invoice

1. Open Alt+G (Go To) > Create Voucher > Sales, or open the Sales voucher from the Gateway of Tally.
2. Select the party ledger and sales ledger.
3. Enter the stock items or service details, quantity, rate, discount and GST ledgers.
4. Set Provide e-Invoice details to Yes.
5. Check the Bill-to and Ship-to details. If the shipping address is different, enter the required consignee details and Ship-to GSTIN/UIN.
6. Press Ctrl+A to save the e-Invoice details and then save the voucher.

Important invoice-number check: Avoid starting invoice numbers with zero, a slash or a hyphen because the IRP can reject them.

Step 3: Generate the IRN from TallyPrime

1. After saving the voucher, confirm that you want to generate the e-Invoice.
2. Enter the IRP login details when TallyPrime asks for them.
3. Press Enter to exchange the invoice details with the portal.
4. Wait for the exchange result. A successful response provides the IRN and QR code details.
5. Print or share the invoice after checking the IRN, QR code, invoice number and tax totals.

You can also review the status from Alt+G > e-Invoice. Open the e-Invoice report to see invoices pending for generation, IRN-generated transactions, rejected transactions and cancelled IRNs.

Generate an e-Way Bill along with the e-Invoice

If your business needs both documents, open the relevant voucher configuration and set Send e-Way Bill details with e-Invoice to Yes. Enter the required dispatch, transport, vehicle and consignee details before saving the voucher. Review the exchange result for both the e-Invoice and e-Way Bill.

Generate IRNs in bulk

1. Press Alt+Z (Exchange).
2. Select Send for e-Invoicing.
3. Review the vouchers ready for IRN generation.
4. Select the required vouchers or send all eligible transactions.
5. Enter the IRP login details and confirm the exchange.

Bulk generation is useful at the end of the day, but review rejected transactions immediately so that incorrect invoices are not delivered to customers.

How to cancel an e-Invoice

Open the voucher in alteration mode and press Alt+X. If the allowed cancellation period has not expired, choose the option to cancel the e-Invoice and voucher, enter the reason and remarks, save with Ctrl+A, and confirm the exchange with the portal.

According to the current TallyHelp guidance, cancellation of an IRN is subject to the applicable 24-hour limit. After the limit, a cancellation request can be rejected by the portal. Always verify the latest rule before acting.

Common e-Invoice errors and solutions

• GSTIN or place-of-supply error: Verify the party master, company GST registration and state details.
• Invalid invoice number: Check that the number does not begin with zero, a slash or a hyphen.
• HSN/SAC or tax-rate mismatch: Correct the item or ledger configuration and recheck the voucher.
• IRP login failure: Confirm the IRP credentials, internet connection and API profile.
• Ship-to details missing: Enter the Ship-to address and GSTIN/UIN when Bill-to and Ship-to locations differ.
• IRN not generated: Open the e-Invoice report, read the rejection reason and correct the voucher before sending it again.
• QR code not printed: Check the print configuration and confirm that the IRN was generated successfully.

Best practices before sending the invoice

• Take a backup before changing GST or e-Invoice configuration.
• Test the process in a sample or backup company first.
• Compare the taxable value, GST amounts, round-off and invoice total with the voucher.
• Verify the recipient GSTIN and email or WhatsApp details before sharing.
• Keep the IRN and response details with the invoice records.

Conclusion

TallyPrime can generate IRNs and QR codes while you record eligible sales invoices. Complete the one-time IRP and company setup, maintain accurate GST master data, review the invoice before exchange, and use the e-Invoice report to track pending, generated and rejected transactions.

For release-specific details, refer to the official TallyHelp guide for generating e-Invoices and printing QR codes.

This article is for software guidance and general information. Confirm current GST and e-Invoice rules with a qualified tax professional.

How to Add a Custom Invoice Print Template in TallyPrime Using TDL

TallyPrime Release 7.1+ supports multiple invoice print templates. In this guide, we register an invoice format called OTS Simple GST Invoice and make it available in the invoice print view.

Before you begin
Test this TDL in TallyPrime Developer with a backup company. The supporting definitions VPC TMPL InvoiceFormatDocs, VPC TMPL Sales and OTS Simple GST Invoice Object Map must be available for your release.

Complete TDL code

;; =========================================================
;; OTS Simple GST Invoice Template
;; TallyPrime Release 7.1+
;; =========================================================

[#Collection: VPC TMPL Custom Formats]
    Object : OTS Simple GST Invoice Template

[Object: OTS Simple GST Invoice Template]
    Use              : VPC TMPL InvoiceFormatDocs
    Country          : @@TMPLCountryIndia
    ViewName         : "OTSSimpleGST"
    UserViewName     : "OTS Simple GST Invoice"
    VarProfile       : "OTS Simple GST Invoice Object Map"
    CarouselTitle    : "OTS Simple GST Invoice"
    IsDefaultAppView : No
    IsDefaultCmpView : Yes

[!Form: OTS Simple GST Invoice Form]
    Use : VPC TMPL Sales

[#Form: Printed Invoice]
    Add : Switch : At Beginning : OTSInvoiceSwitch : OTS Simple GST Invoice Form : +@@VPCTMPLSVPrintViewName = "OTSSimpleGST"

How the code works

1. Register the format: VPC TMPL Custom Formats makes the custom invoice format available to TallyPrime.

2. Define the template: The object assigns the internal view name OTSSimpleGST and the display name OTS Simple GST Invoice.

3. Map the variables: VarProfile connects the format to OTS Simple GST Invoice Object Map.

4. Use the sales form: The custom form inherits VPC TMPL Sales.

5. Switch the print view: The Printed Invoice switch activates this form when the current print view equals OTSSimpleGST.

How to load and test

1. Open TallyPrime Developer and create a separate TDL file.
2. Paste the complete code without changing the internal names.
3. Confirm that the supporting template definitions and object map are loaded.
4. Load the TDL in a test company.
5. Open a Sales voucher and select Print Preview.
6. Look for OTS Simple GST Invoice in the print-template or print-view options.
7. Test the company, buyer, invoice number, date, items, HSN/SAC, GST values and totals.
8. Test local GST, interstate GST, credit notes, multiple items and multi-page invoices.

Create additional invoice designs

Use unique names for every design. For example: OTSCompactGST, OTSModernGST and OTSRetailGST. Each design should have its own ViewName, UserViewName, CarouselTitle, VarProfile and switch condition.

Design ideas
Add a logo, GSTIN, buyer and shipping details, HSN/SAC, quantity, rate, discount, CGST, SGST, IGST, round-off, amount in words, bank details, terms and an authorised-signatory section.

Troubleshooting

• Template does not appear: confirm that the object is added to VPC TMPL Custom Formats and that the TDL loaded successfully.
• Default invoice still prints: verify that the active print view is OTSSimpleGST and that the Printed Invoice switch is evaluated.
• Fields are blank: check the object map and supporting field mappings.
• Errors appear after an upgrade: compare the VPC TMPL definitions with the current TallyPrime release.
• Multiple templates conflict: use unique object, form, switch, view and profile names.

Conclusion

This method adds a named custom invoice template while keeping TallyPrime's default format available. Test the template in Developer mode first, then build additional designs as separate template objects. Always keep a backup of each working TDL version.

How to Configure WhatsApp in TallyPrime to Send Invoices and Reports

How to Configure WhatsApp in TallyPrime to Send Invoices and Reports

TallyPrime allows businesses to send invoices, reports, reminder letters, and other documents directly to customers through WhatsApp. This guide explains the setup process and the steps for sharing documents safely.

This guide applies to TallyPrime Release 4.0 and later, subject to an active subscription and supported WhatsApp services. Menu names may vary slightly between releases.

What You Need Before Starting

Before configuring WhatsApp in TallyPrime, make sure that:

• You are using a supported TallyPrime release.

• Your TallyPrime subscription and required services are active.

• You have a valid business phone number.

• The number is registered with a WhatsApp Business Account.

• Your business verification and WhatsApp templates are approved.

• The customer’s WhatsApp number is available in the party ledger.

TallyPrime uses a registered Business WhatsApp number and approved message templates. Registration may require help from your Tally Partner and the supported WhatsApp service provider.

Step 1: Register Your Business WhatsApp Number

Complete the WhatsApp Business Account onboarding process before configuring TallyPrime. Keep your registered business number, business name, connected service login details, and approved WhatsApp templates ready.

If you have not registered a business number, contact your Tally Partner to discuss WhatsApp onboarding and subscription activation.

Step 2: Add the WhatsApp Number in TallyPrime

1. Open your company in TallyPrime.

2. Press Alt+M (Share).

3. Select Manage > WhatsApp Nos.

4. Choose Add New.

5. Enter the registered business WhatsApp number and business name.

6. Sign in when TallyPrime asks for your connected WhatsApp service credentials.

7. Save the details.

You can add more than one registered business WhatsApp number if the numbers are properly registered and activated.

Step 3: Set the Default WhatsApp Number for a Party

To avoid entering a customer’s number every time:

1. Press Alt+G (Go To).

2. Select Alter Master > Ledger.

3. Open the required customer ledger.

4. Press F12 (Configure).

5. Set Default WhatsApp No. to Yes.

6. Enter the customer’s primary WhatsApp number.

7. Save the ledger.

If a customer has multiple numbers, enable the multiple mobile number option and save the relevant contact names and numbers.

Step 4: Send an Invoice Through WhatsApp

1. Open the sales invoice or Sales Register.

2. Press Alt+M (Share).

3. Select Current under WhatsApp.

4. Select the recipient’s WhatsApp number.

5. Choose the file format and approved WhatsApp template.

6. Press C (Configure) if you want to include the company logo, GSTIN, or other details.

7. Press P (Preview) to check the invoice.

8. Press W (WhatsApp) to send it.

Always preview the invoice and verify the recipient number before sending.

Step 5: Send Reports Through WhatsApp

You can share reports such as Sales Register, Purchase Register, Day Book, Balance Sheet, Profit & Loss A/c, Bills Receivable, Bills Payable, ledger reports, and Confirmation of Accounts.

Open the required report, press Alt+M (Share), select WhatsApp > Current, choose the recipient and template, and press W (WhatsApp).

Step 6: Send Payment Reminders

1. Press Alt+G (Go To).

2. Open Bills Receivable.

3. Press Alt+M (Share).

4. Select WhatsApp > Current.

5. Configure the ageing range and reminder details.

6. Select the approved reminder template.

7. Press W (WhatsApp).

This is useful for following up on overdue invoices without manually preparing separate reminder documents.

Step 7: Share an Invoice Immediately After Saving

You can configure TallyPrime to show the WhatsApp sharing screen after saving a voucher:

1. Press Alt+G (Go To).

2. Select Alter Master > Voucher Type.

3. Open the Sales voucher type.

4. Press F12 (Configure).

5. Set Allow sharing voucher through WhatsApp after saving to Yes.

6. Set WhatsApp voucher after saving to Yes.

7. Save the configuration.

When you save a sales invoice, the WhatsApp screen will appear automatically.

Common WhatsApp Configuration Problems

WhatsApp number is not available: Check whether the number is registered with the WhatsApp Business Account and added correctly in TallyPrime.

Templates are not visible: Only approved templates are available. Create or modify the template through the connected WhatsApp service, wait for approval, and refresh the template list in TallyPrime.

The customer does not receive the message: Verify the customer’s WhatsApp number, country code, active subscription, and message status. Also check that the selected template matches the document type.

WhatsApp is unavailable: Confirm that the TallyPrime subscription is active, the company is not running in Education Mode, the registered number is connected, the user has sharing permission, and the internet connection is working.

Security and User Permissions

Administrators can restrict WhatsApp sharing for selected users. Review user roles when only authorised employees should send invoices or reports. You can restrict sending invoices, sharing financial reports, adding WhatsApp numbers, and sending documents to multiple customers.

Conclusion

Configuring WhatsApp in TallyPrime can make invoice sharing, payment follow-up, and report communication faster. Start by registering a business WhatsApp number, add it in TallyPrime, configure customer numbers, select approved templates, and test the process with one invoice.

WhatsApp availability, pricing, templates, and menu names may vary by TallyPrime release and service configuration. For the latest official steps, refer to TallyHelp: https://help.tallysolutions.com/whatsapp-documents/

Related guide: GSTR-2B reconciliation in TallyPrime: https://tallyexperttips.blogspot.com/2026/10/how-to-reconcile-gstr-2b-in-tallyprime.html

How to Reconcile GSTR-2B in TallyPrime: Step-by-Step Guide

GSTR-2B reconciliation helps you compare purchase transactions recorded in your books with the invoices and credit notes reported by your suppliers on the GST portal. This guide explains how to download or import GSTR-2B data, review differences, and resolve common exceptions in TallyPrime.

What is GSTR-2B?

GSTR-2B is a static, system-generated statement of eligible and ineligible input tax credit based on supplier returns such as GSTR-1, GSTR-5, and GSTR-6. It is generated for a return period and should be compared with your purchase records before claiming input tax credit.

Always verify the applicable GST rules and eligibility with your tax professional. This article explains the TallyPrime workflow and is not a substitute for professional tax advice.

Before you start

• Keep your TallyPrime company data updated and take a backup.
• Confirm that the correct GST registration is configured in the company.
• Download the required GSTR-2B period from the GST portal, or keep the Excel/JSON file ready for import.
• Use a TallyPrime release that supports the GSTR-2B reconciliation features described below.

Step 1: Download GSTR-2B directly into TallyPrime

1. Press Alt+Z (Exchange) and select All GST Options > Download GST Returns.
2. Press C (Configure).
3. Set Return Type to GSTR-2B and select the return period.
4. Press D (Download). If required, sign in to the GST portal and complete the OTP step.
5. After download, open the GSTR-2B Reconciliation report.

Step 2: Import a GSTR-2B file manually

1. Press Alt+O (Import) > GST Returns.
2. Select the GST registration and set Return Type to GSTR-2B.
3. Select the downloaded Excel or JSON file.
4. Press Ctrl+A to accept and review the Import Summary.

Step 3: Open the GSTR-2B Reconciliation report

Press Alt+G (Go To), search for GSTR-2B Reconciliation, and open the report. TallyPrime groups transactions into useful sections such as Reconciled, Unreconciled, Mismatched, Available Only in Books, Available Only on Portal, Mismatch in Return Period, Excluded, and Uncertain Transactions.

Use F3 (Company/Tax Registration) when you need to switch between GST registrations. Use Ctrl+H (Change View) to switch between reconciliation statistics and voucher statistics.

Step 4: Resolve common differences

Invoice available only on the portal

Check whether the purchase invoice was missed in the books. Use the portal view to verify the supplier, invoice number, date, taxable value, and tax amount. Record the correct purchase transaction in TallyPrime, if applicable, and then review the reconciliation status.

Invoice available only in books

Check whether the supplier has filed the return for the relevant period. Verify the supplier GSTIN, invoice number, invoice date, and GST amounts in your books. Follow up with the supplier when the document is missing from GSTR-2B.

Mismatch in invoice number or document date

Small differences caused by prefixes, suffixes, spaces, or typing errors can create a mismatch. Review the portal document and correct the voucher details in the books. TallyPrime also provides options to copy the document number and date from the portal view where applicable.

Mismatch in return period

If the supplier reported the document in a different period, review the transaction and set the appropriate GST Return Effective Date after confirming the correct treatment.

Taxable value or tax amount mismatch

Compare the purchase voucher with the supplier document. Do not mark a transaction as reconciled merely to remove an exception. Correct the underlying voucher or investigate the supplier filing. For minor differences such as permitted rounding differences, use the reconciliation configuration only after reviewing the business and tax impact.

Incorrect GSTIN or section

Correct the party GSTIN/UIN or voucher classification when the mismatch is caused by a data-entry error. If the transaction is not related to your business, exclude it only after documenting why it should not be considered.

Step 5: Recompute GSTR-2B when required

You may need to recompute GSTR-2B after changes to IMS actions, purchase invoices, GST effective dates, or input tax credit availability. Use Alt+Z (Exchange) > All GST Options > Recompute GSTR-2B, select the GST registration and period, and choose R (Recompute). After the process completes, download the latest GSTR-2B data and review the reconciliation report again.

Best practices before claiming ITC

• Do not claim the same document twice.
• Investigate invoices that are missing from GSTR-2B or present only in the books.
• Review blocked or ineligible ITC separately.
• Keep supplier follow-up records for missing or incorrect invoices.
• Maintain a backup and an audit trail before making bulk corrections.

Related TallyPrime guides

For related workflows, read our TallyPrime bank reconciliation guide and our earlier guide on resolving GST voucher mismatches.

Conclusion

GSTR-2B reconciliation in TallyPrime is most effective when you review exceptions systematically: download the correct period, compare books with the portal, correct genuine errors, document supplier issues, and recompute the data when GST or IMS changes affect ITC availability.

Menu names and features can vary by TallyPrime release. Test changes on a backup company and confirm tax treatment with a qualified professional before filing returns.

Official TallyHelp reference: Reconcile GSTR-2B Data in TallyPrime

TallyPrime Bank Reconciliation: A Practical Step-by-Step Guide

Bank reconciliation is one of the simplest ways to catch missing entries, duplicate postings and timing differences before they become accounting problems. In TallyPrime, you can compare your book balance with the bank statement and investigate unmatched transactions in a structured way.

This guide explains a practical workflow for bank reconciliation in TallyPrime. Menu names can vary slightly by release and configuration, so use the equivalent Bank Reconciliation or Banking report available in your installation.

What is bank reconciliation?

Bank reconciliation is the process of comparing the bank balance recorded in your company books with the balance shown by the bank. The two balances may differ because of cheques in transit, direct bank charges, deposits not yet credited, bank interest, or entries that have not been recorded in TallyPrime.

A regular reconciliation helps you:

• find missing receipts and payments;
• identify duplicate or wrongly dated vouchers;
• separate genuine timing differences from accounting errors;
• keep cash-flow reports more reliable; and
• prepare cleaner records for month-end review.

Before you begin

Keep the following ready:

• the latest bank statement in PDF, Excel or another format supported by your process;
• the correct bank ledger in TallyPrime;
• the statement period and closing balance; and
• details of pending cheques, deposits and bank charges.

Take a backup of the company data before making a large batch of corrections. If multiple users work in the same company, coordinate the reconciliation period so that new vouchers do not make the report confusing while you are reviewing it.

Step-by-step bank reconciliation in TallyPrime

1. Open the bank reconciliation report

Open the relevant company and go to the Banking or Display reports area. Select the bank ledger and open the Bank Reconciliation report. In some releases, you can reach the report from the ledger or from the Banking menu.

2. Select the correct bank ledger and period

Choose the exact ledger linked to the bank account you want to review. Set the date range to match the bank statement. Working one month at a time is usually easier than trying to reconcile a full year in a single pass.

3. Enter or import the bank statement details

Depending on your TallyPrime release and bank setup, you may be able to import statement data or enter the relevant transaction details in the reconciliation view. Check the date, amount, transaction type and reference before accepting a match.

Do not match a transaction only because the amount is identical. Confirm the date range, narration, cheque number, reference number or other identifying detail as well.

4. Match cleared transactions

Mark the transactions that have cleared the bank. Receipts deposited into the bank and payments made by cheque should be matched only when they appear in the statement. A voucher can be recorded in the books before the bank processes it, so the book date and clearance date may be different.

5. Review unmatched transactions

Group the unmatched items into practical categories:

• cheques issued but not yet presented;
• deposits recorded in books but not yet credited;
• bank charges or interest missing from TallyPrime;
• direct credits or debits made by the bank;
• wrong dates, amounts or bank references; and
• entries that belong to another bank account or company.

6. Record genuine missing entries

If the bank statement contains a legitimate charge, interest entry or direct debit that is missing from the books, record the appropriate voucher after checking the supporting document. Use the correct expense, income or party ledger and add a clear narration.

For corrections, avoid deleting a voucher just to force the report to match. Reverse or alter it according to your internal accounting policy, retain the audit trail, and document the reason for the change.

7. Verify the reconciled balance

After matching and recording missing entries, compare the reconciled balance with the bank statement closing balance. Investigate any remaining difference instead of carrying it forward without an explanation.

Common reasons for a difference

Difference	Likely reason	What to check
Payment in books, absent in statement	Cheque or transfer is pending	Cheque number, bank date and outstanding list
Credit in statement, absent in books	Direct receipt or bank transfer	Bank reference, customer and remittance advice
Small unexplained debit	Bank charge or tax on charge	Statement narration and bank advice
Same amount appears twice	Duplicate voucher or duplicate import	Voucher number, date and reference
Balance differs after matching	Opening balance, date or amount error	Previous reconciliation and ledger entries

Practical tips for faster reconciliation

1. Reconcile weekly for high-volume bank accounts and at least monthly for other accounts.
2. Use a consistent narration format, such as bank reference plus party name.
3. Keep a short pending-items list with an owner and expected clearance date.
4. Review old unreconciled cheques instead of allowing them to remain indefinitely.
5. Restrict back-dated edits after month-end review and record approved exceptions.
6. Reconcile each bank ledger separately; do not combine accounts just to make the balance appear correct.

Tally.ERP 9 and TallyPrime: what changes?

The exact screens and banking features differ between Tally.ERP 9 and TallyPrime. The accounting principle remains the same: compare the book entry with the bank evidence, record legitimate missing transactions, and explain timing differences. If you are upgrading an older company, confirm that bank ledgers, opening balances and prior reconciliation information have migrated correctly before starting a new period.

Frequently asked questions

Can I reconcile a bank account without importing a statement?

Yes. You can review the bank ledger and mark or enter reconciliation details manually when your release or bank workflow does not support statement import.

Why is a cheque still unreconciled even though it was entered?

Entering a cheque voucher records it in the books. It becomes reconciled only after it clears the bank or after you enter the correct clearance information.

Should I change the voucher date to match the bank date?

Not automatically. The voucher date should reflect the underlying transaction and your accounting policy. Use the reconciliation or clearance details for timing differences, and change a voucher date only when it is genuinely incorrect and the change is properly approved.

Final checklist

• Correct company and bank ledger selected
• Statement period matches the report period
• Opening and closing balances checked
• Cleared transactions matched using references
• Bank charges and direct credits recorded
• Old unreconciled items reviewed
• Backup and review completed

Conclusion: Bank reconciliation works best as a routine control, not as a year-end emergency. A short weekly or monthly review in TallyPrime can reveal errors early and give you a more dependable view of available cash.

Note: This article is for general software and bookkeeping guidance. Always verify the workflow with your accountant and the documentation for your installed Tally release.