Skip to main content
How-To · 4 min read

Busy Accounting Software Reconciliation in India: DBF Data, Multi-Company, and Import-Export Patterns

Busy Accounting Software runs on a DBF data layer and ships with strong India-specific modules — GSTR-2A/2B import, TDS tracking, multi-company consolidation. Reconciliation at scale, across multi-branch operations and across external tax portals, often needs a layer on top. This guide covers the integration patterns.

Terra Insight
Terra Insight Reconciliation Infrastructure

Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →

Published 17 April 2026
Domain expertise
TDS Reconciliation GST Input Credit Platform Settlements NACH Batch Matching Bank Reconciliation Form 26AS Matching ERP Integrations Enterprise Finance Ops
Knowledge Card
Problem

Busy Accounting Software (dominant among Indian trading, wholesale, and CA-firm segments) runs on DBF tables or proprietary indexed binary (Busy 21+) with no sanctioned real-time API — so CA firms managing 20+ client companies on Busy cannot reconcile bank, TDS, and GSTR-2B across entities without an overnight ASCII/XML batch job.

How It's Resolved

Run scheduled ASCII or XML exports from each Busy company directory at end of day, drop files over SFTP to a central location, ingest into an external reconciliation layer that handles multi-company bank, TDS, and GSTR-2B matching, resolve exceptions outside Busy, and post cleared status back via ASCII import. GSTR-2B JSON from the GST portal is consumed externally and matched against the Busy purchase voucher extract.

Configuration

Busy company directory registry, ASCII and XML export templates aligned to Busy schemas (MASTERS.DBF, VOUCHERS.DBF, GSTINFO.DBF), SFTP job scheduler at EOD, CA-firm client mapping for multi-company consolidation, and ASCII import writeback for cleared voucher status.

Output

A CA-firm or multi-branch trading house running 20+ Busy companies reconciled overnight across bank, TDS, and GSTR-2B streams — GSTIN typo and timing-mismatch exceptions handled externally, cleared status pushed back to each Busy company, and consolidated audit trail available at partner review.

Busy Accounting Software is the second most common ERP among Indian SMEs after Tally, particularly strong in the trading, wholesale, and CA-firm segments. Its GST module is one of the most comprehensive in the price band, and its multi-company support makes it a fit for CA firms managing multiple client entities. Reconciliation on top of Busy, particularly at CA-firm scale or multi-branch scale, requires working within the constraints of its DBF data layer and its ASCII/XML export paths.

What Busy Handles Natively

For the single-company SME use case, Busy delivers:

  • GSTR-2A and GSTR-2B reconciliation (Busy Professional / Enterprise, from Busy 18 onwards)
  • TDS deduction with section-wise tracking, challan entry, and Form 26Q generation
  • Bank reconciliation screen with Excel/ASCII import
  • Multi-company support with per-company data directories
  • Audit trail features compliant with CARO 2020 from April 2023

For the CA firm managing 10–30 client books, Busy’s multi-company handling is one of its differentiators.

The DBF Data Layer and What It Means for Integration

Busy’s data layer was originally DBF — the same dBASE-derived format used by a generation of Indian accounting software. From Busy 21, the data format moved to a proprietary indexed binary. Either way, direct third-party reads are not supported by Busy Infotech. The sanctioned integration path is the ASCII/XML import-export interface built into the Busy UI.

This has practical implications:

  • Real-time sync is not a standard option. Integration runs on scheduled extracts.
  • Every export is a file drop; ingestion happens from a file, not a message queue.
  • Data contracts between Busy and the external layer are the ASCII format definitions published in the Busy Help.

Import/Export Reference

FormatUse caseDirectionVolume comfort
ASCII (delimited)Voucher, ledger bulkBothUp to 50,000 rows
ASCII (fixed-width)Master dataBothUp to 10,000 rows
XMLGST return dataBothAs per return size
ExcelSmall master creationImport onlyUnder 500 rows
PDF/printReport distributionExport onlyUnlimited

Multi-Company Reconciliation Pattern

