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 parties (e.g., petrol companies or telecom providers), 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: [Enter Bank Name Here] Rules: 1. RECEIPT VOUCHER (Bank Statement me CREDIT transactions): - Line 1: Sundry Debtors | IsDeemedPositive: No | Amount: positive - Line 2: [Bank Name] | IsDeemedPositive: Yes | Amount: negative 2. PAYMENT VOUCHER (Bank Statement me DEBIT transactions): - Line 1: [Party/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 - Use actual party/creditor name from narration wherever possible - Ensure ledger names exactly match the names already created in Tally - Output only valid Tally XML inside structure - No explanations

Prompt Output

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

LLM Name: Claude