Freelancer & Small Business Spreadsheet Pack: Invoice, Income & Tax Tracker (INR/USD), Client CRM, Budget Planner, Content Calendar (Excel + Google Sheets)

Five formula-driven spreadsheets that run the business side of freelancing, so you can get back to the work.

Stop juggling notes, screenshots and five different apps. This pack gives you **5 polished, ready-to-use spreadsheets** for the admin every freelancer and small business has to handle: billing, money, clients, budgeting and content.

Each one opens on a **Start Here** sheet with step-by-step instructions. They come with **sample data** so you can see how everything works, **dropdowns** to keep entries consistent, and **conditional formatting** that flags what needs your attention. There are **no macros**, so they work the same in **Microsoft Excel, Google Sheets and LibreOffice**.

### What's inside

**1. Invoice Generator**

- Save your business details, bank/UPI/PayPal info and default tax rate once

- Pick a client from a dropdown and the address, email and tax ID fill in automatically

- 10 line items with qty × rate, a discount %, GST/VAT and the total, all calculated

- Print-ready layout: export to PDF in one click

- An **invoice log** shows paid, unpaid and overdue totals and turns overdue invoices red

**2. Income, Expense & Tax Tracker (INR / USD)**

- Log every payment and expense in INR or USD, with an optional exact FX rate per entry

- **Monthly profit summary** for the Indian financial year (April to March) with a running total

- Category breakdown with a heat-map and USD received

- **Tax estimate**: compares actual profit with **presumptive taxation (Sec 44ADA)** under the new regime, using an editable slab table, Sec 87A rebate/marginal relief and cess

- **Advance-tax instalment** schedule (June, September, December, March)

**3. Client & Project CRM**

- Clients with lead source, status, project count and total billed (calculated)

- Projects with stage, value, paid, balance and days left. Overdue work turns red, and anything due within 3 days turns amber

- A follow-up log that highlights the reminders due today

- **Dashboard** with pipeline by stage (INR and USD), outstanding balances, win rate and the next 5 deadlines

**4. Monthly Budget Planner**

- Set budgets per category and group them into Needs, Wants or Savings

- Pick any month to see **planned vs actual**, money remaining and % used

- Over-budget categories turn red. Anything 85% or more used turns amber

- A **50/30/20 split** and your savings rate at a glance

**5. Content & Social Media Calendar**

- Plan posts by date, platform, format, content pillar and status (Idea, Drafting, Scheduled, Published)

- A **month calendar grid** shows the posts and the first title on each day

- A dashboard counts posts by platform × status, this month's output, the next 7 days and your idea backlog

### Who it's for

Freelancers on Fiverr, Upwork and Contra, consultants, designers, developers, creators and small business owners. It's especially useful for **Indian freelancers billing clients abroad** in USD.

### Compatibility

- Microsoft Excel 2010 or newer (Windows, Mac, Microsoft 365)

- Google Sheets: upload the .xlsx file to Drive and open it

- LibreOffice Calc

- Formulas use only standard functions (SUMIFS, COUNTIFS, INDEX/MATCH, SUMPRODUCT, EDATE, EOMONTH). There are no macros, no VBA and no add-ons.

### Important

The tax sheet is a **planning estimate, not tax advice**. Slabs are pre-filled from Budget 2025 (FY 2025-26) and can be edited. Always confirm your figures with a Chartered Accountant.