some_billing_qa.sql

-- Find transactions that are closed but have a non-zero balance
-- makes the (usually safe) assumption that the mmbxs materialized view data is correct
-- change the org unit id as needed to narrow your focus
SELECT COUNT(*)
FROM money.materialized_billable_xact_summary mmbxs
JOIN actor.usr au ON (au.id = mmbxs.usr)
WHERE xact_finish IS NOT NULL
AND balance_owed <> 0
AND au.home_ou IN (SELECT id FROM actor.org_unit_descendants(1));