Monthly Financial Snapshot (Private Use) — enter monthly amounts only. Leave blanks if not applicable.
How to use this worksheet
Use your best estimate if exact numbers are unknown.
This is a planning tool. It does not provide legal, tax, or financial advice.
Calculations appear only in the Summary Report below.
Section 1: Monthly Income
Net Monthly Household Income
Your total household income after taxes and payroll deductions. Include employment income, self-employment (net), pension, Social Security/disability, consistent support received. Do not include one-time windfalls or borrowed money.
Enter the monthly amount.
Cash on Hand (optional)
Enter how much cash is realistically accessible right now (checking/savings). Leave blank if you do not want any cash-based calculations.
Optional.
Section 2: Monthly Budget (Detailed)
A. Housing & Home Costs
Mortgage Payment (Total Monthly Payment)
Your full monthly mortgage payment (principal, interest, taxes, and insurance). If behind, enter the normal scheduled payment.
Property Taxes (if paid separately)
Only enter this if taxes are not included in your mortgage payment.
Homeowners Insurance (if paid separately)
Only enter this if insurance is not included in your mortgage payment.
HOA / Condo Fees
Monthly association or condominium dues, if applicable.
Home Repairs / Maintenance
Average monthly amount spent (or realistically needed) for upkeep and repairs.
Utilities (Gas, Electric, Water/Sewer, Trash)
Enter monthly averages. If a utility is included in rent/HOA, leave it blank.
Internet
Home internet service.
Cell Phones
Total monthly cost for all cell phone lines.
B. Transportation
Vehicle Payments
Total of all car or vehicle loan payments.
Auto Insurance
Monthly auto insurance premiums.
Fuel / Gas
Average monthly fuel cost.
Vehicle Maintenance
Oil changes, repairs, tires, and general upkeep (monthly average).
Public Transportation / Rideshare (if applicable)
Bus, train, Uber, Lyft, or similar services.
C. Food & Household
Groceries
Food and household items purchased from grocery stores.
Dining Out / Takeout
Restaurants, fast food, coffee shops, and delivery services.
Household Supplies
Paper goods, cleaning supplies, toiletries (if not already counted above).
D. Health & Medical
Health Insurance Premiums
Only if not already deducted from your paycheck.
Prescriptions
Monthly prescription medication costs.
Medical Bills / Copays
Doctor visits, hospital bills, therapy, or ongoing medical payments.
Dental / Vision (if applicable)
Monthly dental or vision expenses.
E. Family & Personal Obligations
Childcare / Daycare
Monthly childcare costs.
Child Support / Alimony Paid
Court-ordered support payments.
School / Activities
School fees, sports, lessons, or extracurricular activities.
F. Debts (Non-Mortgage)
Credit Card Minimum Payments
Total of required minimum payments across all credit cards.
Personal Loans
Unsecured or installment loan payments.
Student Loans
Monthly student loan payments.
Medical Debt Payments
If paid separately from the medical section above.
IRS / State Payment Plans
Tax payment plans, if applicable.
G. Insurance (Other Than Home & Auto)
Life Insurance
Monthly premiums.
Other Insurance
Any additional recurring insurance payments.
H. Gifts, Giving & “Invisible Spending” (Expanded)
Why this section matters: Gifts, giving, and “helping others” spending is one of the most underestimated categories in a household budget.
It often happens in small amounts, on different days, and rarely gets tracked as a single total. When you add it up, this category can quietly consume
the equivalent of a car payment (or more) every month—without people realizing it.
How to enter it: Enter your best monthly average for each line. If something is seasonal (holidays, birthdays, weddings),
estimate the monthly average by taking what you spend per year and dividing by 12. If you “occasionally” help family or friends, that still counts—
enter what you realistically average over time.
Family Financial Support
Money you give to family members that you don’t typically label as “your bills,” but it still leaves your account (rent help, phone bills, groceries, gas money, subscriptions, or “I’ll cover it this month” situations).
Gifts & Celebrations
Birthdays, holidays, weddings, graduations, showers, and other events. If you mainly spend during certain months, average it across the year so it shows up as a monthly number.
Charitable & Religious Giving
Any giving that is intentional or automatic (tithes, offerings, donations, fundraisers). Even small recurring amounts add up quickly over a year.
Social & Peer Spending
Covering meals/drinks, group outings, work collections, and “I’ll get it” moments that feel small individually but become significant monthly.
Digital & Automatic Giving
GoFundMe, online campaigns, auto-donations, creator subscriptions, round-ups, and app-based giving.
Miscellaneous Giving
Spontaneous cash, impulse gifts, and anything else not captured above. If this category is high, it’s usually a major “invisible spending” driver.
This worksheet is a snapshot tool for planning and conversation. It does not replace legal, tax, or financial advice.
What “Net Cash Position” means
If Cash on Hand is entered, Net Cash Position = Cash on Hand − Deficiency − (one full month of total monthly expenses).
This is not a forecast—just a simple snapshot number using your inputs.
Editing text later is safe. If you change or remove fields, the calculations may need matching updates in the script.
const $ = (id) => document.getElementById(id);
function n(v){
const x = parseFloat(v);
return Number.isFinite(x) ? x : 0;
}
function fmtUSD(x){
const sign = x < 0 ? "-" : "";
const abs = Math.abs(x);
return sign + abs.toLocaleString(undefined, {style:"currency", currency:"USD"});
}
function setText(id, text){ $(id).textContent = text; }
const expenseIds = [
"mort_total","prop_taxes","home_ins","hoa","repairs",
"util_gas","util_elec","util_water","util_trash","internet","cell",
"veh_pay","auto_ins","fuel","veh_maint","rideshare",
"groceries","dining","supplies",
"health_prem","rx","medical","dental",
"childcare","support_paid","school",
"cc_min","pl","sl","med_debt","tax_plan",
"life_ins","other_ins",
"gift_adult_kids","gift_parents","gift_grandkids","gift_family_emergency",
"gift_birthdays","gift_holidays","gift_weddings","gift_special",
"gift_church","gift_charity","gift_fundraisers",
"gift_meals","gift_events","gift_work",
"gift_crowdfund","gift_auto","gift_app",
"gift_cash","gift_impulse","gift_other_amt",
"subs","gym","personal","clothing",
"other1_amt","other2_amt","other3_amt","other4_amt","other5_amt"
];
const giftIds = [
"gift_adult_kids","gift_parents","gift_grandkids","gift_family_emergency",
"gift_birthdays","gift_holidays","gift_weddings","gift_special",
"gift_church","gift_charity","gift_fundraisers",
"gift_meals","gift_events","gift_work",
"gift_crowdfund","gift_auto","gift_app",
"gift_cash","gift_impulse","gift_other_amt"
];
function calc(){
const income = n($("income_net").value);
let expenses = 0;
for (const id of expenseIds){
const el = $(id);
if (el) expenses += n(el.value);
}
let gifts = 0;
for (const id of giftIds){
const el = $(id);
if (el) gifts += n(el.value);
}
const net = income – expenses;
const breakEven = net < 0 ? Math.abs(net) : 0;
const saleStr = $("sale_date").value;
let daysText = "—";
let daysNote = "";
if (saleStr){
const today = new Date();
today.setHours(0,0,0,0);
const sale = new Date(saleStr + "T00:00:00");
const diffMs = sale – today;
const diffDays = Math.round(diffMs / (1000*60*60*24));
daysText = String(diffDays);
if (diffDays < 0) daysNote = "The entered date is in the past.";
else if (diffDays === 0) daysNote = "Sale date is today (based on your device date).";
else if (diffDays <= 7) daysNote = "Immediate timeline. Consider urgent review of options.";
else if (diffDays 0 && net = 10 ? 1 : 2) + ” months”;
runwayNote = “Estimated: cash ÷ monthly deficit. (A planning estimate, not advice.)”;
} else if (net >= 0){
runwayText = “Not needed”;
runwayNote = “You show a monthly surplus based on the numbers entered.”;
} else if (cash === 0 && net 0){
cashAfterDef = cash – def – expenses;
}
setText(“out_income”, fmtUSD(income));
setText(“out_expenses”, fmtUSD(expenses));
const netEl = $(“out_net”);
netEl.textContent = fmtUSD(net);
netEl.classList.toggle(“negative”, net 0);
setText(“out_net_note”, net 0 ? “Surplus means income exceeds expenses.” : “Break-even (income equals expenses).”));
setText(“out_break_even”, fmtUSD(breakEven));
setText(“out_days”, daysText);
setText(“out_days_note”, daysNote);
setText(“out_runway”, runwayText);
setText(“out_runway_note”, runwayNote);
const cashEl = $(“out_cash_after_def”);
if (cashAfterDef !== null){
cashEl.textContent = fmtUSD(cashAfterDef);
cashEl.classList.toggle(“negative”, cashAfterDef 0);
setText(“out_cash_after_def_note”, “Cash on hand minus the deficiency amount and one full month of total monthly expenses.”);
} else {
setText(“out_cash_after_def”, “—”);
setText(“out_cash_after_def_note”, “Enter Cash on Hand to calculate this value.”);
}
setText(“out_gifts”, fmtUSD(gifts));
if (income > 0){
const pct = (gifts / income) * 100;
setText(“out_gifts_note”, `This equals about ${pct.toFixed(1)}% of your monthly income (based on what you entered).`);
} else {
setText(“out_gifts_note”, “Enter income to see gifts as a percent of income.”);
}
setText(“out_def”, fmtUSD(def));
const ts = new Date();
$(“status”).textContent = “Updated ” + ts.toLocaleTimeString([], {hour:”2-digit”, minute:”2-digit”});
}
function resetAll(){
document.querySelectorAll(‘input’).forEach(i => i.value = “”);
calc();
$(“status”).textContent = “Cleared”;
}
$(“btnCalc”).addEventListener(“click”, calc);
$(“btnPrint”).addEventListener(“click”, () => window.print());
$(“btnReset”).addEventListener(“click”, resetAll);
document.addEventListener(“input”, (e) => {
if (e.target && e.target.tagName === “INPUT”) calc();
});
calc();
I agree to be contacted by Reality Real Estate Professionals via call, email, and text. To opt-out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Message and data rates may apply.