🏦 UMS Balances & Inventory

Live US Bank account balances + mint inventory value. Auto-updating. Updated Aug 07, 2026 09:49 AM CST.
Overall Total Balance (all accounts)
Inventory Value (Mint)
OTC + Regulated OTC
Pending Payments
Accounts + Stock
Cash + inventory

US Bank Accounts — Live Balances

Pulled directly from the bank via Plaid on every rebuild. “Available” reflects holds/pending; “Current” is the posted balance.

AccountMaskAvailableCurrent
Total

Pending Payments

From the SALES export sheet. A payment counts as paid when its Confirmation checkbox is checked; unchecked invoices are pending. Auto-updates on every rebuild.

InvoiceCustomerCategoryDateAmount
Total Pending

Inventory Cost — Mint Items

Value of mint-condition stock (quantity × unit price), auto-updating from the Inventory Cost sheet. Breakdown lists items with qty ≥ 5.

OTC Value
Regulated OTC Value
Grand Total
ProductQtyUnit PriceValue