Help me build a monthly budget tracker in Excel. I want:
Income sources: [LIST WITH AMOUNTS]
Expense categories: [LIST — or use standard categories]
Tracking period: [Monthly / Weekly]
Please:
1. Create the spreadsheet layout with columns for date, category, description, amount, running balance
2. Include formulas for category totals, monthly summary, and budget vs actual
3. Add a dashboard section with key metrics (savings rate, top spending categories, trend vs last month)
4. Include conditional formatting to highlight overspending
5. Write the formulas I need — do not just describe them, give me the actual Excel formulas
6. Suggest a simple data entry workflow I can follow daily
Help me draft an email to negotiate [FINANCIAL SITUATION — e.g. a lower interest rate on my credit card, a medical bill reduction, a salary raise, a better insurance rate, a fee waiver].
Key details:
- Who I am writing to: [COMPANY/PERSON]
- My history with them: [e.g. customer for 5 years, never missed a payment]
- What I am asking for: [SPECIFIC REQUEST]
- My leverage: [e.g. competing offers, loyalty, financial hardship]
The tone should be: [Polite but firm / Friendly / Formal / Direct]
Write the full email. Make it persuasive but professional. Include specific talking points that strengthen my position.
Create an expense report template I can use in Excel for [CONTEXT — e.g. work travel reimbursement, small business expenses, freelance project tracking].
Include:
1. Columns for date, vendor, description, category, amount, payment method, receipt attached (yes/no)
2. Category dropdown list for: [LIST CATEGORIES — or use standard business expense categories]
3. Summary section with totals by category
4. Formulas for subtotals, tax calculations if applicable, and grand total
5. A space for approval signatures and submission date
6. Make it print-friendly on one page if possible
Help me build a loan comparison calculator in Excel. I want to compare [NUMBER] loan offers:
Loan 1: [Amount, Interest rate, Term, Fees]
Loan 2: [Amount, Interest rate, Term, Fees]
Loan 3: [Amount, Interest rate, Term, Fees — if applicable]
Please:
1. Calculate monthly payment for each loan
2. Calculate total interest paid over the life of each loan
3. Calculate total cost (principal + interest + fees)
4. Build an amortization schedule for each loan
5. Include a side-by-side comparison summary
6. Write all the Excel formulas (PMT, IPMT, PPMT) so I can paste them directly
Draft a monthly financial check-in email I can send to [RECIPIENT — e.g. my spouse/partner, my financial advisor, my business partner, myself].
Include a template covering:
1. Income summary for the month
2. Spending summary by category vs budget
3. Savings progress toward goals
4. Debt paydown progress
5. Net worth update
6. Key wins this month
7. Adjustments needed for next month
8. One action item for the upcoming month
Tone: [Casual for partner / Professional for advisor / Motivational for self]
Make it something I can fill in quickly each month in under 10 minutes.
Create a professional invoice template I can use in Excel for my freelance work:
My business: [NAME AND TYPE]
Typical services: [LIST]
Payment terms: [e.g. Net 30, due on receipt]
Currency: [CURRENCY]
Include:
1. Header with my business name, logo placeholder, and contact info
2. Client info section
3. Line items with description, hours/quantity, rate, and line total
4. Subtotal, tax calculation (rate: [TAX RATE]), and grand total
5. Payment instructions section
6. Invoice number auto-increment logic
7. Professional formatting suitable for sending to clients
Help me build a subscription tracker in Excel to manage all my recurring charges:
Please create a spreadsheet with:
1. Columns for: service name, category, billing cycle (monthly/annual), amount, next billing date, payment method, cancel link/notes
2. Formulas to calculate total monthly cost and total annual cost
3. Conditional formatting to highlight subscriptions coming up for renewal in the next 7 days
4. A summary showing spending by category (streaming, software, fitness, news, etc.)
5. A column to mark "keep / review / cancel" with a dropdown
6. Sort by most expensive first
After the template, suggest a quarterly review process to audit subscriptions.