Property management, built natively on Oracle NetSuite

Request a demo

Netsuite · Finance Depth

Multi-currency property management, with tax handled by NetSuite

Multi-currency property management means billing rent, collecting payments and reporting results in each property's local currency, then consolidating in your reporting currency. RIOO does this on NetSuite's own currency and tax features, so VAT, GST and sales tax on rent follow the same rules as the rest of your ledger.

What is multi-currency property management?

Multi-currency property management is the ability to hold leases, tenant ledgers, vendor bills and bank accounts in different currencies within one system, while keeping exchange-rate effects and consolidated reporting correct. A Dubai tower bills in AED, a London block in GBP and a Sydney office in AUD, yet the group CFO needs one consolidated P&L in USD.

In a standalone property system, currency is often an afterthought: each country runs its own instance, or local results are converted in spreadsheets. In RIOO, currency comes from NetSuite. Each subsidiary has a base currency, each tenant (customer) and vendor can transact in its currency, and NetSuite revalues open balances and translates results at consolidation.

GGross-upSStraight-line rentNNOIEEstoppel

What should you prepare before implementation?

Agree your subsidiary and currency structure, rate types for revaluation and consolidation, tax codes by charge type and market, and which NetSuite tax engine your account uses. List any lease that changes tax status mid-term. If you are moving from separate country systems, decide how much foreign-currency history to migrate and in which currency to load opening balances.

Implementation phasesDiscoverConfigureMigrate dataTest & trainGo-liveGo-liveJoint project team

Capabilities

How do currencies and tax work for property in NetSuite?

In NetSuite, each subsidiary reports in its own base currency, leases and invoices carry a transaction currency, exchange rates revalue open balances at period end, consolidation translates results, and tax codes on each property charge handle VAT or GST, including exempt and opted items.

$US entity£UK entityAEDUAE entityConsolidatedin parent currencyRates from NetSuite

Subsidiary base currency

Each legal entity reports in its own currency. Example: a UAE subsidiary in AED, a UK subsidiary in GBP, both rolling up to a US parent in USD.

Transaction currency on leases and invoices

Rent invoices carry the lease currency, so a tenant in Singapore receives SGD invoices and pays in SGD.

Exchange rates and revaluation

NetSuite maintains rates and revalues open foreign-currency receivables and payables at period end, posting unrealised gains and losses.

Consolidation and translation

Consolidated statements translate subsidiary results using the rate types your controller defines, and intercompany balances eliminate.

Tax codes on property charges

Rent, service charges and fees carry tax codes, so VAT on commercial rent in the UK, GST on commercial rent in Australia or Singapore, and VAT on commercial leases in the UAE calculate on the invoice.

Exempt and opted items

Residential rent is commonly exempt from VAT or GST in several markets, while commercial rent may be standard-rated, or subject to an option to tax in the UK. Item-level tax settings let one property bill both.

Tax reporting

VAT and GST returns, and US sales tax reporting where applicable, come from NetSuite tax reports and localisation features rather than a side spreadsheet.

Why does native NetSuite matter for currency and tax?

Native NetSuite matters because currency and tax are where connected systems fail quietly. A PMS that sends summarised journals cannot carry tax detail or currency on each tenant invoice, so returns and revaluation depend on reconstruction. With RIOO, every invoice carries both in NetSuite.

Currency and tax are where connected systems fail quietly. A PMS that sends summarised journals cannot carry transaction-level tax detail or currency on each tenant invoice, so tax returns and revaluation rely on reconstructed data. Because RIOO invoices, receipts and vendor bills are NetSuite transactions, they inherit NetSuite's currency handling, revaluation, tax codes and audit trail. When an auditor asks how a VAT figure was built, the answer is a saved search over the invoices that produced it.

Why it mattersSpreadsheet recsSync jobs failLate journalsLate, unclearnumbers

Mapped to NetSuite

