Consolidated household reports

Put the income tax positions of several taxpayers — spouses, a landlord and their HUF, parents, two households — into one report with each taxpayer's own summary beside clearly labelled combined figures, without ever adding tax liabilities together or treating one person's income as another's.

Updated 20 Oct 2026

Overview

A consolidated report is for the moments when one taxpayer's return is not the whole picture: a couple applying for a loan together, a landlord whose rent is split between their own PAN and their HUF, a son who manages his parents' returns, or an advisor who needs two households on one page. It is built on the Consolidated / household tab of Income & Tax Reports and has three parts:

Individual taxpayer summaries — one block per taxpayer with their own income, deductions, taxable income, tax liability, tax paid, refunds and outstanding demand, their property and income-source breakdown, and their type (Individual / HUF) and period. Each block is the taxpayer's own annual summary, kept separate and identifiable.
Consolidated summary — combined gross receipts, combined rental income with the attribution per taxpayer, combined gross total income and a row labelled Sum of the selected taxpayers' total incomes (not a household taxable income), aggregate tax paid and refunds presented with qualification, and every row showing each taxpayer's contribution. Tax liabilities are shown per taxpayer side by side; there is no "household tax liability" row and none is implied.
Completeness & reconciliation issues — missing and partial years, stale sources, attribution conflicts and open findings across the selection, so a reader knows what the combined figures rest on.

The Compare tab is the lighter form: two or more profiles side by side over a period, metric by metric — gross rent and rental deposits, municipal tax, net annual value, deductions, income from house property, other income, gross total income, total income, tax liability, TDS and TCS, total tax paid, refund claimed, issued and received, outstanding demand — with the year-on-year change and, with exactly two profiles, the absolute and percentage difference. Nothing on the Compare tab is ever summed.

The consolidation rules

Property360 applies these rules, and asks you to acknowledge them before a consolidated report is generated:

Nothing is combined by itself. A taxpayer is in the report only because you ticked them. A shared surname, address, property or bank account never pulls anyone in.
Authorisation for every taxpayer. You must be allowed to see every profile you tick, and the person who receives the report must be entitled to see all of them together.
Individual and HUF records stay separate. An HUF is its own assessee; its income is the HUF's, not the karta's. The two are never merged into one taxpayer.
No double counting. Rent, deposits, deductions, TDS credits, payments and refunds are attributed to exactly one taxpayer by the rent-recipient rules (named on the lease, unit default, ownership share, bank account) and counted once.
Gross receipts, taxable income, tax liability and tax paid are different things and are labelled as such. A combined income row is the sum of the selected taxpayers' own figures; it is not one person's taxable income and not a household taxable income.
Tax liabilities are never added. Each PAN is assessed on its own; the report shows the liabilities beside each other with a note saying so.
Assumptions are flagged. Rent attribution and consolidation assumptions need professional review before anyone relies on them; the report says so on its warnings page.
Consolidated figures reconcile to the underlying records — each combined row shows the contribution per taxpayer, and the individual summaries are the same figures the Dashboard shows.

Before you start

Every taxpayer you want to include needs a profile with its own PAN under Landlord Info → Taxpayer profiles — your own, your HUF, a family member or a related landlord who authorised you. See Taxpayer profiles and HUFs and Landlord relationships.
Each profile needs at least one source for the years you pick; a taxpayer with nothing on file appears with every year Not available and is listed under completeness issues.
A report covers at most 12 taxpayers and 25 years.

Steps

Open Operations → Income Tax → Income & Tax Reports and choose Consolidated / household.
Under 1 · Taxpayers in the report, tick each taxpayer explicitly. A profile shows its type badge, the relationship of a family member, who manages it and the masked PAN. Optionally type a household label beside a taxpayer — Household A, Household B — to group two households in the same report; taxpayers without a label are listed as Not grouped.
Under 2 · Period, metrics and sections, set the From and To years (or a quick range), tick the Metrics to carry (the five core ones are ticked by default; Include adds the rest) and the Sections to include.
Under 3 · Before generating — the consolidation rules, read and tick every statement. The list grows by one line when an HUF is among the taxpayers and by one when only a single taxpayer is ticked (the report then equals that taxpayer's annual report plus a completeness section).
Keep Sensitive data masked unless the report is for your own records.
Click Generate. The preview shows the individual summaries, then the consolidated summary with each row's per-taxpayer contribution, then completeness and reconciliation issues and the warnings page.
Download PDF or Download Excel (.xlsx). The workbook adds the Individual Taxpayer Breakdown and Consolidated Household Summary sheets (and Comparative Analysis on the Compare tab); every combined cell is a SUM formula over the individual cells beside it, so the consolidation is visible and checkable.
To send it to a CA, lender or advisor, create a secure link instead of attaching the file — see Secure sharing. Sharing a report that covers more than one taxpayer or household shows an extra warning first.

Tip:For a quick side-by-side without the household framing, use the Compare tab, or tick two profiles on Income & Tax Trends — the Difference column there is first minus second, never a total.

Example

Arjun Kumar and his wife Priya are applying for a home loan and the lender wants both taxpayers' positions for FY 2023-24 to FY 2025-26, together with Arjun's HUF. Arjun opens the Consolidated tab, ticks Arjun Kumar, Priya Kumar (a related landlord who authorised him) and Kumar HUF, labels the first two Household A, keeps the core metrics and all sections, ticks the six acknowledgements and generates. The individual summaries show three separate positions. The consolidated summary shows combined rental income of ₹27,40,000 with the attribution Arjun ₹12,10,000 · Priya ₹8,30,000 · Kumar HUF ₹7,00,000, the row Sum of the selected taxpayers' total incomes (not a household taxable income), and the three tax liabilities beside each other with the note that they are not added. The completeness section notes that Priya's FY 2023-24 return is not on file, so that year's combined rows carry her contribution as Not available. He creates a masked, 7-day secure link for the lender's loan officer.

FAQs

Why can't I see a combined tax liability?

Because there is no such thing in law: each PAN is assessed on its own slab, rebates and surcharge. Adding two liabilities produces a number nobody owes. The report shows them side by side and says so.

Does the report prove a household income to a lender?

It shows each taxpayer's own return figures and a clearly labelled sum of them, with every source and verification status. What a lender accepts is for the lender to decide; the report never presents the combined figure as any one person's taxable income.

A taxpayer's rent is missing from the consolidated rental income

Rent is attributed by the rent-recipient rules — the taxpayer named on the lease or unit, the bank account's profile, or the ownership share. If a unit's rent goes to the wrong taxpayer, fix the attribution under Landlord Info → Taxpayer profiles or on the lease; the consolidated figures follow the records. See Taxpayer profiles and HUFs.

Can a CA generate a consolidated report?

Yes, across the landlords who name them (and those landlords' managed profiles). A profile outside that scope cannot be ticked; a request that names one anyway is refused and audited.

Troubleshooting

"Acknowledge every statement to continue"

Every line of the consolidation checklist must be ticked before the Generate button works. Read them — they describe what the report does and does not claim.

"The selection or period changed — generate again to refresh the preview"

You changed a taxpayer, year, metric or section after generating. The preview is a snapshot of the previous request; click Generate again.

A taxpayer I expect is not in the picker

You can only tick profiles you may see: your own, the HUFs and family members you manage, related landlords who authorised you, and for a CA the landlords who name them. Ask the landlord who manages the profile to add you under Landlord relationships.

Was this article helpful?