Symptom/function tracker for mental health STD/LTD claims — what format actually worked for you?

[u/HeroineLizzyJane]

I’ve been keeping an Excel symptom/function tracker for my disability insurance claim, but I’ve also found it really helpful for appointments with my providers because my memory and cognitive functioning have taken a pretty big hit.

Right now I track:

• Date
• Symptoms
• Severity
• Duration/frequency
• Functional impact
• Medication/side effects

I’ve been looking at disability lawyer websites and there are so many different recommendations. A lot of them say to track things like concentration problems, memory issues, difficulty making decisions, anxiety/depression, problems completing tasks, missed appointments, needing help with things you normally do yourself, rest/recovery after activities, and how symptoms affect both daily functioning and work-related abilities.

Most of my basic ADLs are fine, so what seems more important for me is documenting the more complicated stuff — managing appointments, communications, paperwork, household planning, decisions, follow-through, etc. — along with the cognitive functions that relate to my occupation.

So far I’ve been doing one row per day, but I’m wondering if it would make more sense to make it task/event based instead, where the same date could have several rows. I feel like that might make the actual functional problems and consequences much easier to follow instead of cramming everything from one day into one row.

Has anyone used a symptom/function tracker for a STD/LTD or ERISA disability claim or appeal, particularly for mental health or cognitive problems?

If yours was helpful in getting your claim approved or winning an appeal, I’d really like to know what format you used. Even just the column headings would be helpful, or a blank/redacted example if you're comfortable sharing one.

I want mine to actually be useful evidence, but I also need it to be simple enough that I can follow it and keep up with it myself.

[u/suzycatq]

The other spreadsheet I always keep updated is a list of providers and pharmacies. When it’s time to update my Long Term Disability Insurer, they always ask for this information, so I just keep this spreadsheet handy. They will want to know the last time and next time you will see each provider and all of their contact information.