Keep the Care Budget Current: A Monthly Upkeep Routine for the Money Runway
A care budget that was right in the first month drifts by the fourth, so keep one page, name one owner, run one monthly check, and know which events force a full recalculation.
A care budget that was right in the first month is usually wrong by the fourth. Hours change, a premium notice arrives, a benefit letter comes late, and the savings you planned to draw down stop matching the bank statement. This guide sets up the upkeep: one page, one owner, one monthly pass, and a short list of events that force a full recalculation.
Local option: New Plan Care gives families in the St. Louis area in-home help so a parent can stay home: companionship, help with bathing and dressing, meals, and overnight care. Call (314) 405-0887.
Build the one-page sheet
Use one sheet with four blocks. The first is liquid funds, meaning checking, savings, and any account you can spend without selling something. The second is fixed monthly outflow, which covers housing, utilities, insurance premiums, loan payments, and any bill you pay on the parent's behalf. The third is care outflow: the hours actually invoiced, the hourly rate on the signed agreement, and any equipment rental or monitoring fee. The fourth is expected inflow, which means only income you can confirm in writing, such as a Social Security deposit shown on the benefit statement the SSA sends, or a pension or VA payment shown on its own statement.
Runway is the liquid funds, minus a cash floor you refuse to touch for emergencies, divided by the monthly net outflow. Write the formula on the sheet itself so the next person can reproduce it without asking you. Leave the numbers blank until you have pulled them from statements, not from memory.
The monthly pass
Each month, check every line against a document, not against what you remember paying. Compare the care invoice to the signed rate and the hours logged, and flag any line that bills time you did not agree to. Compare each premium to the last notice you received. Compare each deposit to the benefit statement. Where a payer's figure differs from your record, call the number printed on that payer's letter and ask for the figure in writing, with the date it applies from. The CFPB publishes plain guidance on reading account statements and spotting charges you did not authorize, and it is worth reading once before you start the routine.
Keep a folder, paper or digital, with the statement, the invoice, and the letter for each line. When an entry is questioned later, the folder answers the question faster than any call.
What forces a full re-run
Some changes should trigger a recalculation the same week, not at the next monthly pass. Recalculate when care hours change in either direction, when a payer approves, denies, or ends coverage, when a premium or rate notice arrives, when the parent's income or account balances change, when someone moves into or out of the house, and after any hospital stay or new equipment order. Each of these changes the runway, and a runway you have not recalculated since the change is a number you should not trust.
Who keeps the sheet
Name one owner who runs the monthly pass and one second person who can read the sheet and the folder when the owner is away. The sheet should say, in one line, where the folder lives and where the login for each account is kept. Store the account credentials with the family's record, not in the spreadsheet itself, and keep that record somewhere the second person can reach it.
If the parent still makes their own financial decisions, the sheet should record that they do. If it is unclear who has legal authority over the parent's money, that is a question for a Missouri attorney, and the Missouri Bar's public lawyer directory is the place to start. The spreadsheet cannot settle it.
Where the upkeep stops
The sheet tells you the numbers. It does not tell you what to do with them. Questions about spending assets to qualify for Medicaid, estate recovery, transfers, trusts, or what happens to a house after a parent dies belong to an attorney. Missouri DSS and Medicaid.gov publish the eligibility rules, so read them, but take the decision to a lawyer. Questions about whether a treatment or level of care is needed belong to the physician, not to the budget. The runway tells you how long the money lasts under a given plan, and only the professionals can tell you whether the plan is the right one.
For the order of these papers and the free counseling that can check your numbers, start with Start Here: The Order to Read, then look at Local Help With Paying for Care, which lists the free counseling programs the Missouri SHIP program and Aging Ahead can point you toward. Every figure in your sheet should trace to a source on the Sources page or to a document in your own folder. For how these guides are written and checked, see How We Write.