Stock and debtors statement for the bank
The bank wants it by the 10th. It's the 14th.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Get the bank's statement format
Use approved stock category and debtor ageing totals from your books, with bank-requested fields. Do not upload account details.
Confirm exclusions locally
Ask bank/accountant for the approved exclusions; don't infer drawing-power rules.
Privacy Use aggregate category balances; remove account numbers, customer contacts and individual details. Delete bank account numbers; replace customer UPI IDs and phone numbers.
I'm attaching stock and debtor summary for [As on date]. Format: [Bank's required fields]. Basis: [Approved basis]. A. Per category show type, gross, approved exclusion and net. Flag missing exclusion or exclusion above gross; do not assume zero. B. Sum valid gross, exclusion and net separately for stock and debtors; show all gross source totals and held categories. Label partial if held. C. List questions for bank/accountant and checklist before submitting actual statement. No drawing power, eligibility or loan recommendation. Use only my data. GST rates, HSN and TDS rates only from my supplied figures; never guess tax treatment. This is a first pass; a person checks and posts any final entries in Tally/Busy.
Which model? Use your tool's strongest model with thinking turned on.
In your AI tool: attach the files with the + button, paste, send.
Keep actual accounting records in your own Excel workbook; ask AI for formulas using column headings only.
Excel A:D type, category, gross, approved exclusion. Basis [Approved basis]. Give formulas for net = gross less exclusion only if both numeric and exclusion between zero and gross; flag held rows, SUMIFS stock and debtor gross/exclusions/net separately, label partial totals. No drawing-power calculation. Tell me exactly where to paste formulas and how to verify totals. Use made-up examples only; do not ask for actual company data.
Run locally, reconcile totals to your source records and have accounts approve any correction or payment before acting.
- ObsoleteExclusion missing. ₹50,000 stock gross; hold net calculation.
- Over 90Exclusion too high. ₹40,000 gross vs ₹50,000 exclusion; verify.
- Raw stock₹2 L net. ₹2.2 L less ₹20,000 approved exclusion.
Then send this: Re-add gross, exclusions and net by type; reconcile valid gross minus exclusion to net and list held rows.
It invents margin
Reply: "No drawing-power calculation."
It treats missing exclusion zero
Reply: "Hold incomplete row."
It combines stock and debtors
Reply: "Separate type totals."
Sir ne bola urgent. Ab bolo: ho gaya.
Did it work?
Doing this every week? Save it once.
Save the prompt in your AI tool, so next time you only drop the files in. Pick your tool at the top to see how.
What is that?
A Project is a folder in ChatGPT that keeps your instructions and files for every chat inside it. It's on the free plan too. Checked 14 Nov 2026.
What is that?
A Project in Claude is a workspace with its own instructions and files that every chat inside it uses. Checked 14 Nov 2026.
What is that?
A Gem is a custom Gemini that loads your instructions before every chat. Free on every plan; you create it on a computer. Checked 14 Nov 2026.
What is that?
Signed in with a work account, Microsoft's Copilot Chat applies enterprise data protection: your prompts aren't used to train its models. Checked 14 Nov 2026.
If your whole team does this, we'll set it up for all of them in one session.