About this video
A Singapore allocator closes the quarter on twenty asset cashflow statements in seven currencies and five languages; Ellie consolidates them into one cited USD statement.
Full description
Tessera Asia Holdings closes Q2 2026 on its US$14.85bn Alabaster Pan-Region Holdings book: twenty quarterly asset cashflow statements from ten reporting sources in seven currencies (EUR, GBP, AUD, SGD, JPY, KRW, HKD) and five languages, no two templates alike: German DATEV-style exports, a French EPRA-style statement, a Korean statement, a Japanese pack labelled by fiscal year, a USALI hotel summary, a data-centre availability statement. One plain-English prompt consolidates all twenty into a single US dollar portfolio statement at the group's quarter-average rates, with by-asset, by-jurisdiction and by-currency cuts, every figure cited to the statement it came from. Ellie then reads the Korean footnote nobody rekeys: a KRW 2.4bn lease-surrender premium booked inside recurring rental income. Reported, the quarter is up 1.6%; like-for-like it is down 0.8%, and the board-pack headline flips. The consolidated statement ships as a shareable Brief and a formula-driven workbook with the account mapping for all nine template families.
Key points
- Twenty different-format statements, seven currencies, five languages, consolidated into one USD statement from one prompt
- Every figure cited to its source statement: click a number and the statement opens at the line, in German, Korean or Japanese
- The wow: a one-off surrender premium hidden in a Korean footnote flips the headline from up 1.6% to down 0.8% like-for-like
- Ellie rebuilds NOI from components when every operator's subtotal is struck after capex, and separates translation from trading
- The board pack: a shareable Brief plus a live-formula workbook with the account mapping for nine template families
Transcript
Tessera Asia Holdings Singapore Alabaster Pan region Holdings 14.85 billion across eight jurisdictions and 20 of those assets report their quarterly cash flow directly to the portfolio team. Q2 has just closed and this is what closing looks like. 10 reporting sources, seven currencies, euro, sterling, Australian dollar, Singapore dollar, yen, won, Hong Kong dollar, five languages, and no two templates alike. The German operator alone sends eight statements in three formats.
A quarterly report as a PDF, a system export as a spreadsheet, and one asset as a raw CSV. Open one. Talstein's Quartalsbericht for Frankfurt-Süd in German figures in thousands of euros and the costs shown as positive deductions. A Korean statement from Soram in Seoul. Five lines, figures in millions of won signed negatives and two footnotes at the bottom. Remember those. A Japanese pack from Kerridge Tokyo which calls the quarter fiscal 2026 first quarter because the Japanese year starts in April.
Millions of yen. A hotel in Melbourne on a USALI summary. rooms, food and beverage, gross operating profit, the management fees, and the FF&E reserve before you get to a number an owner recognizes and a data center in Loyang on an availability statement. Colocation license fees, metered power recoveries, availability credits, megawatts, and PUE next to an office tower on a monthly operating statement rolled to quarter. Some in thousands, some in millions.
Some show costs as positive deductions, some as signed negatives. Today, this is a fortnight of rekeying against the board pack clock and the number the board sees first. Portfolio cash flow against last quarter is the easiest to get wrong and the hardest to evidence. One prompt in plain English. Consolidate the 20 Q2 statements into one US dollar portfolio statement at the group's quarter average rates. Show the statement, the quarteronquarter movement, the cuts by asset, jurisdiction, and currency.
Flag anything that should be treated as oneoff, cite every figure, then build the workbook, and publish the brief. Eight minutes later, Ellie has read all 20 in five languages and the first thing she tells you is that the headline is flattered. We will come back to that. The consolidated statement income $125.7 million up 2.7% net operating cash flow 86.8 capex 10.7 net cash flow after capex 76.12 million against 74.94 in Q1 up 1.6%. Every figure in this table is traceable.
Click one and Ellie shows the working 20 income lines converted at the quarter average rate and behind it the group's own FX schedule at the rate. Then the cuts by jurisdiction Singapore 17 1/2 million Australia 11 1/2 Japan 11.2 Korea 9 and Hong Kong the weakest underlying occupancy down from 94 to 91. By currency, three currencies carry three quarters of the cash flow. And the FX basis stated the group's quarter average rates, Q2 rates to Q2 flows, Q1 rates to the comparatives, no spot.
Germany is down $170,000 and here is why. A capex spike at München-Nord. Click it and the German statement opens at the line. Ellie read it in German. Another part of rekeying pass never finds the Korean statement for Cheongha Premier Tower books 2.4 billion won of early termination penalty inside recurring rental income. It is disclosed in one place. Footnote one in Korean. Click it. There is the footnote highlighted on the Soram statement received in May.
The 12th floor tenants early move out $1.77 million. That single line is bigger than the whole quarter's improvement reported. The portfolio is up 1.6%. Like for like strip the one off and it is down 0.8. The board pack headline flips from up to down and Ellie says so before anyone has re keyed a cell. Two more things she noticed on the way. Every one of the nine templates strikes its net operating cash flow line after capex whatever the label says in German, French, Korean and Japanese.
So she rebuilt NOI from components rather than trusting the subtotals. Taken at face value they would have understated portfolio NOI by the entire capex load. And half a million dollars of the movement is translation. A weaker dollar, not trading. Click it. The FX schedule. Again, the same quarter average rates behind every line. The kind of thing a good portfolio finance team knows to check, done, cited in the first pass. And this is what goes in the board pack.
The brief, the consolidated statement as a sharable page. The four numbers the committee needs at the top reported next to like for like the one-off explained with its source. Then the 20 assets, local currency, and dollars. every line traceable to the statement behind it. Behind it, the workbook saved to the workspace. Open it. The portfolio statement reported. Then like for like with the one-off stripped, then the cuts by jurisdiction and by currency.
Live formulas, not pasted values. Per asset detail, all 20 in local currency and in dollars. Every column traceable to a line on a statement and the account mapping tab. How nine template families in five languages were mapped to one chart of accounts. This is the audit trail. Formuladriven tied out. Every one of the 20 assets reconciles exactly to the subtotal printed on its own statement. 20 statements, seven currencies, five languages. No two templates alike.
One prompt, one consolidated statement. Every line traceable to source. And the headline the board sees is the true one. The consolidation is not just fast, it is right.
Portfolio intelligence across the fund
Video details
- Roles
- Portfolio Manager, Asset Manager, Investor / LP
- Processes
- Portfolio Analytics, Asset Management
- Geographies
- APAC
- Tags
- tessera-cashflow-consolidation, consolidation, multi-currency, briefs, citations, singapore