Job Loss Money RESET™ Financial Command Centre (Google Sheets + Excel)

Short description:

The financial command centre built specifically for job loss. Enter your numbers once and it calculates everything automatically -- your runway, survival budget, benefits, debt priority, emergency fund, job search conversion rate and confidence score. Includes both Google Sheets and Microsoft Excel versions in one download.

Full description:

Most budget spreadsheets are built for people with a steady income.

This one is built for job loss.

The Job Loss Financial Command Centre™ is a 7-tab spreadsheet that does the financial and career calculations you need most during unemployment -- automatically, as you enter your real numbers. It includes both Google Sheets and Microsoft Excel formats so you can use whichever tool you already have.

WHAT IS INSIDE -- 7 TABS

🏠 Start Here

Instructions, colour-coded legend and navigation guide. Yellow cells are where you enter your numbers. Teal cells calculate automatically. Takes 2 minutes to read before you begin.

📊 Dashboard

Your complete recovery picture at a glance. Updates automatically every time you enter data in any other tab.

Includes:

• Six key financial metrics across the top -- runway, monthly income, survival budget, surplus/deficit, benefits total and emergency fund balance
• Weekly RESET Score out of 100 -- seven criteria that tell you exactly where to focus
• Confidence Tracker -- enter your score 1-10 each Sunday across 13 weeks with wins and hard moments logged alongside
• 90-Day Progress Summary -- track your key metrics at Day 1, Day 30, Day 60 and today vs your target

⏱️ Runway & Budget

START HERE. The most important tab in the dashboard.

• Income tracker -- all sources including unemployment benefits, severance, side income and household income
• Savings tracker -- checking, savings, brokerage and Roth IRA (with a clear DO NOT TOUCH warning on 401k and Traditional IRA)
• Survival budget -- every essential expense category with priority notes
• Runway calculator -- the big number. Total available funds divided by monthly survival budget. Auto-calculates the moment you enter your data.
• Surplus / deficit -- income vs essential expenses. Positive means you are stable. Negative means cuts are needed.
• Income Opportunities Tracker -- 8 income ideas with realistic monthly estimate, time required and status

🛡️ Benefits & Bills

• Benefits Tracker -- 13 benefits including Unemployment Insurance, COBRA, ACA Marketplace, Medicaid, SNAP, CARES Act mortgage forbearance, LIHEAP and student loan deferment. Application date, first payment date, monthly amount and reference number for each.
• Bill Tracker -- 15 bills with amount due, due date, status, hardship program column, date contacted and arrangement agreed. Creditor reminder built in.

💳 Debt & Emergency

• Debt priority order -- nine debt categories colour-coded by urgency with creditor communication scripts built in
• Debt tracker -- 10 creditors with balance, minimum payment, date contacted, hardship arranged and status
• Emergency Fund Tracker -- target calculator (3 or 6 months), gap to target, monthly contribution planner and 12-month progress tracker with running total and percentage complete

💼 Job Search

• Weekly targets vs actuals with auto status for seven metrics
• Application Tracker -- 30 rows with company, role, date applied, source, salary range, status and follow-up date
• Interview Tracker -- 15 rows with company, role, date, format, interviewer, outcome and next step
• Follow-up Tracker -- 20 rows tracking every outstanding application with method, response and next action
• Application conversion rate -- auto-calculated from your tracker data. Below 20% signals a resume or targeting issue.

💰 Salary Research

• Minimum salary auto-calculated from your actual survival budget (never guess your floor again)
• Seven-source research table with auto-averaging across low, mid and high ranges
• Salary targets -- minimum, target and stretch -- all auto-calculated from your research
• Five salary negotiation scripts built in for every scenario including negotiating after unemployment
• Offer comparison calculator -- eight package elements compared across two offers vs your minimum

WHAT MAKES THIS DIFFERENT

Every other budget template is built for someone with a steady income. Every other job search tracker is built for someone who is calm. This dashboard is built for the first 72 hours after job loss, when the runway calculator is the most important number in your life.

The Weekly RESET Score is unique to this dashboard. Seven criteria. 100 points. Updated every Sunday. It tells you exactly which tab needs your attention this week so you are never wondering where to focus.

The Confidence Tracker runs alongside your financial data for 13 weeks -- because recovering from job loss is financial and emotional, and both need to be tracked.

HOW TO USE

Google Sheets version:

1. Download the .xlsx file
2. Go to drive.google.com
3. Click New > File Upload and select the file
4. Double-click the uploaded file
5. Click Open with Google Sheets
6. File > Make a Copy to save your own editable version
7. Start with the yellow cells in Tab 3: Runway & Budget

Excel version:

1. Download the .xlsx file
2. Open in Microsoft Excel
3. Click Enable Editing if prompted
4. File > Save As to save your own copy
5. Start with the yellow cells in Tab 3: Runway & Budget

Both files are identical in content. Use whichever format you prefer.

WORKS WITH

✅ Google Sheets (free -- any device)

✅ Microsoft Excel 2016 and later

✅ Microsoft 365

✅ Excel for Mac

COMPANION PRODUCTS

This dashboard is part of the Job Loss Money RESET™ ecosystem and works alongside:

The Job Loss Money RESET™ Workbook -- the book that teaches the RESET Method. The book tells you what to do. The dashboard helps you do it.

The Job Loss Money RESET™ 90-Day GoodNotes Recovery Planner -- the same sections as this dashboard, built for your iPad and Apple Pencil. Daily planning, weekly reviews and habit tracking.

The Notion Career Recovery Command Centre™ -- your complete job search management system with application tracker, networking database and 50 AI coaching prompts.

All available from Charlotte Jones Publishing.