At a glance
Cash receipts applied to open Invoices today. The Controller’s morning telemetry on whether yesterday’s collections work paid off.
| What it counts | SUM(Transaction.Amount) for Transaction.Type = 'CustPymt' (Customer Payment) where TransactionDate = TODAY and the payment has been applied to one or more open Invoices. |
| Tax treatment | Includes tax. Cash applied represents the customer-paid total including VAT / sales tax. |
| Shipping | Included. |
| Refunds | Cash refunds (Customer Refund transaction) are NOT in this card; they’re a separate outflow. The card is inflows-only. |
| Cancelled / voided payments | Excluded. |
| Currency | OneWorld: reporting currency at receipt-date FX. Single-subsidiary: native currency. |
| Subsidiary scope | Respects dashboard filter. |
| Apply state | Counts only fully-applied or partially-applied receipts. Unapplied cash (received but not yet matched to an invoice) sits in a separate state and is captured on Cash Application Rate. |
| Time window | T (today only) |
| Alert trigger | None at headline (informational); the rate-of-application metric has its own alert |
| Roles | owner, finance |
Calculation
Calculated automatically from your NetSuite data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A US wholesale apparel distributor running NetSuite. Today is Monday 14 Apr 26; the AR clerk processed Friday’s mail-in cheques and Friday’s wire receipts this morning.| Receipt source | Receipts count | Applied today (USD) |
|---|---|---|
| ACH wires (Friday batch) | 18 | $214,000 |
| Mailed cheques (Friday batch) | 24 | $86,000 |
| Stripe-routed online payments | 41 | $52,000 |
| Manual customer transfers | 6 | $38,000 |
| Cash Applied Today (this card) | 89 | $390,000 |
- Monday is always the biggest cash-apply day. Friday’s bank receipts hit Monday morning’s reconciliation, and the cheque batch from late-week mail processes Monday. A typical mid-market shop sees Monday at 3-4x average daily applied.
- Stripe-routed payments auto-apply. Stripe’s NetSuite SuiteApp matches each settled charge to the originating Invoice, so $52K hits the books with no manual touch. ACH and cheque receipts require AR clerk to find the right Invoice.
- **Average daily Cash Applied = 390K is healthy; Tuesday will likely fall to $80K and weekend days drop to near zero.
- The card pairs with Cash Application Rate. Today’s 120K of unapplied cash sitting in the AR holding account, the rate is dropping. That’s the AR clerk’s queue length.
- vs Cash Collected. Cash Collected (ns_cash_collected.md) is the rolling 30-day version. Cash Applied Today is the daily heartbeat. Together they tell you whether collections velocity is accelerating or decelerating.
Sibling cards merchants should reference together
| Card | Why pair it with Cash Applied Today |
|---|---|
| Cash Collected | The rolling 30-day version. Today is the heartbeat; rolling is the trend. |
| Cash Application Rate | The efficiency metric. Tells you what fraction of received cash applies vs sits unapplied. |
| Invoice Aging Summary | What’s left to collect. Aging shrinks as cash applies. |
| DSO | Lagging indicator. Strong cash-applied days reduce DSO over time. |
| Overdue Invoices Value | What’s late. Big applied days often clear chunks of the overdue bucket. |
| stripe.stripe_total_revenue | Stripe-routed payments. Tells you the auto-apply share. |
| paypal.pp_total_volume | PayPal-routed equivalent. |
Reconciling against the vendor’s own dashboard
Where to look in NetSuite:Reports → Receivables → Customer Payment Detail filtered to today’s date Transactions → Customers → Receive Customer Payments, list view filtered to todayThe Customer Payment Detail report should match this card to the dollar when filtered to the same subsidiary. NetSuite’s report is the gold standard for this metric. Adjacent reports that look related but aren’t:
- Bank Register: shows all bank deposits including non-customer cash (vendor refunds, intercompany transfers). The card filters to Customer Payment transaction type only.
- Cash Receipts Journal: includes Cash Sales (which book direct to revenue, not AR). Different scope.
- Income Statement: revenue-side view; cash-applied is balance-sheet movement.
| Reason | Direction | Why |
|---|---|---|
| Time zone | Boundary days | Card uses subsidiary base time zone for “today”; if the user views from a different time zone they may see late-evening receipts split across two days. |
| Unapplied cash | Card may be lower | Card counts only applied receipts. If the AR clerk received cash but hasn’t yet matched it to an Invoice, it sits in unapplied. The full receipt count lives on the Bank Register. |
| FX rate | Small | Card uses receipt-date FX; report uses receipt-date FX. Should match unless rates moved intraday. |
| Subsidiary scope | Either | Card defaults to all subsidiaries; native report typically run per-subsidiary. |
| Pending Approval payments | Card may be lower | If your account uses Customer Payment approval workflow, a payment in Pending Approval is recorded but not posted. The card excludes them. |
| Card | Relationship | Why |
|---|---|---|
| stripe.stripe_total_revenue (today) | Stripe-routed slice of cash applied | Stripe-routed payments auto-apply via SuiteApp. Comparing Stripe’s daily settled total to today’s auto-applied portion validates the integration. |
| paypal.pp_total_volume (today) | PayPal-routed slice | Same as Stripe. |
Known limitations / merchant FAQs
Why is today’s number low on Tuesday vs Monday? Mondays absorb Friday’s banking activity, so they’re typically 3-4x average daily applied. Tuesday is the natural recovery day. Look at rolling 7-day averages for trend; daily fluctuations are noise. What’s “unapplied cash” and why does it matter? When the AR clerk receives a wire or cheque without enough information to identify the originating Invoice (e.g. customer pays a round figure that doesn’t match any single Invoice), the receipt is recorded in NetSuite as a Customer Deposit or Unapplied Payment. It’s cash on the bank but not yet against AR. The Cash Application Rate tracks the unapplied bucket; aim for <2% of monthly cash inflows. Sales Order vs Invoice vs Cash App, this card sits where? At the very end of the cycle. Once a Customer Payment posts and applies, the Invoice closes (Status = Paid in Full) and AR drops to zero for that line. This is where revenue becomes cash on the bank. Does the card include Customer Deposits (pre-payment for SOs)? Optional. Customer Deposits are pre-payments against future Sales Orders, not Invoices. They sit in a deferred liability account until the SO bills. The card defaults to Customer Payment transaction type only; the field map can extend to include CustomerDeposit if your accounting policy requires it. Why is Stripe-routed cash automatically applied while ACH isn’t? Stripe’s NetSuite SuiteApp posts Customer Payments with a direct reference to the Invoice ID, so NetSuite auto-applies on import. ACH and cheque receipts arrive without an Invoice reference (the customer’s remittance email may have it, but the bank file does not), so the AR clerk manually identifies and applies. PayPal is similar to Stripe. Multi-currency, what FX rate is used? Receipt-date spot rate for the day of the Customer Payment. NetSuite’s Realised FX Gain/Loss accounts capture the difference between Invoice-date and receipt-date FX. The card shows the receipt-date GBP equivalent in reporting currency. ASC 606 / revenue recognition, does it interact? No. Cash application is a balance-sheet movement, not a revenue-recognition event. ASC 606 governs when revenue is booked to the P&L; this card tracks when AR clears. Does the card include intercompany payments? By default yes. If you want only third-party customer cash, the field map can excludeCustomer.Type = 'Intercompany' records.
How does Lockbox auto-application affect the count?
Lockbox-fed cash auto-applies via NetSuite’s Bank Reconciliation feature when remittance data is good. Quality of remittance data determines the auto-apply hit rate; well-run lockboxes get 80%+ auto-apply, weaker ones drop to 30%. The card sums applied receipts regardless of how they got there.