A freelancer's renewals sheet lists every tool you pay for with its billing month, amount, how often it renews, whether it is for business or personal use, and whether you re-bill it to a client. Sorted by billing month, it shows what is due soon and which costs belong on your books. Build it once, then update it every time an invoice arrives.
What columns does the sheet need?
| Column | What to enter | Why it matters |
|---|---|---|
| Tool or service | Domain, hosting plan, design software, cloud storage | One row per item |
| Billing month and date | For example, 14 August | Sorts by due date |
| Cycle | Monthly, yearly or two-yearly | Decides how often it recurs |
| Amount and currency | As on the invoice | Some tools bill in another currency |
| Business or personal | B, P or Shared | Keeps your books clean |
| Client re-billing | Client name, or No | Reminds you to pass on the cost if agreed |
| Invoice saved | Yes or No, with the folder | Needed when you account for it |
| Auto-renew | On or off | Tells you where to intervene |
Which renewals do freelancers forget most?
- Domain names, which often renew once a year or once in two years on a date that is easy to miss
- Hosting or email plans that have a cheaper first term and a different price at renewal
- Design, editing or writing software on yearly plans
- Cloud storage and backup
- Online meeting and scheduling tools
- Stock images, fonts and plug-ins
Write the renewal date in the sheet on the day you first buy. A domain that lapses can take a website and email address down with it, which costs more than the renewal itself.
How should you tag business and personal costs?
Use a simple code in one column. B means used only for work, P means personal, and S means shared. For shared items, such as a phone plan or a laptop used for both, decide a reasonable split and write it down, for example 70 per cent work and 30 per cent personal, with a note on why. How these costs are treated for accounts or tax is a question for your CA, so keep the invoices and the split rationale ready and ask.
What is the client re-billing note for?
If a tool is bought for a specific project, such as a stock-photo licence or a plug-in, you may have agreed with the client to pass the cost on. A column for client name and invoice number stops you from forgetting. Say a plug-in costs ₹3,200 and your agreed handling note is zero: write 3,200 in the amount column, the client's name in the re-billing column and the date you added it to their invoice.
How do you see what is coming this quarter?
With billing dates in column B as real dates, sort the sheet by column B and add a helper column showing =IF(AND(B2>=TODAY(),B2<=TODAY()+90),"Due soon",""). That flags anything due in the next 90 days, provided column B holds the next due date rather than last year's. In Google Sheets or Excel the formula works as written.
To total a year, use =SUMIFS($D$2:$D$100,$E$2:$E$100,"B") for business-only items, assuming amounts are in D and the B, P or S code is in E. Tools billed in another currency need converting at the rate on the invoice first.
When a sheet stops being enough
If you pay most tools from one card, importing its statement into SpendixAI lets you tag each charge to a category, set a GST rate and ITC-eligible flag on the category, and export a file for your accounting software, with Tally, Zoho Books and QuickBooks templates available. The tax setting figures are estimates to confirm with your CA, and your sheet remains the place for billing months and client notes.
An annual tidy-up
- Cancel or downgrade anything unused in the past quarter.
- Check each auto-renew setting matches what you want.
- Move the dates for next year into your calendar.
- File this year's invoices before the financial year closes.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


