Visit the new site

Automate Your Tally Reports

Streamline your Reports export with one-click automation.

Get a Demo
Showing posts with label Tally. Show all posts
Showing posts with label Tally. Show all posts

Monday, 3 August 2026

What a Failed Sales Job in 2001 Taught Me About Building Business Software

 

What a Failed Sales Job in 2001 Taught Me About Building Business Software

I build TurboData, a reporting and analytics layer for businesses running Tally. Before that I spent twenty-five years in sales, data capture and data warehousing.

This is the story of the year that pointed me here. It did not go well at the time.


Before it went wrong

I started at Philips Semiconductors as a Sales Engineer. People arrived at nine and left at five. Payments were largely in advance. Commercial terms like FOB and FCA were researched properly, by people who cared about the difference. Processes were stable.

It was, to be honest, boring.

My second assignment there was estimating the lighting and semiconductor markets in South India. I built an Access database of product bills of material. It took weeks. But afterwards a product manager in Mumbai could see what was likely to be needed, in what quantity, in which market — instead of waiting for fragmented field reports.

The business head was not thrilled that a junior was spending so much time in the field. The objection, essentially, was that I was gathering too much data.

Then I left. For a real sales territory. Because the database job was boring and I was young and I wanted to sell things.

I did not understand what I was giving up until about a year later.

September 2001

I joined Philips Lighting in Mumbai as a Sales Engineer, with the confidence of a superstar and almost no training.

Within days, the World Trade Center towers fell. The world appeared to be changing, and I reported to the office to begin selling light fittings.

Mumbai was divided into sales territories: Fort to Dadar, Dadar to Andheri, Andheri and beyond, Thane. I was given the second one.

I was assigned two old stockists located next door to each other. Experienced, decent people. Their sales strategy was to sit inside the shop and wait for customers to arrive. When I suggested we go into the market and meet customers, they looked at me as though I had proposed moving the shop to Antarctica.

Enterprise archaeology

Soon after joining, my manager handed me a large accounts-receivable statement. Some invoices were more than four years old. The instruction was straightforward: make the receivables zero.

At that stage I sincerely believed that if management had given me the list, the money must be waiting somewhere.

One line was around ₹73,000. The sale had happened in 1993. Payment was expected by 1997. The customer had closed operations in 1999. I joined in 2001.

My first major assignment was to collect money from a company that had ceased to exist two years before I arrived.

I was not selling lighting products. I was excavating ancient invoices.

The employees who handled the transaction had left. The customer contacts had disappeared. Supporting documents were hard to trace. The instruction did not change. When I failed to produce a financial resurrection, the shouting began.

Old receivables are a data problem long before they are a collection problem. Nobody in that building could separate what was collectible from what was disputed, doubtful or effectively dead — so the entire ledger was handed to the newest employee as a single number.

Who actually owned the customer?

A lighting project could involve an architect, a lighting consultant, an electrical contractor, an end user, a dealer, a design engineer, several salespeople — and at least three people claiming ownership once the order arrived.

Each of them could sit in a different Mumbai territory.

I once started visiting architects and consultants near Dadar. They were close to my assigned stockist, so I assumed this was called business development. Within a short time I received an angry call from head office: each architect had already been allocated to a lighting design engineer. I could not approach an architect a hundred metres from my own stockist without causing a territorial crisis.

I had finally started meeting potential customers, and the organisation reacted as though I had crossed an international border without a passport.

Some companies do not have territories. They have arguments drawn on maps. A territory tells you where a salesperson may travel. It does not tell you who owns the relationship, which is the only question that matters when four people decide one project.

Pricing as a live performance

The central product team circulated standard prices and volume-discount slabs. I communicated them to my stockists.

One month later my Area Manager arrived with the Product Manager and announced an entirely different discount structure.

The stockist looked at me. I looked at the manager. The manager looked completely confident.

Different managers could quote different prices for the same product, customer and quantity. A salesperson could communicate an officially approved price and still appear unreliable a month later.

Customers wanted consistency. Dealers wanted margins. Salespeople needed authority. Operations needed forecasts.

We had volume. Of voice.

Zero out of one hundred

I managed to reach organisations like Indian Oil, Indian Oil Tanking and Bharat Petroleum. They issued complicated tenders with technical specifications running to more than a hundred lighting products.

