Getting started

Freelancers: a 20-minute month-end review across income and spend

Month-end review for freelancers in India: reconcile invoices to money received, separate business and personal debits, and decide what stays in the account.

Editorial illustration for Freelancers: a 20-minute month-end review across income and spend

A freelancer's month-end has one extra job a salaried person never has: matching what you billed to what actually reached your account. Do that first, then sort the debits into business and personal, and finish by deciding how much of the month's money stays where it is. Twenty minutes is realistic if your invoices sit in one list.

Where does the time go?

It goes on three separate places that do not talk to each other: an invoice file, a bank account and a UPI history. Each has half the story. The invoice file knows what you were owed, the statement knows what arrived, and the UPI list knows what you spent in small amounts. You have to put them side by side before any of it makes sense.

Step one: billed against received

Say you raised invoices worth ₹84,000 this month and money received was ₹61,000. The outstanding amount is 84,000 minus 61,000, which is ₹23,000. List what makes up that ₹23,000.

ClientInvoice amountStatus
Client A₹9,000Overdue, follow up this week
Client B₹8,000Within agreed payment time
Client C₹6,000Asked for a corrected invoice
Total outstanding₹23,000Matches 84,000 minus 61,000

The check at the bottom matters: 9,000 + 8,000 + 6,000 is ₹23,000, so nothing is missing. If the numbers disagree, a payment was matched to the wrong invoice.

Step two: sort the debits

Take the month's bank statement and mark each debit as business or personal. Business debits in this example come to ₹12,400. Personal withdrawals and spending are ₹28,000.

What stays is 61,000 minus 12,400 minus 28,000, which is ₹20,600. That is the figure to compare with what you wanted to keep as a buffer.

What should a freelancer record for each payment?

  • The date it arrived and the amount actually credited, which can differ from the invoice if something was deducted.
  • The client name, so you can follow up quickly.
  • Whether it was for work this month or an earlier one.
  • The account it reached, if you use more than one.

Anyone who later asks for proof, whether it is a client, a lender or your accountant, will ask for those four things.

Is it fine to keep personal and business in one account?

Many freelancers do, and it works if you tag each debit. The cost is that the month-end sort takes longer. If you can, keep a second account for business spending and only move across what you draw. Whether and how to do that is a matter for you and your CA, particularly for tax and GST registration, so treat this as a habit suggestion and not a rule.

How can the sorting be quicker?

SpendixAI accepts a bank or card statement as a PDF, CSV or Excel file, shows the rows for review before they are saved, and lets you set your own rules and custom categories. If you create business and personal categories and a rule for repeating payments such as a software subscription, much of the tagging is done on import and you review the rest.

What if the numbers do not tie up?

If billed minus received does not equal your outstanding list, one payment has probably been matched to the wrong invoice, or a client paid a different amount from the invoice because of a deduction at their end. Note the difference beside the client name and ask them for the payment advice. Do not adjust the invoice list until you know what happened.

The same applies to debits. If your business and personal totals do not add up to total debits, there is a row you have not tagged. Sort the statement by amount, because a missing row is usually a large one.

Closing the month

  1. Total billed and total received.
  2. List and chase the outstanding invoices.
  3. Tag business and personal debits.
  4. Compare what remains with your buffer target.
  5. Note any invoice to raise on the 1st.
SPENDIXAI JOURNAL

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

Explore your reports