Review income, spending, savings goals, and a rough debt date in one workbook

A useful weekly money review answers four questions in one sitting: what came in, what went out, whether any savings goal is behind, and whether the debts you are paying have a date you still believe. Four apps, or a budget file plus a separate debt file plus a notes app for goals, make it easy to skip the review. One workbook is enough if the numbers feed each other.

This is a record-keeping setup. It is not financial, investment, or tax advice. A payoff date and an interest total are rough estimates from the balances, rates, and payments you type. Your lender’s statement wins if the two disagree. The sheet will not log into your bank, file a return, or tell you which card to keep.

Start with this month, not the whole year

Open the monthly budget first. Set one planned number per category you actually use — groceries, rent, transport, eating out, whatever matches how you spend — and leave unused categories at zero or rename them. Twenty customizable categories are plenty for a household; more than that usually means two categories that should have been one.

Then log transactions as they happen, or dump them once a week from your statements. Each row needs a date, an amount, and a category from the same list the budget uses. If income and expenses are tagged automatically from that category, you do not have to remember which rows are paychecks. Filters help when you are looking for one store; they are not a substitute for picking the right category on the day you spend.

Planned versus actual should update as you log. A red over-budget mark is a prompt to look, not a verdict. Sometimes the plan was wrong (you forgot an annual bill landed this month). Sometimes the spending was. Write a three-word note on the row if you will not remember next Sunday why the number jumped.

Read the dashboard before you tinker

The dashboard is for a two-minute scan: total income, total spending, net cash flow, and savings rate for the month you have selected, plus a planned-versus-actual chart and a spending breakdown. A twelve-month income versus expenses trend is there so one loud month does not rewrite the story.

Switch months in one cell and keep the history. Do not start a new file every January unless you have a reason. A new file hides the year you already lived through.

Example, made up: grocery plan 450, actual 610 by the third week because of a dinner you hosted. The category is red. The dashboard still shows net cash flow positive because a freelance payment landed. You do not cut groceries to “fix” the red cell if the dinner was planned; you raise next month’s grocery plan or add a “hosting” category so the overage has a name.

Savings goals need a date and a monthly number

A goal without a monthly number is a wish. For each goal, write the target amount, what you have already saved, and the date you want it by. The useful outputs are progress (how far along), months left, how much you need to set aside each month to hit the date, and whether you are on track or behind.

If the monthly amount needed is larger than what the budget has left after bills, the date is the thing to change, not the color of the progress bar. Behind is information. It is not a moral score.

A first-pass at a debt date

List each debt with a balance, an interest rate, and the payment you can actually make. A built-in ranking can order them by avalanche (highest rate first) or snowball (smallest balance first). Months to payoff, a payoff date, and total interest are estimates from those inputs. They assume you keep the payment you typed and that the rate does not change.

Use this as a comparison, not a contract with the future. If you want a dedicated, side-by-side snowball versus avalanche calculator with more debts and a closer look at interest saved, that is a different job than a household budget. Do not treat a dashboard date as advice to close or refinance an account.

A Sunday review that fits in fifteen minutes

1. Switch to the current month if the cell still says last month.
2. Add any transactions you have not logged. Match the category to the budget list.
3. Read planned versus actual. Change the plan only when the category was wrong, not to make the red go away.
4. Check each savings goal. If a goal is behind, either raise the monthly transfer or move the date.
5. Glance at the debt list. If a payment changed, type the new payment so the estimate can move.
6. Stop. The review is done when the four questions have answers, not when the charts look pretty.

Limits

The workbook will not connect to your bank, categorize spending for you, or replace a conversation with a tax professional or a counselor if the numbers are a strain. Interest totals and payoff dates are educational estimates. License is personal use; do not resell or redistribute the file.

What you get is a single Excel workbook: a dashboard (income, expenses, net cash flow, savings rate, planned-versus-actual, a spending breakdown, and a twelve-month trend), a monthly budget with planned versus actual for customizable categories and over-budget marks, a transaction log with category dropdowns, a savings goals tracker with progress and on-track or behind status, a debt payoff planner with avalanche or snowball ranking, and a short instructions sheet. Formula-only, no macros. It opens in Microsoft Excel, and also in Google Sheets and LibreOffice (chart styling may vary). Clear the sample data before you start. One-time file, no subscription. Not financial advice. The link is in the box below.