Personal & Company Accounting · Tally ↔ Claude

Step 1 · Bring in data

Bring in your data

Three ways in — a Tally / ledger file, a bank statement, or a photo of a receipt. Everything is read on your device and lands in the same ledger below. Password-protected PDFs are supported; the password never leaves your browser.

📄

Tally / Ledger file

Day Book or ledger export · .csv .xlsx .xls .html .pdf .txt

Columns like Date · Particulars · Debit · Credit

🏦

Bank statement

Any bank · .pdf .csv .xlsx .xls .html .txt

🔑 Password-protected PDF? We'll ask on screen.

📸

Scan a receipt

Photo · .jpg .png .webp .heic

OCR reads date · amount · category · vendor

Or add an entry by hand

Manual voucher

Date Voucher type Category / income source Amount (AED) VAT (AED · auto 5%) Debit ledger Credit ledger Reference Narration

Bank rows become double-entry vouchers using the ledgers you set in Export (bank ledger + a default counter ledger). You can edit any of it before export.

Step 2 · Overview

Debit & Credit dashboard

QuickBooks-style. Totals roll up by year → month → date → transaction. Click any row to drill in.

📊

No data yet. Import a file or add an entry in Step 1.

Financial position

Net Worth statement

Income by source and expenses by category come straight from your ledger. Add what you own and owe below to complete a real net-worth statement — saved only in this browser.

🟢 Assets — what you own

Name Type Value (AED)

🔴 Liabilities — what you owe

Name Type Value (AED)

Step 3 · Ledger

All entries

Every parsed and manual line. Pick a year, type or month — the summary and the list below update to match. Then export from Step 4.

Step 4 · Output

Export to Tally

Every input row (uploaded, scanned or manual) comes back out in Tally's own Day Book export format. Set the ledgers used to build bank vouchers, then download.

Ledger mapping for bank rows

Bank ledger Default expense (money out) Default income (money in) Company name

Tally Day Book · export format preview

Date,Voucher Type,Voucher No.,Ledger Name,Debit,Credit,Narration
01-Jun-2025,Payment,1,Utilities,850.00,,DEWA electricity
,,,ADCB Current A/c,,850.00,
03-Jun-2025,Receipt,2,ADCB Current A/c,15000.00,,Client fee
,,,Professional Fees,,15000.00,

Tally Day Book CSV is the native double-entry format TallyPrime itself exports and re-imports — two lines per voucher (Date · Voucher Type · Voucher No. · Ledger Name · Debit · Credit · Narration), dates as DD-MMM-YYYY, VAT as its own Input VAT line. The Simple CSV is a one-line-per-voucher sheet that also feeds the Python main.py pipeline.

Step 5 · Live TallyPrime

Push straight into Tally — with buttons

Two ways to run it: manually (download the CSV/XML above and import in Tally), or directly from this page into TallyPrime running on your PC (Port 9000).

One-click

Push from this page

TallyPrime must be running with the gateway on Port 9000 (F1 → Settings → Connectivity → “Both”). For the direct button, run the tiny local bridge once.

Idle.

Setup once

Enable Tally gateway

Open Connectivity

TallyPrime → F1 → Settings → Connectivity (or F12 → Advanced).

Act as “Both”, Port 9000

Enable “Allow Server to use ODBC”. Accept & restart Tally.

Test

Open http://localhost:9000 — you should see a Tally response.

The Python program (runs locally, ~$10/mo)

Same pipeline as the buttons above, scriptable for batches. Extract → Claude classify → build XML → push. Files:

README.md config.py main.py requirements.txt api_server.py extract/tally_reader.py ai/claude_processor.py ai/prompts.py builder/xml_generator.py builder/validator.py push/tally_importer.py

# 1 · install
pip install -r requirements.txt
# 2 · set your key
export ANTHROPIC_API_KEY="sk-ant-…"
# 3 · run the bridge so this page's buttons work
python api_server.py
# …or run a whole CSV batch straight into Tally
python main.py entries.csv