Record Expected and Received Monthly Household Income
Create a monthly household income record using statements and payment records, with separate entries for dependable income, receipts and unresolved amounts.
To record expected and received household income, you can create a register for each month with separate fields for dependable planned income, verified receipts and unresolved amounts. Use existing income records to support the plan and bank statements to check what arrived. This optional worksheet focuses on the income side of a Singapore household budget; keep your monthly costs alongside it for the whole-household calculation.
Define the month and household scope
MoneySense recommends basing monthly income on earnings you can rely on, such as basic salary or rental income, while excluding amounts you are unsure of receiving, such as uncertain bonuses or commissions. [1]
For your register, you can begin by writing the calendar month and whose income the worksheet covers. Choose either an individual record or a combined household record, then use that scope throughout the page. If household members keep separate worksheets, you can note which records feed into the combined total.
Next, gather the existing records you want to use: income statements, payslips, payment records and relevant bank statements. You can list each document beside the income entry it supports. Where a record contains several figures, label the particular amount you have selected for the spending plan rather than leaving its meaning unstated.
You can also add a short scope note describing what belongs in the register. For example, choose to record income from outside the household here and keep movements between the household's own accounts in a separate transfer note. Under that chosen convention, moving an already recorded receipt between accounts does not create another income entry.
Build the monthly income register
You can use a spreadsheet, notebook or document with the following fields. Keep the same layout for each month if you want to compare the records later.
| Field | What you can enter |
|---|---|
| Income source | Person and source associated with the income |
| Planned amount | Dependable income included in this month's plan |
| Planning record | Existing document supporting that amount |
| Received amount | Amount verified in the receipt record |
| Receipt date | Date shown on the supporting bank entry |
| Status | Received, partly received or awaiting verification |
| Record note | Document reference and any unresolved question |
For income expected through several payments, you can use separate receipt lines beneath the relevant source. Keep a single planned total for that source, rather than repeating the full planned amount beside every payment. When adding the register, sum the planned column and the received column separately.
You can keep uncertain earnings in a separate notes area outside the dependable planned total. Label each item with what remains unknown, such as whether it will be paid or what amount is supported. Do not fill the planned-income field with an estimate merely because the worksheet has an empty cell.
For a missing document, you can write a specific follow-up action: locate the income statement, check the relevant bank statement, or ask the household member responsible for that record. Leave the uncertainty visible until the supporting information is available.
Match received income to supporting records
You can check each receipt against the relevant bank statement and enter the amount and date shown there. Beside it, record the income document you have matched to that entry. Keep both references attached to the same receipt line rather than entering the supporting documents as separate receipts.
If an expected receipt has no verified bank entry, you can leave its status as awaiting verification. Avoid treating the planned amount as evidence that the payment arrived. Equally, if a bank credit has an unclear source, keep it on an unresolved list rather than assigning it to an income source without checking.
For month boundaries, you can adopt a written convention: enter receipts in the month shown by their bank-entry date, while retaining the month associated with the income document in a note. If those months differ, describe the difference without counting the receipt in both monthly received totals.
Where only part of an expected amount is verified, you can record that receipt and leave the remaining question open. If the records are incomplete, label the sum as a verified-receipts subtotal. Do not present it as the complete income received for the month.
Use the income total alongside monthly costs
MoneySense describes a budget as a plan for managing income, savings, spending and obligations, giving an overview of where money comes from and where it goes. [1]
For this worksheet, you can carry the dependable planned-income total into your existing monthly household budget. Place it beside the full set of recorded monthly costs, rather than comparing it with only a selected spending category. Keep the received-income subtotal separately labelled so the two figures are not interchangeable.
The following hypothetical example illustrates monthly income minus monthly costs, with the resulting surplus set aside under the stated assumptions.
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 | S$4,200 |
| Total monthly planned costs | S$3,500 |
| Monthly amount left: 4200 minus 3500 | S$700 |
| Amount set aside after 6 months: 700 times 6 | S$4,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.
The result is a planning surplus, not a balance available on a particular date. A dated balance also requires the starting balance and the dates and amounts of income and payments. You can keep that timing record separately if you need to examine a particular payment date.
Close the month with unresolved items visible
MoneySense recommends checking a budget regularly and adjusting it when circumstances change, including a pay increase, a pay reduction or an addition to the family. [1]
As an optional monthly closing step, you can review every unresolved line and write its current status beside it. Keep verified receipts in their subtotal and uncertain amounts outside that subtotal. Where a question carries into the following month, retain a reference to the original entry rather than silently removing it.
You can then prepare the next month's register from the existing layout. Check each planned amount against the records you have, and note the basis for any change. Choose a review reminder that suits your recordkeeping routine; the reminder is an organisational choice, not evidence that an expected payment has arrived.
Frequently asked questions
Should I replace planned income with received income?
Keep them in separate fields. In this optional layout, planned income records the dependable amount used for the monthly plan, while received income records verified receipts. You can annotate a difference without erasing either figure.
What should I do with an unexplained bank credit?
You can record its date and amount on the unresolved list and check the supporting records before including it in an income-source total. Keep the explanation blank or marked unverified until it is established.
Does a positive monthly surplus mean I can spend it today?
No. Monthly income minus costs is a planning calculation. To assess a dated balance, you also need the starting balance and the timing and amounts of incoming money and payments.
This article is general information, not personal financial advice.
