Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceBusiness FinanceFreelance Income & Tax Set-Aside

SpreadsheetBusiness FinanceFree

Freelance Income & Tax Set-Aside

Split every client payment into tax, savings and spending, and plan each quarterly tax payment.

Shown with sample data

Colour

Freelance Income & Tax Set-Aside

Split every client payment into tax, savings and spending, and plan each quarterly tax payment.

Income this year
$33,050
Tax reserved
$9,254
Tax still to pay
$2,234
Reserved but not yet paid
Top client share
44%
Over 50% is a risk
Income by client
  • Brightline Media$14,40044%
  • Granite Partners$8,70026%
  • Cedar Health$6,70020%
  • Oak & Pine Studio$2,3007%
  • Fjord Design$9503%
Income by quarter
  • Q1$7,900
  • Q2$7,450
  • Q3$9,550
  • Q4$8,150

How to use it

  1. 1Set your tax and savings rates on the Settings sheet.
  2. 2Log each payment received with client, invoice number and amount.
  3. 3Move the Tax reserve amount to a separate tax account as each payment lands.
  4. 4Before each deadline, check the Quarterly tax sheet and record what you paid.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Every time a client pays, log it here. The tracker sets aside your tax and savings percentages from each payment, shows what is truly yours to spend, works out the quarter from the date, and lines each quarter up against its estimated tax deadline with what you have reserved, what you have paid and what is still due. Income by client shows who your business depends on.

Who it’s for

  • Freelancers paying quarterly estimated tax
  • Contractors with irregular income
  • Building a habit of paying yourself properly

What’s included

  • Payments sheet: Client payments split into tax, savings and spending money.
  • Quarterly tax sheet: Each quarter's income, tax reserved, tax paid and what is left.
  • Clients sheet: Income by client, so you can see who your business depends on.
  • Settings sheet: Your set-aside percentages.

How to use it

  1. 1Set your tax and savings rates on the Settings sheet.
  2. 2Log each payment received with client, invoice number and amount.
  3. 3Move the Tax reserve amount to a separate tax account as each payment lands.
  4. 4Before each deadline, check the Quarterly tax sheet and record what you paid.

Tips

  • Keep tax money in a separate savings account so it is never spent by accident.
  • If one client is more than half your income, plan for losing them.
  • Review your tax rate with an accountant once your income settles.

Questions

What rate should I set aside?

Many freelancers set aside 25% to 35% to cover income and self-employment tax. Your accountant can give you a precise rate.

What if I paid more than reserved?

Remaining shows a negative amount, meaning you are ahead for that quarter.

Related searchesfreelance income trackerself employed taxestimated tax paymentsquarterly taxestax set aside1099 income

Details

Format
Spreadsheet
Category
Business Finance
Sheets
4
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetBusiness FinanceFree

Freelance Income & Tax Set-Aside

Split every client payment into tax, savings and spending, and plan each quarterly tax payment.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Business Finance
Sheets
4
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More business finance templates

View all
Subscription Revenue (MRR) Tracker4 sheets

Current MRR

$281,700

ARR

$3,380,400

MRR growth, last month

5%

Net new MRR by month
$6,200
$4,300
$7,800
$8,500
$8,500
Dec 2025Jan 2026Feb 2026Mar 2026Apr 2026
SpreadsheetBusiness Finance

Subscription Revenue (MRR) Tracker

Monthly MRR bridge with new, expansion, contraction and churn, plus churn rate, net revenue retention, quick ratio and ARR.

10 min setupPreview
Capital Budgeting NPV and Payback Analysis5 sheets

NPV

$118,225

IRR (approx.)

15%

Profitability index

1.2

Cumulative cash by year
SpreadsheetBusiness Finance

Capital Budgeting NPV and Payback Analysis

Evaluate an investment the way a CFO does: after-tax cash flows, NPV, approximate IRR, profitability index and simple and discounted payback.

10 min setupPreview
Startup Runway & Burn Rate Tracker2 sheets

Cash today

$821,600

Average net burn (3 months)

$71,900

Runway (months)

11.4

Net burn by month
$71k
$71k
$71k
$73k
$74k
Jun 2026Jul 2026Aug 2026Sep 2026Oct 2026
SpreadsheetBusiness Finance

Startup Runway & Burn Rate Tracker

Monthly revenue, spend and cash with net burn, runway in months and the date the money runs out.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