Accounting NEELAM DHOOT

Convert Bank Statement PDF to Tally XML Vouchers

Problem

Manually converting bank statement transactions into Tally vouchers is time-consuming and error-prone. This prompt automates the process by converting PDF bank statements into structured Tally XML vouchers with predefined rules for debit and credit transactions. It is especially useful in cases where payments are made repeatedly to specific party allowing direct use of creditor/party names instead of generic labels, while receipts can be consistently recorded under Sundry Debtors. It also acknowledges that certain transactions such as contra entries (bank or cash transfers) and bank charges may not be fully handled by standard rules and will need to be identified and corrected separately after processing. A key requirement addressed is ensuring that ledger names exactly match those already created in Tally, which is critical for successful import and accurate accounting.

Prompt Input

I have a bank statement PDF. Convert all transactions into Tally XML vouchers. Bank Ledger Name: [Bank Name] Rules: 1. RECEIPT VOUCHER (Bank Statement's CREDIT transactions): * Line 1: Sundry Debtors | IsDeemedPositive: No | Amount: +positive * Line 2: [Bank Name] | IsDeemedPositive: Yes | Amount: -negative 2. PAYMENT VOUCHER (Bank Statement's DEBIT transactions): * Line 1: Creditor Name | IsDeemedPositive: Yes | Amount: -negative * Line 2: [Bank Name] | IsDeemedPositive: No | Amount: +positive Instructions: * Date format: YYYYMMDD (e.g., 20260201) * One voucher per transaction * Output: Valid Tally XML inside structure only * No explanations

Prompt Output

Valid Tally XML vouchers inside structure with correctly classified Receipt and Payment vouchers based on transaction type

LLM Name: Claude