Getting started

A weekly cash flow tracker: see the dip before payday arrives

A cash flow tracker lists money in, money out and the running balance by week; this example shows how to build one and read the low point.

Editorial illustration for A weekly cash flow tracker: see the dip before payday arrives

A cash flow tracker is a short table of money in, money out and the running balance, week by week. Unlike a budget, which asks what you planned to spend, it asks when the money actually moves, and that is why it shows a dip before payday that a monthly total hides. A sheet with three columns and one formula is enough to start.

Budget versus cash flow: what is the difference?

A budget compares categories. Cash flow follows the calendar. You can be on budget for the month and still run short on the 28th because the rent, the EMI and an insurance premium all left in the first week and the salary comes on the 1st. Seeing the balance each week tells you whether that is going to happen.

Build it in four columns

  1. Column A: the week, for example Week 1 (1 to 7).
  2. Column B: money in during that week.
  3. Column C: money out during that week.
  4. Column D: closing balance, with this formula in D2: =D1+B2-C2. Put the opening balance in D1 and copy the formula down.

A worked example for one month

The figures are made up. Say the balance on the last day of the previous month was ₹24,000 and salary of ₹65,000 arrives in week 1.

WeekMoney inMoney outClosing balance
Opening--₹24,000
Week 1₹65,000₹32,700₹56,300
Week 2₹0₹7,400₹48,900
Week 3₹4,500₹9,100₹44,300
Week 4₹0₹8,600₹35,700

Check: week 1 is 24,000 + 65,000 - 32,700 = 56,300; week 2 is 56,300 - 7,400 = 48,900; week 3 is 48,900 + 4,500 - 9,100 = 44,300; week 4 is 44,300 - 8,600 = 35,700. Money in is 69,500, money out is 57,800, and the net is 11,700, which is exactly 35,700 minus 24,000.

How do you read the low point?

Look for the lowest closing balance across the weeks. In the example, the real low is the opening ₹24,000, just before payday. If that number is close to zero, one delayed credit would put you in trouble. Put a note beside the lowest week: what was due, and what could move.

Compare two months side by side. If the low point sits in the same week every month, the cause is structural, such as a due date that always falls just before payday. That is fixable: ask whether the due date can move, or whether a small standing transfer to a separate account can cover it. If the low point wanders, the cause is spending, and the budget is the right tool.

What goes in the 'out' column for annual bills?

Put big irregular payments in the week they actually leave. An annual insurance premium of ₹18,000 in week 4 would drop the closing balance there to ₹17,700 (35,700 - 18,000). That is the benefit: you see it coming a month ahead and can move money or change the date.

Where an expense tracker helps

The 'money out' figures come straight from your statements. With SpendixAI, you can upload each month's statement, review the rows and read the totals by account, then copy weekly figures into your sheet. The forward-looking part, what you expect next week, stays with you.

A weekly habit

  • Same day each week, update money in and out from the statement.
  • Write the next four weeks of known bills ahead of time.
  • Circle the lowest week.
  • If it is below your comfort amount, move something now, not later.
SPENDIXAI JOURNAL

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

Explore your reports