For a CA firm running Busy across 25 client companies, the typical reconciliation flow is:

  1. End-of-day ASCII/XML export from each client’s Busy data directory, scheduled via Windows Task Scheduler.
  2. SFTP or shared-drive drop to a central location.
  3. External layer reads all client extracts, applies bank + GSTR-2B + TDS matching.
  4. Exceptions routed to the CA firm’s review queue, classified by variance type.
  5. Cleared status returned to each client’s Busy instance via ASCII import at start of next day.

The alternative — doing reconciliation within each Busy instance separately — works for one or two companies but does not scale to 20+.

For Indian CA firms and mid-market businesses on Busy, a reconciliation software India layer that consumes the ASCII/XML exports and handles cross-client reconciliation is the standard architecture. GSTR-2B handling at portfolio scale is covered by dedicated GST reconciliation software that reads the Busy purchase export and GSTR-2B JSON together.

India-Specific Considerations

Busy’s GST module enforces GSTIN validation at voucher entry but does not validate challan-level TDS acknowledgement against TRACES — a pattern shared with Tally and the other SME ERPs covered in reconciliation in SAP, Oracle and Tally India. The GSTR-2B reconciliation guide details the matching logic that sits on top of any Indian ERP export. Busy’s full ASCII format documentation and DBF schema are published via the Busy Infotech Support Portal.

The FAQ below covers the most common Busy automation questions from Indian users.

Primary reference: Busy Infotech Support Portal — where Busy publishes the DBF schema, ASCII import formats, and GST module documentation.

Frequently Asked Questions

What data layer does Busy Accounting Software use, and how does that affect reconciliation?
Busy uses a DBF (dBASE) file-based data layer up to Busy 21, and a proprietary indexed binary format from Busy 21 onwards. Each company is a separate folder with DBF tables like MASTERS.DBF, VOUCHERS.DBF, and GSTINFO.DBF. Direct DBF read via ODBC or third-party DBF readers is technically possible but not supported by Busy Infotech. The sanctioned export path is ASCII/XML export from within the Busy UI — limiting real-time reconciliation to scheduled extracts rather than continuous sync.
Does Busy Accounting Software have native GSTR-2A/2B reconciliation?
Yes. Busy Professional Edition and Enterprise Edition include a GST Reconciliation module that imports GSTR-2A and GSTR-2B JSON from the GST portal and matches against the purchase register on GSTIN + invoice number + invoice date + taxable value. The module was introduced in Busy 18 and refined in Busy 21 with support for debit note and credit note matching. At volumes below 300 invoices/month, it is adequate; above that, GSTIN typo and timing-mismatch exceptions become burdensome without external handling.
How does Busy handle multi-company or multi-branch consolidation for reconciliation?
Busy supports multi-company operation where each company is a separate data directory. The consolidation module in Busy Enterprise allows grouping of companies for consolidated balance sheet and P&L. For reconciliation specifically, the standard pattern is ASCII or XML export from each branch/company on a scheduled basis (daily or weekly), followed by consolidation in an external layer. Busy has no built-in cross-company bank or GST reconciliation — it is single-company within each data folder.
What import/export formats does Busy Accounting Software support?
Busy supports ASCII (fixed-width and delimited), XML, and Excel import/export for masters (ledger, item, party), vouchers (sale, purchase, payment, receipt), and report output. The ASCII format is documented in the Busy Help and is the most reliable for bulk import back into Busy. XML is used primarily for GST return data exchange. Excel import is convenient for small-volume master creation but not recommended for transaction volumes above 500 rows per file.
What is the typical reconciliation integration pattern for Busy Accounting Software users in India?
The standard pattern is: (1) scheduled ASCII or XML export from each Busy company directory at end of day, (2) SFTP drop to a shared location, (3) ingestion by an external reconciliation layer that handles bank, TDS, and GSTR-2B matching across all entities, (4) exception resolution outside Busy, and (5) manual or ASCII-import posting of cleared status back into Busy vouchers. High-volume CA firms managing 20+ client companies on Busy typically run this as an overnight batch.

See how TransactIG handles reconciliation for your industry

Configuration takes 2–4 weeks. No code development required. ISO 27001:2022 certified.