Life events

Domain, hosting and software renewals for freelancers: one sheet

A one-sheet renewals tracker for freelancers: domains, hosting and software with billing months, business or personal tags and client re-billing notes.

Editorial illustration for Domain, hosting and software renewals for freelancers: one sheet

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?

ColumnWhat to enterWhy it matters
Tool or serviceDomain, hosting plan, design software, cloud storageOne row per item
Billing month and dateFor example, 14 AugustSorts by due date
CycleMonthly, yearly or two-yearlyDecides how often it recurs
Amount and currencyAs on the invoiceSome tools bill in another currency
Business or personalB, P or SharedKeeps your books clean
Client re-billingClient name, or NoReminds you to pass on the cost if agreed
Invoice savedYes or No, with the folderNeeded when you account for it
Auto-renewOn or offTells 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

  1. Cancel or downgrade anything unused in the past quarter.
  2. Check each auto-renew setting matches what you want.
  3. Move the dates for next year into your calendar.
  4. File this year's invoices before the financial year closes.
SPENDIXAI JOURNAL

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

Explore your reports