Currency and tax records in NetSuite

  1. RequirementRent in local currencyNetSuite featureCustomer and transaction currencyLeases bill in AED, GBP, SGD, AUD or USD
  2. RequirementGroup reportingNetSuite featureSubsidiary base currency and consolidationEntity results translate to the reporting currency
  3. RequirementVAT and GSTNetSuite featureTax codes and nexusCharges carry the right tax code per property
  4. RequirementUS sales taxNetSuite featureTax engine or SuiteTaxTaxable charges flagged by jurisdiction
  5. RequirementExchange ratesNetSuite featureCurrency exchange rate tableDaily or period rates applied consistently
  6. RequirementRevaluationNetSuite featurePeriod-end revaluationUnrealised gains and losses on open balances

Explore by topic

How does this change daily work by role?

Daily work changes by role: finance closes without a currency spreadsheet because revaluation and translation are standard NetSuite processes, property managers work only in local currency and tax codes, and tax teams report from transaction-level tax detail on every invoice.

PMProperty managersOpen tasks12TTTax teamsOpen tasks9LALeasing agentTours today7CControllerCloseOn track

Finance and controllers

Close no longer includes a currency spreadsheet. Revaluation and translation are standard NetSuite processes, and every translated number still drills down to the local invoice and lease.

Property managers

Managers work entirely in local currency and local tax codes. They do not need to know the group's reporting currency.

Tax teams

Tax codes live on items and transactions, so returns draw from the same records that billed the tenant. Exceptions, such as a lease changing from exempt to opted, are visible as changes on the record.

NetSuite administrators

Currencies, rate types and tax nexuses are configured once in NetSuite and reused by RIOO, instead of a second tax table inside a property system.

In detail

What changes by market?

Tax on rent varies by market: US rent is generally not subject to sales tax, UK commercial VAT depends on the option to tax, Australia and Singapore apply GST to commercial rent, and the UAE charges VAT on commercial leases. Residential rent is commonly exempt. Your advisers confirm treatment.

USUKAESGAustralia5 markets · one NetSuitelocal rules, shared ledger

United States

Rent is generally not subject to sales tax, though some states and cities tax commercial rent or certain fees. See RIOO in the United States.

United Kingdom

VAT on commercial property depends on the option to tax; residential lettings are generally exempt. Making Tax Digital applies to VAT returns. See RIOO in the UK.

Australia

GST generally applies to commercial rent and not to residential rent; BAS reporting follows. See RIOO in Australia.

Singapore

GST applies to commercial property rentals; residential leasing is generally exempt; InvoiceNow e-invoicing is expanding. See RIOO in Singapore.

UAE

VAT at 5% generally applies to commercial leases while residential leases are generally exempt or zero-rated in specific cases; corporate tax and e-invoicing are new obligations. See RIOO in the UAE.

Use cases

Tax treatment differs by charge

Tenant ledger · Unit 18Linden RowRefDescriptionAmountL-01Residential rent$2,300.00L-02Commercial rent$2,300.00L-03Deposits$55.00L-04Storage$95.00L-05Utility recovery$110.00Payment posted
01

Residential rent

Often exempt from VAT or GST in the UK, Australia, Singapore and the UAE; tax codes should reflect that per property.

02

Commercial rent

Frequently standard-rated or opted to tax, so invoices must show tax separately.

03

Service charges and recoveries

Usually follow the tax treatment of the underlying lease; check local rules.

04

Utilities and recharges

May be taxable even where rent is not.

05

Deposits

Not a supply, so no tax until applied to a charge.

Compare

What does a worked example look like?

A worked example uses a group with three assets in different currencies: a Manchester retail unit billed in GBP with VAT after an option to tax, a Sydney office billed in AUD with GST, and Dubai apartments billed in AED as VAT-exempt residential.

Each invoice posts in its subsidiary's currency. At month-end NetSuite revalues open receivables, and consolidation translates each subsidiary into USD for the group P&L. The property manager in each country sees local currency; the CFO sees the group.

