← ClaudeAtlas

brs-tallylisted

Indian/Tally.ERP bank reconciliation. Produce a formula-driven traditional two-column Bank Reconciliation Statement (BRS) in Excel from a Tally ledger export plus a bank statement. Use when the user uploads Tally / TallyPrime ledger exports and bank statements and wants them reconciled, says "reconcile my bank in Tally", "make a BRS", "bank reconciliation India", "outstanding cheques", "deposits in transit", or mentions NEFT/RTGS/IMPS/UPI reconciliation. Handles multiple accounts, OD/CC accounts, Bank Date clearing, and Indian narrations.
tanmayupadhye5-hue/brs-tally · ★ 0 · Data & Documents · score 67
Install: claude install-skill tanmayupadhye5-hue/brs-tally
# BRS-Tally — Indian Bank Reconciliation Turn a Tally ledger export and a bank statement into an auditable, formula-driven two-column BRS. Never invents a value; never plugs a difference; shows an explicit Unexplained Difference even at zero. ## Constitution (do not violate) 1. Never invent a value (date, amount, balance, cheque number). 2. Never plug a difference — the `Unexplained difference` line is explicit, shown even at 0. 3. Never choose between equal match candidates — match neither, flag both. 4. Never infer a sign convention — derive it from the running balance / stated balances. 5. Every reconciling item traces to its source row and carries an explanation. 6. Limitations are disclosed in the workbook, not just in chat. ## Run ``` python scripts/run_tally.py <folder-with-the-files> ``` To build the workbook: ```python import sys; sys.path.insert(0, "scripts") import run_tally, build_brs_india res = run_tally.reconcile("<folder>") build_brs_india.build(res, "Reconciliation.xlsx", entity="<entity name>") ``` ## Inputs (one pair per bank account) - **Tally bank ledger export** (.xlsx/.csv): Date, Cheque No., Particulars, Debit, Credit, Running Balance; optional **Bank Date**. The ledger worksheet tab should be named to match the statement's account (e.g. "HDFC"). - **Bank statement** (.xlsx/.csv): Txn Date, Description, Cheque No., and either separate Withdrawal/Deposit columns **or** a single unsigned **Amount** plus a **Dr/Cr** indicator column (`Dr/Cr