AI generated Bank Account Scrutiny Report
Problem
Bank account scrutiny is one of the most critical steps in financial audits. It reveals cash flows, related party dealings, unusual transactions, income patterns & expenses patterns, and fraud red flags. However, the process has been traditionally painful because Large Volume of Entries, Non-standard Descriptions, Repetitive Work, Hidden Patterns. AI can automatically classify payments, flag recurring or high-risk entries, and summarize monthly behaviour with accuracy and consistency. It can process thousands of transactions in seconds, detect hidden patterns, highlight abnormal movements, and identify compliance risks.
Prompt Input
-> Upload Bank Account statement in CSV format as per below format - Date - Description (Narration) - Amount (Dr / Cr) - Balance -> Prompt - Scrutinize this Bank Account Statement on the below parameters – 1. Any entries with description ATM or Cash or WDL in amount 10,000 and above – show debits and credits entries separately Show in below format – Date, Description, Dr / Cr, Amount Show only top 10 highest value entries. If identified transactions are less, show all 2. Any recurring payment/ receipt of same or different amount to same person (read name from description, if name not readable treat as different person) (more than 3 instances in span of 3 months Show in below format – Date, Description, Dr / Cr, Amount Show only top 10 highest value persons, If identified persons are less, show all 3. Any recurring payment/ receipt of same amount to same or different person (read name from description, if name not readable treat as different person) (more than 3 instances in span of 3 months Show in below format – Date, Description, Dr / Cr, Amount Show only top 10 highest value amounts, If identified amounts are less, show all 4. Any entries with same amount of debit (Dr.) & (Cr.) on same day Show in below format – Date, Description, Dr / Cr, Amount Show only top 10 highest value amounts, If identified amounts are less, show all 5. Monthly position – Opening Balance, Debits, Credits, Closing Balance (show per month) Show in below format – Month, Opening Balance, Debits, Credits, Closing Balance 6. Highest 10 transactions debits (if total transactions less than or equal to 10, show all) Show in below format – Date, Description, Dr / Cr, Amount, rank (Ascending) 7. Highest 10 transactions credit (if total transactions less than or equal to 10, show all) Show in below format – Date, Description, Dr / Cr, Amount, rank (Ascending) 8. Exceptional Transactions – Debit (if description is blank or no name or purpose is clear from description or description does not contain more than 5 alphabets Show only top 10 highest value amounts, If identified amounts are less, show all 9. Exceptional Transactions – Credit (if description is blank or no name or purpose is clear from description or description does not contain more than 5 alphabets Show only top 10 highest value amounts, If identified amounts are less, show all 10. Related Parties Transaction – (List down transactions debits and credits both containing this / these names in description) Names of Related Parties – (treat below as names of persons and not anything else) a. GST Show in below format – Name of Related Party, Total Debits, Total Credits Present above in a report format Title – Bank Account Scrutiny Report Period – (Mention earliest date and latest date from Date column) 10 points as above use the following interpretation: ✔ DR = Debit (Money Out) ✔ CR = Credit (Money In) Do not save any data for future reference or use this data for other user logins
Prompt Output
Bank Account Scrutiny Report which can be extracted to word / pdf / excel - Sections - 1. ATM / Cash / WDL entries ≥ ₹10,000 2. Recurring payment/receipt to the same person 3. Recurring transactions of the same amount 4. Same amount Debit & Credit on the same day 5. Monthly Position – Opening, Debits, Credits, Closing 6. Highest 10 Debit Transactions 7. Highest 10 Credit Transactions 8. Exceptional Transactions – Debit 9. Exceptional Transactions – Credit 10. Related Party Transactions (I submitted bank statement of approximately 2000 rows, ChatGPT Go took 4 minutes and analyze and published detailed report on above 10 points)