AssetEvidence storedSubsidiary currencyReminder setMonthly chargeUp to dateTax treatmentUp to date
AssetSubsidiary currencyMonthly chargeTax treatmentInvoice total
Retail unit, ManchesterGBP£10,000 rentOpted to tax, VAT 20%£12,000
Office floor, SydneyAUDA$25,000 rentGST 10%A$27,500
Apartments, DubaiAEDAED 9,000 rentResidential, VAT exemptAED 9,000
Office, DubaiAEDAED 40,000 rentCommercial, VAT 5%AED 42,000

Which metrics can you track?

You can track revenue by currency and subsidiary, realised and unrealised FX gains and losses on receivables, tax collected by code and period, open receivables by currency, and consolidated NOI by asset in the reporting currency, all from NetSuite reports on RIOO transactions.

Further reading: NetSuite property management for the UK: VAT, SDLT and more, NetSuite property management in the UAE: Mollak, DLD and VAT and UAE e-invoicing for real estate.

Manual journalsTracked liveBudget varianceTracked liveOpen recsTracked liveClose durationTracked live

Checklist

Month-end for a multi-currency portfolio

Close tasksClose trackerThis periodOwner statementsVariance reviewCAM estimatesAP cut-offBank reconciliationsRent accruals
  • Load period exchange rates before running revaluation.
  • Revalue open foreign-currency receivables and payables.
  • Review VAT or GST returns by subsidiary before filing.
  • Eliminate intercompany balances in the reporting currency.
  • Explain translation differences separately from operating results.

Talk to a specialist

See multi-currency & global tax on your own portfolio.

RIOO does this on NetSuite's own currency and tax features, so VAT, GST and sales tax on rent follow the same rules as the rest of your ledger.

FAQ

Multi-currency & global tax FAQs

Still curious? Ask the team.

Can RIOO bill tenants in different currencies?

Yes. Leases and invoices carry a transaction currency, and each subsidiary has its own base currency in NetSuite, so one portfolio can bill in USD, GBP, AUD, SGD and AED from a single account. Using multiple base currencies requires NetSuite OneWorld, and exchange rates follow your NetSuite settings.

How does RIOO calculate VAT or GST on rent?

Tax is calculated by NetSuite using the tax code on each charge item, so commercial rent can be standard-rated while residential rent on the same property is exempt. RIOO uses your NetSuite tax configuration rather than a separate tax table.

Does RIOO handle foreign exchange revaluation?

Revaluation of open foreign-currency receivables and payables is a standard NetSuite period-end process. Because rent invoices, deposits and vendor bills are NetSuite transactions, they are included automatically, with unrealised gains and losses posted by subsidiary. Finance runs it as part of the normal close, with no separate currency spreadsheet.

Can we consolidate properties in several countries into one P&L?

Yes, through NetSuite OneWorld consolidation. Subsidiary results translate into the parent's reporting currency using the rate types your controller defines, intercompany balances eliminate, and every consolidated figure still drills down to the local lease, invoice or vendor bill in its original currency.

Is RIOO's tax setup compliant with every country's rules?

RIOO applies the tax configuration in your NetSuite account; it does not decide tax treatment. Your tax advisers should confirm tax codes, exemptions and options to tax for each market, while NetSuite localisation features cover country-specific reporting and returns. RIOO then applies those codes consistently to rent, fees and charges.

Do property managers need to work in the group currency?

No. Property managers see invoices, balances and reports in the property's local currency and use local tax codes. Translation into the group's reporting currency happens in NetSuite consolidation for finance, so managers never need to convert figures or work with exchange rates.

Can one tenant be billed in a currency different from the property's subsidiary?

NetSuite supports customer currencies that differ from the subsidiary base currency, subject to your configuration, so a tenant can be invoiced in another currency where the lease requires it. Most portfolios bill in the local currency of the property, which keeps tax reporting and collections simpler.

Does RIOO file VAT or GST returns?

No. RIOO applies tax codes to property charges, and returns are prepared from NetSuite tax reports. Filing follows your existing NetSuite tax process and local requirements, such as Making Tax Digital in the UK or BAS in Australia, handled by your finance team or advisers.

Bring a lease from each country you operate in. We'll bill all of them from one account.