Sheet Names & Structure

• Income Statement: Core financial summary of research income and expenses.
• Research Expenses: Detailed log of all expenditures related to your project.
• Incomes & Grants: Records all funding sources, including personal savings, freelance work, or small grants.
• Project Timeline: Tracks research milestones and their associated financial phases.
• Dashboards: Visual summary with charts and KPIs for quick performance review.

Table Structures, Columns & Data Types

The Research Expenses sheet includes:

The Incomes & Grants sheet includes:

The Income Statement aggregates data from the above sheets using formulas to calculate:

• Total Income (SUM of all received amounts)
• Total Expenses (SUM of all expenses categorized under research)
• Net Research Balance = Total Income - Total Expenses
• Months of Sustainability = Net Balance / Monthly Average Expense

Required Formulas

• In “Income Statement”, cell B2: =SUM(Incomes&Grants!D:D) — Total Income
• Cell B3: =SUM(Research Expenses!D:D) — Total Expenses
• Cell B4: =B2-B3 — Net Research Balance
• Cell B5: =IF(B3>0,B4/SUMIFS(Research Expenses!D:D,Research Expenses!A:A,">="&TODAY()-30,Research Expenses!A:A,"<="&TODAY())/30,"N/A") — Months of Sustainability (avg monthly expense over last 30 days)
• In “Dashboards”, use SUMIF and COUNTIF to dynamically populate pie charts by Category and Status.
• Cell D2 in “Project Timeline”: Uses a formula to highlight overdue milestones with: =IF(TODAY()>C2,"OVERDUE","On Track")

Conditional Formatting

• In “Research Expenses”, any row where "Paid By" = "Personal Savings" and Amount > $500 is highlighted in light red — to warn of over-reliance on personal funds.
• Rows where “Status” in “Incomes & Grants” is “Expired” are shaded orange.
• In the Income Statement, if Net Research Balance (B4) is negative for 3 consecutive months, cell B4 turns red and displays a warning icon (via icon set formatting).
• Cells in “Project Timeline” with “OVERDUE” status are flagged with bold red text.

User Instructions

1. Begin by entering all your funding sources under “Incomes & Grants.” Use consistent naming (e.g., always "Personal Savings" not "My Money").
2. Log every research-related expense in the “Research Expenses” sheet — even small items like printer ink or a book subscription.
3. Update the Project Timeline with your planned milestones and target dates; this helps correlate financial burn rate with progress.
4. Review the Dashboard weekly: it visually shows if you’re spending faster than you’re earning — critical for long-term research sustainability.
5. Do NOT use this template to track non-research personal expenses (e.g., groceries, rent). Keep research finances separate to ensure accurate cost allocation.
6. Use the “Months of Sustainability” metric to decide if you need to seek additional funding or delay a phase — it’s your financial early-warning system.

Example Rows

Recommended Charts & Dashboards

The “Dashboards” sheet includes:

• Pie Chart #1: “Expenses by Category” — Visualize where your research money goes. Helps identify areas for cost reduction (e.g., if software is 60% of spending, explore open-source alternatives).
• Line Chart: “Income vs Expenses Over Time” — Plot monthly totals to detect trends. Are expenses spiking before a conference? Is income inconsistent?
• Donut Chart: “Funding Sources” — Shows reliance on personal savings vs external grants. Avoids burnout by revealing over-dependence on one source.
• KPI Box: Displays the Net Research Balance, Months of Sustainability, and Expense-to-Income Ratio as large numbers for quick glance.

This template transforms abstract research into a financially accountable endeavor. In personal research — where passion often meets financial uncertainty — this Income Statement becomes your lifeline. It empowers you to make data-driven decisions: delay a publication fee until grant funds arrive, cut travel expenses in favor of virtual conferences, or recognize when it’s time to pause and find income elsewhere. Because even independent scholarship deserves sustainable economics.