AI and MCP

Prompts for a small shop owner's daily cash book

Prompts that turn a rough daily list of sales, purchases and expenses into a tidy cash book table, with a day-end check that the cash adds up.

Editorial illustration for Prompts for a small shop owner's daily cash book

To keep a daily cash book for a small shop with an AI assistant, type or dictate the day's rough list, ask for a table of cash in and cash out, then ask for a closing-cash check against the cash you actually count. The assistant does the tidying and the arithmetic; you stay responsible for counting the drawer. The prompts below use a hypothetical general store.

Write the day as you would on paper

Plain words are fine. Say: "Opening cash 4,200. Sales: cash 7,400, UPI 3,150. Bought milk from supplier 1,800 cash. Bought biscuits from distributor 2,400 by UPI. Tea 60, auto 150, labour 300, all cash. Put 5,000 cash in the bank."

Prompt 1: make the table

Prompt: "I run a small general store. Turn today's notes into a table with these columns: Item, Type (Sale, Purchase, Expense or Bank deposit), Mode (Cash or UPI), and Amount in rupees. Do not change any number. If something is unclear, ask me before you add it."

Keep the same table layout every day. Paste yesterday's closing cash as today's opening cash, so the chain of days stays connected and an error does not hide for a week.

The sentence about not changing numbers matters most: a handwritten-style list invites the assistant to tidy figures that were correct.

If you dictate by voice, read the table back against your notes before you trust it. Numbers like 1,800 and 18,000 sound alike, and a table that looks neat can hide a slipped zero.

How do I check that the day closes?

Prompt: "Using the table, calculate expected closing cash as opening cash plus cash sales, minus cash purchases, minus cash expenses, minus cash deposited in the bank. UPI entries do not change the cash drawer. Show every step."

StepAmount (₹)
Opening cash4,200
Add cash sales7,400
Less cash purchases (milk)1,800
Less cash expenses (tea 60, auto 150, labour 300)510
Less cash put in bank5,000
Expected closing cash4,290

That is 4,200 + 7,400 = 11,600, less 1,800 = 9,800, less 510 = 9,290, less 5,000 = 4,290. Now count the drawer. Say it holds ₹4,250. The difference is ₹40 short.

Credit sales deserve their own small list: customer name or code, date, amount given on credit and amount received later. Add a line to the prompt: "Keep credit sales out of cash sales and list who still owes me after today." The cash book then shows two separate truths, what is in the drawer and what is owed to you. Mixing them is how a good sales day ends with a short drawer.

What should I record separately?

  • Credit given to a customer, because it is a sale that has not turned into cash yet.
  • Money taken out for the household, so it does not pass as a shop expense.
  • UPI receipts, which reach the bank, not the drawer.

Can I run this weekly too?

Yes. Paste seven daily tables and ask: "Total sales, purchases and expenses for the week, and list each day's difference between expected and counted cash." A pattern of small shortfalls on the same day is worth noticing.

At month end, paste the four weekly summaries and ask for the total of each expense type, so you can see whether tea, transport or labour is creeping up.

What this is not

A cash book is a record, not a filing. This does not replace your accountant, stock register or tax work, and the assistant should not be asked about tax rules. SpendixAI is built for personal expenses from statements and hand-entered entries, not for shop sales or stock, so keep the shop's cash book separate.

SPENDIXAI JOURNAL

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

Explore your reports