INV-402
Second reminder sent, owner requested a revised payment timeline.
Amount
$18,200
Owner: Nina Patel
Due date
Apr 4
Paid: Not paid yet
Quick access
Move between active modules without reopening the sidebar.
William Liu
Executive Ops · Admin
Cash Collection
Finance loading
Collected Revenue
3 settled invoicesCollected revenue already confirmed in the mock finance ledger.
Receivables
2 overdue invoicesOutstanding receivables that still need payment collection follow-up.
Due This Week
2 invoices due soonInvoices in the next review window before they become overdue.
Month-End Projection
$18,500 signedWeighted month-end estimate using confirmed revenue, static receivable confidence, and signed pipeline value.
Monthly revenue projection
Formula snapshot
Projected revenue = confirmed revenue + weighted receivables
Month-end estimate = projected revenue + signed pipeline
Projected revenue
$94,565
66% weighted collection coverage
Weighted projection from scheduled, due, and overdue receivables using static confidence rates.
Confirmed revenue
$58,850
3 settled invoices
Confirmed collections already marked as paid in the seeded April ledger.
Outstanding receivables
$54,100
5 open invoices
Open invoice value still outstanding before the month closes.
Month-end estimate
$113,065
$18,500 signed pipeline
Adds closed-won revenue from the current sales cycle on top of the weighted collection forecast.
Receivable weighting assumptions
Static confidence rates keep the forecast readable without introducing backend logic into the demo.
Scheduled invoices
100% applied$6,200
$6,200 gross · 1 invoice
Scheduled work is already approved in the seeded ledger, so it counts at full value.
Due invoices
85% applied$16,915
$19,900 gross · 2 invoices
Current-cycle receivables use a fixed 85% collection assumption for the month-end view.
Overdue invoices
45% applied$12,600
$28,000 gross · 2 invoices
Overdue balances stay conservative with a lower static recovery rate in the projection.
Projection bridge
This bridge shows how the weighted receivable forecast rolls up into the final month-end estimate.
Confirmed revenue
Paid invoices already cleared
$58,850
Weighted receivables
66% collection coverage
$35,715
Projected revenue
Confirmed plus weighted open collections
$94,565
Signed pipeline
Closed-won revenue queued for onboarding
$18,500
Month-end estimate
Static forecast for the current month close
$113,065
Payment tracking
Narrow the collection queue without losing the rollup
Search by client, invoice, or owner and keep the summary cards aligned to the records still in view.
Clients in view
6
of 6 accounts
Open balance
$54,100
5 open invoices
Overdue exposure
$28,000
at-risk collections in scope
Invoices shown
8
matched rows after filters
Harbor & Pine
Account manager: Maya Chen · 2 invoices
Harbor & Pine still has 1 overdue invoice blocking clean collections.
Open balance
$22,700
INV-402
Second reminder sent, owner requested a revised payment timeline.
Amount
$18,200
Owner: Nina Patel
Due date
Apr 4
Paid: Not paid yet
INV-408
Creative production add-on will post after approval.
Amount
$4,500
Owner: Nina Patel
Due date
Apr 16
Paid: Not paid yet
Awaiting payment
| Invoice | Amount | Due date | Status | Date paid | Collection flags |
|---|---|---|---|---|---|
INV-402 Second reminder sent, owner requested a revised payment timeline. Owner: Nina Patel Open client payment review | $18,200 | Apr 4 | overdue | Not paid yet | 9 days overdue |
INV-408 Creative production add-on will post after approval. Owner: Nina Patel Open client payment review | $4,500 | Apr 16 | due | Not paid yet | Awaiting payment |
Atlas Cold Brew
Account manager: Jordan Reyes · 1 invoice
Atlas Cold Brew still has 1 overdue invoice blocking clean collections.
Open balance
$9,800
INV-405
Escalated to account lead because launch tasks depend on payment clearance.
Amount
$9,800
Owner: Nina Patel
Due date
Apr 8
Paid: Not paid yet
| Invoice | Amount | Due date | Status | Date paid | Collection flags |
|---|---|---|---|---|---|
INV-405 Escalated to account lead because launch tasks depend on payment clearance. Owner: Nina Patel Open client payment review | $9,800 | Apr 8 | overdue | Not paid yet | 5 days overdue |
Solstice Labs
Account manager: William Liu · 1 invoice
1 invoice still need payment confirmation for this account.
Open balance
$15,400
INV-403
Invoice queued for Monday finance review.
Amount
$15,400
Owner: Nina Patel
Due date
Apr 15
Paid: Not paid yet
Awaiting payment
| Invoice | Amount | Due date | Status | Date paid | Collection flags |
|---|---|---|---|---|---|
INV-403 Invoice queued for Monday finance review. Owner: Nina Patel Open client payment review | $15,400 | Apr 15 | due | Not paid yet | Awaiting payment |
Northstar Skin
Account manager: Maya Chen · 2 invoices
1 invoice still need payment confirmation for this account.
Open balance
$6,200
INV-401
Retainer settled ahead of the first weekly review.
Amount
$24,000
Owner: Nina Patel
Due date
Apr 6
Paid: Apr 5
Settled
INV-407
Additional segmentation workshop scoped into the April sprint.
Amount
$6,200
Owner: Nina Patel
Due date
Apr 19
Paid: Not paid yet
Scheduled
| Invoice | Amount | Due date | Status | Date paid | Collection flags |
|---|---|---|---|---|---|
INV-401 Retainer settled ahead of the first weekly review. Owner: Nina Patel Open client payment review | $24,000 | Apr 6 | paid | Apr 5 | Settled |
INV-407 Additional segmentation workshop scoped into the April sprint. Owner: Nina Patel Open client payment review | $6,200 | Apr 19 | scheduled | Not paid yet | Scheduled |
Aurelia Home
Account manager: William Liu · 1 invoice
All invoices in the current view are already settled.
Open balance
$0
INV-404
Paid with quarterly upsell included.
Amount
$22,100
Owner: Nina Patel
Due date
Apr 2
Paid: Apr 1
Settled
| Invoice | Amount | Due date | Status | Date paid | Collection flags |
|---|---|---|---|---|---|
INV-404 Paid with quarterly upsell included. Owner: Nina Patel Open client payment review | $22,100 | Apr 2 | paid | Apr 1 | Settled |
Willow & Wren
Account manager: Chloe Santos · 1 invoice
All invoices in the current view are already settled.
Open balance
$0
INV-406
Processed with no exceptions.
Amount
$12,750
Owner: Nina Patel
Due date
Apr 12
Paid: Apr 11
Settled
| Invoice | Amount | Due date | Status | Date paid | Collection flags |
|---|---|---|---|---|---|
INV-406 Processed with no exceptions. Owner: Nina Patel Open client payment review | $12,750 | Apr 12 | paid | Apr 11 | Settled |
Expense log
The expense table keeps recent operating spend visible by category, owner, and note so the finance team can review where agency costs are stacking up.
Logged this cycle
$8,356
12 recent entries
Trim the expense log down to the spend you need to review
Summary cards reflect the current filters so category and owner-level costs stay clear before deeper review.
Entries in view
12
of 12 logged expenses
Spend in view
$8,356
live total for the current filters
Largest category
Contractor
$3,685
Average line item
$696
per matching expense entry
$249
Owner
Chloe Santos
Date
Apr 13
Notes
Monthly Figma and creative review seats renewed for design QA.
$1,820
Owner
Rafael Torres
Date
Apr 12
Notes
Emergency top-up for internal prospecting campaigns tied to April outbound targets.
$640
Owner
Maya Chen
Date
Apr 11
Notes
Client workshop transport and hotel deposit for the Harbor & Pine planning day.
$2,200
Owner
Nina Patel
Date
Apr 10
Notes
Freelance motion designer retainer for the Aurelia Home launch creative package.
$318
Owner
Chloe Santos
Date
Apr 9
Notes
Studio props, sample product handling, and rush shipping for campaign reshoots.
$96
Owner
Jordan Reyes
Date
Apr 9
Notes
Daily standup facilitation tools and documentation subscription for operations.
$129
Owner
Nina Patel
Date
Apr 8
Notes
Analytics connector renewal used to reconcile platform pacing with client reports.
$1,485
Owner
Maya Chen
Date
Apr 7
Notes
Copywriting support for Solstice Labs replenishment launch emails and landing pages.
$410
Owner
Rafael Torres
Date
Apr 6
Notes
Test budget for a cold-audience creative angle before rolling it into client spend.
$154
Owner
William Liu
Date
Apr 5
Notes
Working session lunch and print materials for the weekly cross-functional review.
$580
Owner
Chloe Santos
Date
Apr 4
Notes
Rush editing and caption burn-ins for new ad variations needed before Monday launch.
$275
Owner
Jordan Reyes
Date
Apr 3
Notes
Local travel reimbursements for onsite content capture and client delivery handoff.
| Category | Amount | Owner | Date | Notes |
|---|---|---|---|---|
| Software Open expense detail | $249 | Chloe Santos | Apr 13 | Monthly Figma and creative review seats renewed for design QA. |
| Paid Media Open expense detail | $1,820 | Rafael Torres | Apr 12 | Emergency top-up for internal prospecting campaigns tied to April outbound targets. |
| Travel Open expense detail | $640 | Maya Chen | Apr 11 | Client workshop transport and hotel deposit for the Harbor & Pine planning day. |
| Contractor Open expense detail | $2,200 | Nina Patel | Apr 10 | Freelance motion designer retainer for the Aurelia Home launch creative package. |
| Production Open expense detail | $318 | Chloe Santos | Apr 9 | Studio props, sample product handling, and rush shipping for campaign reshoots. |
| Team Operations Open expense detail | $96 | Jordan Reyes | Apr 9 | Daily standup facilitation tools and documentation subscription for operations. |
| Software Open expense detail | $129 | Nina Patel | Apr 8 | Analytics connector renewal used to reconcile platform pacing with client reports. |
| Contractor Open expense detail | $1,485 | Maya Chen | Apr 7 | Copywriting support for Solstice Labs replenishment launch emails and landing pages. |
| Paid Media Open expense detail | $410 | Rafael Torres | Apr 6 | Test budget for a cold-audience creative angle before rolling it into client spend. |
| Team Operations Open expense detail | $154 | William Liu | Apr 5 | Working session lunch and print materials for the weekly cross-functional review. |
| Production Open expense detail | $580 | Chloe Santos | Apr 4 | Rush editing and caption burn-ins for new ad variations needed before Monday launch. |
| Travel Open expense detail | $275 | Jordan Reyes | Apr 3 | Local travel reimbursements for onsite content capture and client delivery handoff. |
Contractor payouts
Keep freelancer payout timing visible alongside collections so delivery obligations do not disappear behind incoming receivables.
Outstanding payouts
$6,325
5 active releases
Noah Valencia
Client: Atlas Cold Brew
Atlas Cold Brew · Wholesale landing page updates
$890 · Apr 7
Mateo Cruz
Client: Harbor & Pine
Harbor & Pine · Spring creative reshoot edit package
$1,650 · Apr 9
Jules Ramirez
Internal project
Internal case study motion reel
$1,320 · Apr 13
Settlement reconciliation
Needs review
04
Client packets still carrying an open receivable inside the current finance view.
Ready
00
Clients the team marked ready to settle from this queue.
On hold
00
Client packets intentionally held for collection follow-through.
Harbor & Pine still has 1 overdue invoice blocking clean collections.
Open balance
$22,700
1 overdue
Payout context
Mateo Cruz
$1,650
Finance pulse
Cash position is stable, but Harbor & Pine and Atlas Cold Brew collections still need attention before Solstice Labs and internal contractor payouts are released.
Collection priorities
Harbor & Pine
$22,700 open · 2 open
Harbor & Pine still has 1 overdue invoice blocking clean collections.
Atlas Cold Brew
$9,800 open · 1 open
Atlas Cold Brew still has 1 overdue invoice blocking clean collections.
Solstice Labs
$15,400 open · 1 open
1 invoice still need payment confirmation for this account.
Northstar Skin
$6,200 open · 1 open
1 invoice still need payment confirmation for this account.
Weekly finance note
Finance pulse covering Harbor & Pine and Atlas Cold Brew receivables, the Solstice Labs invoice review, and payout timing tied to active client work.
Finance note
Cash position is stable, but Harbor & Pine and Atlas Cold Brew collections still need attention before Solstice Labs and internal contractor payouts are released.
Operations dependency
Finance has enough lead time to support Monday reviews if collections move today.