This one-page template takes about 30 minutes a month: five minutes to gather your inputs, ten to run a few prompts, seven to verify the numbers, five to decide, and three to log what you decided. Copy the headings into a notes app or document and fill in the blanks each month.
The time budget
| Block | Minutes | Output |
|---|---|---|
| Gather | 5 | Rows for the month, last month's total, notes on special events |
| Run prompts | 10 | Category table, top payments, changes from last month |
| Verify | 7 | Two numbers matched against your own report |
| Decide | 5 | One to three decisions |
| Log | 3 | A short entry you can find next month |
| Total | 30 | One finished page |
Part A: inputs to gather (5 minutes)
Write these at the top of your page.
- Month: ______
- Total spending from my tracker or statements: ₹______
- Number of transactions: ______
- Last month's total: ₹______
- Special events this month (festival, travel, repair, fees): ______
- Anything I paid in cash and have not recorded: ______
Part B: prompts to run (10 minutes)
Paste your rows and run these in order. Each asks for a number you can check in Part C.
- Total spend by category as a table, with the row count beside each total.
- The five largest single payments, with date and merchant.
- Categories that moved by more than ₹1,000 against last month, shown as a table with the difference. No explanations yet.
- Merchants I paid more than three times, with counts.
- Any repeating payment I may have forgotten about, listed as rows only.
Part C: numbers to verify (7 minutes)
Do not skip this part. The aim is to find out whether the assistant's numbers hold up before you act on them.
- Assistant's grand total: ₹______ Tracker or statement total: ₹______ Match? yes / no
- One category total: ₹______ vs ₹______, row count ______ vs ______
- Largest payment confirmed on the statement? yes / no
Say the assistant gives ₹52,340 and your report gives ₹52,340. Good. If it says ₹49,840, the gap is ₹2,500, so look for one or two missing rows, such as a rent payment or a large transfer, before moving on.
Part D: what decisions come out of it? (5 minutes)
Write at most three. Each should be a specific action with a date, not a mood.
| Decision | Why (which row or total) | By when |
|---|---|---|
| ______ | ______ | ______ |
| ______ | ______ | ______ |
| ______ | ______ | ______ |
Examples of the right size: "Review the three subscription renewals due next month", "Set a ₹6,000 limit for dining and check it on the 20th", "Ask my CA about the repair bill with no GST details". Avoid vague ones like "spend less".
Part E: log (3 minutes)
- Date reviewed: ______
- Total and top three categories: ______
- What changed since last month: ______
- Open questions for next month: ______
Three lines each month is plenty. After six months you will see patterns that no single review shows.
A finished entry might read: reviewed 14 December. Total ₹52,340 over 118 transactions; top categories rent, groceries and dining. Dining up ₹1,800 on last month. Decision: cap dining at ₹5,000 and check it on the 20th. Open question: why two payments to the same pharmacy on one day.
Where does the tracker fit?
If you use SpendixAI, the dashboard, insights and the weekly summary can feed Parts A and C, and its category and period reports give you a second number to compare. The template works equally well from a spreadsheet or bank statements.
Adapting it
- Couples can review together and put both names on the decisions.
- Freelancers can add a line for money owed to them.
- Festival months can add a line for gifts and travel, planned against actual.
- If thirty minutes is too long, drop prompts four and five.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
