Monthly Profit & Loss Trendline
Filtered dynamically by your top Year/Month selector. Click any number or account row in the matrix below to drill through to the Source Journal.
Monthly Income & Expense Progress vs. Historical Average Budget
Benchmarks actual monthly performance against your historical average run-rate. Click any progress bar to drill through to its journal entries.
Income Progress vs. Budget ("Remaining to Earn")
Expense Progress vs. Budget ("Remaining Left to Spend")
Monthly Balance Sheet Progression & Trendline
Tracks Total Gross Assets, Accounts Payable, and Retained Earnings. Click any cell in the schedule below to drill through to the General Ledger.
Sub-Account Breakdown
Click any sub-account row below to filter the posted journal entries to that specific bank, asset, investment, or counterparty.
SQLite Source Journal Inspector (All Posted Entries)
Loading...
Forensic Audit Comparison: Raw SQLite vs. Manager.io Extract vs. Active Dashboard
Compares unadjusted SQLite native sums (at standard 0.58 NZD / 0.017 PHP rates), your Manager.io statement extract, and the currently loaded dataset.
Forensic Audit Finding #1: Base Currency is Set to USD ($), Not NZD
In your SQLite database, ContentType 39dde4fc... (Base Currency) is configured as United Stated Dollar (USD, $), while New Zealand Dollar (NZD) is stored in the Foreign Currencies table with a static rate of 0.58. Consequently, every NZD transaction is multiplied by 0.58 on your Manager.io statements:
- Employment Income: Actual NZD deposited across 48 fortnightly pay runs is $141,198.83 NZD, reported as $81,895.38 ($141,198.83 × 0.58).
- Monthly Utilities Contribution: Actual NZD transferred across 56 entries is $48,819.54 NZD, reported as $28,315.34.
- ANZ Home Loan (S007): Actual NZD principal balance is $337,018.82 NZD, reported as $195,470.92 inside Accounts Payable.
Forensic Audit Finding #2: FX Rate Overrides in Field 21
Inside ContentType 5ea52bc4..., Field 21 stores a manual exchange rate override. While standard PHP entries use 0.017, several PHP entries accidentally inherited the NZD rate of 0.58 (a 34.1× overstatement):
- School Tuition ($6,654.80): Includes 1 entry on 2025-04-23 of ₱5,018.00 PHP @ 0.58 = $2,910.44 (should be $85.31 at 0.017, overstating tuition by $2,825.13).
- Other Income ($5,585.71): Includes ₱6,020.40 PHP @ 0.58 = $3,491.83 in Aug & Oct 2026 (should be $102.35 at 0.017, overstating income by $3,389.48).
- Interest Received ($32.12): Includes quarterly PHP entries totaling ₱0.44 PHP @ 0.58.
Consolidate 16 Bank Accounts into ANZ Home Loan Offset
You hold $35,516.33 USD ($61,235.05 NZD) across 16 cash accounts (HOME Fund ANZ $26,655.40, Cash $6,540.23, Travel BNZ $2,312.79), yet earned only $32.12 in interest over 22.5 months. Offsetting $50,000 NZD against your $337,018.82 NZD ANZ Home Loan (S007) at ~6.5% saves ~$3,250 NZD/year tax-free.
Eliminate -$2,784.94 FX Loss & ₱4,966.86 Wire Fees
105 separate bank fee entries and frequent small transfers between ANZ/BNZ, Wise, BDO Mama (#5179), and SEC (#5234) created -$2,784.94 in FX drag. Batch PHP remittances quarterly and match Philippine outflows (Family Support $5,341.03, Rabdon Insurance $1,122.00, SSS $894.88) against onshore PHP inflows.
Shift Non-Yielding Land Equity to High-ROIC Portfolios
Your $111,063.68 Investment portfolio (Schwab $50,995.93, KiwiSaver Milford $20,731.68, IBKR $15,052.00, Kraken $8,387.00) generated +$35,251.82 in unrealized gains + $867.36 dividends, whereas 14 Philippine land lots lock up capital with minimal cash yield. Divest 1–2 non-core Davao lots to accelerate mortgage paydown.