Client database
Your clients, households, loans and income, linked together. Click any row to see everything connected to it.
Last updated 09:34Refresh
Draft · 2 questions still open · built Thu 15 Oct 09:34
Loans2 rows · click a row to see everything linked to it
| ALoan | ABorrowers | AHouseholds | ALender | AType | AProduct | AAcct (last 4) | ALimit | $Balance | ABalance date | #Rate % | ARate type | AFixed expiry | $Repayment | AFrequency | ABalance source | ARate as at | ARate source | APurpose | AInferred | AHow it was worked out | AEvidence | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | F0001 | P0001 Alex Taylor, P0002 Sam Taylor | H0001 | Westpac | home_loan | Flexi First | 1234 | 612,400 | 2026-09-30 | 6.74 | variable | 3950 | monthly | stated | 2026-09-30 | stated | owner-occupied | rate 6.74% on the statement to 2026-09-30 | ||||
| 2 | F0002 | P0001 Alex Taylor | H0001 | CBA | investment_loan | Investment Home Loan | 5678 | 455,000 | 2026-08-31 | 6.21 | variable | 2800 | monthly | stated | 2026-08-31 | calculated | investment | interest $2,320.18 over 30 days on $455,000 = 6.21% a year |
Noteslinked to F0001 · 1 rows
| AHousehold/Party | ACategory | ANote | ADate | ASource | AEvidence | |
|---|---|---|---|---|---|---|
| 1 | H0001 | refinance | Asked about fixing part of the loan before the rate review | 2026-07-02 |