Wallet Balance

The balance of every member wallet at the end of each day, exported as a full snapshot.

The Wallet Balance file contains the balance of every member wallet at the end of the day: earned, spent, active, pending, blocked, and expired units.

Snapshot export. This is not a delta file. Each file contains one row for every wallet that existed at the end of the day, including wallets that did not change and wallets with a zero balance. Replace the previous day's data with the new file, or keep each file as a dated partition to build a daily balance history. Do not sum files together.

File: analytics/WalletBalance/wallet_balance_YYYY_MM_DD.csv Primary key: walletId

wallet_balance_2026_09_24.csv contains balances as of the end of 24 September 2026 (23:59:59 UTC). Every value is calculated from all transfers created before 2026-09-25 00:00:00 UTC, so it can be compared directly with the Unit Transfers files up to and including points_2026_09_24.csv.

A sample file is provided below:

wallet_balance_2025_12_02.csv

438B

Open

Available Data (in column order, see Column types for how each type is written):

Column	Type	Can be empty	Description
tenantId	uuid	No	ID of the tenant where the wallet is registered
memberId	uuid	No	ID of the member who owns the wallet
walletId	uuid	No	Unique ID of the wallet (links to walletId in the Unit Transfers file and defaultAccount.accountId in the Members file)
walletTypeCode	string	No	Code of the wallet type (for example default, coins)
earnedUnits	decimal	No	Lifetime units earned in this wallet (adding transfers that are active and not cancelled)
transferredUnits	decimal	No	Lifetime units received from other members (p2p_adding)
spentUnits	decimal	No	Lifetime units spent or sent to other members (spending and p2p_spending)
activeUnits	decimal	No	Current balance available for use
lockedUnits	decimal	No	Units currently pending (not yet active)
blockedUnits	decimal	No	Units currently blocked by an administrator
expiredUnits	decimal	No	Lifetime units expired
createdAt	datetime	No	Date when the wallet was created
updatedAt	datetime	Yes	Date of the most recent transfer on the wallet. Empty if the wallet has no transfers.

This file uses a different format from the other exports: timestamps are written as YYYY-MM-DD HH:MM:SS.ffffff (UTC, without an offset), and unit values can have trailing zeros, for example 100.000000.