AI and MCP

AI prompts to prepare your expense records for a CA meeting

Prompts that turn a year of categorised spending into a one-page brief for your CA: totals, missing receipts, odd entries and questions to ask.

Editorial illustration for AI prompts to prepare your expense records for a CA meeting

To prepare expense records for a CA meeting, collect one financial year of categorised spending (April to March), then ask an AI assistant to turn it into a one-page brief: totals by category, entries without receipts, unusual items, and a list of questions. The assistant tidies and adds up; your CA decides what anything means for tax. Keep every prompt to preparation only.

What goes into the one-page brief

  • Totals by category for April to March, with the number of entries behind each total.
  • Months where a category jumped well above its usual level.
  • Every entry above a size you pick (say ₹10,000), listed one by one with date and merchant.
  • Entries with no receipt or invoice, grouped by category.
  • Spends that mix personal and work use, such as a phone bill or a laptop.
  • Anything you honestly do not know how to label.

Prompt 1: totals, with a self-check

Prompt: "Below is my spending for April to March as a table with the columns Date, Merchant, Amount in rupees and Category. Give me the total and the number of entries for each category, then the grand total. Add up your category totals a second time and tell me if they match the grand total. If a figure is not in my table, say so instead of estimating."

The last two sentences matter. Assistants sometimes round or quietly fill gaps, so you want a second addition and a refusal to guess. Compare the entry count it reports with the number of rows you pasted. If you pasted 412 rows and the counts add up to 409, three rows went missing and the totals cannot be trusted yet.

Which entries are missing receipts or look odd?

Add a column called Receipt and fill it with Yes or No from memory and your files. Then ask: "Using the same table with the Receipt column, list every entry above ₹10,000, every merchant that appears only once, and every entry whose category is Miscellaneous or blank. After that, list the entries where Receipt is No, grouped by category, with a subtotal in rupees for each group."

Cash spending is where the No entries pile up. Do not let the assistant guess a merchant for a cash entry; mark it as cash with your own one-line note instead.

Which questions should I take to my CA?

Prompt: "From the entries you flagged, write ten questions I could ask my accountant. Phrase each one as a question about how my records should be kept or labelled. Do not state what is deductible, claimable or taxable, and do not give a view on any rule."

Good output sounds like these:

  • I bought a laptop in October that I use for both client work and home. How should I label it so the records are clear?
  • Several payments went to the same person by UPI with no invoice. What proof should I keep for those?
  • Should annual payments such as insurance or software renewals sit in their own category?
  • Which of my Miscellaneous entries need a better label before the year closes?
Brief sectionWhat to pasteWhat to check by hand
Category totalsDate, merchant, amount, categoryRow count and grand total against your statement
Large entriesThe same tableEach big item against its invoice
Missing receiptsTable plus the Receipt columnThat every No is truly missing, not just unfiled
QuestionsThe flagged list onlyThat none of the questions asks for tax advice from the assistant

Before you paste anything

Replace account numbers, card numbers and family members' names with initials or labels. Merchant, date, amount and category are usually enough for this brief. Never paste OTPs, PINs or net-banking logins into any chat. If your records already sit in SpendixAI, the Report builder can group a year by category and download a CSV, which gives you a clean table to paste.

Checklist for the day before the meeting

  1. Print or save the one-page brief and the full table side by side.
  2. Gather invoices for the large entries and the receipt-less entries you can still trace.
  3. Write your own answer next to each question, even if it is "not sure".
  4. Note any category you renamed during the year so your CA is not confused by old labels.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports