Getting Started

How the Finance Planner for Creatives is Structured

All Categories > Getting Started > How the Finance Planner for Creatives is Structured

 

How the Finance Planner for Creatives is Structured

This Finance Planner for Creatives was designed to help you manage your income, expenses, and financial goals with clarity and ease—without the overwhelm of complicated apps, and to give you unique insights and charts based on your financial situation. Here's a breakdown of how the key sections are organized and how they work together.


Start Here

This is your welcome page with setup instructions, quick tips, and helpful links. Start by making a copy of the planner and renaming it for your records (e.g. “Finance Planner – Original”).

See more on Getting Started here →


Income + Expense Sheets

These four sheets are the core of your financial tracking—designed to separate and organize your finances for better clarity and planning:

Income Sheets

  • Taxable Income: Track earnings that you'll report on your taxes—like freelance projects, client payments, or your day job.

  • Non-Taxable Income: Log income that isn’t subject to tax, such as gifts, reimbursements, or certain grants.

Expense Sheets

  • Business Expenses: Record any business-related purchases—from software subscriptions to supplies—to help with budgeting and tax prep.

  • Personal Expenses: Track your everyday personal spending to get a clear picture of where your money goes.

Each sheet includes:

  • A customizable dropdown section where you can tailor your categories, subcategories, retailers, and payment methods to match your real-life habits.

  • An itemized log section to document each transaction.

  • A yearly calendar view to see your finances month-by-month and spot trends at a glance.

See more on Income and Expense Sheets here →


🧮 Planned Budget Sheet

This sheet helps you map out your finances ahead of time so you can make more intentional decisions about your spending and earning.

It’s organized into four sections to align with your actual financial tracking:

  • Planned Taxable Income – Estimate how much you expect to earn from freelance projects, your job, or other taxable sources.

  • Planned Non-Taxable Income – Plan for things like gifts, reimbursements, or other income that isn’t taxed.

  • Planned Business Expenses – Set monthly budgets for different business-related categories, such as software, marketing, or supplies.

  • Planned Personal Expenses – Estimate what you’ll spend on personal needs, from groceries to entertainment.

Each section includes:

  • A line for each category, where you can input what you expect to earn or spend each month.

  • Automatic totals by category and by month, giving you a clear view of your planned cash flow.

Use this sheet to plan for the year, track patterns, and stay in control of your financial goals.

See more on the Planned Budget Sheet here →


📊 Summaries + Insights

These auto-populated sheets do the heavy lifting for you.

  • Monthly Summaries: Show comparisons for income vs. expenses and planned vs. actual per month, with charts to visualize your cash flow.

  • Yearly Overview: Get a full visual snapshot of your year at a glance.

These sheets update automatically based on what you enter in the Planned Budget, Income, and Expense sheets.

See more on Summaries here →


💸 Tax Sheets

These sheets are designed to help you stay organized and proactive about your taxes—without needing to be a tax expert.

📊 Profit & Loss Report

This sheet automatically pulls data from your Income and Business Expense logs to show:

  • Your total taxable income and total business expenses

  • A breakdown of income and expenses by subcategory

  • Your net profit (income minus expenses)—helpful for tax reporting and tracking how your business is doing financially

This report is especially useful when you're preparing your taxes or applying for things like loans or grants.

📅 Taxes Sheet

This is your central hub for estimating and tracking tax-related activity:

  • Estimate your quarterly taxes based on your actual income and expenses

  • See how much you need to save each month and quarter to stay on track

  • Track your tax savings: Document how much you’ve set aside each month

  • Record your federal and state tax dues and payments to keep everything in one place

These tools are especially helpful for freelancers and small business owners who want to avoid surprises and feel more in control during tax season.

See more on Tax Sheets here →


🎯 Goals Sheet

This section helps you set, track, and reflect on your financial goals—both short-term and long-term.

  • Current Goals: Define specific targets for each quarter (like savings or income goals) and see how your charts and insights update as you add data.

  • Top Goals: Record your big-picture 1-, 3-, 5-, and 10-year goals. These aren’t linked to calculations, but help you stay focused on your bigger vision.

  • Goal Prompts: Use these reflective prompts to spark ideas and clarify your priorities. Add custom responses and action steps to help you move forward.

This sheet is here to help you stay intentional with your finances and align your daily decisions with your long-term vision.

See more on the Goals Sheet here →

How to Start Using the Finance Planner for Creatives

All Categories > Getting Started > How to Start Using the Finance Planner for Creatives

 

This Finance Planner for Creatives was built in Google Sheets so you can track your finances with clarity and ease — no extra apps or logins needed. But before you dive in, you might be wondering how to edit the finance planner. First, you need to make sure you're working from your own copy.

 

Make a Copy

Before you can start editing, you’ll need to make your own copy of the planner in Google Sheets:

  1. Click File in the top-left menu

  2. Select “Make a copy”

  3. Choose a location to save it in your Google Drive

  4. Rename your copy so it’s easy to keep track

 

Naming Tips

  • Add the year to the name (e.g. “Finance Planner 2025” if you like your files organized by name or “2025 Finance Planner” if you like them organized by date/year)

  • Consider saving an untouched original by naming it something like “Finance Planner – Original”

  • Use a second copy for experimenting or customizing before committing to real data

💡 This way, you always have a clean reference version, and you can easily find your current year’s planner.

 

That’s it — you’re ready to get started with your own version of the Finance Planner for Creatives!

What You Can and Shouldn't Modify in the Finance Planner for Creatives

All Categories > Getting Started > What You Can and Shouldn't Modify in the Finance Planner for Creatives

 

What You Can and Shouldn't Modify in the Finance Planner for Creatives

To keep your Finance Planner for Creatives working properly, it’s important to only make changes where intended. Here’s how to know which cells are safe to edit:

 

✅ What You Should Edit

Only edit:

  • Cells with visible borders: These are designed for your input (like logging income, expenses, goals, etc.). You will see an example of what the editable cells should look like on each sheet, or see instructions on where to edit.

  • Dropdown Option Sections: These are located on the Income and Expense sheets (starting at cell A50). Here, you can customize options for:

    • Categories

    • Subcategories

    • Retailers

    • Payment Methods

These fields are meant to reflect your unique financial situation—feel free to personalize them!

 

🚫 What You Shouldn’t Edit

Do not edit:

  • Cells without borders: These contain built-in formulas and information that power your charts, summaries, and automations. Editing or deleting them may break important calculations. The dropdown options are an exception to this rule.

  • Shaded cells or auto-filled fields: These are populated automatically based on your entries and should be left alone.

  • Any sheets or sections marked with warnings: These reminders help protect the structure of the planner.

 

🧠 Tip: If You See a Warning…

A popup or message will appear if you try to modify something that shouldn’t be changed. These are here to protect formulas and help keep everything running smoothly.

There are special cases where you can ignore those warnings. See here to learn more →

How to Clear Data Safely in the Finance Planner for Creatives

All Categories > Getting Started > How to Clear Data Safely in the Finance Planner for Creatives

 

How to Clear Data Safely in the Finance Planner for Creatives

Ready to reset your Finance Planner for Creatives, reuse it for a new year, or remove test info? While you have access to both a clean version and one with sample info, knowing how to clear data from the sample version is a great way to get familiar with the planner and learn how to use it efficiently. (Just make sure you’ve saved an untouched copy before making any changes!) Here's how to safely wipe your data without disrupting any formulas or formatting.

 

✅ What You Can Clear

You can safely clear entire sections of the planner by selecting groups of bordered cells — no need to delete entries one cell at a time!

Look for areas with bordered cells on the following sheets:

  • 💰 Income & Expense Logs
    Select large blocks of entries in the itemized tables. You can drag-select multiple rows with bordered cells and hit Delete. Just be sure to leave shaded columns (with formulas) untouched.

  • 📊 Planned Budget Sheet
    You can drag-select the entire input area for each section and hit Delete.

  • 🧮 Tax and Goals Sheets
    Groups of bordered cells can be safely cleared by drag-selecting and hitting Delete.

 

⚠️ Watch Out

  • Don’t delete entire rows or columns. Even if a cell looks blank, it may have a formula, so be sure to stick to only the bordered cells.

  • Don’t clear shaded cells — these contain formulas that power charts and summaries.

  • If you see a warning popup, that means you're trying to edit a protected area.
    Just hit Cancel, reselect only the bordered cells, and try again.
    There are special cases where warnings can be ignored. Learn more here →

 

💡 Pro Tip

Want to start a new year or keep a backup?
Make a duplicate of the planner and rename it with the year (e.g. Finance Planner – 2024 Archive) before clearing anything!