Monthly prepaid and accrual schedules
Annual insurance paid in April. Every month the same spreadsheet asks how much to expense.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Get cost schedule inputs
Use ref, type, total amount, number of months and months already recognised before this month. Confirm amount and treatment with accountant.
Confirm recognition basis
Sample uses straight-line monthly recognition with no partial months. Ask accountant if actual terms differ.
Privacy Use approved cost refs and totals; remove personal policyholder details and bank identifiers. Delete bank account numbers; replace customer UPI IDs and phone numbers.
I'm attaching approved schedules for [Closing month]. Basis: [Approved basis]. A. Per row validate positive total and months, whole prior months between zero and term. If valid, monthly amount = total/months, opening recognised = monthly × prior months, current recognition = monthly if prior < term else zero, closing recognised and remaining. Hold missing/invalid rows; round to paise and final month adjust to total if needed. B. Sum current recognition separately for prepaid and accrual; list completed and held rows. Don't combine accounting types into a posting. C. Draft entry working: prepaid expense recognition and approved accrual recognition separately, questions for accountant; no automatic entry. 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 approved schedules in Excel.
Excel A:E = ref, type, total, months, prior months. Basis [Approved basis]. Write formulas for F validity, G monthly amount, H opening recognised, I current amount with final-month rounding adjustment, J closing recognised, K remaining; blanks if invalid. Show type-specific totals. Tell me where to paste.
Fill down, verify period and approved treatment with accountant; post only approved entries.
- P1₹10,000 monthly. ₹120,000 / 12; 4 prior months, ₹70,000 remains after current.
- A1₹5,000 monthly. ₹30,000 / 6; approved accrual working.
- P3 / A2Missing / invalid. P3 term missing; A2 prior months exceed term.
Then send this: Recalculate each monthly amount and recognition, reconcile closing recognised + remaining to total for valid rows, verify held exclusions.
It recognises full cost
Reply: "Use equal monthly allocation only."
It fills missing term
Reply: "Hold missing term."
It merges accrual and prepaid
Reply: "Separate types and entry working."
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.