How It Works — Th e 5-Step Process

Upload Transaction

Reports Verify & Refine Data Convert to XML Files Integrate with Tally Entries Confirmed

Businesses across India — from service companies and D2C brands to SaaS platforms and retail operators — collect payments digitally through gateways like Razorpay, Cashfree, PayU, and Paytm. Yet their accounting software, typically TallyPrime, has no way to receive this data automatically. Every transaction sits in a gateway report as a flat Excel or CSV row, waiting to be entered manually.

The pain is not limited to businesses alone. CA firms managing multiple clients face this problem at scale. When client data from payment gateways arrives late — or has to be entered manually before it can even be reviewed — the entire compliance chain gets delayed. GST returns, TDS filings, and monthly closings all depend on accurate, timely books. Delayed data entry means delayed compliances, which means penalties, notices, and strained client relationships.

The manual process itself is error-prone: inconsistent line items, mismatched values, wrong categorisation of transactions, missing GSTINs, and incorrect tax splits are common. Every error that enters Tally requires correction before filings — adding more time to an already stretched workflow.

"The gap between payment gateways and TallyPrime is not a minor inconvenience. It is a structural compliance risk that compounds every month for millions of Indian SMEs."

Tally PG Importer is a browser-based digital tool — designed by C.A. Shalini Somani — that automates the transfer of financial information from payment providers directly into TallyPrime accounting software. Users upload transaction reports, verify and refine data through a central dashboard, and the tool converts raw sales records into TallyPrime-compatible XML files, optimising integration between payment gateways and Tally's internal ledger management.

The tool auto-creates party ledgers from GSTINs, generates stock items from product descriptions, applies the correct IGST or CGST+SGST split based on state-code matching, and attaches bill references for outstanding tracking. It is entirely gateway-agnostic — the column-mapping step makes it work with any payment gateway's export format.

Compliance context: Since 1 August 2023, B2B e-invoicing is mandatory above Rs.5 crore turnover. CBIC detected Rs.36,374 crore in erroneous or fraudulent ITC across 9,190 cases in FY2023-24. (CBIC / PIB Ref 2038602)

01

Gateway-Agnostic Upload

Accepts Excel or CSV exports from any payment gateway

— Razorpay, Cashfree, PayU, Paytm — without preprocessing or reformatting.

02

Flexible Column Mapping

Users map column headers once per gateway format. No rigid template required. Works with any export structure the gateway produces.

03

Row-Level Validation

Every row is scanned before posting. Warnings flagged for missing GSTINs, blank fields, or amount inconsistencies — errors caught before reaching Tally. 04

Auto GST Split

CGST+SGST for same-state transactions; IGST for interstate — determined automatically by GSTIN statecode matching. Zero manual lookup required.

05

Master Auto-Creation

Party ledgers are created from GSTIN data. Stock items generated from product descriptions. No preconfiguration or admin setup needed in Tally.

06

XML Preview & Batch Retry

Users can preview and download the XML before posting. Failed batches flagged individually and retried without reprocessing completed entries.

01 — Claude

GST Logic Implementation

The CGST/SGST vs IGST split rule based on GSTIN statecode matching was described to Claude as a business rule. Claude converted it into edge-case-safe code covering composition dealers, unregistered parties, and reverse charge scenarios.

02 — Claude + Codex

TallyPrime XML Schema

TallyPrime's XML import format is largely undocumented and fails silently on errors. Claude and Codex were used to reverse-engineer the correct voucher schema, ledger creation fields, stock item structure, and bill reference fields.

03 — Python + Claude

Error Recovery & Retry Logic

Python bridge logic for batch retries, partial-import safety, and mid-session crash recovery was designed with Claude — mapping edge cases such as Tally disconnecting mid-import or a single row failing within a batch.

04 — Claude

UI/UX for Accountants

The column-mapping interface and inline validation feedback system was designed with Claude's assistance to ensure non-technical accountants could operate the tool independently, without support or training.

01

Man-Hours Saved

4–8 hours of manual Tally entry reduced to under 10 minutes per 200 transactions per month — a structural time saving, not a marginal one.

02

CA Firms in Practice

One CA firm handling 20–30 clients with payment gateway data saves the equivalent of a full week of staff time every month, with improved consistency.

03

SMEs in Service Industry

SaaS businesses, freelancers, D2C brands, and retail operators can close their books in minutes at monthend — without an accountant manually entering every transaction.

04

Fewer Errors, Less Litigation

Correct GSTIN handling, automatic GST splits, and autocreated ledgers eliminate the source of ITC mismatches, notices, and scrutiny assessments from manual entry errors.

"The problem is enormous. The solution is simple. And it works."