PROMPT BRO
Accounts desk

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

By hand3–5 hrs
With AI45 min
Per month · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

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.

First time? Try it on fake data first:

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.

Fill the orange boxes
You send (the "prompt": the message you paste into your AI tool)
bank-stock-debtors.xlsx

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.

What you'll get back (example, from the practice files)
₹3 Lstock net
₹1.5 Ldebtor net
2held categories
  • 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.
Before you trust it

Then send this: Re-add gross, exclusions and net by type; reconcile valid gross minus exclusion to net and list held rows.

If it goes wrong
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?