I had never been trained in lighting design. I was uncomfortable with the design software. I did not know how to configure a hundred products in a technical bid. I was competing against companies with dedicated design teams and several sales officers covering the same market.

One tender contained more than a hundred items. We won zero.

Winning nothing out of a hundred requires remarkably consistent performance. Our pricing was not competitive, availability was uncertain, technical support was weak and coordination was poor.

One part of the process, however, worked perfectly. The blame reached me by evening.

Nobody asked which items we lost on price and which on specification. Nobody asked what the winning rate had been. Nobody asked which products we simply did not have. A tender where you win zero of a hundred should produce a win-loss analysis. Ours produced a meeting.

Responsibility travels faster than material

Since my stockists preferred waiting for customers, I opened the Mumbai Yellow Pages and looked for alternatives. There was no LinkedIn, no prospecting software, no CRM intelligence. There was a large yellow directory and optimism.

I found a former high-performing stockist of a competing brand and persuaded them to sell our products. Together we pursued a project near Thane. Unknown to me, my own manager was chasing the same opportunity through another channel partner. We won anyway.

For one brief moment I felt like the superstar I had imagined myself to be. Then delivery began.

The material was not available locally and had to come from Kolkata. The shipment was delayed. The customer complained directly to the CEO.

I had found the dealer, developed the opportunity and helped win the order. Inventory, dispatch and logistics were outside my control. The blame came to me.

Responsibility travels downward considerably faster than material travels from Kolkata.

Not fit for sales

By early 2002 I had reached my limit. Around twenty-four people had reportedly left before me. Turnover was high, though management did not seem curious about why.

Management refused to settle my expenses unless I reduced the old receivables to zero. My reimbursement depended on collecting invoices from customers who no longer existed.

Eventually, in a meeting attended by the HR head, the Regional Manager told me I was not fit for sales.

At the time, I believed him. I went home to Gurgaon convinced my career had failed before it properly began.

What I did instead

I documented all of it — the absent training, the incoherent territories, the conflicting channel ownership, the pricing by announcement, the uncollectable legacy receivables, the weak design support, the tender failures, the delivery problems, the turnover, and the gap between responsibility and authority.

I circulated it internally. Then I took it to Bajaj, Crompton and Thorn — not as an interview, but as a diagnosis of the market they were competing in.

I received two offers.

The man declared not fit for sales had sold his analysis of a broken sales system to three of its competitors. That was, in retrospect, my first consulting assignment.

Why any of this matters now

Every problem in that year was a visibility problem.

They had receivable reports but could not tell collectible amounts from dead accounts. They had territories but no account ownership. They had prices but no record of what was approved, by whom, from when. They had orders but no view of what was actually going to ship. They had data. They did not have information anybody could act on.

Twenty-five years later, that is still the most common condition I find inside a well-run business with a well-maintained Tally installation. The data is all there. The answers are not.

That is what TurboData is for. It makes the state of the business provable — which receivables are genuinely open and traceable to the bills and payments behind them, and, for contractors and developers, what a slipped milestone actually cost, read from vouchers rather than estimated in a meeting.

Instead of telling a salesperson to make receivables zero, management should be able to see which amounts are collectible, disputed, doubtful or dead. That is not a sophisticated ambition. It is the report I needed in 2001 and did not have.

The final irony

They told me I was not fit for sales, and they may have been partly right.

I was not fit for a sales system in which customers had no clear ownership, prices changed without control, impossible receivables were handed to new employees, training was absent, delivery failures became salesperson failures, and data existed but insight did not.

It was an expensive management course. No certificate, no refund and, for some time, not even my expenses.

But it taught me exactly what a poorly instrumented business needs. Clear data. Clear ownership. Clear pricing. Clear accountability. And considerably less shouting.


If any of this sounds like your own ledger, the fastest way to find out is to look at your actual numbers. We run a 30-minute session on your own Tally data and show you what is currently invisible in it — no slides.

Receivables and collections → · Construction and project costing → · Talk to us →

Friday, 31 July 2026

How Tally Partners Can Export Large Sales Registers Without Tally Hanging

 

How Tally Partners Can Export Large Sales Registers Without Tally Hanging

Tally partners frequently face a familiar support request:

