maiven gateway · online··
manifest · 1d ago
Sign in
Back to catalog
MAIVENmodelmarts

mart_cash_position

beta
mart table

Daily cash in/out and running balance per bank account.

Lineage Builds
Definition

One row per (as_of_day × bank_account) from bank transactions: credit increases cash, debit decreases it. `net_flow` is the day's credit - debit; `running_balance` is the cumulative balance through the day per account (the latest row per account is the current balance). A cash snapshot, not a full cash-flow-statement categorization.

Watch out for
  • highSumming running_balance across days

    `running_balance` is already cumulative. Summing it across days compounds the balance nonsensically — pick the latest day per account instead.

  • mediumMixing currencies across accounts

    Each bank account carries its own `currency` (USD, EUR). Summing `running_balance` across accounts of different currencies mixes units; convert or group by currency first.

Questions this answers
  • “What is our current cash balance per bank account?”
  • “How did cash move last month for the US operating account?”
Related metrics
11 of 11
Column
Type
Description
Tests · PII
as_of_day
Date
Calendar day of the cash activity. Date. Part of the grain.
1 test
bank_account_id
UInt64
FK to stg_postgres__bank_accounts.bank_account_id. Part of the grain.
1 test
account_name
String
Internal bank-account name. Nullable.
bank_name
String
Bank name. Nullable.
currency
String
Account currency (USD / EUR). Nullable.
region
Nullable(String)
Account region (US / EU). Nullable.
cash_in
Decimal(18, 2)
Sum of credit (cash-in) amounts on the day. Decimal(18,2).
1 test
cash_out
Decimal(18, 2)
Sum of debit (cash-out) amounts on the day. Decimal(18,2).
1 test
net_flow
Decimal(18, 2)
Day's net cash flow — cash_in - cash_out. Decimal(18,2).
1 test
running_balance
Decimal(18, 2)
Cumulative cash balance through the day per account. Decimal(18,2).
1 test
transaction_count
UInt64
Number of bank transactions on the day. UInt64.