HNISQR.
Private preview

For families moving to India

Every member’s books. One position for the head of the family.

A family arriving in India rarely has one set of accounts. There are several people, often a trust or a holding company, and money in more than one currency. HNISQR keeps each of them as its own set of books — then consolidates them into a single position for whoever is accountable for the whole.

Double-entry, enforced at the database Consolidates across currencies
FAMILY GROUP  ·  31 Mar 2026  ·  INR
Balanced
Member Net position
Head of the family books in INR 4,82,60,000
Spouse books in INR 1,15,40,000
Son books in USD 5,41,62,000
$612,000 translated at 88.50  
Family trust books in INR 2,20,00,000
Consolidated 13,59,62,000

Illustrative figures. Balances between members are removed before this total, so a loan from one to another is not counted twice; the gap left by translating at two different rates is carried as a translation reserve rather than folded into the number.

What it does

Nine things, done properly.

One position, and the parts behind it

per member

Every member keeps their own books, chart of accounts and financial years, and reports on them alone whenever they need to. The head of the family gets the consolidated statement and the breakdown showing which member each figure came from — not a single number to be taken on trust.

Books in more than one currency

closing · average

Members who keep books abroad are translated into the family’s reporting currency: balances at the closing rate, income and expenses at the average rate for the period. Those two rates disagree, and the gap between them is shown as a translation reserve in equity rather than quietly absorbed. A missing rate stops the report instead of being assumed.

Money between members isn’t counted twice

eliminations

Lending between family members is routine, and it appears as an asset in one set of books and a liability in another. Consolidating naively counts both and inflates the family’s position. Those balances are cancelled — and where the two sides disagree about what is owed, you are told, rather than having the difference split for you.

You can see what is internal

internal turnover

Where members transact with each other, the amount and its share of the total is stated on the face of the accounts. A headline figure is never quietly inflated by the family transacting with itself.

Balanced by construction

Σ Dr = Σ Cr

Balance is not a report you run at the year end to find out what went wrong. Every entry is checked as it commits, by the database rather than by the application, so an entry that does not balance cannot be recorded by any route.

Statements file themselves

10 Indian banks

Drop in a statement and HNISQR recognises the bank, reads the rows and proposes an account for each line with a confidence score. Spreadsheets from ICICI, Axis and SBI; PDFs from those three plus HDFC and its credit card, Kotak, HSBC, Union Bank, Bank of Baroda and Indian Bank. Correct one and the rule is remembered for next month.

Why the number moved, not just that it did

opening → closing

“We are better off than in January” is the beginning of a question. The movement between any two dates is split into what caused it: earned, spent, put in, taken out, and moved by the exchange rate. The parts add up to the movement exactly — opening plus the bars equals closing — and the report carries that check rather than asking you to take it on trust. Assets are held at cost, so gains you have not realised are absent by design; it says so rather than leaving you to wonder.

What changed, rather than what is large

month on month

Each category is compared against its own recent history, not against the other categories. Salaries are the biggest number on the page every month and are never interesting; a standing payment that quietly stopped is small and usually is. Measured against the median rather than the average, so one unusual month cannot disguise itself, and in each member’s own currency, so a moving exchange rate is never mistaken for a change in behaviour. Nothing is called unusual on fewer than three months of history.

Who in the family funds whom

before elimination

Consolidation removes what the family owes itself, which is correct — and it also removes the answer to where the money actually sits. This shows those balances before they are cancelled: who has lent to whom, how much, and whether it has grown or been repaid across the months. Where two members record the same debt differently, it reports the disagreement instead of splitting the difference.

The reporting cycle

Statement to family position, in four moves.

01

Import

Upload each member’s statements. The format is recognised, and rows from an overlapping export are ignored rather than duplicated.

02

Categorise

Each transaction gets a proposed account and a confidence score. You confirm, correct, or leave it for later.

03

Post

Confirmed transactions become balanced entries in that member’s books — or they do not post at all.

04

Consolidate

Translate, cancel what the family owes itself, and produce one position as at any date you choose.

Consolidated · family group · as at 31 Mar 2026
Account Debit Credit
Bank & cash3,84,20,000—
Investments7,10,00,000—
Property4,60,00,000—
Loans from family members—1,86,50,000
Translation reserve—7,65,000
Capital & retained—13,60,05,000
Σ15,54,20,00015,54,20,000

Reporting

The statements fall out of the ledger.

Because every account carries its type and the statement it belongs to, the reports are not assembled by hand. They are a reading of the ledger at a date — for one member, or for the family as a whole, in whichever currency you report in.

  • TBTrial balance, per member or consolidated
  • BSStatement of assets and liabilities
  • P&LIncome and expenditure for any period

Illustrative figures.

Where it is today

What works, and what is still coming.

Working now

  • Separate books per family member, consolidated for the head
  • Translation across currencies, with the reserve shown openly
  • Balances between members removed from the family position
  • Internal transactions measured and disclosed
  • The position as at any date, and the movement between two
  • What moved the family’s worth, split from what the exchange rate moved
  • Spending compared against its own history, per member and category
  • Who has lent to whom inside the family, and whether it is growing
  • Bank statement import and review across ten Indian banks

Not yet

  • Account heads shaped for a household rather than a company
  • Residency status and the split between Indian and foreign income
  • Removing internal transactions from the totals, rather than only reporting them

Early access

HNISQR is in private preview.

We are working with a small number of families relocating to India, and with the advisers who look after them. If that is you, we would like to hear how you keep track today.

Request access