“Can you export my complete Sales Register into Excel in a proper columnar format?”

At first, this appears to be a simple export requirement. In practice, the customer may need several layers of information:

  • Voucher-wise sales details
  • Item-wise sales movement
  • Buyer and consignee information
  • GSTIN, PAN, HSN and place of supply
  • Quantity, rate, amount, godown and batch
  • Credit Notes and Debit Notes
  • Ledger debit and credit details
  • GST reconciliation-ready information
  • Data covering several months or years
  • Consolidated output across multiple Tally companies

The problem becomes more serious when the customer has a large volume of transactions.

Why large Sales Register exports become a support problem

Tally processes a significant amount of reporting data in memory. When a customer attempts to export a very large Sales Register in one operation, the process may become slow, appear unresponsive or fail.

The Tally partner is then expected to answer questions such as:

  • Which report should be exported?
  • Should the customer use the Voucher Register or Day Book?
  • How can item details be included?
  • How can Credit Notes be adjusted?
  • Why does one report differ from another?
  • How can the data be exported for a complete financial year?
  • How can the same process be repeated for several companies?
  • How can the output be converted into an analysis-friendly Excel table?

This creates an ongoing support burden. The partner may successfully sell Tally, but then spend considerable time helping customers perform repetitive exports and resolve report-format problems.

The TurboData Sales Register Extract

To solve this problem, we have developed the TurboData Columnar Sales Register Extract.

The module captures the sales movement through multiple Tally extraction approaches:

  • Voucher Register
  • Ledger Vouchers
  • Day Book
  • Tally’s built-in voucher collections

The output is transformed into a clean, columnar Excel format suitable for filtering, PivotTables, Power BI, GST analysis and management reporting.

The module supports Sales, Credit Notes and Debit Notes, including customer-created voucher types. It identifies the voucher family using Tally’s internal logic instead of depending only on the visible voucher-type name. Credit Note values are presented with negative signs, while a separate document-type column distinguishes Sales, Credit Notes and Debit Notes.

One row per stock-item movement

The Sales Register output is designed at the item-line level.

Each stock-item movement can carry the corresponding voucher information, including:

  • Company
  • Voucher date
  • Document type
  • Voucher type
  • Voucher number
  • Reference number and date
  • Party ledger
  • Buyer name and address
  • Consignee name and address
  • Party GSTIN
  • Party PAN
  • Place of supply
  • Narration
  • Stock item
  • HSN
  • Actual quantity
  • Billed quantity
  • Unit of measurement
  • Rate
  • Item amount
  • Godown
  • Batch
  • Sales ledger
  • Order and dispatch details
  • Cancellation, optional and void status
  • Voucher GUID

Voucher-header information is repeated against each item row, making the output directly usable as a columnar dataset. The module also generates a separate ledger debit-credit sheet for accounting verification.

Four extraction methods—and a comparison between them

A major feature of the module is that it does not depend on only one Tally report.

The same sales movement can be tested through four engines:

  1. Built-in voucher collection
  2. Day Book
  3. Voucher Register
  4. Ledger Vouchers

The advanced comparison mode produces a cross-verification sheet showing:

  • Whether a voucher was found by each engine
  • Whether all four engines agree
  • Amount differences between the engines
  • Vouchers found through Ledger Vouchers but missed by the other routes
  • Entries requiring further review

This is particularly useful when a customer says:

“The Excel total does not match what I can see in another Tally report.”

Instead of debating which output is correct, the partner can compare all supported extraction routes and identify the exact voucher causing the difference.

Chunk-wise export prevents Tally from hanging

The module does not attempt to pull an entire large period in one uncontrolled request.

It processes the selected period in smaller date windows. When a response becomes too large or fails, the period is automatically split into smaller windows.

The module can also gradually increase the window size again after successful small extractions. This balances performance and safety.

As a result:

  • Tally remains responsive
  • Large periods can be processed reliably
  • Failed periods can be retried
  • The customer does not need to manually export month by month
  • Very large responses are divided automatically
  • Completed extraction units can be checkpointed for restart

The program records request time, response size, voucher count, failures, empty responses and window splits. It can also write company-wise part files instead of holding the entire extraction in memory.

Unlimited companies and unlimited time ranges

