Get all ledgers (accounts) from TallyPrime

Get all stock items from TallyPrime

Get vouchers (Day Book) from TallyPrime filtered by date range

Get the currently open company info from TallyPrime

Get the Profit & Loss statement from TallyPrime for a date range

Get the Balance Sheet from TallyPrime as of a given date

Get the Trial Balance from TallyPrime for a date range

Get all account groups (e.g. Sundry Debtors, Fixed Assets) from TallyPrime

Get all voucher types configured in TallyPrime (e.g. Payment, Sales, Journal)

Get all cost centres from TallyPrime

Get the Stock Summary report from TallyPrime as of a given date

Get outstanding Bills Receivable from TallyPrime as of a given date

Get outstanding Bills Payable from TallyPrime as of a given date

Get all voucher entries posted to a specific ledger within a date range

Create a new ledger (account) in TallyPrime

Create a new voucher (e.g. Payment, Receipt, Sales, Purchase, Journal) in TallyPrime with two ledger entries (debit and credit)

Create a new account group in TallyPrime, nested under a parent group

Create a new stock item in TallyPrime

Update the group and/or unit of an existing stock item in TallyPrime

Delete a stock item from TallyPrime. Fails if it has transactions posted against it.

Update an existing voucher in TallyPrime, replacing its ledger entries and narration. The voucher is matched by type + date + voucher number, so that combination must be unique and must exactly match an existing voucher (use get_ledger_vouchers or get_vouchers first to confirm it).

Pull ledgers, groups, stock items, and vouchers (last 365 days) from TallyPrime into a local in-memory SQL cache, so query_sql can run fast arbitrary queries without hitting Tally each time

Run a read-only SQL SELECT query against the local cache populated by sync_to_sql. Tables: ledgers(name, parent, closing_balance), groups(name, parent), stock_items(name, parent, closing_balance), vouchers(date, voucher_type, ledger, amount, narration)