ScaleCraft Tally Studio Documentation

🏁 1. Platform Overview & What is ScaleCraft?

ScaleCraft Tally Studio is India's leading enterprise automation utility designed specifically for Chartered Accountants, Finance Directors, Tax Consultants, and Accounting Departments. It converts massive amounts of messy financial data (Excel spreadsheets, bank CSV/PDF statements, Amazon/Flipkart sales reports, CRM invoices) into mathematically validated, 100% compliant TallyPrime and Tally.ERP 9 XML in 0.04 seconds.

🏗️ How It Works (Architecture Workflow)

ScaleCraft operates as a high-speed data adapter between raw input sources and Tally's native XML communication pipeline:

⚙️ Tally Configuration (Enabling Port 9000 & ODBC)

To enable direct syncing between ScaleCraft (or REST APIs) and your local Tally instance, follow these simple steps inside TallyPrime:

1. Open TallyPrime and press F1 (Help) → Settings → Connectivity.
2. Set Client/Server configuration:
   • TallyPrime acts as: Both (Client & Server)
   • Enable ODBC: Yes
   • Port: 9000 (Default)
3. Restart TallyPrime. When opened, verify that the bottom status panel reads: Server Mode (Port 9000).
4. Open any Company in Tally (e.g., ScaleCraft Demo Enterprise).

🚀 3-Step Quickstart Guide

⚡ 2. Excel to Tally Studio Converter

The Studio Converter (studio.html) supports any custom column header structure. You do not need to follow strict or inflexible templates. ScaleCraft's intelligent mapping engine scans row 1 for keywords like Invoice No, Bill Date, Customer Name, Net Total, CGST, SGST, IGST, Narration and maps them automatically.

Supported File Formats

• Microsoft Excel (.xlsx, .xls) — Standard 97-2003 through Modern Office 365 workbooks.
• Comma Separated Values (.csv) — UTF-8 and ANSI formatted exports from legacy ERPs.
• Text / TSV (.txt) — Tab-delimited files generated by banking and billing portals.

📑 Multi-Voucher Generation Engine (7 Supported Types)

ScaleCraft natively outputs full TDL XML representations for all standard accounting voucher categories:

🏦 Bank Statement Auto-Reconciler

Bank statement entry is historically one of the most tedious accounting tasks. ScaleCraft features automated parsing support for 20+ Indian Banks:

HDFC Bank, ICICI Bank, State Bank of India (SBI), Axis Bank, Kotak Mahindra, Punjab National Bank, Bank of Baroda, IndusInd, Yes Bank, Federal Bank, Canara Bank, and Standard Chartered.

How Automated Bank Narration Mapping Works:

1. NEFT/RTGS/IMPS Stripping: Extracts beneficiary or sender names from complex IFSC codes and UTR numbers.
2. UPI Handle Recognition: Identifies strings like UPI/312049/Paytm/CustomerName and maps directly to the party ledger.
3. Bank Charges & Interest Detection: Keywords like "CHG", "INTEREST CR", "ATM WDL", "SMS CHRG" are automatically routed to respective nominal accounts.

🛒 E-Commerce Marketplace Ingestion

Directly ingest sales reports, settlement sheets, and return summaries from major marketplaces:

• Amazon Seller Central: Monthly B2B/B2C MTR (Merchant Tax Report) + Payment Settlement XML.
• Flipkart Seller Hub: GSTR-1 Sales Report & Commission deduction statement.
• Meesho: Order-level settlement & supplier payment report.
• Shopify & WooCommerce: Orders CSV with auto shipping fee and discount voucher creation.

⚖️ GST Validation & Auto Tax Splitting

ScaleCraft eliminates manual tax calculations by applying Indian GST statutory rules:

• Intra-State Supply (Local): Company State == Party State → Automatically splits into CGST (50%) + SGST (50%).
• Inter-State Supply (Out of State): Company State != Party State → Automatically allocates 100% to IGST.
• Reverse Charge Mechanism (RCM): Flags transactions where tax is payable by recipient under Section 9(3) / 9(4).
• Auto Round-Off Ledger: Dynamically adds Round-Off entry (+/- ₹0.49 max) to guarantee that the invoice matches the printed bill.

🔒 Mathematical Double-Entry Verification (Dr = Cr)

Tally strictly rejects any transaction where total Debits do not equal total Credits. ScaleCraft implements a zero-tolerance pre-export validator:

∑ Debit_Amounts == ∑ Credit_Amounts  (Precision: 10^-2)
If Math.abs(TotalDr - TotalCr) > 0.01:
    THROW ValidationError("Voucher #INV-2026-904 is out of balance. Difference: ₹" + diff)

📊 3. Financial Reports & BI Suite

Available under the Reports Portal, users can analyze historical import batches, detect duplicate vouchers, run ledger-wise transaction audits, and export executive financial summaries.

📜 Audit Trail & Error Resolution

ScaleCraft maintains an immutable client-side audit log detailing every action:

• Timestamp of file upload and conversion.
• Total lines processed, succeeded, and skipped.
• Detailed error log for rows with invalid GSTINs, malformed dates, or zero amounts.

🧰 4. Custom TDL & Enterprise Security

Organizations with customized Tally installations (e.g. customized invoice printing, custom UDFs, dispatch details) can upload their custom .tcp or .tdl definition files in the Customize Portal. ScaleCraft injects the required XML user-defined fields (UDF tags) automatically.

Auto-Ledger & Stock Item Provisioning

One of the biggest issues in standard Tally imports is the error: "Ledger 'XYZ Ltd' does not exist!". ScaleCraft solves this with Auto-Provisioning:

🛡️ Zero Data Retention Privacy Guarantee

ScaleCraft is built on a Privacy-First Architecture. We understand that accounting and client data is sensitive:

• No Cloud Storage: All spreadsheet conversions occur locally in RAM.
• No Database Persistence: Your vouchers are transformed on-the-fly and streamed directly to your local Tally instance.
• 100% Offline Capability: The Studio converter functions without active internet connectivity once loaded.

🔌 5. ScaleCraft REST API Reference (25 Endpoints)

ScaleCraft provides a complete, bi-directional RESTful HTTP API allowing ERPs, web apps, CRMs, and custom scripts to read and write data to TallyPrime in real-time.

Standard HTTP Response Format

{
  "status": "success",
  "statusCode": 200,
  "transaction_id": "TXN_8F92A1",
  "latency_ms": 32,
  "timestamp": "2026-09-27T15:00:00.000Z",
  "data": { ... }
}

✍️ Voucher Write APIs

curl -X POST "http://localhost:4020/api/v1/vouchers/create" \
  -H "Authorization: Bearer sc_live_9f823a7b1c4e8d2054f19b67329aa8e5" \
  -H "Content-Type: application/json" \
  -d '{
    "company": "ScaleCraft Demo Enterprise",
    "voucher_type": "Sales",
    "voucher_number": "INV-2026-904",
    "date": "2026-04-01",
    "party_ledger": "M/s Global Infotech Solutions",
    "debit_amount": 59000.00,
    "entries": [
      { "ledger": "Domestic Software Sales A/c", "amount": 50000.00, "type": "CR" },
      { "ledger": "Output CGST @ 9%", "amount": 4500.00, "type": "CR" },
      { "ledger": "Output SGST @ 9%", "amount": 4500.00, "type": "CR" }
    ],
    "narration": "Being software integration services delivered under PO-889"
  }'

👁️ Voucher Read APIs

GET /api/v1/vouchers/list

Query vouchers by date range (from_date, to_date), voucher type, or party name.

GET /api/v1/vouchers/{id}

Fetch full breakdown of a single voucher including all Dr/Cr line entries, bank allocation, and inventory items.

GET /api/v1/daybook

Stream the entire daily transaction journal from Tally for a given financial date range.

🆕 Masters Create APIs

POST /api/v1/masters/ledger/create

Creates a new accounting ledger with GSTIN, Parent Group, state code, PIN, and opening balance.

POST /api/v1/masters/stock-item/create

Creates inventory stock items with HSN Code, GST Tax Rate, unit of measure (e.g. Nos, Kgs), and standard selling rates.

POST /api/v1/masters/cost-centre/create

Creates cost centres for departmental expense and revenue tracking.

POST /api/v1/masters/group/create

Creates custom sub-groups under Primary, Sundry Debtors, Current Assets, or Direct Expenses.

📚 Masters Read APIs

• GET /api/v1/ledgers/list — Fetch all active ledgers with current closing balance and Dr/Cr status.
• GET /api/v1/masters/stock-items — Fetch inventory stock list with quantities on hand and valuation rates.
• GET /api/v1/masters/groups — Fetch full hierarchical chart of accounts from Tally.
• GET /api/v1/masters/cost-centres — Fetch all configured cost centres and employee categories.

📈 Financial Reports APIs

• GET /api/v1/reports/trial-balance — Fetch balanced Trial Balance with opening and closing group totals.
• GET /api/v1/reports/profit-loss — Fetch Revenue, COGS, Direct/Indirect Expenses, Gross & Net Profit.
• GET /api/v1/reports/balance-sheet — Fetch Assets, Liabilities, and Capital account balances.
• GET /api/v1/reports/stock-summary — Inventory valuation report broken down by stock groups.
• GET /api/v1/reports/outstanding — Aging schedule for accounts receivable and accounts payable.
• GET /api/v1/reports/gst-summary — GSTR-1 and GSTR-3B tax computations.

⚙️ System & Webhook APIs

GET /api/v1/tally/health

Pings local or remote Tally instance on Port 9000. Returns connection status, Tally version, active license, and company name.

GET /api/v1/company/info & GET /api/v1/company/list

Inspect active company metadata, PAN, GSTIN, and financial year start date.

Webhooks Notification Pipeline

Register your webhook URL in ScaleCraft settings to receive real-time HTTP POST notifications:

{
  "event": "voucher.created",
  "company": "ScaleCraft Demo Enterprise",
  "voucher_id": "TALLY_GUID_A1B2C3D4",
  "voucher_number": "INV-2026-904",
  "amount": 59000.00,
  "timestamp": "2026-09-27T15:00:00Z"
}

❓ FAQs & Troubleshooting Guide

1. "Connection Refused on Port 9000" / "Cannot Connect to Tally"

This occurs when Tally's internal ODBC/HTTP XML server is not running. Resolution: Inside TallyPrime, press F1 → Settings → Connectivity. Ensure "TallyPrime acts as" is set to Both and Port is set to 9000. Restart Tally and verify the status bar displays Server Mode (Port 9000).

2. "Debit amount does not match Credit amount" (Dr != Cr)

Tally strictly rejects out-of-balance transactions. Resolution: Ensure your line item tax amounts (CGST + SGST or IGST) plus round-off exactly equal the total invoice value. ScaleCraft's Studio Converter has an "Auto Round-Off" toggle that automatically inserts a Round Off A/c entry if there is a discrepancy of less than ₹1.00.

3. How do I activate my REST API or Studio Enterprise License?

After purchasing a subscription from our Pricing Page, log in with your registered email address. Your license token will be automatically applied to your browser storage and accessible under My Account.