Cash Balances by RC

Purpose

Provide a reporting-level aggregation of cash balances, expressed in standardized reporting currencies.

This model collapses all converted asset values into a single total per reporting currency and time period, making it suitable for:

• Net worth reporting
• Cash position tracking
• Executive dashboards and summaries

It represents the final consumption layer for asset-based cash balances.

Business Logic

• Start from the Assets Converted transformations
• Group converted asset values by:
  • Date
  • ISO week
  • Reporting currency
• Aggregate values using SUM
• Round final balances to two decimal places
• Produce one row per reporting currency per date

Output Contract

Definitions

Sample & Implementation

{{config(materialised='view')}}

with assets_converted as (
    select * from {{ref ('assets_converted') }}
)

select
    date,
    weeknum,
    reporting_currency,
    ROUND(
        sum(converted_value)
        ,2) as converted_cash_balances
from assets_converted
group by date, weeknum, reporting_currency
order by weeknum

Dependencies

• Transformations: Assets Converted