Compare Planned and Received Income in Your Monthly Budget
Create a monthly income comparison using existing statements and payslips, with separate records for planned amounts, received payments and unresolved entries.
To compare planned and received income in your monthly budget, place the amount you expected beside the amount supported by that month's records. Keep unresolved payments separate, then use the verified income total alongside your household costs. This article sets out an optional worksheet for that specific task, using existing statements, payslips and your current budget.
A budget starts with estimates of income and spending. NIDirect advises tracking what actually comes in and goes out so those estimates can be reviewed against actual figures. [1]
Define the month's income comparison
You could begin with a worksheet headed with the month being reviewed. Write a short scope note such as: “Received income uses payments shown on the bank statement within this calendar month.” Apply that same rule throughout the worksheet, and keep the planned figures on a monthly basis too.
Preserve the income amounts from your original monthly plan in a dedicated column. Put received amounts in a different column rather than replacing the plan as payments arrive. If you decide to revise a future month's plan, make that a separate entry with its own month label.
For planning, NIDirect advises averaging irregular income and leaving out one-off or uncertain amounts. Keep that distinction when choosing the income figure your budget will rely on. [1]
As an optional layout, create a main comparison for the income included in your plan and a separate section for verified one-off receipts. Give uncertain entries their own unresolved list. Do not move a payment into the planned-income section merely because it appears somewhere in your records.
Gather records and enter received amounts
StepChange recommends checking your bank account regularly. [2]
For this worksheet, you could gather the statement covering your chosen month, relevant payslips and the income section of your existing budget. Use a payslip to describe or investigate a payment, while entering the received amount from the statement under your stated recording rule.
A compact comparison might use these fields:
| Field | What you could record |
|---|---|
| Income line | The same label used in your monthly plan |
| Planned monthly amount | The expectation recorded before the comparison |
| Verified received amount | The amount supported by the selected record |
| Receipt date | The date shown on that record |
| Record reference | A statement page or document name |
| Review note | A question, explanation supported by records, or unresolved status |
If an income line has several verified payments during the month, you could list those payments beneath it and total them once. Retain each payment's date and reference. Avoid entering both the individual payments and their subtotal as separate income in the final monthly total.
Before assigning an unfamiliar credit to an income line, check what the available records establish. If its purpose remains unclear, record the entry and the question separately. Leave its treatment unresolved rather than inventing an explanation or silently assigning it a zero value.
Compare each income line
You could review each planned line in turn. Look at the planned amount, the verified received amount and the supporting records together. Add a short status note, such as “matches plan”, “received amount differs” or “awaiting evidence”. Use these as descriptions of the records, without assuming why an amount differs.
For an expected payment with no verified receipt, distinguish between an expectation and evidence of receipt. Leave the received field marked “unresolved” while you check the relevant records. Do not include an expected amount in the verified total solely to make the worksheet agree with the plan.
Where the records support a different received amount, you could keep both figures and add a factual note identifying the document checked. If that document does not explain the difference, retain the question. Avoid rewriting the original expectation after seeing the result.
At the foot of the worksheet, add the verified received amounts once. If relevant records or income classifications remain unresolved, label the result “provisional verified income subtotal” and name the outstanding items. Keep any separately recorded one-off receipts visible rather than folding them into the dependable planning figure.
Connect income to the whole monthly budget
NIDirect explains that subtracting spending from income for the same period shows whether the budget has money left over or a shortfall. Use the monthly basis for both sides of this comparison. [1]
For your own worksheet, you could place the income total beside the household's monthly cost total. Label each figure as planned, verified or provisional, as appropriate. Do not present a calculation using planned costs as though it were a completed account of actual spending.
The hypothetical example below illustrates monthly income minus monthly costs and the accumulation of the resulting planning surplus under its stated assumptions. It is separate from your personal records.
Hypothetical cash-flow example
These invented figures demonstrate arithmetic, not typical incomes or recommended spending amounts. Assume take-home income and all planned costs stay the same each month. Costs include essentials, required debt payments and other planned spending. Start with no money set aside for this example; assume no interest, fees, withdrawals or unexpected costs.
| Item | Amount |
|---|---|
| Monthly take-home income | £2,400 |
| Total monthly planned costs | £2,200 |
| Monthly amount left: 2400 minus 2200 | £200 |
| Amount set aside after 6 months: 200 times 6 | £1,200 |
This total is possible only if the full amount left is set aside each month under these assumptions. It is not a forecast. If income falls or costs rise, recalculate before choosing an amount to set aside.
A monthly planning surplus does not show the cash available today or before a bill is due. Check the current balance and the dates and amounts of expected income and payments before setting money aside; keep money needed for bills available.
Use that example to understand the relationship between the two monthly totals. Its fixed inputs do not resolve missing records or establish the income you will receive in a future month. Keep its assumptions separate from any notes about your household.
A monthly planning surplus is not a dated bank balance or proof that money is available before a payment falls due. A dated balance also requires the starting balance and the dates and amounts of income and payments. Keep that timing question separate from this monthly comparison.
Leave a clear month-end record
When you finish a review, you could add a dated note stating which records you used, whether the income total is provisional, and what remains unresolved. Keep the original plan beside the received figures so a later reader can see both without reconstructing your changes.
For each outstanding question, record the document or entry still to check. An optional reminder can name the next review date you choose. Leave the question open until the records support a decision; the reminder itself is not evidence that a payment was received.
Before using the worksheet in another monthly budget, check which figures you intend to carry forward. Preserve verified one-off receipts as historical records, keep uncertain amounts separate, and apply your planning rule again rather than copying the previous month's total automatically.
Frequently asked questions
Should I replace planned income with the amount received?
For this comparison, keep both in separate columns. You can then record what arrived without losing the expectation you are reviewing. Any revised plan for another month can sit in that month's worksheet.
What if I cannot identify a payment?
Keep its statement reference and amount in the unresolved list while you verify its treatment. Label any affected income total as provisional and explain what remains outstanding.
Does higher received income mean I can spend the difference?
This income worksheet alone does not establish that. Check the whole household budget, existing commitments, current balance and payment dates before treating an amount as available to spend or set aside.
This article is general information, not personal financial advice.
