Self-Employed Income Calculator for a Loan File
Turn business profit into an income worksheet and compare up to two financial periods.
Business results
Income estimate
Example inputs- $116,285
Self-employed income worksheet
Average $116,285
| Calculation | Latest | Prior |
|---|---|---|
| Months covered | 12 | 12 |
| Reported profit or loss | $164,800 | $186,900 |
| Add-back | $6,200 | $5,800 |
| Deduction | $3,400 | $2,500 |
| Adjusted business profit | $167,600 | $190,200 |
| Ownership share | 65% | 65% |
| Income for the period | $108,940 | $123,630 |
| Annual equivalent | $108,940 | $123,630 |
File references
Latest period ____________________
Prior period _____________________
Lender policy ____________________
Start With the Same Profit Measure
Enter the profit or loss for the exact period shown in the business accounts. Use the same measure for both periods, such as net profit before tax. Enter a full year as 12 months and a loss as a negative amount.
Use the whole business’s figure when applying an ownership share. If you start with income already allocated to the borrower, applying their share again understates it. The worksheet uses one ownership share for all periods.
Adjust and Compare Periods
The worksheet adds the entered add-back and subtracts the entered deduction before applying the ownership share. Enter both adjustments as positive amounts. Leave an adjustment blank if the starting profit already reflects the intended treatment.
With more than one proposed add-back or deduction, list each item once in your file notes and enter the sum for each category. Keep the original line and the lender policy reference beside each adjustment so you can check how it changes profit.
Latest period shows the adjusted share for the months entered. Annualise multiplies that share by 12 and divides it by the period length in months. Average gives each of the two annual equivalents equal weight.
In the example, latest profit of $164,800 plus $6,200 less $3,400 leaves $167,600. A 65% share produces $108,940, down from $123,630 in the prior year. The $116,285 average sits above the latest result, so keep both periods visible when explaining the decline.
Annualising a short period projects its earning pace. A seasonal peak or a one-off sale can raise the projection, and the lender can apply a different treatment to the figures.
Retain the Evidence
Print the worksheet or download its CSV and file it with the source documents. Write the entity, period dates and profit line beside each period’s reference. Use the adjustment notes to point to the financial statement, ledger or tax reconciliation that supports each amount.
Reconcile the starting amounts with the tax returns and use the ownership records to support the percentage. CommBank’s home loan document guide gives an example of the business financial statements and personal tax evidence a lender may request.
Record the lender’s reason for accepting, reducing or excluding an adjustment and the period treatment used in its assessment. The worksheet preserves your calculation for that comparison.