Bank statements from photos or PDF to excel
Problem
Converting bank statements received in PDF format into a clean and structured Excel file. The prompt extracts all transactions, arranges them in tabular format, identifies debit and credit amounts, and prepares the data for accounting, reconciliation, audit, or GST work. This eliminates manual data entry and saves significant time.
Prompt Input
bank statement in pdf and the following prompt "You are an expert forensic accountant and data analyst. Review the uploaded bank statement PDFs and extract the data : Generate a comprehensive financial report for this account based strictly on the rules below. Do not miss, consolidate, or set off any entries. Every single transaction must be listed individually in a chronological markdown table. Use the following exact column headers: | Date | Debit | Credit | Ledger Name | Calculated Running Balance | Running Balance as per Statement | Particulars exactly as per bank statement To determine the "Ledger Name", strictly apply the following hierarchical rules: 1. Party Names: If a specific person's or company's name is mentioned in the Particulars, extract it and use that party's name as the Ledger Name. 2. Bank Fees: For SMS charges, processing fees, GST on charges, or similar fees, set the Ledger Name to "Bank Charges". 3. Interest: For any interest debited or credited, set the Ledger Name to "Interest". 4. Keywords: For other standard transactions, use obvious transaction keywords from the particulars to determine a logical ledger name. 5. Unidentified/Fallback: If no specific keyword, party, or internal account can be identified, mark the Ledger Name as "Suspense". Important Execution Rules: - Process every single transaction chronologically for this account. - Do NOT skip any entries. Do NOT consolidate multiple entries on the same day into one row. - Mathematically calculate the 'Calculated Running Balance' step-by-step and ensure it matches the 'Running Balance as per Statement'. If there is a discrepancy, note it. "
Prompt Output
A structured transaction register in Markdown/Excel format containing Date, Debit, Credit, Ledger Name, Calculated Running Balance, Statement Balance, and Original Particulars. The output is complete, chronologically arranged, and ready for accounting, bank reconciliation, audit, GST, income tax, forensic review, and further financial analysis. Any mismatch in running balance is highlighted separately.