T PRI 6.0.....IMPORT ...BK STAT...IN EXCEL-XSLX-CSV(CSD).......SAYS INVALID FORMAT

This query is : Resolved

Quick Summary

User faced 'invalid format' error importing bank statements in Tally Prime. Issue arises due to incorrect CSV/Excel structure from PDF conversion. Solution: use Tally template, clean data, ensure proper headers, date format, and correct file type.

ATUL

ATUL (Querist)
Follow

21 September 2025 HELP ME
IMPORT -- BANK STAT IN TALLY-PRIME 6.1

BANK STAT IN PDF
PDF CONVERTED IN EXCEL
PDF CONVERTED IN CSV ….COMMA DELITED
PDF CONVERTED IN XSLX

WHILE IMPORTTNG IN TALLY

SHOWS ERROR AS NOT A VALID FORMAT

ANY SPECIFIC FORMAT...................

Dhirajlal Rambhia

Dhirajlal Rambhia (Expert)
Follow

21 September 2025 Required Format and Common Causes

Tally Prime expects bank statements in specific formats (CSV, XLS, XLSX, MT940), with clear column headers like Date, Description, Amount, etc., and often in a particular date format (e.g., DD/MM/YYYY).

PDF-to-Excel or CSV conversion may add extra formatting, blank rows, merged cells, or incorrect date/amount formats.

Any extra rows, missing headers, or wrong separators (such as using tabs rather than commas in a CSV) will cause the “not a valid format” error.

Commas removed during CSV creation may make the file unusable as the required delimiters are lost.

Dhirajlal Rambhia

Dhirajlal Rambhia (Expert)
Follow

21 September 2025 Steps to Successfully Import Bank Statement
1. Get a Sample Template
Download a sample import template from TallyPrime’s official help or through the software’s Bank Reconciliation Import screen. This shows the expected column headers and structure.

2. Clean the Data

Open the converted Excel/CSV file in Excel.

Ensure there are no merged cells, blank rows, or hidden extra columns.

Copy/paste your data into the downloaded template, retaining exactly the same column order and headings.

Dates should be in a consistent format, e.g., DD/MM/YYYY.

Amount columns should NOT have currency symbols or formatting.

Dhirajlal Rambhia

Dhirajlal Rambhia (Expert)
Follow

21 September 2025 3. Save in the Correct Format

Save as CSV (comma-separated values) if possible.

Else, save as Excel (.xlsx), but do not use formulas, filters, or formatting.

4. Import through Tally’s Menu

Go to Gateway of Tally > Banking > Bank Reconciliation > Import (Alt+O).

Choose the exact file type (CSV/Excel/MT940).

Select the cleaned file for import.

Dhirajlal Rambhia

Dhirajlal Rambhia (Expert)
Follow

21 September 2025 Advanced Solutions

If using add-ons or third-party tools to import, ensure you’re using the latest compatible version, and check their documentation for template downloads.

For highly complex bank statement PDFs, consider cloud converters or automated tools like EazyAUTO4, Suvit, or Repotic to generate Tally-ready files directly from PDF.

If the error persists, review Tally’s import log to locate the exact format issue or missing header.

Dhirajlal Rambhia

Dhirajlal Rambhia (Expert)
Follow

21 September 2025 Always refer to your bank’s export options—some banks directly offer Tally or CSV-compatible downloads.

Keep a backup of company data before importing.

Remove all unnecessary formatting, comments, or extra columns before import.

Use only one sheet per Excel file if importing XLSX.

By following these cleaning and templating steps, the error “not a valid format” during bank statement import in Tally Prime 6.1 can be resolved.

Dhirajlal Rambhia

Dhirajlal Rambhia (Expert)
Follow

21 September 2025 Good luck....

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now