Profit Allocation & Dividend Planner
Financial year: 1 July – 30 June. Uses Finance monthly records and the Dividends register.
Tax & Pension Planning Settings
Saved separately for each financial year. Rates are your editable assumptions, not automatic HMRC calculations. Planned pension amounts are not confirmed deductible payments.
Monthly Profit Allocation
Three separate bars for planned pension, estimated tax and remaining profit.
Cumulative Retained Profit
Estimated post-tax and pension profit less recorded dividend payments; excludes opening reserves.
Monthly Dividend Tracker — 2026–2027
Income and overheads automatically reflect your saved Finance figures. Dividend payments come from the existing Dividends register by payment date. Blank future months are shown as zero, not forecasts.
| Month | Income | Overheads | Profit before pension | Planned pension | Est. tax | After tax | Dividends paid | Cumulative retained* |
|---|---|---|---|---|---|---|---|---|
| Jul 2026 | £2,095.65 | £1,422.87 | £672.78 | £134.56 | £102.26 | £435.96 | £0.00 | £435.96 |
| Aug 2026 | £2,214.67 | £1,545.18 | £669.49 | £133.90 | £101.76 | £433.83 | £0.00 | £869.79 |
| Sep 2026 | £2,071.75 | £1,417.70 | £654.05 | £130.81 | £99.42 | £423.82 | £0.00 | £1,293.62 |
| Oct 2026 | £2,068.09 | £1,885.52 | £182.57 | £36.51 | £27.75 | £118.31 | £0.00 | £1,411.92 |
| Nov 2026 (no entry) | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £1,411.92 |
| Dec 2026 (no entry) | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £1,411.92 |
| Jan 2027 (no entry) | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £1,411.92 |
| Feb 2027 (no entry) | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £1,411.92 |
| Mar 2027 (no entry) | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £1,411.92 |
| Apr 2027 (no entry) | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £1,411.92 |
| May 2027 (no entry) | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £1,411.92 |
| Jun 2027 (no entry) | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £1,411.92 |
| Total / closing | £8,450.16 | £6,271.27 | £2,178.89 | £435.78 | £331.19 | £1,411.92 | £0.00 | £1,411.92 |
Important: dividend availability
* This is a planning estimate only, not an amount certified as legally distributable. Profit can differ from distributable reserves and available cash. The illustrative tax calculation assumes planned pension allocations are actually paid and deductible; it does not calculate marginal relief, associated-company rules, adjustments, losses or actual tax liabilities. Opening reserves must be reconciled to approved accounts. Before declaring a dividend, verify relevant accounts, reserves, liabilities and available funds, and obtain professional advice where needed.