Link Monthly Budget Figures to Statements and Bills
Add a source reference beside each monthly budget figure, with practical steps for linking statements, bills and planned costs and noting unresolved questions.
To link your monthly budget figures to statements and bills, you can add a source-reference column beside the amounts already in your worksheet. For each income or cost line, record the document, the relevant date or period, and where the supporting entry appears. Where a figure is planned rather than documented, link it to a planning note. The task is to record what each figure rests on, while leaving unanswered questions visible.
Set up a source-reference column
A budget planner provides headings for different types of income and expenditure, with space for your own amounts. [1]
As an optional addition to that layout, place a column called ‘Source reference’ beside your existing monthly figures. Keep the amount in its usual place. Use the new column for the document reference, rather than entering another amount that could be included in the total.
You could use the following fields, either as separate columns or together in a notes cell:
| Field | What you could record |
|---|---|
| Budget line | The income or cost heading already used |
| Source document | A recognisable statement, bill or planning-note name |
| Location | The page, entry date or section containing the figure |
| Period covered | The month or other period shown in the record |
| Open question | Anything about the reference or amount still to check |
Choose a reference format that fits your existing records. For digital documents, you could use the saved filename and page. For paper documents, you could use the folder label and statement period. Apply your chosen format throughout that month’s worksheet.
Give each budget figure a specific reference
Start with a line in your existing budget and find the statement or bill you used when entering it. In the source column, identify the relevant entry as well as the document. A reference to an entire folder leaves the particular figure unspecified; a page or entry date gives that reference a narrower location.
For an income line, you could reference the existing record from which you took the amount. Keep the reference beside the figure it supports. If your worksheet includes both planned income and recorded income, give each its own reference rather than leaving it unclear which amount the document relates to.
For a cost line, you could record the document’s period separately from the budget month. If those periods differ, add a short note describing how you used the document. Do not silently present an amount covering a different period as the monthly figure.
You can also distinguish the role of each record. A bill might be the document used for a planned cost, while a statement entry might be the record used for a payment. If you retain both references, label their roles and keep the budget amount in its designated amount cell.
Record how combined and planned figures were formed
Where an existing budget line combines several documented amounts, you could link it to a supporting note. List the component references and show the addition there. Put the resulting total in the budget’s amount column, with the note’s reference alongside it.
Keep the supporting calculation outside the main list of budget costs. Treat it as the working behind that line, rather than another cost to add. If your worksheet already contains the components as separate expense rows, choose whether the combined line is a subtotal or a separate planning line, and label it accordingly.
For a planned figure without a matching bill or statement, you could create a short planning note. Record the budget heading, the basis you chose and the document you consulted, if any. Call it a planning note rather than describing it as evidence of an actual payment.
Keep the task limited to the figures and records you already have. You do not need to reconstruct a bill from charges or pricing information to write a source reference. If the existing document does not explain the amount you entered, place the question on your unresolved list.
Keep unresolved references visible
A budget contains estimates of income and spending. Tracking what actually comes in and goes out is part of checking those estimates against experience. [1]
For your own worksheet, you could keep a short unresolved list beside the source column. Record the affected budget line, the question and the record you intend to check. Distinguish a missing reference from an uncertain amount: you might know the amount but still need to locate its supporting document.
If an amount itself remains uncertain, keep that uncertainty visible. Do not replace it with zero merely because the document is missing. If your recorded spending is incomplete, describe the sum of verified expenses as a provisional subtotal and state what remains unresolved.
When you settle a question, you could add the confirmed reference and a brief resolution note. If you change the amount, record the reason separately from the document location. This leaves both the source and your treatment of it available in the worksheet.
Read the monthly planning surplus
Taking spending away from income for the same month shows whether the budget has a surplus or a shortfall. [1]
The hypothetical calculation below illustrates that monthly relationship. In your own worksheet, the source-reference column would sit behind the income and cost inputs, identifying the records or planning notes used for them.
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,150 |
| Monthly amount left: 2400 minus 2150 | £250 |
| Amount set aside after 6 months: 250 times 6 | £1,500 |
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.
Read the result as a planning surplus. It does not establish what is available on a particular date. A dated balance also needs the opening balance and the dates and amounts of income and payments. A source reference beside a monthly figure does not supply those missing details.
Before applying the calculation to your own records, you could mark whether the inputs are planned amounts or recorded actuals. Keep unresolved costs visible alongside the result rather than presenting an incomplete set of records as a complete monthly position.
Review references and answer common questions
StepChange recommends revisiting your budget regularly. [2]
You could include the source column in whichever monthly review you choose. Check that references still point to the intended records, that planning notes remain labelled, and that unresolved questions have a recorded status. This is an optional recordkeeping checklist, separate from the source’s general recommendation.
Do I need to rename all my documents?
No renaming is required for this worksheet approach. You can use existing filenames or paper labels, adding a page, period or entry date where needed.
Can the same document support several budget lines?
You can reference the same document beside several lines. Specify the relevant entry or section for each figure, rather than repeating an undifferentiated document reference.
What if a figure has no supporting document yet?
You could link it to a clearly labelled planning note and record the outstanding question. Keep a planned figure distinct from a documented payment, and leave uncertain amounts explicitly unresolved.
This article is general information, not personal financial advice.