The module can work across all companies currently loaded in Tally.

The customer can choose:

  • A single company
  • Selected companies
  • All loaded companies

The selected date range can cover a day, month, financial year or a much longer historical period. The extraction engine processes the period in controlled chunks rather than forcing the customer to repeat exports manually.

The result is a consistent Excel structure across every company.

Automation of repetitive Tally operations

A normal Tally export often requires repeated use of shortcut keys and configuration screens:

  • F2 for changing the period
  • F3 for selecting companies
  • F4 or voucher-related navigation
  • F8 for Sales
  • F12 for report configuration
  • Export selections and file-path entry

TurboData reduces the need to repeat these actions for every company and every period.

The extraction can be configured for automated execution, standardised output naming, logging, JSON generation and Excel creation.

This is not merely an Excel export. It is a repeatable extraction process.

Benefits for the Tally partner

The biggest benefit is not only the report—it is the reduction in support effort.

1. Immediate revenue opportunity

The Sales Register module addresses a requirement that customers already understand.

There is no need to begin by selling a complex data warehouse. The partner can start with a practical problem:

“We will give you a complete, columnar Sales Register in Excel, including item and GST details.”

2. Reduced customer-support burden

TurboData can provide technical support for:

  • Installation
  • Extraction setup
  • Large-data handling
  • Output validation
  • Excel format changes
  • Troubleshooting
  • Customer-specific reporting requirements

The Tally partner can continue to manage the customer relationship without becoming responsible for every extraction issue.

3. A path to higher-value modules

Once the customer starts using the Sales Register output, the partner can introduce:

  • Purchase Register
  • Cash Register
  • GSTR-1
  • GSTR-2 / GSTR-2B reconciliation
  • TDS reports
  • Power BI dashboards
  • SQL Server data warehouse
  • Audit-log analysis
  • Multi-company consolidation
  • Scheduled extraction

The Sales Register becomes an entry product that can later lead to larger implementations.

Other available TurboData outputs

The same extraction and automation approach has also been developed for:

  • Purchase Register
  • Cash Register
  • GSTR-1
  • GSTR-2 and GSTR-2B reconciliation
  • TDS reporting
  • Voucher and ledger analysis
  • Inventory movement
  • Multi-company Power BI reporting
  • SQL Server-based reporting and audit analytics

The objective is to convert Tally data into structured, reusable and analysis-ready information without requiring the customer to perform repeated manual exports.

Who should use this module?

The TurboData Sales Register Extract is suitable for:

  • Tally partners
  • Tally Institutes of Learning
  • Tally implementation firms
  • Accountants
  • GST consultants
  • Finance departments
  • Internal audit teams
  • Companies using multiple Tally entities
  • Businesses with large sales volumes
  • Customers moving from Excel reporting to Power BI
  • IT teams integrating Tally with SQL Server or another ERP

Conclusion

A customer asking for a Sales Register export is not asking only for an Excel file.

The customer is asking for:

  • Complete data
  • Correct totals
  • Item-level movement
  • GST information
  • Large-period handling
  • Repeatable extraction
  • Multi-company support
  • A report that does not require Tally expertise every time

TurboData helps the Tally partner fulfil this requirement without taking on a permanent manual-support burden.

The partner can offer the module as an immediate service, while TurboData handles the technical extraction, automation and output support.


Call to Action

Request a Sales Register Demo

Do your customers need a complete Sales Register in Excel with voucher details, item movement, GSTIN, HSN, quantity, rate, Credit Notes and Debit Notes?

TurboData extracts large volumes of Tally data in controlled chunks, reducing the risk of Tally becoming unresponsive. The module supports multiple companies, long date ranges and comparison across different Tally extraction methods.

Tally partners can manage the customer relationship while our team provides installation, testing and technical support.

Contact for a demonstration

Apoorv Chaturvedi
TurboData / MN Data Solutions
Phone: +91 88024 66356
Email: support@turbodatatool.com
YouTube: @mndatasolutions2042

Product page:
https://www.turbodatatool.com/sales-register-module

Featured Posts

What a Failed Sales Job in 2001 Taught Me About Building Business Software

  What a Failed Sales Job in 2001 Taught Me About Building Business Software I build TurboData, a reporting and analytics layer for busine...

Our Most Popular Post