Income and work

Monthly salary to project payments: a first-year cash calendar

Freelance first year cash flow: a twelve-month cash calendar that sets expected project payments against fixed bills, built from your invoice terms.

Editorial illustration for Monthly salary to project payments: a first-year cash calendar

A first-year cash calendar lists every month of the year with three things: invoices you expect to raise, the month the money will really arrive, and the fixed bills due. The closing balance each month tells you where you will be short before you are.

Why does a calendar beat a yearly total?

A year of work might add up to enough, yet you can still be broke in month three. Pay arrives in lumps after delays, while rent and school fees come every month. A calendar shows the timing, and timing is what runs out first.

How do I build the calendar?

  1. Make a row for each of the twelve months, starting with the month you leave your job.
  2. Add your opening cash: your buffer and any final settlement that has actually been credited.
  3. List the invoices you expect to raise each month, using realistic work, not hoped-for work.
  4. Move each invoice to the month the money will arrive. If terms are 30 days but clients usually take 45, plan for the later month.
  5. Write your fixed bills each month: household, business costs, EMIs, insurance.
  6. Closing cash = opening cash + cash received - bills. The closing cash is next month's opening.

A made-up first six months

Say your opening cash is ₹1,50,000 and your fixed bills, household plus business, are ₹48,000 a month. You raise invoices of ₹60,000, ₹80,000, ₹50,000, ₹90,000, ₹70,000 and ₹40,000 in months 1 to 6. Clients take about two months to pay, so each invoice is paid two months later.

MonthInvoice raisedCash receivedFixed billsClosing cash
1₹60,000₹0₹48,000₹1,02,000
2₹80,000₹0₹48,000₹54,000
3₹50,000₹60,000₹48,000₹66,000
4₹90,000₹80,000₹48,000₹98,000
5₹70,000₹50,000₹48,000₹1,00,000
6₹40,000₹90,000₹48,000₹1,42,000

Check month 2: 1,02,000 + 0 - 48,000 = 54,000. Month 3: 54,000 + 60,000 - 48,000 = 66,000. The lowest point is ₹54,000 in month 2, which is a little more than one month of bills. That is the number you need to see in advance, not after.

What if one client pays a month later?

Move that invoice one column to the right and recalculate. If the ₹80,000 invoice from month 2 is paid in month 5 instead of month 4,month 4 closes at ₹18,000 less 80,000 plus... in plain terms, month 4 closes at ₹18,000 instead of ₹98,000 (66,000 + 0 - 48,000). Month 5 catches up, but you lived through a thin month. That is the point of the calendar: one slow client can empty a month.

What should go in the later months?

Fill the months you cannot foresee with a conservative guess, such as the average of the months you already know, reduced a little. Mark the cells in a different colour so that you know they are guesses. As real invoices arrive, replace the guess with fact.

How can a tracker feed the calendar?

The bills side is the one you can check against reality. After each month, import the account statement into SpendixAI, review the rows before saving, and compare the real spending with the fixed bills in your calendar. Reports can be downloaded as CSV if you want to paste monthly totals into your sheet. SpendixAI does not track invoices or client payments, so the received column stays in your own sheet.

Your calendar checklist

  • Opening cash includes only money that is actually in the bank.
  • Receipts are placed in the month of expected payment, not the month of invoice.
  • Every yearly bill, such as insurance or fees, appears in its month.
  • The lowest closing balance is circled and compared with one month of bills.
  • The calendar is updated on the first of each month.
SPENDIXAI JOURNAL

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

Explore your reports