Strategic Entrepreneur Spreadsheet

 

 

The Strategic Entrepreneur

Dual-Role Management Spreadsheet

Building Business + Caregiving Systems

Emergency Contacts
Communication Templates
Business Continuity
Schedule Integration
Financial Dashboard
Capacity Monitor

Instructions: Complete all contact information. Print and keep copies in multiple locations (office, home, car, with family members). Update quarterly.
Family & Medical Contacts
Contact TypeName/OrganizationPhoneEmailAddress/NotesAvailable Hours
Primary Care Physician
Specialist #1
Specialist #2
Pharmacy
Insurance – Primary
Business Critical Contacts
Contact TypeName/OrganizationPhoneEmailRole/ServicesBackup Contact
Top Client #1
Top Client #2
Accountant/Bookkeeper
Business Attorney
Bank/Business Financing
Support Network
NameRelationshipPhoneCan Help WithAvailabilityNotice Needed

Instructions: Customize these templates with your specific language and contact details. Save as drafts in your email for quick access during emergencies.
Client Emergency Communication
Medical Emergency
Planned Care Absence
Team/Staff Notifications
Immediate Crisis
Family Update Templates
Medical Update

Instructions: Map out critical business processes and backup plans. Review and update monthly. Assign priority levels: High (business-critical), Medium (important), Low (can wait).
Key Business Processes
Process/TaskCurrent OwnerBackup PersonPriority LevelInstructions LocationMax Delay Acceptable
Client Communication
Payroll Processing
Invoice Generation
Vendor Payments
Project Management
Revenue Pipeline Risk Assessment
Client/ProjectMonthly ValueContract End DateRisk Level if You’re UnavailableMitigation StrategyBackup Contact

Instructions: Track caregiving commitments alongside business obligations. Plan buffer time around medical appointments. Coordinate backup coverage for both roles.
Weekly Caregiving Schedule
Day/TimeCaregiving TaskDurationCan be Delegated?Backup PersonBusiness Impact
Medical Appointments & Business Conflicts
Appointment DateType/ProviderDurationBusiness ConflictsResolution PlanFollow-up Needed

Instructions: Track the financial intersection of caregiving and business. Update monthly to identify trends and plan cash flow accordingly.
Monthly Caregiving Costs
Expense CategoryMonthly CostCovered by InsuranceOut-of-PocketBusiness ImpactTax Deductible?
Medical Copays
Medications
Home Care Services
Transportation
Lost Revenue Tracking
DateMissed OpportunityReasonEstimated ValueRecoverable?Prevention Strategy

Instructions: Monitor your capacity weekly to prevent burnout. Track patterns to identify when you need additional support. Rate items 1-10 (10 = excellent/high capacity).
Weekly Capacity Assessment
Week of:Energy Level (1-10)Stress Level (1-10)Business Hours WorkedCaregiving HoursPersonal TimeSleep Quality (1-10)